research methods

1. Frequency distribution of Nominal Data

Methods of Describing Sets of Data (see a similar example of this question in the word file (Freq dist of Nominal Data ) and the companion excel file (Graph of Table 4 in the example of freq dist nominal data ) on Moodle Week 2 (Examples of materials similar to the questions in Project Assignment 1)

In a sample survey of 40 students selected randomly from VIU, the following information were collected from each student about the content of origin (Asia, Africa, North America, South America, Antarctica, Europe and Australia) and gender (male , Female)

  1. Use the data given in Table 1 to construct three tables showing the distribution by content (Table 2), by Gender (Table 3), and by both content and gender (Table 4).
  2. Use Excel to construct a column graph of the data in Table 4. Copy the graph from Excel to this word solution file. See the solution below

ID

Content

Gender

1

Asia

Male

2

Asia

Male

3

Asia

Female

4

Europe

Male

5

Africa

Female

6

Africa

Male

7

South America

Male

8

Asia

Female

9

Asia

Male

10

South America

Female

11

Africa

Male

12

South America

Male

13

Asia

Female

14

Asia

Male

15

South America

Female

16

Asia

Male

17

Asia

Male

18

Asia

Female

19

Europe

Male

20

Africa

Female

21

Asia

Male

22

Asia

Male

23

Asia

Female

24

Europe

Male

25

Africa

Female

26

Africa

Male

27

South America

Male

28

Asia

Female

29

Asia

Male

30

South America

Female

31

Africa

Male

32

South America

Male

33

Asia

Female

34

Asia

Male

35

South America

Female

36

Asia

Male

37

Asia

Male

38

Asia

Female

39

Europe

Male

40

Africa

Female

Solution Fill in each of the following

Table 2: Distribution by Content

Content

Frequency

Percent (%)

Africa

Asia

Europe

South America

Total

Table 3 Distribution Gender

Country

Frequency

Percent (%)

Male

Female

Total

Table 4 Distribution by content and gender

ContentGender

Male

Female

Africa

Asia

Europe

South America

b. To get a column graph of the information in Table 4, follow the following instructions.

1. Copy The whole table 4 above (all its 5 row and 5 columns) , open an excel file and paste Table 4

in that Excel file. ( See the companion excel file called Table 4)

2. After pasting Table 4 in the excel sheet , highlight all Table 4 and click on

INSERT in the menu of the Excel file

and click twice on the column choice. You will see the graph on your excel sheet

3. click twice (right mouse) on the graph in the excel sheet and you will see a side menu ,select copy from that side menu.

4. go to your solution word file , select the place where you will paste the graph and paste the graph. Save your solution word file

Insert the Column Graph of Table 4 below

Q2. Descriptive Statistics of Quantitative Data (measured on Ratio scale)

In a sample survey of 40 students selected randomly from VIU, the following information were collected from each student about their age and the cumulative Grade Point Average ( GPA).

Use the data given in the table below and the Data Analysis Option on Excel 2010 or later to obtain

the 18 descriptive statistics (Mean, Standard Error, Median, Mode, ….. MAD, IQR ) of both variables Age and GPA .

Table Data on Age and GPA collected from a sample of 40 students selected randomly from VIU.

ID

Age

GPA

1

23

3

2

25

3.2

3

24

3.2

4

24

3.1

5

25

3.5

6

30

2.8

7

32

2.9

8

33

2.9

9

35

4

10

40

3.9

11

31

2.5

12

25

3

13

24

3.2

14

22

3.5

15

50

2.8

16

24

2.8

17

26

2.7

18

25

3.3

19

23

3.4

20

26

3.5

21

29

3

22

23

3.2

23

24

3.2

24

25

3.1

25

25

3.5

26

26

2.8

27

27

2.9

28

28

2.9

29

28

4

30

27

3.9

31

25

2.5

32

23

3

33

22

3.2

34

25

3.5

35

27

2.8

36

28

2.8

37

24

2.7

38

24

3.3

39

25

3.4

40

26

3.5

Note: Copy the data for the two variables into an excel fileand follow the instructions given in the word file (Descriptive Statistics using Excel) on Week 2 of Moodle and the example (Descriptive Statistics using Excel example) in the same place. After you find the required statistics in excel copy them and paste your answer below.

Answer:

Q3. Frequency distribution and Histogram of Quantitative data

Use the data on age for the 40 students in the table presented above and the given bins, namely this data

Age

Bins

23

25

25

30

24

35

24

40

25

45

30

50

32

33

35

40

31

25

24

22

50

24

26

25

23

26

29

23

24

25

25

26

27

28

28

27

25

23

22

25

27

28

24

24

25

26

To construct a frequency distribution table of age and the histogram of the age. And present both below.

Note: Copy these data and the bins into an excel file and follow the instructions given in the word file (How to Create a Histogram in Excel) on Week 2 of Moodle and the example (create histogram example on excel) in the same place. Make sure you read the instructions carefully . After you find the required frequency table and the histogram in the excel file , copy them and paste your answer below.

ANSWER

THE FREUENCY TABE THE HISTOGRAM

Q4. Correlation between two Quantitative data sets

Use the data for age and GPA of the sample of 40 students given in question 7 above, to calculate the correlation coefficient between the age data and the GPA data.

Copy the two columns of data into an excel file and use the datadata analysis option to find the required coefficient. Read the word file (Correlation using excel) to help you understand how to use that option on Excel. After you calculate the correlation in excel, copy you answer below

Answer:

The Correlation between age and GPA:

Q5. Multiple Linear Regression Equation.

See the Excel file (multiple regression example on Week 2 Moodle to do similar analysis for this question.

Use the following data for a sample of 11 males . The data represent the Systolic Blood Pressure (dependent variable y) and the two independent variables (X1 Age in years, and X2 Weight in pounds).

Systolic Blood Pressure Data

Y

X1

X2

132

52

173

143

59

184

153

67

194

162

73

211

154

64

196

168

74

220

137

54

188

149

61

188

159

65

207

128

46

167

166

72

217

  1. a. Do the multiple regression analysis using Excel datadata analysisregression to obtain the regression results and then use them to find the regression equation.
  2. b. Use the coefficients to present the regression equation and use to estimate the blood pressure of a man of age 65 and weight of 220 pounds.

Copy the Answer from Excel and paste it below.

Refer below attached documents for examples

"Is this question part of your assignment? We can help"

ORDER NOW