Syntax

QRS.BIN.​UNIQUE(​x, [y], [option name], [option value], …)

x[any]

Vector containing the values of the variable to be binned.

y[number]optional

Vector containing the values of the binary dependent variable. Leave blank if not applicable.

option name/valueoptional

The name or value of an option. See the Options section for details.

Options

• HEADER: TRUE to include a header row in the output.
• TOTAL: TRUE to include a total row in the output. The cell in the WOE column contains the information value (IV).
• COLS: String of comma-separated flags to include only selected columns in the output. The possible flags are:
  • ID for identifier.
  • DESC for description.
  • N for frequency.
  • N0 for frequency of zeros in y.
  • N1 for frequency of ones in y.
  • P for proportion of ones in y.
  • WOE for weight of evidence, which is log-odds of the bin minus overall log-odds, where odds is N1/N0.

Remarks

• Blank cells are read as zeros and dates are read as numbers due to Excel limitations.
• The length of x must be the same as the length of y, if applicable.

Examples

• How to create bins with a monotonic weight of evidence trend in Excel.