Run-Time Error '13' Type Mismatch

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

Run-time Error '13' Type Mismatch

Rate this: (2.2/5 from 4 votes)

	I 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 Payers24 on 08 Aug 2006

Replies - Displaying 11 to 13 of 13

Order Replies By: Most Recent | Chronological | Highest Rated

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 dalerhs on 30 Jun 2010

	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 aeroshare on 11 Sep 2011

	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 RachelGomez161999 on 09 Dec 2022

Back

Displaying page 2 of 2