View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton[_2_] Mike Middleton[_2_] is offline
external usenet poster
 
Posts: 110
Default multiple polynomial regression in Excel

icystorm -

what is the function for creating the statistics with coefficients for
muliple polynomial regression? <


LINEST

Multiple polynomial regression is a special case of multiple regression.

You can array-enter LINEST directly, e.g., =LINEST(y,x^{1,2,3},1,1),
substituting your data ranges for y and x, or you can use INDEX to get
specific values of the output array, as described by John Walkenbach at

http://spreadsheetpage.com/index.php...line_formulas/

For predictions, you can use the coefficients from LINEST in worksheet
formulas, or you can use array-entered TREND directly, e.g.,
=TREND(knownY,knownX^{1,2,3},newX^{1,2,3},1).

- Mike
http://www.MikeMiddleton.com


"icystorm" wrote in message
...
On Aug 28, 4:59 pm, icystorm wrote:

My question is this:

Is Excel able to create an array of statistics, similar to LINEST and
LOGEST, that contains the coefficients for an array of multiple x
values (independent variables) and, of course, the single column of y
values (dependent variables)?


I botched my question, leaving out the most important part. Let me
rephrase...

Is Excel able to create an array of statistics, similar to LINEST and
LOGEST, that contains the coefficients for an array of multiple x
values (independent variables) and, of course, the single column of y
values (dependent variables) that can be used for predicting the value
of Y in an Nth order polynomial.

In other words, what is the function for creating the statistics with
coefficients for muliple polynomial regression?

Thank you.

Joseph