Conversion factor

[joeholiday]

Hi, I'm not sure whether this is even possible but if it is someone on here will surely know!

I have two sets of data, one is a value I gained from experiments and the other is a known value. Ive tested these data sets with the correl function and they have >0.9 correllation, slightly less for the R square value of a trendline when plotted on a graph. So this leads me to believe that there is an equation which can be applied to my figures to work out the known value. Is there any way of working this equation out on excel?

Many thanks
Joe

 

[brettdj]

You can use the LINEST function to return the trendline equations that Excel can plot on graphs

LINEST will fit log curves, polynomials etc, not just straight lines
http://office.microsoft.com/en-us/excel-help/linest-HP005209155.aspx

That said graphing data is always advisable to look at the patterns by eye.

Cheers

Dave