Solve using native excel functionalities please, not the analytic solver platform!

(All answers were generated using 1,000 trials and native Excel functionality.) The Iowa Energy are scheduled to play against the Maine Red Claws in an upcoming game in the substantially. Assume that each player's point production can be represented as an integer uniform 1 2 3 4 Player lowa Energy Maine Red Claws [5,20] [7,12] [7,20] (15,20] [5,10] (10,20] (10,40] (15,30] [6,20] [5,10] (3,10] [1,20] [2,5] [1,4] [2,4] [2,4] Develop a spreadsheet model that simulates the points scored by each team and the difference in 5 6 7 8 (a) What are the average and standard deviation of points scored by the Iowa Energy? Round your answers to one decimal place. Average: 84.5 Standard Deviation: 12.1 What is the shape of the distribution of points scored by the Iowa Energy? Bell-shaped, symmetric (b) What are the average and standard deviation of points scored by the Maine Red Claws? Round your answers to one decimal place. Average: Standard Deviation: What is the shape of the distribution of points scored by the Maine Red Claws? Select your answer - (All answers were generated using 1,000 trials and native Excel functionality.) The Iowa Energy are scheduled to play against the Maine Red Claws in an upcoming game in the substantially. Assume that each player's point production can be represented as an integer uniform 1 2 3 4 Player lowa Energy Maine Red Claws [5,20] [7,12] [7,20] (15,20] [5,10] (10,20] (10,40] (15,30] [6,20] [5,10] (3,10] [1,20] [2,5] [1,4] [2,4] [2,4] Develop a spreadsheet model that simulates the points scored by each team and the difference in 5 6 7 8 (a) What are the average and standard deviation of points scored by the Iowa Energy? Round your answers to one decimal place. Average: 84.5 Standard Deviation: 12.1 What is the shape of the distribution of points scored by the Iowa Energy? Bell-shaped, symmetric (b) What are the average and standard deviation of points scored by the Maine Red Claws? Round your answers to one decimal place. Average: Standard Deviation: What is the shape of the distribution of points scored by the Maine Red Claws? Select your