Can you explain the Excel 2003 or later indicator variables a little more? I
have four non-numerical values for race.

Thanks for the information on gender. I was using 1 for men and 2 for
females.

"Jerry W. Lewis" wrote:

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.