Chi Square Test - (5 questions) – Conduct a Chi square test in Excel on the surv
ID: 2926043 • Letter: C
Question
Chi Square Test - (5 questions) – Conduct a Chi square test in Excel on the survey data below to determine if male or females are more likely to get an annual flu shot.
Chi Square data:
Male
Female
Total
Not at all
25
40
Somewhat
20
19
Very
10
28
Total
1. What is null hypothesis for this study?
2. What is the alternate hypothesis for this study?
3. What is the chi square statistic that you calculated?
4. Would you accept or reject the null hypothesis? Justify your answer using your p and alpha values.
5. Does this test indicate that males and females are different in the target population with respect to their willingness to get an annual flu shot? Justify your answer with test results.
Male
Female
Total
Not at all
25
40
Somewhat
20
19
Very
10
28
Total
Explanation / Answer
1) Null hypothesis: There is no relationship between male and female
2) Alternative hypothesis: There is a relationship between male and female
3) Test statistic
Test statistic:
chi square=5.059
4) chi square critical value at 2 df with 5% level is 11.07
Conclusion: chisquare cal < chi square critical value, we donot reject the H0.
5) Hence there is no relationship between males and females
Oi ei (oi-ei)^2/ei 25 25.1760563 0.001231 40 39.8239437 0.000778 20 15.1056338 1.58582 19 23.8943662 1.00253 10 14.7183099 1.512568 28 23.2816901 0.956221Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.