Microsoft Office Tutorials and References
In Depth Information
FIND THE CORRELATION
With the correlation function, you can measure the
relationship between two variables. You can explore
questions such as whether baseball players hit fewer
home runs as they age.
A correlation does not prove one thing causes
another. The most you can say is that one number
varies with the other. Their variation may be the
result of how your numbers were measured or the
result of some factor underlying both variables. When
you use correlations, you start with a theory that two
things are related. If there is a correlation, you must
then gather evidence and develop plausible reasons
for the correlation.
Use the CORREL function to determine a correlation.
CORREL takes two arguments: array1 and array2 —
the two lists of numbers. The result of the function is
a number, r , between –1 and 1. The closer r gets to
–1 or 1, the stronger the relationship. If r is negative,
the relationship is an inverse relationship — for
example, as age increases, batting averages decrease.
A positive result suggests that as one variable
increases, so does the other.
Click the cell in which you want
to place your answer.
Type =correl( or double-click
CORREL on the Function
Click the Insert Function button.