Question: 9-11. Copy the range C8:D29 to the range C49:D70. In cells E49:E70, construct a column to find x i *P(x i ). In cell E71,
| 9-11. | Copy the range C8:D29 to the range C49:D70. In cells E49:E70, construct a column to find xi*P(xi). In cell E71, add up the data in the range E49:E70 to find the expected frequency (average) of games played per player. | |||||||
| 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 | ||||||
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
