View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lian Lian is offline
external usenet poster
 
Posts: 1
Default multiple nonlinear regression

Hello,

I had a question about using excel to calculate the regression
equation for many independent variables (I have 7). I'm not too
knowledgable about stats, but I used tools-data analysis- regression
to get a multiple linear regression equation, but I want to try
polynomial or non-linear, as the R I got was a bit too low. I have no
idea what to expect in the resultant equation , so I don't want to
fill up the worksheet columns with A^2, A^3, B^2, C^3, etc...

I read the posts about LINEST, but when I tried it, all I get is a
number, when I want a list of coefficients or an equation, and when I
tried using ^{1,2,3}, I get a #VALUE! error.

Thank you any help...
Lian