Statistics

[William]

Hi,

Looking at the data below is there a way for Excell to
tell me
Is there any correlation between column B numbers and the
value of Column A on the next day (Did it follow that
trend?)?

Thanks
William

A B
58.63 0.06
58.27 1.42
58.66 0.68
59.21 -0.32
59.73 -1.68
59.57 0.70
59.43 1.01

 

[Michael R Middleton]

William -

Looking at the data below is there a way for Excell to tell me Is there

any correlation between column B numbers and the value of Column A on the
next day (Did it follow that trend?)?

A B
58.63 0.06
58.27 1.42
58.66 0.68
59.21 -0.32
59.73 -1.68
59.57 0.70
59.43 1.01

Depending on how you've arranged the data, you could use
=CORREL(B1:B6,A2:A7) or something similar (to measure the extent of linear
relationship).

But you may gain more insight if you "look at the data" using two series on
a line chart first.

- Mike Middleton, www.usfca.edu/~middleton