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.

COMPLETE PROBLEM 1: It is pretty common across most schools to find the grades at the MBA level divided between A’s and B’s. As such, you expect the mean GPA to be around 3.50. Using the sample of 200 MBA students, conduct a one-sample hypothesis test to determine if the mean graduate GPA is different from 3.50. 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 calculated mean with the hypothesized mean.

COMPLETE PROBLEM 2: Assume you read in the Whatsamatta U website that the average age of their MBA students is 45. Is this really true or have they failed to update this correctly? You think it is far less because more students have started their Masters sooner since the economy is so bad. You took a sample of 200 students (in the data file). Conduct a one-sample hypothesis test to determine if the mean age is less than 45. 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 calculated mean with the hypothesized mean.

COMPLETE PROBLEM 3: You have heard from idle chatter that most students don’t declare a major in their MBA programs. You took a sample of 200 students (in the data file). Conduct a one-sample hypothesis test to determine if the proportion without a major is greater than 50%. 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 calculated proportion with the hypothesized proportion.