Overview | Module | Use | Devguide | Index

Values | Values' Details

:: com :: sun :: star :: sheet ::
enum GeneralFunction
Description used to specify a function to be calculated from values.

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.

Top of Page

Copyright © 2003 Sun Microsystems, Inc.