Continuous Fitted distribution

 

Format: ContinuousFit({data}, min, max, uncertainty)

 

Fits a non-parametric continuous (i.e. an  Ogive) distribution to data. Use the Uncertainty parameter to choose between a first-order non-parametric distribution and a second-order non-parametric distribution.

{data} - an array of spreadsheet data.

min - (optional) the lower bound of the fitted distribution. If omitted, the data minimum is chosen as lower bound.

max - (optional) the upper bound of the fitted distribution. If omitted, the data maximum is chosen as upper bound.

Uncertainty - (optional) boolean parameter (TRUE/FALSE). Set to TRUE to include second-order uncertainty about the fitted distribution itself. Set to FALSE (default) to use a "best-guess" distribution.

U - optional parameter specifying the cumulative percentile of the distribution. If omitted the function generates random values.

ModelRisk functions added to Microsoft Excel for the Continuous Fitted distribution

VoseContinuousFit generates random values from this distribution for Monte Carlo simulation, or calculates a percentile if used with a U parameter.

VoseContinuousFitProb returns the probability density or cumulative distribution function for this distribution.

VoseContinuousFitProb10 returns the log10 of the probability density or cumulative distribution function.  

 

 

ModelRisk

Monte Carlo simulation in Excel. Learn more

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Navigation

FREE MONTE CARLO SIMULATION SOFTWARE

For Microsoft Excel

Download your free copy of ModelRisk Basic today. Professional quality risk modeling software and no catches

Download ModelRisk Basic now

FREE PROJECT RISK SOFTWARE

For Primavera & Microsoft Project

Download your free copy of Tamara Basic today. Professional quality project risk software and no catches.

Download Tamara Basic now
-->