Statistical Spreadsheet Functions

Statistical Spreadsheet Functions

All of the arguments of these functions (x, y, z, s, and w) are expressions. Series and array subranges are allowed in any argument requiring a series or array (without subscripts).

DPL Excel Action
@avg(x,y,z,...)AVERAGE(x,y,z,...) The average of the non-empty (non-null) expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@count(x,y,z,...)COUNT(x,y,z,...) The number of non-empty (non-null) expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@max(x,y,z,...)MAX(x,y,z,...) The maximum of the expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@min(x,y,z,...)MIN(x,y,z,...) The minimum of the expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@std(x,y,z,...)STDEV(x,y,z,...) The standard deviation of the non-empty expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@sum(x,y,z,...)SUM(x,y,z,...) The sum of the expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@var(x,y,z,...)VAR(x,y,z,...) The variance of the non-empty (non-null) expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@sumproduct(array1, array2, array3,...)SUMPRODUCT(array1, array2, array3,...) Multiplies corresponding components in the given arrays, and returns the sum of those products.

DPL treats null elements in the argument list in the same way a spreadsheet treats empty (null) cells. For instance, the @count() function will count the number of elements in an argument list, but will omit null elements from the count.

Notes: This information is subject to change. New functions are added from time to time. Contact technical support for the latest compatibility information.

Versions: DPL Professional, DPL Enterprise, DPL Portfolio

See Also

Spreadsheet Functions