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, s 1 =...

Do a two-sample test for equality of means assuming unequal variances. Calculate thep-value using Excel.


(a-1)Comparison of GPA for randomly chosen college juniors and seniors:

x⎯⎯1x¯1 = 4.5,s
₁ = .20,n
₁ = 15, x⎯⎯2x¯2 = 4.9,s
₂ = .30,n
₂ = 15,α = .025, left-tailed test.

(Negative values should be indicated by a minus sign. Round down yourd.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.

• 
  
  
  

  
  

  Do not reject the null hypothesis

  
  

  
  
  
  


• 
  
  
  

  
  

  Reject the null hypothesis

  
  

  
  
  
  

(b-1)Comparison of average commute miles for randomly chosen students at two community colleges:

x⎯⎯1x¯1 = 23,s
₁ = 5,n
₁ = 22, x⎯⎯2x¯2 = 32,s
₂ = 7,n
₂ = 19,α = .05, two-tailed test.

(Negative values should be indicated by a minus sign. Round down yourd.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⎯⎯1x¯1 = 149,s
₁ = 2.8,n
₁ = 12, x⎯⎯2x¯2 = 146,s
₂ = 2.7,n
₂ = 17,α = .05, right-tailed test.

(Negative values should be indicated by a minus sign. Round down yourd.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