Share via

How can I remove the "input data contains non-numeric data" from a regression analysis? While maintaining multiple labels?

Anonymous
2023-01-24T18:08:34+00:00

![](https://learn-attachment.microsoft.com/api/attachments/6bab8661-0412-4da0-a4b8-0b547cdc6230?platform=QnA"https://www.youtube.com/watch?v=vDHxcd58SPU" rel="ugc nofollow">https://www.youtube.com/watch?v=vDHxcd58SPU

But, from my input data, it keeps appearing as "Regression - Input range contains non-numeric data."

However, if i only try one "x" and another "y" variable it does work.

What is causing my numbers to be nonnumerical? I have tried to format it with both the "number" and "general" format.

I would really appreciate your help

Microsoft 365 and Office | Excel | For education | MacOS

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-01-25T07:26:18+00:00

    Hi Smushimink,

    Greetings! Thank you for posting to Microsoft Community.

    It's possible one of the columns (or just a single cell) contains what looks like numbers but in text form. 

    You can use Isnumber to check the format of your numbers.

    Best Regards,

    Snow Lu

    17 people found this answer helpful.
    0 comments