Values |
NONE |
nothing is calculated.
|
AUTO |
function is determined automatically.
|
SUM |
sum of all numerical values is calculated.
|
COUNT |
all values, including non-numerical values, are counted.
|
AVERAGE |
average of all numerical values is calculated.
|
MAX |
maximum value of all numerical values is calculated.
|
MIN |
minimum value of all numerical values is calculated.
|
PRODUCT |
product of all numerical values is calculated.
|
COUNTNUMS |
numerical values are counted.
|
STDEV |
standard deviation is calculated based on a sample.
|
STDEVP |
standard deviation is calculated based on the entire population.
|
VAR |
variance is calculated based on a sample.
|
VARP |
variance is calculated based on the entire population.
|
Values' Details |
NONE
NONE,
- Description
- nothing is calculated.
|
|
AUTO
AUTO,
- Description
- function is determined automatically.
If the values are all numerical, SUM is used, otherwise COUNT.
|
|
SUM
SUM,
- Description
- sum of all numerical values is calculated.
|
|
COUNT
COUNT,
- Description
- all values, including non-numerical values, are counted.
|
|
AVERAGE
AVERAGE,
- Description
- average of all numerical values is calculated.
|
|
MAX
MAX,
- Description
- maximum value of all numerical values is calculated.
|
|
MIN
MIN,
- Description
- minimum value of all numerical values is calculated.
|
|
PRODUCT
PRODUCT,
- Description
- product of all numerical values is calculated.
|
|
COUNTNUMS
COUNTNUMS,
- Description
- numerical values are counted.
|
|
STDEV
STDEV,
- Description
- standard deviation is calculated based on a sample.
|
|
STDEVP
STDEVP,
- Description
- standard deviation is calculated based on the entire population.
|
|
VAR
VAR,
- Description
- variance is calculated based on a sample.
|
|
VARP
VARP,
- Description
- variance is calculated based on the entire population.
|
|
Copyright © 2000, 2012 LibreOffice contributors and/or their affiliates. All rights reserved.
LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.
The Document Foundation acknowledges all community members, please find more info at our website.