Question

Problem 16-09

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?
   
   
   
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?
   
   
   
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.
   
   
   
   What is the standard deviation in the point differential?
   
   
   
   What is the shape of the point differential distribution?
   
   
   
4. What is the probability of that the Iowa Energy scores more points than the Maine Red Claws? If required, round your answer to three decimal places.
   
   
   
5. The coach of the Iowa Energy feels that they are the underdog and is considering a "riskier" game strategy. The effect of the riskier game strategy is that the range of each Energy player's point production increases symmetrically so that the new range is [0, original upper bound + original lower bound]. For example, Energy player 1's range with the risky strategy is [0, 25]. How does the new strategy affect the average and standard deviation of the Energy point total?
   
   Average =
   
   Standard Deviation =
   
   Explain.
   
   The input in the box below will not be graded, but may be reviewed and considered by your instructor.
   
   
   
   How is the probability of the Iowa Energy scoring more points that the Maine Red Claws affected? If required, round your answer to three decimal places.
   
   Probability =
   
   Explain.
   
   The input in the box below will not be graded, but may be reviewed and considered by your instructor.
   

Answer 1

a)

The results obtained from the Analytic solver Platform for cell B15 are as shown below:

b)

The results obtained from the Analytic solver Platform for cell F15 are as shown below:

c)

The results obtained from the Analytic solver Platform for cell B19 are as shown below:

d)

The Iowa Energy has approximately a 0.40 probability of scoring more points than the Maine Red Claws

e)

The results obtained from the Analytic solver Platform for cell B15 are as shown below:

The probability of the Iowa Energy scoring more points than the Maine Red Claws increses to 0.44