Answered step by step
Verified Expert Solution
Question
1 Approved Answer
6. In cell I31, find the relative frequency of playing 10 games. 7. In cell I32, find the number of games played that has the
6. | In cell I31, find the relative frequency of playing 10 games. | |
7. | In cell I32, find the number of "games played" that has the highest frequency. | |
8. | Highlight the frequency column (cells C7:C29) and select the Insert tab and theInsert Column or Bar Chart icon. Click on the first2-D Column icon. Move the column chart and resize it to fit in the range B34:F46. Add data labels and go toChart Tools tab and click in theDesign tab. Change theChart Style toStyle 9. Change the chart title to "Games Played per Player Frequency". |
xi | Frequency | Relative Frequency (Probability) | |
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 | |
Total | 210 | 1.0000 |
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