Stats homework in Excel

Stats homework in Excel

1. The battle of the sexes lives on still today. Since admission standards do not address gender whatsoever, there should be an equally diverse group of men and women in school, but do they perform equally well. Using the sample of 200 students, conduct a hypothesis test for two independent samples to determine if the mean GPA differs for men and women. Use a .05 significance level.

2.Can a student keep up their grade performance at the next level? Is a strong GPA at the Bachelors level a good predictor of a strong GPA at the Masters level, or are GPAs naturally going to decline since graduate school is tougher, or will GPAs automatically be higher in graduate school because of the 3.00 requirement to graduate and the treatment of a C as subpar instead of average? Using the sample of 200 students (in the data file), conduct a hypothesis test for paired samples and test if there is a difference in the mean GPA from the Bachelors to the Masters programs. Use a .05 significance level.

3.Given the reasons why people get their Masters, you surmise that men are more likely to declare a major than women. Using the sample of 200 students (in the data file), conduct a hypothesis test of proportions to determine if the proportion of women with “no major” is greater than the proportion of men with “no major”. Use a .05 significance level.

4.You have probably heard that if you want something done, give it to a busy person. So is one’s employment status a factor in their academic performance? Using the sample of 200 students (in the data file), conduct a hypothesis test using Analysis of Variance to determine if there is a difference in the mean GPA for those who are unemployed vs. work part-time vs. work full-time.

Frequency Distribution:
Range Frequency
2.50-2.75 0
2.75-3.00 20
3.00-3.25 46
3.25-3.50 45
3.50-3.75 52
3.75-4.00 37

MBA_GPA
Descriptive Statistics:
Mean 3.42145
Standard Error 0.021807909
Median 3.44
Mode 3.56
Standard Deviation 0.308410412
Sample Variance 0.095116982
Kurtosis -0.964607469
Skewness -0.153411203
Range 1.19
Minimum 2.8
Maximum 3.99
Sum 684.29
Count 200
FOR YOUR ASSIGNMENTS TO BE DONE AT A CHEAPER PRICE PLACE THIS ORDER OR A SIMILAR ORDER WITH US NOW