STDEVA
Syntax:
STDEVA ( argument-list )
Description: Makes an estimate of the standard deviation based on a sample, using the "unbiased" or "n-1" method.
Note: :
STDEVA
assumes that its arguments are a sample of the population. If the data represents the entire population, STDEVPA
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 STDEV
instead. Mathematical Formula:
where x is the sample mean AVERAGE(
argument-1,
argument-2,…,
argument-n)
and n is the sample size.
Arguments:
Name |
Type |
Description |
---|---|---|
argument-list |
logical, number, name, text, array, reference. The argument list can also be an array of numbers. |
The arguments in argument-list designate the numbers that are samples of the population. Arguments that contain |
Return Type and Value: number – An estimate of the standard deviation based on a sample.
example: