Do two-sample test for equality of means assuming unequal variances. Calculate the p-value using Excel.
(a-1)Comparison of GPA for randomly chosen college juniors and seniors:
x1 = 4, s1 = .20, n1 = 15, x2 = 4.25, s2 = .30, n2 = 15, ? = .025, left-tailed test. (Negative values should be indicated by a minus sign. Round down your d.f. answer to the nearest whole number and other answers to 4 decimal places. Do not use “quick” rules for degrees of freedom.)
d.f.
t-calculated
p-value
t-critical
??(a-2)Based on the above data choose the correct decision.
-Reject the null hypothesis
-Do not reject the null hypothesis
(b-1)Comparison of average commute miles for randomly chosen students at two community colleges:
x1 = 17, s1 = 5, n1 = 22, x2 = 21, s2 = 7, n2 = 19, ? = .05, two-tailed test. (Negative values should be indicated by a minus sign. Round down your d.f. answer to the nearest whole number and other answers to 4 decimal places. Do not use “quick” rules for degrees of freedom.)
d.f.
t-calculated
p-value
t-critical+/-
(b-2)Based on the above data choose the correct decision.
-Reject the null hypothesis
-Do not reject the null hypothesis
(c-1)Comparison of credits at time of graduation for randomly chosen accounting and economics students:
x1 = 141, s1 = 2.8, n1 = 12, x2 = 138, s2 = 2.7, n2 = 17, ? = .05, right-tailed test.
(Negative values should be indicated by a minus sign. Round down your d.f. answer to the nearest whole number and other answers to 4 decimal places. Do not use “quick” rules for degrees of freedom.)
d.f.
t-calculated
p-value
t-critical
(c-2)Based on the above data choose the correct decision.
– Do not reject the null hypothesis
-Reject the null hypothesis





