Syntax

QRS.BIN.​EQFREQ(​x, [y], [nbin], [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.

nbinnumberoptional

The desired number of numerical bins. Must be at least 2. Defaults to 5.

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. Numerical bins are identified by their lower bounds.
  • 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.
• EXC: TRUE to define numerical bins using exclusive (key_n < x ≤ key_n+1) rather than inclusive (key_n ≤ x < key_n+1) lower bounds.

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.
• The equal frequency binning method is applied only to numerical values.
• The final number of numerical bins is limited by the number of unique numerical values.

Examples

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