Select the worksheet. The data range is displayed automatically. 

Variable names in the first row : Check this and the list of variables in the dataset will appear. Select the variable to be binned. This means, binning will be done on the values in that column.

Name of the binned variable : If we have chosen x3 as the variable to be binned, XLMiner™ will create a variable, Binned_x3 and store the results of binning in it.

Bins to be made with : 

Equal count : The binning is performed such that there are equal number of records in each bin. (There is a possibility that the number of records in a bin may be different here due to some factors like border values, #records being indivisible by the no. of bins etc. We will see this in the examples.)

Equal interval : Depending on the number of bins, the data values are divided among equal intervals. The interval is calculated as (Maximum value -Minimum value)/#bins. The options of Rank and  Mid value are available .

Value in the binned variable :  Here the user has to specify what value to be assigned to the bin variable for any single bin. Different options are available to assign values to the binned variable, depending upon the method of making bins -- equal count or equal interval.

Rank of the bin : The user can specify the start value. That value will be assigned to the binned variable in the first bin. The binned variable in the second bin will get assigned by (start value + interval) and so on. 

Mean of the bin : XLMiner™ calculates the mean of all values in the bin and assigns that value to the binned variable. 

Median of the bin : XLMiner™ finds the median of all values in the bin and assigns that value to the binned variable. 

Mid Value :  The mid value = (Maximum value +Minimum value)/2.

Apply this option to the selected variable : All the options selected are applied to the variable after selecting this.

Click OK and the binned output is displayed in a separate sheet.

See also: