14. Using a quarter, simulate two complete NFL seasons under conditions of ideal competitive balance. Report your result

[answerhappygod]

14 Using A Quarter Simulate Two Complete Nfl Seasons Under Conditions Of Ideal Competitive Balance Report Your Result 1 (49.91 KiB) Viewed 26 times

14. Using a quarter, simulate two complete NFL seasons under conditions of ideal competitive balance. Report your result as a Win-Loss sequence of the form L.L,L,W,W, W. L.W.W.W.L.L.W.W.L.L. (see how easy that was?) How much do your simulated win percentages deviate from 50%? Finally, make an Excel spreadsheet that automates the simulation of an ideal NFL season. Coin nipis sacred a. Extension: use a dice to physically simulate an NFL season of a team whose ex-ante probability of winning any given game is exactly two- thirds. b. Extension: modify your Excel spreadsheet so that it can simulate an NFL season using a user-specified win probability (p). That is, there should be a special cell, marked "Game Win Probability," that lets the user try different values like 0.5,2/3, etc. If this seems hard, start Googling) Test: when p is close to 100%, your simulated seasons should be almost all wins, and when p is close to 0%, your simulated seasons should be almost all losses c. Extension: using only a quarter, physically simulate an NFL season of a team whose ex- ante probability of winning any given game is five-eighths. (Hint: this needs forty-eight flips).