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⎯⎯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

Answer 1

Ans a-1 2. 2- IS l S df= 24.9 Roundingt the neatest whole umber __ calculated O.2D o.JD IS Vale: m tdisbibution Table avea under the cwnive t lhe left Ct-4618% and-by (df-14) Lg given by 0.0001 サence. P Value. = o.ooo!

df:Ra) ís given by =-20639 tence ticA = -2.0639 Sirce P-valuea. we Yespect te nall hypothesis Degrees 라 ffedon : 2- df- え2" 19 df-32.02 Roundeng to e nearest snumber

七一calenlated 5 p-value From t-distribution table: awea u curve to the left (t_-4-1S04) (df 32 s give by6.000 tie test iù a too thilal test ttence P-value =0.000|ix2 0.0002 t- Critica 0.05 te tedt is boo tailed test 0.05 2.