View Single Post
  #1   Report Post  
itgoeson
 
Posts: n/a
Default Fitter malfunctioning?


Hello--

I attempted to plot a trendline as a new data set (I looked at the fit
equation and created a new set of data with it). However, the line the
equation draws is not the same as the trendline! Am I making a mistake
somewhere?

The black line is the trendline. The blue line is the line the
equation describes.

Thanks,
Jennifer


For the Y column I'm using:
=(0.0000000009*(J2^3)) - (0.000004*(J2^2)) + (0.0057*J2) + 0.3246

Col J Col K
X Y
20 0.4370072
30 0.4920243
40 0.5462576
50 0.5997125
60 0.6523944
70 0.7043087
80 0.7554608
90 0.8058561
100 0.8555
110 0.9043979
120 0.9525552
130 0.9999773
140 1.0466696
...and so on...

Output:
[image:
http://general.krl.caltech.edu/~jenant/fitter.jpg]


--
itgoeson
------------------------------------------------------------------------
itgoeson's Profile: http://www.excelforum.com/member.php...o&userid=25793
View this thread: http://www.excelforum.com/showthread...hreadid=392368