Question

gpa	studyweek	sleepnight	gender
3.89	50	6	female
3.9	15	6	female
3.75	15	7	female
3.6	10	6	male
4	25	7	female
3.15	20	7	male
3.25	15	6	female
3.925	10	8	female
3.428	12	8	female
3.8	2	8	male
3.9	10	8	female
2.9	30	6	female
3.925	30	7	female
3.65	21	9	female
3.75	10	8.5	female
4.67	14	6.5	male
3.1	12	7.5	male

A sample of 17 students is selected. Data is collected on the students’ GPA, the # of hours studying per week, the # of hours sleeping per night and gender. using excel to calculate:

a) Decide at the level of significance of 5% if there is any difference between the average GPA of females and males.

b) Decide at the level of significance of 5% if there is any difference between the average # of hours studying per week of females and males.

c) Decide at the level of significance of 5% if there is any difference between the average # of hours sleeping per night of females and males

Answer 1