Apple iWork '09 User Manual
Page 292
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 first 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:
“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