Question

The Iowa Energy are scheduled to play against the Maine Red Claws in an upcoming game in the National Basketball Association Developmental League (NBA-DL). Because a player in the NBA-DL is still developing their skills, the number of points he scores in a game can vary. Assume that each player's point production can be represented as an integer uniform variable with the ranges provided in 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]

1. Develop a spreadsheet model that simulates the points scored by each team. What is the average and standard deviation of points scored by the Iowa Energy? If required, round your answer to one decimal place.
   
   Average =
   
   Standard Deviation =
   
   What is the shape of the distribution of points scored by the Iowa Energy?
   
   
   • Right Skewed
   • Triangle Shaped
   • Bell Shaped
   • Left Skewed
   
   
2. What is the average and standard deviation of points scored by the Maine Red Claws? If required, round your answer to one decimal place.
   
   Average =
   
   Standard Deviation =
   
   What is the shape of the distribution of points scored by the Maine Red Claws?
   
   
   • Right Skewed
   • Triangle Shaped
   • Bell Shaped
   • Left Skewed
   
   
3. Let Point Differential = Iowa Energy points - Maine Red Claw points. What is the average point differential between the Iowa Energy and Maine Red Claws? If required, round your answer to one decimal place.
   

Please answer using excel

Answer 1