Formulas and Functions

Chapter 10 Statistical Functions 243
CORREL(y-values, x-values)
 y-values: The collection containing the y (dependent) values. y-values is a collection
that can contain number, date/time, or duration values. All values must be of the
same type.
 x-values: The collection containing the x (independent) values. x-values is a
collection that can contain number, date/time, or duration values. All values must be
of the same type.
Usage Notes
 y-values and x-values must have the same dimensions.
If text or Boolean values are included in the collections, they are ignored. Â
Example
In this example, the CORREL 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.
=CORREL(A2:A11, B2:B11) evaluates to approximately -0.9076, indicating a close correlation (as prices
rose, the thermostat was lowered).
Related Topics
For related functions and additional information, see:
“COVAR” on page 250
“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