Chat with us
  1. aytm Help Center
  2. Knowledge Base
  3. Basic Survey Analysis

Articles in this section

See more

Data Weighting allows researchers to rebalance their sample results to more evenly distribute responses across a population. When you use this feature in your Results, weighted data will be reflected across platform charts and Banner table exports.

 

 

1. Preparing to construct your custom schema

You will need: 

  • your desired metric or variable for weighting
  • the exact target-percentage for each option or value
  • the sampled percentage for each option
  • a raw data file from your survey with individual values to be weighted (Excel with Coded Map is recommended)

 

 

2. Constructing the Schema

  1. Download a raw data file from your survey (Excel with Coded Map is recommended).
  2. Delete all columns EXCEPT the Response ID column and the original variable column (ex: gender).
  3. 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
  4. 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.
  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.
  6. Save the file as a .CSV or in Excel format.
 
weighted value = target % / actual(sample) %

 

 

3. Data Weighting your results

  1. On your results page, click the Filters tab, scroll to the bottom, and click Upload custom variable.
  2. Select the weighted variable file from your hard drive.
  3. Click the Data Weighting icon in the left menu.
  4. Click the Choose Weighting Variable drop-down, and select Weight by custom variable.
  5. click the drop-down to select the custom variable you uploaded.
  6. Toggle Weighting is OFF to Weighting is ON. 

The data on your page will reload with the weighted variable data. From here you can save as a new report, or reset the data to the Original - as fielded report.
Snag_34c66ed6.png