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

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.
 

  • Do not reject the null hypothesis

  • Reject the null hypothesis

 (c-1) Comparison of credits at time of graduation for randomly chosen accounting and economics students:
 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.
 

  • Do not reject the null hypothesis

  • Reject the null hypothesis

Step by Step Solution

3.44 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!