HXW

The HXW function is used to compare height and weight together.

Number of roles
1
Number of dimensions
(in each role)
1
Height cutoff
2
Weight cutoff
5
Weight table
mpi_wgtsval, mpi_wgthead, mpi_wgt2dim, wgtnval
  1. The comparison string values are actual height and weight values as standardized by HEIGHT and WEIGHT standardization functions. The height is in inches with upper and lower boundaries. Weight is in pounds with upper and lower boundaries.
  2. When heights are compared, the differences between the actual heights are computed and a match is assumed if the difference is less than a threshold (value = 2).
  3. When weights are compared, the percentage difference between the weights is calculated and it is assumed a match if the percentage difference is less than a threshold (value = 5).
  4. The height and weight counts that are used for calculating the score (weight) is done by collecting the counts for height and weight intervals. Counts for height and weight alone are also calculated separately.
  5. Since the height and weight counts are calculated by using intervals, the actual height and weight are used to declare a match. For example, one member can have a height of 79 and another a height of 80. These heights match because the difference is less than 2, but they belong to different intervals of 78 and 80.

    Two case examples are:

    1. Case 1 - Both height and weight are available and they match.
      1. Members are in the same interval for both height and weight. The weight is taken from the BOTH weight table by using quantized member height and weight.
      2. Members are not in the same interval for either height or weight. Take weights from the BOTH table for each member and add half of each to the final weight.
    2. Case 2 - Either height or weight alone is available and they match.
      1. Members are in the same interval for this attribute. The weight is taken from either the LEFT or RIGHT table (height or weight) by using the quantized member attribute,
      2. Members are in different intervals for this attribute. Weights are taken from the LEFT/RIGHT tables for each member and half of each is added to the final weight.
    3. Case 3 - At least one of the attributes is available but does not match. Weight is taken from the 2DIM weight table indexed by the quantized differences in height and weight.
Tip: The wgtsval table has values such as HGT72+WGT170 or MISSING+WGT170, or HGT72+MISSING which correspond to exact match for height 72 inches, weight 170 lbs, or height missing, exact match weight 170, or exact match height 72 inches, weight missing.

Weight tables for HXW:

  • mpi_wgthead
    |1|A|CMPID-HXW-2DIM|2DIM|CMPID-HXW-2DIM|16|16|0|0|
    1|1|A|CMPID-HXW-BOTH|SVAL|CMPID-HXW-BOTH|0|0|0|0|
    1|1|A|CMPID-HXW-LEFT|NVAL|CMPID-HXW-LEFT|0|0|0|0|
    1|1|A|CMPID-HXW-RIGHT|NVAL|CMPID-HXW-RIGHT|0|0|0|0|
    
  • mpi_wgt2dim
    1|1|A|CMPID-HXW-2DIM|0|0|88|-45|-147|-130|-55|-133|-44|-128|-91|-119|-92
    |-106|-140|-148|-134|
    1|1|A|CMPID-HXW-2DIM|1|94|101|-93|-181|-107|114|114|103|-67|114|114|114|
    114|114|114|114|
    1|1|A|CMPID-HXW-2DIM|2|22|-104|114|-32|-105|-40|-193|-191|54|114|114|-99
    |114|-39|-5|114|
    1|1|A|CMPID-HXW-2DIM|3|-41|101|-64|-39|114|-49|114|-64|-194|114|114|-188
    |114|-39|114|114|
    
  • mpi_wgtsval
    1|1|A|CMPID-HXW-BOTH|78+120|191|
    1|1|A|CMPID-HXW-BOTH|78+140|191|
    1|1|A|CMPID-HXW-BOTH|82+140|92|
    1|1|A|CMPID-HXW-BOTH|88+200|102|
    1|1|A|CMPID-HXW-BOTH|88+300|191|
    1|1|A|CMPID-HXW-BOTH|a|124|
    1|1|A|CMPID-HXW-BOTH|d|-96|
    
  • mpi_wgtnval
    1|1|A|CMPID-HXW-LEFT|-2|-94|
    1|1|A|CMPID-HXW-LEFT|-1|123|
    1|1|A|CMPID-HXW-LEFT|38|199|
    1|1|A|CMPID-HXW-LEFT|40|199|
    1|1|A|CMPID-HXW-LEFT|44|110|
    
    1|1|A|CMPID-HXW-RIGHT|-2|-107|
    1|1|A|CMPID-HXW-RIGHT|-1|115|
    1|1|A|CMPID-HXW-RIGHT|80|80|
    1|1|A|CMPID-HXW-RIGHT|100|83|
    1|1|A|CMPID-HXW-RIGHT|110|264|
    1|1|A|CMPID-HXW-RIGHT|120|204|
    1|1|A|CMPID-HXW-RIGHT|130|264|