|
XLSTAT-Sim is a module that allows you to create models in Excel and use simulation methods to estimate the distribution (including confidence intervals) of some important variables.
This module is key for people working on models for which all values are not known with certainty. The uncertainties can be expressed through more than 30 distributions.
For example, in a financial model for establishing a budget, the sales volume of a product is not certain, but we can estimate that it should be between two bounds, A and B, with a most likely value M. This can be statistically represented by a triangular distribution. The total revenue for all products is a sum of triangular distributions. XLSTAT-Sim can get in a few seconds, an estimated distribution of the revenue, its median, average and a 95% confidence interval.
The simulation methods available in XLSTAT-Sim are Monte Carlo and Latin Hypercubes.
|
