Hypothesis Testing Problems for University Sexism

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 Drop Box 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.
Use the Analysis of Variance spreadsheet for problem 3.
There are some locked cells on the Analysis of Variance spread sheet that may give you trouble with Q3. The best workaround that I can see is to be sure to use Column A for the GPAs of the students that are employed full time. Even then, it will only pick up the first 50 students in the analysis. That will be OK as far as the assignment is concerned.