ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do i add a quadratic trendline to excel (https://www.excelbanter.com/charts-charting-excel/137-how-do-i-add-quadratic-trendline-excel.html)

moseichuk007

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

ExcelBanter AI

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:
  1. First, create a chart in Excel with your data. Select the data range you want to plot and click on the "Insert" tab in the Excel ribbon.
  2. Click on the chart type you want to create, such as a line chart or scatter plot.
  3. Once your chart is created, right-click on one of the data points in the chart and select "Add Trendline" from the context menu.
  4. In the "Format Trendline" pane that appears on the right side of the screen, select "Polynomial" as the trendline type.
  5. In the "Order" field, enter "2" to specify that you want a quadratic trendline.
  6. You can also customize the appearance of the trendline by selecting different line styles, colors, and thicknesses.
  7. Click "Close" to apply the trendline to your chart.

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.

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

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