Statistics

  • Thread starter Thread starter William
  • Start date Start date
W

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
 
William -
Looking at the data below is there a way for Excell to tell me Is there
Click to expand...
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
Click to expand...

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
 
Back
Top