Statwing offers several specific ways to create new variables from your existing data.
|Bucketing numbers into groups||
|Grouping categories together||
|Mathematical functions and formulas||
Start by selecting the “Create” button on the left side of the interface:
You’ll be presented with five different tabs, each of which is a different way to create a variable:
***Update: "Bucket a Category" and "Bucket a Number" have been collapsed into one tab since the writing of this help document. They still work as described below, but now that are accessed from the same tab.
Bucket a Category
Bucket a category when you have a category with many groups and you want to combine them into a simpler, aggregated variable. For example:
Use a spreadsheet-like formula to create a new variable.
Statwing has a variety of functions. If you need one that we don’t have, contact us and we can add it quickly, sometimes within 24 hours.
Time-functions, also accessible via the “Formula” tab, make it easy to analyze cycles by, for example, pulling out the month from a column of dates. So if you’re variable looks like this…
…you can pull out the month of the year…
…resulting in this:
Bucket a Number
Sometimes it’s useful to turn numeric data into categorical data by bucketing. So this…
…can be turned into this…
…by using the “Bucket a Number” tab:
Variable by Filters
Use the familiar filter interface from Statwing to identify a specific group and assign it either (1) a specific value like “True” or (2) a value grabbed from another variable.
For example, this set of filters will classify men with a Bachelor’s or Graduate degree as “Highly educated men”, similarly educated women as “Highly educated women”, and any respondent to whom neither of those applies will be classified as “Other”:
Instead of assigning new categories like “Highly educated men”, we could have pulled in the value from a variable, here pulling in whatever value was in the “Religious preference” variable for that respondent: