Data format for checkbox groups (multi-select questions) | Statwing

Data format for checkbox groups (multi-select questions)

If you’re analyzing a survey with checkboxes, Statwing can recognize them automatically and handle them appropriately.

checkbox-example-display

 

The data can be uploaded with one column for each checkbox, or with one column containing the result for all checkboxes.

 

For the most part Statwing is intelligent about interpreting your data as checkboxes. These are some but not all of the acceptable formats for a column of checkboxes:

checkbox-column-example-columns

 

If some questions were skipped by some survey respondents, those cells must be left blank, and cells where respondents saw the checkbox but did not check it must be given a value. Some but not all of the acceptable formats for a column of checkboxes where some respondents didn’t see the question:

checkbox-column-example-columns-with-skips

 

Auto-detected Checkbox Group Formats

Here are some of the ways we group checkboxes together, based on the name:

  • Checkbox names and values separated by a colon
    • "Color: Red", "Color: Blue", "Color: Green" will be grouped under a variable named "Color" with checkbox values "Red", "Blue", "Green"
  • Checkbox name before values wrapped by brackets, "[ ]"
    • "Color [Red]", "Color [Blue]", "Color [Green]" will similarly create a checkbox variable named "Color" with values "Red", "blue", "Green"
    • Note: The checkbox name MUST be the exactly the same for each variable to be auto-grouped. The checkbox name is the part before the brackets, "[]". Also note the space between "Color" and the bracketed text.

 

Manual Checkbox Grouping

 If Statwing doesn't automatically recognize a checkbox group, you can also manually tell Statwing to make a grouping. Do so by clicking "Create" on the left side of the screen and then "Checkbox", and follow the directions to indicate which columns of data belong together.