Quadratic trend equation?

C

cptak

In Office 2003, there was an option under tools, data analysis, regression to
do a linear or quadratic analysis. How is this now done under Excel 2007?
 
M

Mike Middleton

cptak -

In both Excel 2003 and Excel 2007:

(a) the Regression tool always creates a linear combination of the x-range
variables. Of course, the data on the worksheet for one of your x-range
variables could actually be x^2 values, thereby allowing you to fit a
quadratic.

(b) if you create an XY Scatter chart type, the Add Trendline feature allows
linear or polynomial (and other) fits. Polynomial of order 2 is quadratic.

- Mike
http://www.MikeMiddleton.com
 

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

Top