Microsoft Office Tutorials and References
In Depth Information
l The Function
Arguments dialog box
appears.
4
Click and drag to select
the first series of
numbers, or type the
cell range.
5
Click and drag to select
the second series of
numbers, or type the
cell range.
Note: You can select a
subset of a list, but make
sure the same subset is
selected for each list.
4 5
6
6
Click OK.
l The correlation coefficient appears.
Note: The sign suggests whether the
relationship is positive (+) or negative (–).
Did You Know?
When using CORREL , if a reference cell contains
text, logical values, or empty cells, Excel ignores
those values. However, reference cells that have a
value of 0 are included in the calculation. If the
number of data points in array1 and array2 are
not equal, Excel returns the error message #N/A.
Did You Know?
An add-in is software that adds one or more
features to Excel. To learn how to install add-ins,
see Task #94. The Analysis Toolpak is an add-in that
contains a number of statistical tools, including the
Correlation tool, which you can use to calculate
correlations. Correlations calculated by using the
Correlation tool do not automatically update as you
update your worksheet.
Chapter 5: Explore the Patterns in Your Data
127
 
Search JabSto ::




Custom Search