beautypg.com

Apple iWork '09 User Manual

Page 251

background image

Chapter 10

Statistical Functions

251

Example

In this example, the COVAR function is used to determine how closely related the price of heating oil
(column A) is to the temperature that this hypothetical homeowner has set on the thermostat.

=COVAR(A2:A11, B2:B11) evaluates to approximately -1.6202, indicating a correlation (as prices rose,
the thermostat was lowered).

Related Topics
For related functions and additional information, see:

“CORREL” on page 242

“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