Computes the variance of the specified arguments.
Syntax
 Copy Code
|
|---|
VARP( Number n1, Number n2, ... ) → Number |
Parameters
- n1
n2
… - Two or more numbers representing the set.
Remarks
The arguments can be either numbers or cells, ranges, or arrays that contain numbers. Logical values, text, and empty cells are ignored. If the specified arguments contain only a single number, the function returns #DIV/0!.
Example
| Formula
Copy Code
|
|---|
=VARP({1245;1201;1268;1222;1211}) |
See Also
Function Reference
VAR Function
STDEVP Function
AVERAGE Function