ModelRisk database connectivity functions | Vose Software

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

 

Navigation