VARPA

Description Returns the variance of a population based on the entire population of values.

This function is equivalent to the VARP function, but its implementation treats text and logical values in cell and range references differently.

Syntax VARPA ( number_list )

Argument Description

number_list A list of up to 30 arguments separated by commas. The list may contain numeric values, cell references, range references, or array constants.Text in cells referenced by this function is treated as the number 0 (this includes zero-length text). Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Text and logical values in arrays are ignored. Logical values referenced in cells or entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE.

Argument	Description
number_list	A list of up to 30 arguments separated by commas. The list may contain numeric values, cell references, range references, or array constants.Text in cells referenced by this function is treated as the number 0 (this includes zero-length text). Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Text and logical values in arrays are ignored. Logical values referenced in cells or entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE.

Example This function returns .26530612:

VARPA(4.0, 3.0, 3.0, 3.5, 2.5, 4.0, 3.5)

See Also STDEV, STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP