VARP function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
VARP
Returns the population variance.
Syntax:
VARP(number1; number2; ... number30)
- number1 to number30 are up to 30 numbers or ranges containing numbers.
- VARP returns the standard deviation where number1 to number30 are the entire population. If you only have a sample of the population, use VAR instead. For a population of N values, the calculation formula is:
.
Example:
VARP(3; 3; 7; 7)
- returns 4.
Issues:
- Calc assumes that logical values are 1 (TRUE) and 0 (FALSE). Excel ignores logical values.
See Also
