Simulation Analysis

Probabilistic simulation generates random values for input variables and calculates the resulting random values for output variables. In Excel, data tables can be used to track random values which are generated many times (iterations). This chapter simply randomizes the index values for input variables and focuses instead on different ways of tracking and analyzing the random output to identify patterns and relationships.