Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Regression Formula | Excel Worksheet Functions | |||
The multiple regression tool - linear or non-linear regression? | Excel Discussion (Misc queries) | |||
formula for linear regression | Excel Worksheet Functions | |||
Regression | Excel Programming |