Formulas and Functions

Related Topics
For related functions and additional information, see:
“COUNT” on page 244
“COUNTA” on page 245
“COUNTBLANK” on page 246
“COUNTIF” on page 247
“Specifying Conditions and Using Wildcards” on page 360
“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
COVAR
The COVAR function returns the covariance of two collections.
COVAR(sample-1-values, sample-2-values)
 sample-1-values: The collection containing the rst collection of sample values.
sample-1-values is a collection containing number values.
 sample-2-values: The collection containing the second collection of sample values.
sample-2-values is a collection containing number values.
Usage Notes
The two arrays must have the same dimensions. Â
If text or Boolean values are included within the arrays, they are ignored. Â
If the two collections are identical, the covariance is the same as the population Â
variance.
250 Chapter 10 Statistical Functions