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
3.8	12	8	female
3.4	4	9	female
3.575	45	6.5	female
3.85	6	7	female
3.4	10	7	female
3.5	12	8	male
3.6	13	6	female
3.825	35	8	female
3.925	10	8	female
4	40	8	female
3.425	14	9	female
3.75	30	6	female
3.15	8	6	female
3.4	8	6.5	female
3.7	20	7	female
3.36	40	7	female
3.7	15	7	male
3.7	25	5	female
3.6	10	7	female
3.825	18	7	female
3.2	15	6	female
3.5	30	8	male
3.5	11	7	female
3	28	6	female
3.98	4	7	female
3.7	4	5	male
3.81	25	7.5	female
4	42	5	female
3.1	3	7	male
3.4	42	9	male
3.5	25	8	male
3.65	20	6	female
3.7	7	8	female
3.1	6	8	female
4	20	7	female
3.35	45	6	female
3.541	30	7.5	female
2.9	20	6	female

lem Statement: A sample of 55 students is selected. Data is collected on the students’ GPA, the # of hours studying per week, the # of hours sleeping per night and gender.

Divide the sample into two samples based on gender (Females versus Males). Calculate the statistics for all variables and answer the following questions:

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.

Show all your work on the Excel file and upload the excel file on D2L by due date.

Answer 1

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

The hypothesis being tested is:

H₀: µ₁ = µ₂

H₁: µ₁ ≠ µ₂

The p-value is 0.2680.

Since the p-value (0.2680) is greater than the significance level (0.05), we fail to reject the null hypothesis.

Therefore, we cannot conclude that there is a 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.

The hypothesis being tested is:

H₀: µ₁ = µ₂

H₁: µ₁ ≠ µ₂

The p-value is 0.3112.

Since the p-value (0.31120) is greater than the significance level (0.05), we fail to reject the null hypothesis.

Therefore, we cannot conclude that there is a 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.

The hypothesis being tested is:

H₀: µ₁ = µ₂

H₁: µ₁ ≠ µ₂

The p-value is 0.7220.

Since the p-value (0.7220) is greater than the significance level (0.05), we fail to reject the null hypothesis.

Therefore, we cannot conclude that there is a difference between the average # of hours sleeping per night of females and males.

The Excel output is: