I can't figure out what I'm doing wrong with trendline equation in the attached chart. The graph showing temperature in "Deg F" vs "Lab Data" looks fine. The trendline created with R^2 = 1 also looks great.
My problem is that Col D, where I have "Calculated Trendline" values (Y) from the trendline equation, are not even close to the "Lab Data" values (X), from which the trendline equation was originally derived! I just can't figure out where my error is in using this formula.
Thanks for your help. I know I'll kick myself in the butt when I see the solution.
Bookmarks