Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

? asked in Computers & InternetSoftware · 8 years ago

How to run regression on excel with non-numeric data?

I'm trying to run a regression analysis with a given set of data.

On one column (A1:A13), I have the months - jan, feb, marhc, and so on. This is the dependent variable

And on columns B and C's I have my independent variables.

I followed the exact step - go to data/data analysis/regression

and put in the correct range but I get error message saying I've included non-numeric data?

I'm assuming it's because of the months. How do I fix this?

Update:

When I changed the months into numbers (1 to 12), it will perform the regression analysis, but I would get a different answer to what I should be getting...

3 Answers

Relevance
  • ?
    Lv 6
    8 years ago

    You can't do a regression model fit with non-numeric data, it's statistically meaningless. You can do it with ordinal data - such as 1, 2, 3 etc for the months, which you have tried. It would be useful to know in what way the answer is different from what you should be getting.

    Oh, and do you mean that the months are the independent variable?

  • Anonymous
    5 years ago

    sure .. its attainable... n the interface is likewise rather undemanding... (use the wizard)... n if something gets messd up.. use the inbuilt help... in basic terms create the table then choose the fields to plot on click on the graphs n charts button on the top...

  • 5 years ago

    sure .. its attainable... n the interface is likewise rather undemanding... (use the wizard)... n if something gets messd up.. use the inbuilt help... in basic terms create the table then choose the fields to plot on click on the graphs n charts button on the top...

Still have questions? Get your answers by asking now.