Youmustuse Excel to carry out all calculations and statistical analyses.

A study was commissioned to investigate the characteristics of students in a second year statistics unit. Data was collected on 60 students and the following variables recorded.

Column 1GPAWhat was your approximate GPA (1.0 to 7.0)

Column 2GenderWhat is your gender? (Male = 0, Female = 1)

Column 3WorkHrsAbout how many hours per week do you expect to work at anoutside job this semester?

Column 4DistanceHow far from campus do you live, in kilometres? (0 if on campus)

Column 5ExerciseHow often do you exercise (aerobics, running, etc)? (1 = Not At All,2 = Sometimes, 3 = Regularly)

Column 6IpadDo you have an iPad? (1 = No, 2 = Yes)

Question 1(7 marks)

Test, at the 5% level of significance, whether the average GPA is different for females compared to males.

[You may assume that the unknown population standard deviations for males and females are equal]

Question 2(6 marks)

Test, at the 5% level of significance, whether a student owning an Ipad is dependent to how often they exercise?

Question 3(7 marks)

Can we conclude, at a 5% level of significance, that a linear relationship exists between the Work Hours (y) and Distance (x) a person lives from campus?

NOTE: The data was randomly created for the sole purpose of this assignment and can be assumed to be normally distributed for all continuous variables.