beautypg.com

Apple iWork '09 User Manual

Page 304

background image

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.

=VARPA(B2:B13) returns 565.0208, the dispersion as measured by VARPA, of the sample of daily high
temperatures.

Related Topics
For related functions and additional information, see:

“STDEV” on page 290

“STDEVA” on page 291

“STDEVP” on page 293

“STDEVPA” on page 294

VAR” on page 298

VARA” on page 300

VARP” on page 302

“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

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

304

Chapter 10

Statistical Functions