Manuals/calci/VARPA

VARPA(n1,n2,n3…)

• $n1,n2,n3,...$ are numbers.

Description

• This function gives the variance based on the entire population.
• Variance is a measure of dispersion obtained by taking the mean of the squared deviations of the observed values from their mean in a frequency distribution.
• i.e.,variance is a measure of how far each value in the data set is from the mean.
• It is denoted by $\sigma$. The square root of variance is called the standard deviation.
• In $VARPA(n1,n2,n3,...)$, $n1,n2,n3,...$are numbers based on a population. Here $n_{1}$ is required.$n2,n3,...$ are optional.
• To find the variance we can use the following formula:

$Variance={\frac {\sum (x_{i}-{\bar {x}})^{2}}{n-1}}$ where ${\bar {x}}$ is the sample mean of $x_{i}$ and $n$ is the sample size.

• Suppose $\sigma =0$ which is indicating all the values are identical.
• When $\sigma$ is non-zero then it is always positive.
• This function is considering our given data is the entire population.
• Suppose it should consider the data as the sample of the population, we can use the VARA function.
• The arguments can be either numbers or names, array,constants or references that contain numbers.
• Also we can give the text representations of numbers or logical values , like TRUE or FALSE, in a reference.
• Suppose the arguments containing TRUE which is evaluate as 1, and the arguments containing FALSE which is evaluate as 0.
• Suppose the array contains the empty cells and text values like that values are not considered.
• Suppose the function don't want to consider the logical values and text representations of numbers in a reference , we can use the VARP function.
• This function will return the result as error when

     1. Any one of the argument is non-numeric. 
     2. The arguments containing the error values or text that cannot be translated in to numbers. 

Examples

Spreadsheet

	A	B	C	D	E	F
1	40	45	60	24	72	81
2	10.21	11.65	17.81	15.02	18.18	27.41

1. =VARP(A1:F1) = 377.555555556
2. =VARP(A1:F2) = 31.4284222222
3. =VARPA(12,23,34,45,true) = 242
4. =VARPA(12,23,34,45,FALSE) = 151.25(CALCI)

See Also

• DVAR
• DVARP
• VARP
• VAR