VoseFrequency

See also: VoseFrequencyCumulA, VoseFrequencyCumulD, Data Analysis window

VoseFrequency({dataset},{bins},label,relative)

 

 

Example model

Two column array function that returns a frequency or relative frequency analysis of a set of data. Note that the output array columns should be once cell larger than the array with bin values, because the function includes the frequency of data with values higher than the largest bin value.

  • Dataset - an array of values to be analyzed.

  • {bins} - ascending array of values defining the minimum value of each bin.

  • Label - optional boolean parameter (TRUE/FALSE). TRUE makes each returned column started with a label where the first cell of DataSet is interpreted as a label.

  • Relative - boolean parameter (TRUE/FALSE): TRUE (or any non-zero value) makes the function return relative frequencies.

Comment

Excel provides a FREQUENCY function that does much the same thing but it is difficult to interpret its output.

 

 

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
-->