Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started