
A New Method for Including Qualitative Information in Database Models
Bruce Ratner, Ph.D. The classic approach to include a qualitative information, namely, nominallevel categorical variables, into the modeling process involves dummy variable coding. A categorical variable with k classes of qualitative (nonnumerical) information is replaced by a set of k1 quantitative dummy variables. The dummy variables are defined by the present or absent of the class values. The class left out is called the reference class, to which the other classes are compared when interpreting the effects of dummy variables on response. The classic approach instructs that the complete set of k1 dummy variables is included in the model regardless of the number of dummy variables that are declared nonsignificant. This approach is problematic when the number of classes is large, which is typically the case in big data applications. By chance alone, as the number of classes increases, the probability of one or more dummy variables being declared nonsignificant increases. To put all the dummy variables in the model effectively adds "noise" or unreliability to the model, as nonsignificant variables are known to be "noisy." Intuitively, a large set of inseparable dummy variables poses a difficulty in model building, in that they quickly "fill up" the model not allowing room for other variables. The purpose of this article is to present a new method that upgrades the complete set of nominallevel dummy variables into a smaller set of smooth (reliable) intervallevel quantitative variables, which retains a large percentage of the original information. Thus, the new variables not only offer greater reliability in the database model, but make room for other variables. Related Articles: Data Mining and Its Aplications 1 800 DM STAT1, or email at br@dmstat1.com. 
