UPCOMING WEBINAR: Run Research Your Way With AI Skills Register now >>

Articles in this section

See more

How to Apply a Weight to a Specified Column or Column Span

  • Updated
Follow

These rules allow you to apply a weight to either a single column or a specified column span in a table or visualization. Both rules work by generating a new table in the background, applying the selected weight to that table, and then copying the column of weighted numbers into the original table or visualization.

For example, you can go from a standard crosstab...

UnweightedMale.png

...to a crosstab or visualization with a weight applied to a specific column, such as the Male column:

WeightedMale.png

Or from a crosstab with spans...

UnweightedAge.png

...to a crosstab or visualization with a weight applied to a specific column span, such as the Under 35 span:

WeightedAge.png

Requirements

  • A crosstab without spans if you want to apply a weight to a single column.
  • A crosstab with spans if you want to apply a weight to a specified column span.
  • 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 Properties 26UI_ObjectInspector.png of a visualization.

TableInput.png

You will also see a warning in the Rules section of Properties 26UI_ObjectInspector.png 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:

RuleCannotBeApplied.png

Method: Apply Weight to a Specified Column

  1. Select your table.
  2. Go to Data > Rules in Properties 26UI_ObjectInspector.png.
  3. Select Plus (+) > Calculation > Apply Weight to Specified Column.
  4. Select Column to weight.
  5. Select your Weight variable.
  6. Press OK.

Method: Apply Weight to a Specified Column Span

  1. Select your table.
  2. Go to Data > Rules in Properties 26UI_ObjectInspector.png.
  3. Select Plus (+) > Calculation > Apply Weight to Specified Column Span.
  4. Select Column span to weight.
  5. Select your Weight variable.
  6. 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.

Next

How to Use Rules in Displayr

Related articles