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
Get step-by-step solutions from verified subject matter experts
