Question: I have no idea what formula do I need to put in the D2-D5. Practice What You've Learned In Class, Jan. 28, 2020 On Sunday,

I have no idea what formula do I need to put in the D2-D5. I have no idea what formula do I need to put in

I have no idea what formula do I need to put in

Practice What You've Learned In Class, Jan. 28, 2020 On Sunday, Jan. 20, 2019, we witnessed the worst non-call in the history of professional football. The Los Angeles Rams should have been called for pass interference with less than two minutes to go near their end zone. Most fans assume that, had the penalty been properly called, the New Orleans Saints would have run the clock down to a few seconds left, kicked an easy field goal, and moved on to the Super Bowl. Instead, they had to kick the field goal immediately, which allowed the Rams time to march down the field, tie the game, and eventually win it in overtime. However, we don't know for sure that the Saints would have won following a proper penalty call. After careful analysis and consultation with ESPN and a world-renowned psychic, the following outcomes and probabilities have been determined: Event Saints run out the clock, kick the field goal, and win 80% Saints fumble on the next play, and the Rams run it into the end zone for the victory 15% The field goal is blocked, and the Rams still win in overtime The Saints win, but they're so afraid to face Tom Brady that they forfeit the Super Bowl 2% 3% Create a simple simulation model that generates a random probability and uses embedded IF statements to return the proper event for the given probability. Hint: The second event will occur for probabilities between 80% and 95%. So the first IF condition could test if the probability is

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!