In: Statistics and Probability
In a effort to better predict the demand for courses offered by a certain MBA program, it was hypothesized that students' academic backgrounds affect their choice of MBA major, thus, their course selection. A random sample of last year's MBA students was selected. The results are shown below. (A) State the null hypothesis and alternative hypothesis. (B) USING EXCEL Can we infer that undergraduate degree affects MBA students' course preferences?
Actual Results | ||||
Degree | Marketing | Finance | Accounting | |
BA | 31 | 13 | 16 | |
BENG | 8 | 16 | 7 | |
BBA | 12 | 10 | 17 | |
Other | 10 | 5 | 7 | |
Expected Results | ||||
Degree | Marketing | Finance | Accounting | |
BA | 24.08 | 17.37 | 18.55 | |
BENG | 12.44 | 8.97 | 9.59 | |
BBA | 15.65 | 11.29 | 12.06 | |
Other | 8.83 | 6.37 | 6.80 | |
Answer A.
Null Hypothesis, Ho: There is no significant relationship between undergraduate degree and course preference.
Alternative Hypothesis, Ha: There is significant relationship between undergraduate degree and course preference.
Answer B.
Test-Statistics: Under Ho,
Calculations:
Conclusion: SInce p-value = 0.0226< 0.05 (say) so we Reject Ho at 5% level of significance and conclude that There is significant relationship between undergraduate degree and course preference.