Performing Simple Probabilistic Simulations in Microsoft® Excel

Chapter 5, Printout 1


  1. Launch Excel.

  2. Enter the variables and simulate random data.

    Excel generates random values for the variables.

    Screenshot: screenshot

  3. Simulate Efficiency.

    Excel fills cells I2-I101 with simulated efficiency values.

    Screenshot: screenshot

  4. Display descriptive statistics of Efficiency.

    Excel computes descriptive statistics for Efficiency and displays them in cells K1-L15.

    Screenshot: screenshot