Home : Products : Hach WIMS : Hach WIMS Client : Documentation : Function Reference : Spread Functions : Primitive Functions : VARS
Q14801 - INFO: VARS

VARS (Primitive Spread Function) calculates the sample variance (values represent a subset of the data, not the entire population)

SYNTAX:

VARS(Cell Range)

REMARKS:

The variance returns how spread out a set of data is.

The VARS function assumes that its arguments are  a subset of the data, not the entire population. If your data represents a sample of the population, then compute the variance using the VARP function.

The VARS function uses the following formula to calculate the variance: 

       

Where Xbar is the mean, n is number of values, and x are the individual values.                                                                                

EXAMPLES:

VARS(A1:A9)

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 7/30/2024 11:31 AM.
Last Modified on 7/30/2024 11:31 AM.
Last Modified by Scott Dorner.
Article has been viewed 421 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article