Model Simulation using Data Tables

Mean: ${{mean:Decimal;#,##0.00}}           Standard Deviation: ${{stddev:Decimal;#,##0.00}}

This demo application uses Excel’s Data Tables feature to simulate a financial model for calculating premiums on a life insurance product. It performs 1,000 simulations by varying the Policy Amount through an inverse normal distribution with the NORMINV function in Excel. The resulting premiums are then displayed in a histogram.

You can generate a new set of 1,000 simulations by adjusting any of the variables and clicking the Run Simulations button.