Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Run-Time Error '13' Type Mismatch > No data for one or more independent variables Share

No data for one or more independent variables

Excel Help for No Data For One Or More Independent Variables in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicLogin

No Data For One Or More Independent Variables

Rate this:
(3/5 from 1 vote)
OopsAfter some testing, we came across a similar error when one or more independent variables have no data.  If titles are entered for independent variables, the program assumes that data exists beneath it. It then attempts look for empty or non-numeric input to exclude before running the analysis.  Since no data exists, it continues this process all the way to the last row of the worksheet.

We have updated the download version to check for missing variable data in order to resolve this issue.


 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for No data for one or more independent variables in the