Categorical Variables In Regression Excel. The independant variables are a mixture of categorical and numerical values but at a push I could remove the categorical independant variables and just leave the numerical. You can also use the equation to make predictions.
We need to convert the categorical variable gender into a form that makes sense to regression analysis. Each such dummy variable will only take the value 0 or 1 although in ANOVA using Regression we describe an alternative coding that takes values 0 1 or -1. Now change the Code type to Categorical coding.
Suppose we wish to explain what determines whether or not a person is employed.
The independant variables are a mixture of categorical and numerical values but at a push I could remove the categorical independant variables and just leave the numerical. Sep 10 2013 1 of my variables is a Yes or No 3 of my variables have a few 3-5 discrete options The output is money continuous. One way to represent a categorical variable is to code the categories 0 and 1 as follows. Regression analysis requires numerical variables.
