Placing coefficients from fit onto worksheet

[farinelli]

If I have a data set and fit it with a polynomial, how do I put the
coefficients from the fit into a worksheet so that I can do some
calculations using the fit parameters without manually typing them in.
I know you can easily do this if it is a linear fit by using the LINEST
function, but how do you do this for a polynomial fit. Also, is there
a way of getting the standard errors for the fit.

 

[Michael R Middleton]

farinelli -


For second order polynomial, use LINEST(Yrange,Xrange^{1,2},TRUE,TRUE).


LINEST returns standard errors. See Excel's Help for information. Select a
large range of empty cells before array-entering the LINEST function
(Control + Shift + Enter).


Since this is a non-Mac-specific question, you may get better responses by
posting in microsoft.public.excel.worksheet.functions forum.


- Mike


www.mikemiddleton.com


++++++++++++++++++++++++++


If I have a data set and fit it with a polynomial, how do I put the
coefficients from the fit into a worksheet so that I can do some
calculations using the fit parameters without manually typing them in. I
know you can easily do this if it is a linear fit by using the LINEST
function, but how do you do this for a polynomial fit. Also, is there a way
of getting the standard errors for the fit.

 

[JE McGimpsey]

If I have a data set and fit it with a polynomial, how do I put the
coefficients from the fit into a worksheet so that I can do some
calculations using the fit parameters without manually typing them in.
I know you can easily do this if it is a linear fit by using the LINEST
function, but how do you do this for a polynomial fit. Also, is there
a way of getting the standard errors for the fit.

Take a look here:

http://groups-beta.google.com/group/microsoft.public.excel.misc/msg/4d440
d271303e0d6

 

[Bob Greenblatt]

Take a look here:

http://groups-beta.google.com/group/microsoft.public.excel.misc/msg/4d440
d271303e0d6

Or, another way that I have used, is to simply parse the trend line string
from the chart. It's maybe not as elegant as Dave's solution, but quick and
simple.

 

[JE McGimpsey]

Or, another way that I have used, is to simply parse the trend line string
from the chart. It's maybe not as elegant as Dave's solution, but quick and
simple.

If one knows the order of the polynomial, I agree that simply parsing is
easier.