Do a two-sample test for equality of means assuming unequal variances. Calculate the p -value using Excel.
Question:
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¯1x¯1 = 4.5, s1 = .20, n1 = 15, x¯2x¯2 = 4.9, 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¯1x¯1 = 23, s1 = 5, n1 = 22, x¯2x¯2 = 32, 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.
x¯1x¯1 = 149, s1 = 2.8, n1 = 12, x¯2x¯2 = 146, 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.
Applied Statistics in Business and Economics
ISBN: 978-0073521480
4th edition
Authors: David Doane, Lori Seward