You are testing the claim that the mean GPA of night students is different from the mean GPA of day students. You sample 30 night students, and the sample mean GPA is 2.35 with a standard deviation of 0.46. You sample 25 day students, and the sample mean GPA is 2.58 with a standard deviation of 0.47. Test the claim using a 5% level of significance. Assume the sample standard deviations are unequal and that GPAs are normally distributed. Give answer to exactly 4 decimal places. Hypotheses:
sub(H,0):sub(μ,1) = sub(μ,2)
sub(H,1):sub(μ,1) â  sub(μ,2)
**I'm not sure how to calculate this in excel***
Enter the test statistic - round to 4 decimal places.
A=
Enter the p-value - round to 4 decimal places.
A=

Test statistic t = -1.8246

P-value = 0.0737

The null hypothesis failed to be rejected.

There is not enough evidence to support the claim that the mean GPA of night students is different from the mean GPA of day students.

Step-by-step explanation:

This is a hypothesis test for the difference between populations means.

The claim is that the mean GPA of night students is different from the mean GPA of day students.

Then, the null and alternative hypothesis are:

The significance level is 0.05.

The sample 1, of size n1=30 has a mean of 2.35 and a standard deviation of 0.46.

The sample 2, of size n2=25 has a mean of 2.58 and a standard deviation of 0.47.

The difference between sample means is Md=-0.23.

The estimated standard error of the difference between means is computed using the formula:

Then, we can calculate the t-statistic as:

The degrees of freedom for this test are:

This test is a two-tailed test, with 53 degrees of freedom and t=-1.8246, so the P-value for this test is calculated as (using a t-table):

As the P-value (0.0737) is greater than the significance level (0.05), the effect is not significant.

The null hypothesis failed to be rejected.

There is not enough evidence to support the claim that the mean GPA of night students is different from the mean GPA of day students.