Use the Student_Data.xls file which consists of 200 MBA students at Whatsamattu U. The file includes variables regarding students’ age, gender, major, GPA, Bachelors GPA, course load, English speaking status, family, weekly hours spent studying. Each of the three assigned problems should be formatted as a one-page memo. Answers to all three of the problems should be submitted via the DropBox as a single Word document with each of the problems clearly labeled. Be sure to include your name on the document itself!

COMPLETE PROBLEM 1: The battle of the sexes lives on still today. Since admission standards do not address gender 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. Report on your findings (100+ words, 3 or more sentences). In your report, be sure to include the results of the hypothesis test and indicate whether you are using a two-tail, upper-tail, or lower-tail test. Also include a chart (a bar chart or column chart will probably work best) comparing the means of the two groups. COMPLETE PROBLEM 2: You have heard that men are more likely than women to declare a major in an MBA program. 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. Report on your findings (100+ words, 3 or more sentences). In your report, be sure to include the results of the hypothesis test and indicate whether you are using a two-tail, upper-tail, or lower-tail test. Also include a chart comparing the proportion of men without a major with the proportion of women without a major. COMPLETE PROBLEM 3: 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. Report on your findings (100+ words, 3 or more sentences). In your report, be sure to include the results of the hypothesis test and indicate whether you are using a two-tail, upper-tail, or lower-tail test. Also, include a chart comparing the means of the three groups. For this problem, a bar chart or column chart will work well; the display of the confidence intervals of the groups will also work. (100+ words, 3 or more sentences).