Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Run-time error 9 Share

Run-time error 9

Excel Help for Run-time Error 9 in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

Run-time Error 9

Rate this:
(3/5 from 1 vote)
ConfusedEvery time I try to run a regression I get a run-time error 9, subscript out of range.  I cant figure out what is causing this.
Also, I need to run a regression with apporximately 36-40 independent variables.  How would you say is the best way to do this?
 Posted by on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
Steps  to Fix the Runtime Error 9: Subscript Out of RangeGo to "Start" > "Control Panel."Click "Windows Update" to see if there are any updates available for your computer.Click "Check for Updates" and then download and install any recommended files.Regards,
Rachel Gomez
 rachel
 Posted by on
Confused
Rate this:
(2/5 from 2 votes)
The Runtime error 9 may occur if any of the sheets have been renamed and therefore the program cannot reference them when processing the output.

The number of independent variables that can be run is limited to 10 in order to maintain reasonable processing times on slower computers. It is unusual to have more than 10 independent variables that all hold a strong relationship to the dependent variable, without there being any multi-colinearity between them. For more than 10, You could run ten at a time and evaluate the Independent analysis to determine which ones have the strongest relationship to the dependent.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Run-time error 9 in the