ModelRisk database connectivity functions

See also: VoseDataObject,Data Object

Example model

ModelRisk offers a number of database connectivity functions that take a VoseDataObject as a parameter and return different properties of the referenced data.

Depending on the number of data columns that the VoseDataObject is referencing, the functions below will return a single (if number of data columns = 1) or multiple (one value per each column of data) values.

VoseDataMean(DataObject)

    Returns the mean value of each data column

VoseDataStdev(DataObject)

    Returns the standard deviation of each data column

VoseDataVariance(DataObject)

    Returns the variance of each data column

VoseDataSkewness(DataObject)

    Returns the skewness of each data column

VoseDataKurtosis(DataObject)

    Returns the kurtosis of each data column

VoseDataCofV(DataObject)

    Returns the coefficient of variance of each data column

VoseDataMin(DataObject)

    Returns the minimum value of each data column

VoseDataMax(DataObject)

    Returns the maximum value of each data column

VoseDataMoments(DataObject)

    Returns the mean, variance, skewness and kurtosis of each data column

VoseDataRawMoments(DataObject)

    Returns 4 raw moments of each data column

VoseDataPercentile(DataObject,Percentile)

    Returns the percentile value of each data column

VoseDataProbability({x},DataObject,Cumulative)

    Returns the probability mass (if Cumulative = FALSE) or cumulative probability (if Cumulative = TRUE) for an array of x-values for each data column

VoseDataRow(DataObject, Row)

    Returns data array from the given row

VoseDataRowCount(DataObject)

    Returns the number of rows in the referenced data

VoseDataRowLabel(DataObject)

    Returns the array of labels for the referenced data

VoseDataSample(DataObject)

    Returns a randomly sampled value from each data column

 

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