LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"