Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |