MINRATE subcommand (RESPONSE RATE command)

The optional MINRATE subcommand specifies a minimum cumulative response rate to use to color-code the output table and to use as a reference line on the response rate line chart. The following alternatives are available for specifying minimum response rate:

RATE=NONE. No minimum response rate. This is the default if the subcommand is omitted.

RATE=value. Use the specified percentage value as the minimum cumulative response rate. Specify a value greater than 0 and less than 100.

FORMULA=value1,value2. Calculate minimum cumulative response rate based on the formula (value1/value2)*100. Both values must be positive numbers. The result should be a value greater than 0 and less than 100. In direct marketing, for example, value1 might be the cost of mailing a package, and value2 might be net revenue per response. If the cost of mailing a package is $0.75 and the net revenue per response is $56, then the minimum response rate is: (0.75/56)*100=1.34%

Each keyword must be followed by an equals sign (=) and a variable name.

• If MINRATE is specified without MAXCOUNT, all rows with a cumulative response rate equal to or greater than the specified minimum are displayed with a green background, and all rows with a cumulative response rate less than the specified minimum are displayed with a red background.
• If MAXCOUNT is also specified, only rows with a cumulative response rate above the specified minimum and rows with a cumulative count below the specified maximum are displayed with a green background. For example, if the response rate is higher than the specified minimum, but the cumulative count is greater than the specified maximum, then the row will have a red background.

Example

RESPONSE RATE
  /VARIABLES 
   NUMERATOR=Responses
   DENOMINATOR=Customers
   GROUP=PostalRank
  /MINRATE=5.