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