VARA
Syntax:
VARA ( argument-list )
VARA
assumes that its arguments are a sample of the population. If the data represents the entire population, VARPA
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 VAR
instead. 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 samples of the population. Logical values and text representations of numbers that are entered directly into the list of arguments are included. Arguments that contain |
Return Type and Value: number – An estimate of the variance based on a sample.