This rule applies a weight to a single column of a table or visualization. This is achieved by generating a new table, applying the selected weight to that table, and then copying the column of weighted numbers into the original table.
The rule takes you from a standard crosstab...
...to a crosstab or visualization with a weight applied to a specific column, e.g., the Male column:
Requirements
- A crosstab without spans.
- A weight variable.
Note: You must apply the rule directly to the input table if you see a table icon in the Data > Data Source > Data field in the object inspector of a visualization.
You will also see a warning in the Rules section of the object inspector if you have applied a rule directly to a non-compatible visualization, and you will need to apply it to the input table instead. For example:
Method
- Select your table.
- Go to Data > Rules in the object inspector.
- Select the Plus (+) > Calculation > Apply Weight to Specified Column.
- Select Column to weight.
- Select your Weight variable.
- Press OK.
Technical Details
Any significance testing results for the weighted columns are taken from the weighted table only, and no attempt is made to reconcile tests between the weighted and unweighted portions of the table. This means that the results in a column with the rule applied are highly unlikely to be comparable to any columns without the rule.