* Please complete in excel and include formulas as well, thank you!

MgtOp 470-Business Modeling with Spreadsheets Practice What You've Learned After Class, January 24, 2023 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 3% The Saints win, but they're so afraid to face Tom Brady that they forfeit the Super Bowl 2% Create a simple simulation model that generates a random probability and uses embedded IF statements to return the proper event for the given probability. To clarify, have the program generate a single random number into a specific cell (A6). In cell A7, enter single formula containing embedded IF statements that refer to the resulting number in cell A6. Also, rather than typing each event into the big formula, it would be better to enter each event into four separate cells (A1:A4) and then have the IF functions cell-reference the appropriate events. Calculation Hint: The second event will occur for probabilities between 80% and 95%. So the first IF condition could test if the probability is