A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

how do i add a quadratic trendline to excel



 
 
Thread Tools Display Modes
  #1  
Old December 13th 04, 12:27 AM
moseichuk007
external usenet poster
 
Posts: n/a
Default 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
Ads
  #2  
Old December 13th 04, 12:34 PM
Jerry W. Lewis
external usenet poster
 
Posts: n/a
Default

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get the trendline equation from Excel to script? Mattias Charts and Charting in Excel 1 December 7th 04 12:21 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 08:05 PM
Fonts get size 1 and can't be changed after a procedure - even by excel GUI!! Marie J-son Charts and Charting in Excel 2 December 6th 04 04:11 AM
Excel 2003 BLG Charts and Charting in Excel 1 December 3rd 04 02:15 PM
Trendline error??? Eugepticus Charts and Charting in Excel 3 November 30th 04 04:40 AM


All times are GMT +1. The time now is 07:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.