chi square analysis

Employee _Ref Promoted

Management_Training _Program

1 No Yes 2 No Yes 3 No Yes 4 No Yes 5 No No 6 No No 7 No No 8 No No 9 No No 10 No No 140 No No Here is where the "HIDE" command w 141 No No 142 No No 143 No No 144 Yes No 145 Yes No 146 Yes No 147 Yes Yes 148 Yes Yes 149 Yes Yes 150 Yes Yes

Formula # Promoted Training Program Formula

Yes 96 83 No 54 67 p-value = 0.02701

Total 150 150

# Promoted Training Program Yes 64.0% 55.3% No 36.0% 44.7%

Total 100.0% 100.0%

We are testing the idea that Promotion = function (Going to the training program).

=COUNTIF(B2:B151,$A$154)

In Per Cent

Chi square test with Excel form

=CHISQ.TEST(C154:C155,B

ARE 122 - Spring 2020 Chi Square Test

ws used

mula

B154:B155)

ARE 122 - Spring 2020 Chi Square Test