I need to show my work for my answers so I just need the process of arriving to the answers shown. For instance, the instructions ask for a spread sheet on question #1, as well as #2.

#1

---> Show your work. Create a spreadsheet.

(d) Let Point Differential = Iowa Energy points - Maine Red Claw points. (Round your answers to one decimal place.) What is the average point differential between the Iowa Energy and Maine Red Claws? 3.6 -3.6 What is the standard deviation in the point differential? 14.9 14.9 What is the shape of the point differential distribution? O uniform bell-shaped O skewed left O skewed right (e) What is the probability that the Iowa Energy scores more points than the Maine Red Claws? (Round your answer to three decimal places.) 0.3887 0.3887 (f) 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? How is the probability of the Iowa Energy scoring more points that the Maine Red Claws affected? The average Iowa Energy point total remains the same v remains the same , and the standard deviation of the Energy point total |increases v . increases . The probability of the Iowa Energy scoring more points than the Maine Red Claws |increases v increases Show your work. Upload your spreadsheet. (Submit a file with a maximum size of 1 MB.)The wedding date for a couple is quickly approaching, and the wedding planner must provide the caterer an estimate of how many people will attend the reception so that the appropriate quantity of food is prepared for the buffet. The following table contains information on the number of RSVP guests for the 145 invitations. Unfortunately, the number of guests does not always correspond to the number of RSVPed guests. Based on her experience, the wedding planner knows it is extremely rare for guests to attend a wedding if they notified that they will not be attending. Therefore, the wedding planner will assume that no one from these 50 invitations will attend. The wedding planner estimates that the each of the 25 guests planning to come solo has a 75% chance of attending alone, a 20% chance of not attending, and a 5% chance of bringing a companion. For each of the 60 RSVPs who plan to bring a companion, there is a 90% chance that she or he will attend with a companion, a 5% chance of attending solo, and a 5% chance of not attending at all. For the 10 people who have not responded, the wedding planner assumes that there is an 80% chance that each will not attend, a 15% chance each will attend alone, and a 5% chance each will attend with a companion. RSVPed Guests Number of Invitations 0 50 1 25 2 60 No response 10 (a) Assist the wedding planner by constructing a spreadsheet simulation model to determine the expected number of guests who will attend the reception. (Use at least 1,000 trials. Round your answer to two decimal places.) expected number of guests: 134.74 134.74 (b) To be accommodating hosts, the couple has instructed the wedding planner to use the Monte Carlo simulation model to determine X, the minimum number of guests for which the caterer should prepare the meal, so that there is at least a 90% chance that the actual attendance is less than or equal to X. What is the best estimate for the value of X? P(X S 140 140 ) = 89.3% and P(X s |141 141 ) = 91.6%. So |141 141 guests would be a relatively safe number on which to base meal preparations. Show your work. Upload your spreadsheet. (Submit a file with a maximum size of 1 MB.)The Iowa Energy of the National Basketball Association Developmental League (NBADL) 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 Iowa Energy Maine Red Claws 1 [5, 20] [7, 12] 2 [7, 20 [15, 20] [5, 10] [10, 20] A [10, 40] [15, 30] 5 [6, 20] [5, 10] [3, 10] [1, 20] [2, 51 [1, 4] [2, 4] [2, 4] (a) Develop a spreadsheet model that simulates the points scored by each team. (b) Consider the points scored by the Iowa Energy team. (Round your answers to one decimal place.) What is the average of points scored? B4.4 $ 84.4 What is the standard deviation? 12.2 12.2 What is the shape of the distribution? O uniform bell-shaped O skewed left O skewed right (c) Consider the points scored by the Maine Red Claws. (Round your answers to one decimal place.) What is the average of points scored? BB.1 88.1 What is the standard deviation? 8.7 1 9 8.7 What is the shape of the distribution? O uniform bell-shaped O skewed left O skewed right