View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default Polynomial Curve Fit

rcc -

(1) Use an XY (Scatter) chart type, not a Line chart type (which treats the
X values as 1,2,3,... for the curve fit).

(2) Be sure all values are numeric, not text.

(3) I get the following results using Trendline or worksheet function
LINEST:

Y = -0.000013147702647*x^2 +
0.1503983217785*x +
134.511365283

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"rcc" wrote in message
...
I'm trying to do a polynomial curve fit (order 2) for the data below, but
the
equation that the curve fit provides is way off. Any ideas why this isn't
working? It works for a similar set of data...

x y
10600 250
10600 250
10250 300
9750 350
9250 400
8625 450
8000 500
6750 550