Manuals/calci/VAR
Jump to navigation
Jump to search
VAR(n1,n2,...)
Where n1,n2...are arguments.
This function calculates the variance based on a sample.
Arguments can be numbers or names, arrays, or references.
The logical values and the text representations of numbers are counted.
Use the VARA function, t to include logical values and text representations of numbers. ]
- The formula to find out VAR is:
where x is the sample mean average (n1,n2,…) and n is the sample size.
VAR
Lets see an example,
B
150
130
165
132
110
137
121
=VAR(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 |
