Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Run-Time Error '13' Type Mismatch Share

Run-Time Error '13' Type Mismatch

Excel Help for Run-time Error '13' Type Mismatch in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

Run-time Error '13' Type Mismatch

Rate this:
(2.2/5 from 4 votes)
ConfusedI read the previous post in the forum to check data type when this occurs. All of the data is clearly numerical and should not be the problem. I am working with about 14,000 observarations and keep getting this error. Is it because there are to many observations? There is no difference in the number of observations per variable so this is also not the problem. Please let me know how to fix this.
 Posted by on
 
Replies - Displaying 11 to 13 of 13Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Software Glitch
Rate this:
(3/5 from 1 vote)
There is obviously a software glitch with Excel. I sometimes get the error and there are times I do not get the error running the same program with no changes. If I close the program and reopen it the problem remains. However, sometimes if I restart Excel it will correct the problem and the program will run OK for a while. Then all of a sudden I try to run the program again and "Run-Time Error '13' Type Mismatch". Aaaaargh!!! There is no type mismatch with the data. I checked and rechecked if there was some way I was mixing data types of had blank data. None!!! I've downloaded a fix from Microsoft for this problem but have had no luck installing the fix. I tried updating Windows XP to service pack 3, which is suppose to have the fix in it, but still get the error about 50% of the time. If anyone has found a solution to this software bug please let me know.

Thanks in advance.
 Posted by on
Shocked
Run time error 13
Rate this:
(3/5 from 1 vote)
I have just downloaded the trial software and tried running some numerical data for regression.  I am also having Run-time error 13.  All of my data is complete and numbers.  I tried formatting the numbers, pasting only data into cells. Restarting excel 2007.  

Data is:
SPrice SF BR FB HB TtlFl Garage Carport View Pool
249000, 2300, 3, 2, 0, 1, 2, 0, 1, 0

This program is exactly what I am looking for if I can get it to run correctly. 
 John Patton
 Posted by on
Confused
New "Run-Time Error '13' Type Mismatch"
Rate this:
(3/5 from 1 vote)
In Excel, on the taskbar, select the File tab, then left-click Open from the list provided. Now click on the required file and select Open -> Open and restore -> Restore (you can also select the Extract data tab). If everything goes well, runtime error 13 will not bother you again.
Regards,Rachel Gomez
 rachel
 Posted by on
 Displaying page 2 of 2 

Find relevant Excel templates and add-ins for Run-Time Error '13' Type Mismatch in the

© Business Spreadsheets   Legal   Follow us: