Manuals/calci/VARP
Jump to navigation
Jump to search
VARP(v1,v2,...)
Where v1,v2..are arguments.
This function calculates 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. In this, the arguments that contain TRUE evaluate as 1; and that contain text or FALSE evaluate as 0 (zero). Empty cells and text values are ignored.
- To calculate VARP
where x is the sample mean AVERAGE (v1,v2,…) and n is the sample size.
VARP
Lets see an example,
VARP(v1,v2....)
B
150
130
165
132
110
137
121
=VARP(B2:B8) is 283.428571
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 150 | 283.428571 | ||
| Row2 | 130 | |||
| Row3 | 165 | |||
| Row4 | 132 | |||
| Row5 | 110 | |||
| Row6 | 137 | |||
| Row7 | 121 |
