Recreate the simulation presented in the "Performing Monte Carlo Simulation" section from the

Recreate the simulation presented in the "Performing Monte Carlo Simulation" section from the Lynda.com庐 video, "Up and Running with Excel What-If Analysis with Curt Frye.

Create an Excel庐 spreadsheet simulating the method.

To simulate a free throw, we use a random draw in an IF statement.  Scroll down to see how.

The random draw uses the formula, "=RANDOM()", to get a uniformly distributed number in the 0,1 interval.

Click in cell B5 to see the formula.  Hit F9 (or CTRL - =) to draw a new number.  For more on random number generation, see sections 9.2 and 9.3.

Question:

"I noticed that sometimes he misses in cell B23, but makes it in cells C18 through D19. What's going on?"

Question:

"Sometimes I see the word "Calculate" at the bottom of the screen.  What does that mean?"