Variable List (RATIO STATISTICS command)

The variable list specifies the numerator variable, denominator variable, and optional group variable.

  • The numerator variable must be the first specification after the procedure name.
  • The denominator variable must be preceded by the keyword WITH.
  • The group variable, if specified, must be preceded by the keyword BY.
  • Both the numerator and the denominator variables must be numeric.
  • The group variable can be of any type (numeric or string).
  • By default or when the keyword ASCENDING is specified, values of the group variable are displayed in ascending order. Specify the keyword DESCENDING to display in descending order. Specify NOSORT to preserve the appearance order in the data.
  • Only cases with no (system- or user-) missing values in both the numerator and the denominator variables will be used. Please note that this rule does not apply to the group variable.

Example

RATIO STATISTICS appraise WITH price
  /PRINT = AAD BCOC((1,2) (3,4)) MEAN.
  • This is a typical analysis where appraise is the appraised value and price is the transaction price. The ratio is computed by dividing appraise by price.

Example

RATIO STATISTICS appraise WITH price BY county
  /PRINT = CIN(90) MEDIAN.
  • The ratio is still computed by dividing appraise by price. However, separate ratio statistics are requested for each category of county.