K5.xlsK4.xlsK3.xlsxK2.docxK1.xlsUse 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.

400-600 wordsIn one of your initial meetings with the chief executive officer (CEO), she asked you to identify a number of the typical criteria used when making new location decisions. Complete the following:Describe and list at least 8 specific criteria to use.Explain the logic of why each criterion should be important.On a relative scale of importance, assign a high, medium, or low weight to each of the 8 criteria.Do not put all of this information into 1 paragraph; instead use 8 paragraphs, answering all 3 questions for each of the 8 criteria in a separate paragraph. A chart would also be acceptable.

incorrect stats questions.docxThis document has incorrect answers highlighted in yellow and a not in red below the incorrect problem.  You must show your work and also either provide a link to a calculator or provide formula in an Excel.