how do i add a quadratic trendline to excel
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 |
Answer: how do i add a quadratic trendline to excel
Yes, you can definitely add a quadratic trendline to your Excel chart. Here are the steps to do so:
That's it! You should now see a quadratic trendline plotted on your chart. If you want to see the equation for the trendline, you can check the "Display Equation on chart" option in the "Format Trendline" pane. |
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 moseichuk007 wrote: 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 |
All times are GMT +1. The time now is 08:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com