Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Regression analysis problem Share

Regression analysis problem

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


Forum TopicPost Reply Login

Regression Analysis Problem

Rate this:
(3/5 from 1 vote)
ConfusedI 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 on
 
Replies - Displaying 1 to 4 of 4Order Replies By: Most Recent | Chronological | Highest Rated
Surprised
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 on
Angry
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 on
Oops
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 on
Confused
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 on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Regression analysis problem in the