Forum Discussion
Larissa_10
Nov 15, 2023Copper Contributor
Multiple lineare Regression
Hello, the regrssion tool doesn't allow more than 16 variables in excel. I need 31 variables. What can I do now? Larissa
JKPieterse
Nov 15, 2023Silver Contributor
31 variables, wow. Perhaps this is out of Excel's league?
Do you mean 31 'x' variables?
Do you mean 31 'x' variables?
- Larissa_10Nov 16, 2023Copper Contributor
JKPieterse Yes, I mean 31 'X' variables.
- Larissa_10Nov 16, 2023Copper ContributorJKPieterse, do you have another idea how to do this?
- JKPieterseNov 17, 2023Silver ContributorIf these are all first order linear variables you can use the LINEST function, as far as I know you can pass as many columns of x-variables to it you have, provided they are immediately next to each other.