beautypg.com

Apple iWork '09 User Manual

Page 301

background image

Chapter 10

Statistical Functions

301

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).

=VARA(B2:B13) returns 616.3864, the dispersion as measured by VARA, 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

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

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

“Pasting from Examples in Help” on page 41