Microsoft Office Tutorials and References

In Depth Information

FIND THE CORRELATION

between variables

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.

1

Click the cell in which you want

to place your answer.

2

Type
=correl(
or double-click

CORREL
on the Function

AutoComplete list.

1

2

3

Click the Insert Function button.

3

126