Manuals/calci/VARPA
Jump to navigation
Jump to search
VARPA(v1,v2,...)
Where v1,v2...are arguments
This function returns the variance based on the entire population.
The Arguments can be numbers or names, arrays, or references.
Logical values and text representations of numbers are calculated.
Here an Arguments contain TRUE, then that calculate as 1; and that contain FALSE evaluate as 0 (zero).
- The equation for VARPA is :
where x is the sample mean AVERAGE(v1,v2,…) and n is the sample size.
VARPA
Lets see an example,
VARPA(v1,v2....)
B
150
130
165
132
110
137
121
=VARPA(B2:B8) is 283.43
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 150 | 283.428571 | ||
| Row2 | 130 | |||
| Row3 | 165 | |||
| Row4 | 132 | |||
| Row5 | 110 | |||
| Row6 | 137 | |||
| Row7 | 121 |
