Users with certain License packages can use Data Weighting to analyze their survey results.
1. Applying Custom Variable Weights
- Starting at the Results Page, export a raw data file from your Original - as fielded survey results. Select either Raw CSV, Excel, or Excel with coded map.
-
Follow the rules of a custom variable upload, deleting all columns EXCEPT the Response ID column and the original variable column (ex: gender).
- Add a column for the custom weight with a title that starts with aytm: followed by either wt or weight, and another word or phrase to help you remember what the variable is. Ex: aytm:wt_gender or aytm:age_weight
Note: this name must be unique from other variables that already exist in the platform like date, gender, age, relationship status, etc.
- Calculate the value of each group by dividing the target percentage by the sampled percentage.
Note: You must use exact, non-rounded percentages in calculations. Weighting should not create extreme changes within the data set - values should be greater than 0.2, and less than 5.
- Populate the aytm:wt___ column with the appropriate weighted value for each respondent
Tip: use a filter and copy+paste the values, or consider an if/then formula.
- Save the file as a .CSV or in Excel format.
Helpful Hint: weighted value = target % / actual(sample) %
|
 |
The industry standard for weighting is RIM weighting, also known as raking. This method uses an algorithm to allow for weighting on multiple variables. If you have questions about developing an appropriate weighting scheme for your data, our Research Services team can help.
2. Weighting your results
- Click the filter icon and scroll past any/all pre-populated variables to the bottom of the page.
- Select Upload more variables, and upload the newly saved CSV.
- Navigate to the Data weighing page by clicking on the scales icon in the left-hand menu.
- Click the Choose weighting variable dropdown menu and select Weight by Custom variable.
- Toggle the button next to Weighting is OFF to Weighting is ON. The data set will reload, and the selected weighting schema will be reflected in your results.
- Click Save as to save a new report with the weighted data.
Note: The platform supports uploading multiple weighted variables. Upload new weighting schemas and save as new reports to toggle between report views.
|
 |