how do i add a quadratic trendline to excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

moseichuk007 - 13 Dec 2004 00:27 GMT

i need to add a trendline for a quadratic equation for my math project but it
seems to me that its not available is there a way that i can do it?
im using windows XP home edition

Reply to this Message

Jerry W. Lewis - 13 Dec 2004 12:34 GMT

Chart|Add Trendline
select a polynomial of order 2 then click on the Options tab and request
that Excel display the formula.

Alternately
=LINEST(ydata,xdata^{1,2})
will give you the quadratic coefficients in a worksheet.

Jerry

> i need to add a trendline for a quadratic equation for my math project but it
> seems to me that its not available is there a way that i can do it?
> im using windows XP home edition

Reply to this Message