Manuals/calci/VARA
Jump to navigation
Jump to search
VARA(v1,v2,...)
Where v1,v2..are arguments.
This function returns variance based on a sample.
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 VARA
where x is the sample mean AVERAGE (v1,v2,…) and n is the sample size.
VARA
Lets see an example,
VARA(v1,v2....)
B
150
130
165
132
110
137
121
=VARA(B2:B8) is 330.67
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 150 | 330.666667 | ||
| Row2 | 130 | |||
| Row3 | 165 | |||
| Row4 | 132 | |||
| Row5 | 110 | |||
| Row6 | 137 | |||
| Row7 | 121 |
