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