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)

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 

 a. Do the multiple regression analysis using Excel datadata analysisregression to obtain the regression results and then use them to find the regression equation.
 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