Data Analysis

[xylonanthes]

Part A: Data Collection (4 marks)

You need to attach a sample of GOOGLE FORMS used in your survey which consist the following information. (2 marks)

Gender:
Race:
Age:
Number of siblings:
Height (centimeters):
Weight (kilograms):
Father’s
Age:
Height (centimeters):
Weight (kilograms):

After the data collection, create and key in your data into the excel spread sheet by using the following given headings and attach it in your report. You may need to use the given link to complete the last two columns. (2 marks)

Gender
Race
Age
Number of siblings
Height (cm)
Weight (kg)
Father
Participant’s BMI
Father’s BMI







Age
Height (cm)
Weight (kg)




Part B: (29 marks)
Identify the type of each variable stated in part A, part I from item 1 to 6. Indicate whether it is qualitative or quantitative. If it is quantitative data, indicate whether it is discrete or continuous. [5 marks]

Identify whether the analysis you were considering in this survey is a population or sample. Provide a relevant reason. [2 marks]

By using Excel, construct a descriptive statistics table for the BMI of the participant and his/her father which MUST include the FIRST & THIRD quartiles and IQR. [4 marks]

Based on the above descriptive table of the participant’s BMI,
identify and interpret the most appropriate value to represent the central location. [2 marks]
identify and interpret the most appropriate value to represent the dispersion. [2 marks]

Between the participant and his/hers father’s BMI, justify who’s spread more. [4 marks]

By using Excel, draw an appropriate graph for
a qualitative variable [3 marks]
a quantitative variable [3 marks]
Interpret both graphs by giving TWO relevant points for each graph. [4 marks]

Part C: (16 marks)
You and your group members are going to use the fathers’ BMI and participant’s BMI to do the following analysis:

Identify the independent and dependent variable for the analysis. [2 marks]

Using Excel to draw a scatterplot with its regression line for the chosen data in part C question 1. Your graph must include the coefficient of determination value, the regression line and its equation. [6 marks]

Interpret
the scatterplot [2 marks]
the value of y-intercept [1 mark]
the slope [2 marks]
the coefficient of correlation value [1 mark]
the coefficient of determination value [2 marks]


Part D: (11 marks)
Use the BMI categories provided in the webpage, develop a contingency table for the BMI categories and the gender of the participant which includes the total for each column and row. [2 marks]

Find the probability (in 4 decimal places) that a participant chosen at random is
a male [1 mark]
a male and he is overweight [1 mark]
normal weight given that she is a female [2 marks]
not in the obesity category [2 marks]
a male or underweight [3 marks]

 

[FDibbins]

soooo basically you want someone to just do your homework for you, with no input or effort from your side at all?

good luck with that!!