Question: x i Frequency Relative Frequency (Probability) x i * P(x i ) x i - E(x) (x i - E(x))^2 (x i - E(x))^2* P(x)
| xi | Frequency | Relative Frequency (Probability) | xi* P(xi) | xi- E(x) | (xi- E(x))^2 | (xi- E(x))^2* P(x) |
| 1 | 13 | 0.0619 | ||||
| 2 | 12 | 0.0571 | ||||
| 3 | 9 | 0.0429 | ||||
| 4 | 15 | 0.0714 | ||||
| 5 | 32 | 0.1524 | ||||
| 6 | 24 | 0.1143 | ||||
| 7 | 21 | 0.1000 | ||||
| 8 | 5 | 0.0238 | ||||
| 9 | 11 | 0.0524 | ||||
| 10 | 17 | 0.0810 | ||||
| 11 | 11 | 0.0524 | ||||
| 12 | 1 | 0.0048 | ||||
| 13 | 2 | 0.0095 | ||||
| 14 | 1 | 0.0048 | ||||
| 15 | 4 | 0.0190 | ||||
| 16 | 0 | 0.0000 | ||||
| 17 | 10 | 0.0476 | ||||
| 18 | 2 | 0.0095 | ||||
| 19 | 8 | 0.0381 | ||||
| 20 | 2 | 0.0095 | ||||
| 21 | 6 | 0.0286 | ||||
| 22 | 4 | 0.0190 | ||||
| 12. | In cell I72, find the expected frequency (average) using the data ranges B49:B70 and D49:D70. | ||
| 13. | In cells F49:F70, find xi- E(x). | ||
| 14. | In cells G49:G70, square the values in cells F49:F70. |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
