It is clear with this sample of 100 therefore the

Existing Education leave policy is adequate
Management Level Yes No
Executives 30 25
Managers 40 35
Support Staff 30 80
Based on this output, can the firm conclude that the opinion on the education policy is dependent
on the level of management of the employees? Use a chi square test and a level of significance of
0.05. ( 4 Points )
5. H0: Education Policy is Independent, Ha: Education policy is dependent
- x2 = ∑i∑j (fjj – ejj)2 / ejj (Calculated using excel for Repetitive calculations)
- x2 = Expected Totals: Calculated in Excel ***** Using = EX - A11*C9/ C11 to Calc Expected values =chi
test(E3:F4,(Expected Values A – C ) p value *****
- Executives - yes: 30 (22.92) [2.19] No: 25 (32.08) [1.56] Total: 55
- Managers – Yes: 40 (31.25) [2.45] No: 35 (43.75) [1.75]
- Support – Yes: 30 (45.83) [5.47]
- Totals: 100, 140: 55, 75, 100: GT: 240
- Therefore the Chi Test Statistic = 17.33
- Determining the P value using Chi table – DOF and 17.33 as Chi Stat
- Therefore the p – value is less than 0.01
- Reject H0: P – value <= 0.05
- Therefore we reject the Null hypothesis, the above variable have been proven Dependent using the
above calculations.