how do i add a quadratic trendline to excel

G

Guest

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
 
J

Jerry W. Lewis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i add a quadratic trendline to excel 1
Trendline Equations in Excel 2003 7
trend line equations 2
how do i extract the formula from a trendline in Excel? 1
How to add a trendline in Excel 2007 4
using polynomial trendline equations 2
Trendline Issues 4
How to Show/calculate End-values of Trendline? 2

Top