Question

In: Statistics and Probability

We want to test to see whether average SAT scores for science majors equals the average...

  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

Solutions

Expert Solution

First to test the equality of two variances,

using excel, Data -> Data Analysis -> F -Test Two sample for variances, we get the following output :

Since P-value = 0.0000013022 < 0.05, so at 5% level of significance we reject the null hypothesis and we can conclude that the two variances are significantly different.

Now, to test the two means using t test for unequal variances,

using excel, Data -> Data Analysis -> t-Test: Two-Sample Assuming Unequal Variances, we get the following output :

Since P-value = 0.81 > 0.05, so so at 5% level of significance we fail to reject the null hypothesis and we can conclude that average SAT scores for science majors for non-science majors are not significantly different.


Related Solutions

We want to test to see whether average SAT scores for science majors equals the average...
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...
Why do we compare means instead of individual scores? for comparing average SAT test scores across...
Why do we compare means instead of individual scores? for comparing average SAT test scores across the various bachelors batches which test would we use and why?
The following are the average scores on the mathematics part of the Scholastic Aptitude Test (SAT)...
The following are the average scores on the mathematics part of the Scholastic Aptitude Test (SAT) for some of the years from 1994 to 2009. Year, SAT Score 1994 504 1996 508 1998 512 2000 514 2002 516 2004 518 2005 520 2007 515 2009 515 Assuming a simple linear regression model, predict the average scores in 1997, 2006 and 2008
28. SAT Scores the average national SAT score is 1019. If we assume a bell-shaped distribution...
28. SAT Scores the average national SAT score is 1019. If we assume a bell-shaped distribution and a standard deviation equal to 110, what percentage of scores will you expect to fall above 1129? Above 799? Source: New York Times Almanac. 28th Question Solution: 16%; 97.5% For above 1129: 16% For above 799: 97.5% Why? please someone send me from where 16% and 97.5% came from?
1. The SAT test scores have an average value of 1200 with a standard deviation of...
1. The SAT test scores have an average value of 1200 with a standard deviation of 100. A random sample of 35 scores is selected for study. A) What is the shape, mean(expected value) and standard deviation of the sampling distribution of the sample mean for samples of size 35? B) What is the probability that the sample mean will be larger than 1235? C) What is the probability that the sample mean will fall within 25 points of the...
The SAT test scores have an average value of 1200 with a standard deviation of 100....
The SAT test scores have an average value of 1200 with a standard deviation of 100. A random sample of 35 scores is selected for the study. A) What are the shape, mean(expected value) and standard deviation of the sampling distribution of the sample mean for samples of size 35? B) What is the probability that the sample mean will be larger than 1235? C) What is the probability that the sample mean will fall within 25 points of the...
1. The SAT test scores have an average value of 1200 with a standard deviation of...
1. The SAT test scores have an average value of 1200 with a standard deviation of 105. A random sample of 35 scores is selected for study. A) What is the shape, mean(expected value) and standard deviation of the sampling distribution of the sample mean for samples of size 35? B) What is the probability that the sample mean will be larger than 1235? C) What is the probability that the sample mean will fall within 25 points of the...
Let’s say I want to see if four years of college can improve SAT scores. 5...
Let’s say I want to see if four years of college can improve SAT scores. 5 randomly sampled high school freshman were asked to take the SAT and their scores were (1010, 1150, 1310, 1250, 980). After four years of college those same 5 students again took the SAT exam. Their scores after college were (1030, 1100, 1380, 1240, 1100). State the null and alternative hypotheses, find the test statistic, the rejection region, the p-value and state your conclusion.
Scores on the SAT Mathematics test are believed to be normally distributed. The scores of a...
Scores on the SAT Mathematics test are believed to be normally distributed. The scores of a simple random sample of five students who recently took the exam are 570, 620, 710, 540 and 480. We want to find a 95% confidence interval of the population mean of SAT math scores. A) Calculate the point estimate. (Round to four decimal places as​ needed.) B) Calculate the sample standard deviation. (Round to four decimal places as​ needed.) C) Calculate the standard error...
Suppose we want to test whether or not three means are equal. We want to perform...
Suppose we want to test whether or not three means are equal. We want to perform this test with a 2% significance level. If we perform an ANOVA test, what is the probability of the test producing accurate results (avoiding a Type I error)? Suppose we, instead, run three separate hypothesis tests (t-tests), each with 2% significance level. Mean 1 = Mean 2 Mean 1 = Mean 3 Mean 2 = Mean 3 What is the probability that all three...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT