Continuous Fitted distribution | Vose Software

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

Spreadsheet risk analysis modeling

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Project risk analysis

Navigation

Enterprise Risk Management software (ERM)

Learn more about our enterprise risk analysis management software tool, Pelican

Enterprise risk management software introduction