Multiple lineare Regression

Question

Hello,the regrssion tool doesn't allow more than 16 variables in excel. I need 31 variables. What can I do now?&nbsp;&nbsp;Larissa

jkpieterse · Answer

31 variables, wow. Perhaps this is out of Excel's league?Do you mean 31 'x' variables?

larissa_10 · Answer

JKPieterse&nbsp;Yes, I mean 31 'X' variables.&nbsp;

larissa_10 · Answer

JKPieterse, do you have another idea how to do this?

jkpieterse · Answer

If 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.

Forum Discussion

Multiple lineare Regression

4 Replies

Resources