View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
icystorm icystorm is offline
external usenet poster
 
Posts: 20
Default multiple polynomial regression in Excel

First, please excuse me if this is the wrong newsgroup for posting
this question... If so, kindly direct me on. Thanks!

In Excel, it is easy to create the coefficients for muliple linear
regression and multiple non-linear regression by using the LINEST and
LOGEST functions to produce an array of statistics that contain the
coefficients dervived from the x, y data set. I use these functions
routinely and they work well.

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)?

Thanks kindly!

Joseph