Question: do a twosample test for equality of means assuming unequal...
Question details
Do a twosample test for equality of means assuming unequal variances. Calculate the pvalue using Excel. 
(a1) 
Comparison of GPA for randomly chosen college juniors and seniors: 
x⎯⎯1x1 = 4.75, s_{1} = .20, n_{1} = 15, x⎯⎯2x2 = 5.18, s_{2} = .30, n_{2} = 15, α = .025, lefttailed 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.  
tcalculated  
pvalue  
tcritical  
(a2)  Based on the above data choose the correct decision.  

(b1) 
Comparison of average commute miles for randomly chosen students at two community colleges: 
x⎯⎯1x1 = 25, s_{1} = 5, n_{1} = 22, x⎯⎯2x2 = 33, s_{2} = 7, n_{2} = 19, α = .05, twotailed 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.  
tcalculated  
pvalue  
tcritical  +/ 
(b2)  Based on the above data choose the correct decision.  

(c1) 
Comparison of credits at time of graduation for randomly chosen accounting and economics students: 
x⎯⎯1x1 = 150, s_{1} = 2.8, n_{1} = 12, x⎯⎯2x2 = 143, s_{2} = 2.7, n_{2} = 17, α = .05, righttailed 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.  
tcalculated  
pvalue  
tcritical  
(c2)  Based on the above data choose the correct decision.  
