Correlations, how do I graph one?

  • Thread starter Thread starter misscrf
  • Start date Start date
M

misscrf

I have data of my weekly pay and hours worked. I want to show the
correlation between the two. When I do a linear regression it doesn't
work, and I don't understand why the correl function is for the range
of each data set.

For example:

5/1 $100 5 hours
5/15 $200 7 hours
5/30 $50 3 hours
etc.

I have the money and hours graphed on a charted over time, on two
separate axis. now how do I show the correlation between them on this
chart?

I tried to use the CORREL function to do somthing like this :

CORREL (money1:money3,hours1:hours3)

but the amount comes out as a really small decimal, like .04. Even if
I switch it around, and do hours,money I get the same amount. I am
thinking that I should not have the hours charted on the second axis,
but don't understand how I get the correct correlation percentage
charted.

Please help!

Thanks!
 
misscrf -

It would help if you describe a little bit more than "it doesn't work."

If you are interested in the correlation between money and hours, construct
an XY (Scatter) chart using that data.

The correlation is a single-number summary measure of the linear
relationship between two related sets of numbers. Since it is a single
number, it is not usually plotted.

CORREL({100,200,50},{5,7,3}) is approximately 0.98.

- Mike
http://www.mikemiddleton.com
 
Back
Top