Fixed-Width Bins
When you choose Fixed-width as the binning method, a new set of options is displayed in the dialog box.
Name extension. Specify an extension to use for the generated field(s). _BIN is the default extension. You may also specify whether the extension is added to the start (Prefix) or end (Suffix) of the field name. For example, you could generate a new field called income_BIN.
Bin width. Specify a value (integer or real) used to calculate the “width” of the bin. For example, you can use the default value, 10, to bin the field Age. Since Age has a range from 18–65, the generated bins would be as shown in the following table.
| Bin 1 | Bin 2 | Bin 3 | Bin 4 | Bin 5 | Bin 6 |
|---|---|---|---|---|---|
| >=13 to <23 | >=23 to <33 | >=33 to <43 | >=43 to <53 | >=53 to <63 | >=63 to <73 |
The start of bin intervals is calculated using the lowest scanned value minus half of the bin width (as specified). For example, in the bins shown above, 13 is used to start the intervals according to the following calculation: 18 [lowest data value] – 5 [0.5 × (Bin width of 10)] = 13.
No. of bins. Use this option to specify an integer used to determine the number of fixed-width bins (categories) for the new field(s).
Once you have executed the Binning node in a stream, you can view the bin thresholds generated by clicking the Preview tab in the Binning node dialog box. See the topic Previewing the Generated Bins for more information.