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.
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
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.
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?
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.
