Betheluniversityonline net cps

Please use the following Book Reference as one of the references:

Mirabella, J. (2011) Business Statistics, (Savant Learning Systems) Retrieved from Bethel University, College of Professional Studies: http://betheluniversityonline.net/cps

COMPLETE SECTION:

BE SURE TO USE THE ATTACHED CHARTS TO COMPLETE THIS SECTION……

IMPORTANT DETAIL: ****Please find the student_Data.xls under the excel sheet with the name Two-Sample Mean Independent.

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.