Stress Level Commuting time 9 By writing formulas in Excel give the expected fre
ID: 2923826 • Letter: S
Question
Stress Level
Commuting time
9
By writing formulas in Excel give the expected frequencies (rounded to nearest tenth) and give the calculated Chi Square. ALL work must be done by writing formulas in Excel. I must be able to see your formulas. There should be only formula for the expected frequentics. What is the critical Chi Square?
Is stress level independent of commuting time? (yes or no) You must answer "yes" or "no" for independence.
Comparing the expected and the observed frequencies, which stress level(s) is/are over represented in the data for the Over 45 min commuting time. Remember if something is over represented in the data, it means the data is more than the expected. And if something is under represented in the data, it means the data is less than the expected.
Submit all work by the first post due date. I will point out any mistakes. Then you don't have to do anything. But if you want to improve your grade it will be up to you to reread the lecture and figure out what you need to do to correct your mistake.
Please note: I will point out where your mistakes are, NOT what you must do to fix them. It is your responsibility as part of the learning process, to go over the lecture again. Then you should work the problems in the lecture and compare what you did with what is in the lecture, thereby discovering on your own what needs to be done to fix your mistakes.
EMAIL WORK- TO bg201708@gmial.com
the email is g mail have to write it like this
Commuting time
high moderate low total under 15min9
5 18 32 15-45 min 17 8 28 53 over 45 min 18 6 7 31 total 44 19 53 116Explanation / Answer
since TS < critical value
we fail to reject the null and hence we conclude that stress level is independent of commuting time
YES
c1 c2 c3 sum r1 9 5 18 32 r2 17 8 28 53 r3 18 6 7 31 sum 44 19 53 116 Eij 1 2 3 expected 1 12.13793 5.241379 14.62069 2 20.10345 8.681034 24.21552 3 11.75862 5.077586 14.16379 0i 9 5 18 17 8 28 18 6 7 Ei 12.13793 5.241379 14.62069 20.10345 8.681034 24.21552 11.75862 5.077586 14.16379 (Oi-Ei)^2/Ei 0.811226 0.011116 0.781067 0.479092 0.053428 0.591452 3.312873 0.167569 3.623318 TS 9.831141 critical value 9.487729