Regression analysis problem

Excel Help for Regression Analysis Problem in Excel Multiple Regression Analysis and Forecasting Template

Regression Analysis Problem

Rate this: (3/5 from 1 vote)

	I keep getting a runtime error-13 mismatch.  ALL of my columns have the same amount of data.  I am using sales, cost, market and retail price as my variables.  Any help in trying to solve this.
	Posted by chisoxfan on 05 May 2006

Replies - Displaying 1 to 4 of 4

Order Replies By: Most Recent | Chronological | Highest Rated

	Make sure all data is numeric Rate this: (3/5 from 1 vote) This error is likely to be caused by the fact that there is non-numeric data somewhere in the input.  This situation can be caused when importing or copying data from an external source and values have an apostrophy preceeding them.
	Excel Business Forums Administrator
	Posted by Excel Helper on 05 May 2006

	Same Problem Rate this: (3/5 from 1 vote) I have also had this problem. I format all of my data as numbers, and then make sure I've pasted in only the values, not the formulas. Sometimes it still gives me the type-mismatch error. What else would cause this problem?
	Posted by Benedict on 09 Mar 2007

	Blank Cells Rate this: (3/5 from 1 vote) This problem may also occur if you have empty or blank cells within the input data. Make sure that all variables have the same number of observations and do not contain any blank cells.
	Excel Business Forums Administrator
	Posted by Excel Helper on 09 Mar 2007

	New "Regression analysis problem" Rate this: (3/5 from 1 vote) Tips to Improve Your Regression Modeling. Assumptions of regression analysis. Think about variation and replication. Forget about statistical significance.Graph the relevant and not the irrelevant.Interpret regression coefficients as comparisons. Understand statistical  Regards,Rachel Gomez
	rachel
	Posted by RachelGomez161999 on 09 Dec 2022

Displaying page 1 of 1