The Iowa Energy are scheduled to play against the Maine RedClaws in an upcoming game in the National Basketball AssociationDevelopmental League (NBA-DL). Because a player in the NBA-DL isstill developing their skills, the number of points he scores in agame can vary. Assume that each player's point production can berepresented as an integer uniform variable with the ranges providedin the table below.
| Player | Iowa Energy | Maine Red Claws |
| 1 | [5, 20] | [7, 12] |
| 2 | [7, 20] | [15, 20] |
| 3 | [5, 10] | [10, 20] |
| 4 | [10, 40] | [15, 30] |
| 5 | [6, 20] | [5, 10] |
| 6 | [3, 10] | [1, 20] |
| 7 | [2, 5] | [1, 4] |
| 8 | [2, 4] | [2, 4] |
- Develop a spreadsheet model that simulates the points scored byeach team. What is the average and standard deviation of pointsscored by the Iowa Energy? If required, round your answer to onedecimal place.
Average =
Standard Deviation =
What is the shape of the distribution of points scored by the IowaEnergy?
- Right Skewed
- Triangle Shaped
- Bell Shaped
- Left Skewed
- What is the average and standard deviation of points scored bythe Maine Red Claws? If required, round your answer to one decimalplace.
Average =
Standard Deviation =
What is the shape of the distribution of points scored by the MaineRed Claws?
- Right Skewed
- Triangle Shaped
- Bell Shaped
- Left Skewed
- Let Point Differential = Iowa Energy points - Maine Red Clawpoints. What is the average point differential between the IowaEnergy and Maine Red Claws? If required, round your answer to onedecimal place.
Please answer using excel
