Welcome to Kovach Computing Services. This website uses 'cookies' to give you the best, most relevant experience. Using this website means you’re Ok with this. You can find out more about them, and find out how to opt out of their use, by following this link (or by clicking the 'Privacy' link at the top of any page).

XLSTAT-Sim

Tutorial
View tutorial
s
XLSTAT-Sim is a module for XLSTAT-Pro that allows you to create models with assessed risk in Microsoft Excel and uses simulation methods such as Monte Carlo and Latin Hypercubes simulations to estimate the distribution (including confidence intervals) of important variables.

XLSTAT-Sim module is a key decision making tool for people working on statistical risk analysis of models which may contain uncertain values. These 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 produce in mere seconds, an estimated distribution of the revenue, its median, average and a 95% confidence interval.

Dialog

Graph

The simulation methods available in XLSTAT-Sim are Monte Carlo and Latin Hypercubes.

Demo version

A trial version of XLSTAT-Sim is included in the main XLSTAT-Pro download.

Prices and ordering

For prices, on-line ordering and other purchasing information please go to our ordering page.

Copyright © 2013 Kovach Computing Services, Anglesey, Wales. All Rights Reserved. Portions copyright Addinsoft and Provalis Research.

Last modified 5 April, 2013

 
1 August, 2011