LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Formula for regression

Is there an Excel formula that can do the regression to find the best
quadratic fit for a set of x-y data.

The equation would be
y = a0 + a1 * x + a2 * x^2

I know that index(linest(...),..) can give me individual coefficients
for a simpler linear equation y = a0 + a1 * x.
Is there a similar formula for the equation above? I don't want to
go through multiple menus or create extra 'dummy' columns.
Any simpler way? Thanks.

Kaspa


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula PJ[_3_] Excel Worksheet Functions 2 June 2nd 10 03:45 PM
Regression Formula Abby Excel Worksheet Functions 2 May 5th 10 01:59 AM
The multiple regression tool - linear or non-linear regression? Statistical interest Excel Discussion (Misc queries) 2 February 6th 08 11:01 PM
formula for linear regression DBane Excel Worksheet Functions 14 September 1st 05 09:54 PM
Regression Clark[_2_] Excel Programming 0 July 31st 03 11:58 PM


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

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

About Us

"It's about Microsoft Excel"