Apple iWork '09 - Manual (Page 295)

Chapter 10 Statistical Functions 295
The standard deviation is the square root of the variance returned by the VARPA Â
function.
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 sensor failed after the first few days so the following table is the
population of high and low temperatures.
=STDEVPA(B2:B13) returns 23.7702, the dispersion as measured by STDEVPA, 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
“STDEVA” on page 291
“STDEVP” on page 293
“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