It is clear with this sample of 100 Therefore the above variables are dependent

# It is clear with this sample of 100 therefore the

This preview shows page 6 - 8 out of 8 pages.

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.

#### You've reached the end of your free preview.

Want to read all 8 pages?

• Winter '15
• Business, Null hypothesis, Statistical hypothesis testing, 90%, p1