Owner manual
Example
Assume you have installed a temperature sensor in Cupertino, California. The sensor records each
day’s high and low temperatures. In addition, you have kept a record of each day you turned on the
air conditioner in your condo. The data from the rst few days is shown in the following table and is
used as a sample for the population of high and low temperatures (note that this is an example only;
this would not be statistically valid).
=STDEVA(B2:B13) returns 24.8271, the dispersion as measured by STDEVA, of the sample of daily high
temperatures.
It exceeds the actual range of high temperatures of 15 degrees because the “unavailable” temperature
is given a value of zero.
Related Topics
For related functions and additional information, see:
“STDEV” on page 290
“STDEVP” on page 293
“STDEVPA” on page 294
“VAR” on page 298
“VARA” on page 300
“VARP” on page 302
“VARPA” on page 303
“Survey Results Example” on page 362
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
292 Chapter 10 Statistical Functions