SimResults
The XLRisk simulation results are discussed here in the context of the worked example. The simulation results sheet named "Risk Results 1" contains the following:
Input cells are the cells containing risk distribution functions. The first columns of the results sheet under the heading "Inputs" contain the sampled values of the input cell for each iteration. The cell address and the formula of each input cell are displayed at the top of each column.
The value of each output cell is stored in each iteration. The columns under the heading "Outputs" contain the calculated values of the output cells for each iteration. The cell address and output name are displayed at the top of each column.
For each output cell, a range of statistics are displayed including the mean, the standard deviation etc.
In addition the percentiles of the distributions of the output cells are displayed from 0% to 100% by 5%.
PERCENTRANK is an Excel function that calculates the proportion of the values of a specified range tha lie below a given range. Below the percentiles you can perform such a calculation for the output distributions. For example you may want to know the proportion of the iterations that resulted in negative NPV. If you click on the first cell with a thick outside border (Output cell) you can select the NPV cell Sheet1!$F$13 from the drop down list. Then, in the second cell with thick borders (Value) type 0. In the result you will see a value close to 15.7% which an estimate of the probability of negative NPV.
For each output cell a cumulative distribution is created as the one below for the NPV.
In addition and if you have Excel 16 or later, for each output cell a histogram is created as the one below for the NPV. You may want to manually adjust the number format of the X-axis (bins).
