Do a 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:
x⎯⎯1x1 = 4.75, s1 = .20, n1 = 15, x⎯⎯2x2 = 5.18, 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:
x⎯⎯1x1 = 25, s1 = 5, n1 = 22, x⎯⎯2x2 = 33, 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:
x⎯⎯1x1 = 150, s1 = 2.8, n1 = 12, x⎯⎯2x2 = 143, 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