From: Kipi on 12 Apr 2010 08:58 I know that there is a LINEST function to return the coefficient of best linear curve fit However I would like to know if there is anyway to return the coefficients of, say , a quadratic curve fit? Or if there is anyway to manual type in algorithm that excel use in polynomial curve fit? Oh and I would like to have a 0 y-intercept Thanks From: Ron Rosenfeld on 12 Apr 2010 09:41 On Mon, 12 Apr 2010 05:58:02 -0700, Kipi wrote: >I know that there is a LINEST function to return the coefficient of best >linear curve fit >However I would like to know if there is anyway to return the coefficients >of, say , a quadratic curve fit? Or if there is anyway to manual type in >algorithm that excel use in polynomial curve fit? Oh and I would like to have >a 0 y-intercept >Thanks Did you check HELP for LINEST? Is this not what you are looking for? ======================= .... you can use LINEST to calculate a range of other regression types by entering functions of the x and y variables as the x and y series for LINEST. For example, the following formula: =LINEST(yvalues, xvalues^COLUMN(\$A:\$C)) works when you have a single column of y-values and a single column of x-values to calculate the cubic (polynomial of order 3) approximation of the form: y = m1*x + m2*x^2 + m3*x^3 + b ============================== --ron  |  Pages: 1 Prev: Desparate For Help - Pivot Table Field ListNext: .csv Re-Format Question