# 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) 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). 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.

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.

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

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