|
Introduction
Binning
is a process of grouping
measured data into data classes. These data classes can be further used in
various analyses. For example a variable, which takes continuous
numerical value, may not be allowed to be selected as input/output
variable in certain routines of XLMiner™. So Binning utility addresses
this by putting the values of that variable in certain number of bins. The
“binned-variable” can be chosen as a categorical variable. The user
can decide what values the binned variable should take.
There
are following options available for binning-
-
Equal
count : In equal count bin interval is decided on the basis of number
of records present in the bin variable. In equal count there are
following options available :
-
Rank : In
this option each value in the variable is assigned a rank according to the
start and increment value. User can specify the starting and increment
value.
-
Mean
: Mean
is calculated as mean of the values lying in bin interval. This mean value
is assigned to each value of the variable that lies in that interval.
-
Median
: Records
with the same binning value are counted and median is calculated on the
input value. The median value is then assigned to the binned variable.
Equal Interval : Equal
interval is based on the bin size. In equal interval, the whole range is
divided in the user specified bin size. In equal interval the options of
Rank and Mid value are available.
See
also:
|