Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nonlinear multiple regression SPSS | Excel Discussion (Misc queries) | |||
how can i use of nonlinear multiple regression in excel? | Excel Discussion (Misc queries) | |||
nonlinear regression | Excel Discussion (Misc queries) | |||
Nonlinear regression | Excel Worksheet Functions | |||
nonlinear regression/ curve fits | Excel Discussion (Misc queries) |