How do I run a regression on data that is not numerical?
Where only two values are possible (as with gender) then you use a single
variable with +1 for one gender and -1 for the other. Extending to more than
two values is possible, but non-trivial.
Alternately, if you have Excel 2003 or later, you can create an indicator
variable (0 or 1) for each possible non-numeric value. This approach
directly permits more than 2 possible values.
Jerry
"NG" wrote:
I am using Microsoft Excel 2003. I have been running regressions on
numerical data and am curious to know how to run one if part of my data is
non-numerical such as gender or race.
|