Excel: Analysis Toolpack -> regression
Posted on 2003-03-02
I have read that it is possible to regress one y variable on, say, two x variables, and the tool to do this would be the analysis toolpack.
When I go to regression, and select the input range for y, there is no problem. But how do I select the input range for the x variables? I have one sheet with x1 variables and another one with x2 variables, all in columns.
Thank you for your help!