VARPA

Syntax:

VARPA ( argument-list )

Description: Makes the variance of an entire population. [Note: VARPA assumes that its arguments are the total population. If the data represents a population sample only, VARA should be used instead. If logical values and text representations of numbers in a reference are to be excluded as part of the calculation, use VARP instead. end note]

Mathematical Formula:

where x is the sample mean AVERAGE(argument-1, argument-1,…, argument-n) and n is the sample size.

Arguments:

Name	Type	Description
argument-list	logical, number, name, text, array, reference	The arguments in argument-list designate the numbers that are the members of the population.

 

Return Type and Value: number – The variance of an entire population.

Arguments can be numbers; names, arrays, or references that contain numbers; text representations of numbers; or logical values, in a reference. Text representations of numbers that are entered directly into the list of arguments are included. Arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as zero. If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.

[Example:

VARPA(1202,1220,1323,1254,1302) results in 2146.56

end example]