Forum Discussion

jipper's avatar
jipper
Copper Contributor
Dec 14, 2019

Regression in Excel issue saying some of my data is non-numeric

Get an error message when trying to run my regression analysis in Excel.  Says some of my data is non-numeric.  What could the issue or possible fixes be?

 

excel

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Dec 16, 2019
    Column X contains 5 cells which have a "." in them. Select column X, press F5, click Special, select Constants, uncheck "Numbers" and click OK. Now hit the TAB key to move through the selected cells.

Resources