no psi functions. please show work and formulas in excel. thank you. will upvote and post positive comment if correct.

Problem #4: The NBA-DL The lowa Energy of the National Basketball Association Developmental League (NBA-DL) are scheduled to play against the Maine Red Claws in an upcoming game. Because a player in the NBA- DL is still developing his skills, the number of points he scores in a game can vary dramatically. Assume that each player's point production can be represented as an integer uniform variable with the ranges provided in the table below. Player lowa Energy Maine Red Claws 1 15.20 [7.12) 2 17.20 [15.20 3 15, 109 [10,201 [10.40) [15.30) 5 18.20 15. 10) 6 13.10 [1.20 12.5 11.4 7 8 12.4 12.4 a) Develop a spreadsheet model that simulates the points scored by each team. b) What is the average and standard deviation of points scored by the lowa Energy? What is the shape of the distribution of points scored by the lowa Energy? c) What are the average and standard deviation of points scored by the Maine Red Claws? What is the shape of the distribution of points scored by the Maine Red Claws? d) Let Point Differential=lowa Energy points-Maine Red Claw points. What is the average point differential between the lowa Energy and Maine Red Claws? What is the standard deviation in the point differential? What is the shape of the point differential distribution? e) What is the probability of that the lowa Energy scores more points than the Maine Red Claws? f) The coach of the lowa 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? How is the probability of the lowa Energy scoring more points that the Maine Red Claws affected