Share via

Excel Data Analysis tool

Anonymous
2021-01-19T01:30:44+00:00

Good day!

I tried to do data analysis using regression, but unfortunately it says, "Regression - Input range contains non-numeric data." How to resolve this?I am just doing the same as those practices in youtube. 

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2021-01-19T03:18:54+00:00

    The message means that one or more cells used by the regression looks like a number, but is not considered a number by Excel.

    A quick look at the screen cap, there is no obvious bad data.  The obvious clue is that a number is aligned on the left side of the cell.

    .

    My next guess is the numbers under "Predicted Monthly". 

    is 1200 in a cell separate from "A models", etc?  The look like the values are all in one cell. If you use that as input to the regression, that would cause the error.

    .

    The "easy" way I know of to find text values mixed in numbers is to import the data into PowerQuery.  You will instantly see which cells a text, ie

    A less easy way is using the =IsText() function, ie

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-01-21T09:56:29+00:00

    Hi Hanifa09，

    Welcome to post back if there are any updates.

    Regards,

    Clark

    0 comments