Question

1. We want to test to see whether average SAT scores for science majors equals the average SAT scores for non-science majors. We collect the following sample SAT scores:

Science            Non-Science

440                  1000

1550                1010

1400                970

370                  1020

600                  980

800                  1000

1390                1080

1100   

1500   

1480   

450     

1430   

Use Excel to test this hypothesis at the 0.05 level by first testing variances (at the 0.05 level) and then means. Submit your Excel file along with your explanation.

Answer 1

Variance test:

1. Go to Data -> Data Analysis ->

2. Here is the input and output:

Since p-value < 0.05, we reject the null hypothesis that variance are equal.

3. Go to Data -> Data Analysis ->

4. Here are the inputs and output of the test:

Since p-value > 0.05, therefore we fail to reject the null hypothesis.

Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!