Send to a Friend

ScottyMcGeester's avatar

How else can you correlate data on Excel?

Asked by ScottyMcGeester (1897points) December 16th, 2012

I have to correlate two sets of data on this graph I made for work. My boss is going to be out for a while, but he left a note on my work saying he wants me to correlate the data. Unfortunately, like I said, he won’t be around for a while so I can’t ask him exactly what he means.

We did an experiment where I recorded data from these two machines. What he wants to do is kind of hard to explain. See, one machine is old and the other is new. He wants to make a correlation between the two, like. . .to see how off one machine is compared to the other one. Something like that.

Like I said, I have two sets of data, these averages from numbers I recorded. I made a graph and both sets are linear. I put the linear equation thing and the R squared value for both sets on the graph. I thought that was what he meant at first. I also thought he meant to do the ”=correl(enter cells here)” command and post that value there. But that wasn’t what he meant either – he had still told me that I needed to make a correlation.

I think whatever it is he means is a correlation on the actual graph, or a separate graph that calculates the correlation? I don’t know. What other stuff with correlation can you do on excel graphs?

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.