Contents

Transform Categorical Data

Using the Transform Categorical Data Utility

  1. Create Dummies :

     

    2. Select  XLMiner --> Data Utilities --> Transform Categorical Data --> Create Dummies

     

    Data Range : Either type the address directly in this box, or using the reference button, mark the required data range from the worksheet. If the cell pointer (active cell) is already somewhere in the data range, XLMiner™ automatically picks up the contiguous data range surrounding the active cell. When the data range is selected XLMiner™ displays the number of records in the selected range.

    First row contains headers : When this box is checked, XLMiner™ picks up the headers from first row of the selected data range. When the box is unchecked, XLMiner™ follows the default naming convention, i.e., the variable in the first column of the selected range will be called "Var1", the second column "Var2," etc.

    Variables : This list box contains the names of the variables in the selected data range.  To select a variable click on it, then click on the ">" button.  Use the ctrl key to select multiple variables.

    Variables to be factored : Variables appear under this heading when selected from the list.

    Select OK to see the result.

  2. Create Category Scores :

Select  XLMiner --> Data Utilities --> Transform Categorical Data --> Create Category Scores

 

 

Data Range : Either type the address directly in this box, or using the reference button, mark the required data range from the worksheet. If the cell pointer (active cell) is already somewhere in the data range, XLMiner™ automatically picks up the contiguous data range surrounding the active cell. When the data range is selected XLMiner™ displays the number of records in the selected range.

First row contains headers : When this box is checked, XLMiner™ picks up the headers from first row of the selected data range. When the box is unchecked, XLMiner™ follows the default naming convention, i.e., the variable in the first column of the selected range will be called "Var1", the second column "Var2," etc.

Variables : This list box contains the names of the variables in the selected data range.  To select a variable click on it, then click on the ">" button.  Use the ctrl key to select multiple variables.

Variables to be factored : Variables appear under this heading when selected from the list.

Options : The user can specify the number with which to start categorization 0 or 1. Select the appropriate option.

 

Select OK to see the result.

 

 

See also: