Name | Description | |
---|---|---|
![]() | Aggregate | Gets or sets a predefined aggregate function. |
![]() ![]() | Average | Returns the average value of the non-null cells in the group. |
![]() | Caption | Gets or sets a formatted string to convert the value to string. |
![]() ![]() | Count | Returns the count of non-null values in the group. |
![]() | IsNumeric | Gets whether the function is needs numeric values to be computed. |
![]() ![]() | Maximum | Returns the maximum value in the group. |
![]() ![]() | Minimum | Returns the minimum value in the group. |
![]() ![]() | Range | Returns the difference between the maximum and minimum values in the group. |
![]() ![]() | Std | Returns the sample standard deviation of the values in the group (uses the formula based on n-1). |
![]() ![]() | StdPop | Returns the population standard deviation of the values in the group (uses the formula based on n). |
![]() ![]() | Sum | Returns the sum of all values in the group. |
![]() ![]() | Var | Returns the sample variance of the values in the group (uses the formula based on n-1). |
![]() ![]() | VarPop | Returns the population variance of the values in the group (uses the formula based on n). |