Name
CORREL
Synopsis
Use CORREL to examine two different arrays of values and determine the correlation. For example, you could compare the distance to the office array to the number of bus riders in a second array.
To Calculate
=CORREL(Array1,Array2)
Both arguments must be specified for this function.
Example
Figure 15-7 illustrates how CORREL is used to compare two arrays and determine the correlation. The example compares the values in each array and determines the correlation between the changes in values. The example illustrates that there is a strong, positive, linear relationship between the number of bus riders and the distance to work.
Figure 15-7. Find the correlation between the changes in the values of two arrays with CORREL
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
