Chi Square Testing, business and finance homework help

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:
Historically, in the MBA program at Whatsamattu U., about 40% of the students
choose a Leadership major, 30% choose Finance, 20% choose Marketing, and 10%
choose no major. Does the most recent
class of 200 MBA students fit that same pattern or has there been a shift in
the choice of majors? Using the sample of 200 students (in the data file), conduct a Chi Square Goodness of Fit
test to determine if the current distribution fits the historical pattern. Use
a .05 significance level. Report on your findings (100+ words, 3 or more
sentences). In your report, be sure to include
the tables with the results of the Chi-square test as well as a chart (a bar
chart or column chart) comparing the expected vs. the observed
frequencies. 

COMPLETE PROBLEM 2:
While job opportunities for men and women are considerably more balanced than
they were 40 years ago, the career aspirations may still differ. Is there a difference in majors chosen by
men and women? Using the sample of 200 MBA students (in the data file), conduct a Chi Square Test of Independence
to determine if one’s choice of major is independent of their gender. Use a .05
significance level. Report on your findings (100+ words, 3 or more
sentences). In your report, be sure to
include the tables with the results of the Chi-square test as well as a chart
(a stacked column chart works well) comparing the expected vs. the observed
frequencies. 

COMPLETE PROBLEM 3:
You wonder if there is a relationship between students’ employment status and
their choice of major. Do unemployed
students choose majors that have the greatest employment potential? Do fully
employed students choose the ‘easiest’ major? Using the sample of 200 MBA
students (in the data file), conduct a
Chi Square Test of Independence to determine if one’s choice of major is
independent of their employment status. Use a .05 significance level.
Report on your findings (100+ words, 3 or more sentences). In your report, be
sure to include the tables with the
results of the Chi-square test as well as a chart (a stacked column chart works
well) comparing the expected vs. the observed frequencies.