Statistical Functions

All Scripting can now reference the following array based functions:

StdDev(Array of Double) - Returns the sample standard deviation for elements in an array.

Mean(Array of Double) - Returns the average of all values in an array.

Sum(Array of Double) - Returns the sum of the elements in an array.

SumInt(Array of Integer) - Returns the sum of the elements in an integer array.

SumOfSquares(Array of Double) - Returns the sum of the squared values from a data array.

MinValue(Array of Double) - Returns smallest signed value in an array.

MinIntValue(Array of Integer) - Returns the smallest signed value in an integer array.

MeanAndStdDev(Array of Double, Mean, StdDev) - Calculates the mean and standard deviation of array elements. 1st Parameters is the Array of Numbers, 2nd and 3rd parameters are values that will be passed in and then set as the result of the function.

PopnStdDev(Array of Double) - Calculates the population standard deviation.

Variance(Array of Double) - Calculates statistical sample variance from an array of data. Calculates the sample variance of all values in the Data array parameter, using the n-1 method (unbiased)

PopnVariance(Array of Double) - Calculates the population variance.

TotalVariance(Array of Double) - Calculates the population variance.

Norm(Array of Double) - Returns the Euclidean 'L-2' norm.

Poly**(X : Double, Array of Double)** - Evaluates a uniform polynomial of one variable at the value X. Evaluates the polynomial represented by the Coefficients parameter at the point where the variable equals the value of the X parameter. The coefficients are ordered in increasing powers of X.

SumsAndSquares(Array of Double, Sum, SumOfSquares) - Returns the sum of the values and the sum of the squared values in an array. 1st Parameters is the Array of Numbers, 2nd and 3rd parameters are values that will be passed in and then set as the result of the function.

MomentSkewKurtosis(Array of Double, M1, M2, M3, M4, Skew, Kurtosis) - Calculates the mean, variance, skew, and kurtosis. Calculates the core factors of statistical analysis: the first four moments plus the coefficients of skew and kurtosis. 1st Parameters is the Array of Numbers, 2nd-7th parameters are values that will be passed in and then set as the result of the function.

**InternalRateOfReturn(**Guess, Array of Double) - Determines the internal rate of return on an investment. It references an array that contains cash flow information and uses the supplied internal rate of return estimate to calculate results.

NetPresentValue(Rate,CashFlows Array of Double; PaymentTime - 0 or 1 - 0=EndOfPeriod 1=StartOfPeriod) - Ccalculates the current value of an array of estimated cash flow values, discounted at the given interest rate of Rate.