Cleaning/improving/modifying existing variables | Statwing

Cleaning/improving/modifying existing variables

With hand-entered data, it’s not uncommon to see messy data like this:

Screen Shot 2014-09-25 at 10.33.46 PM

 

Select the variable, then “Clean”…

clean-variable

 

…then drag the categories into the correct positions…

female-category-grouping

 

…so now your data will look like this:

Screen Shot 2014-09-28 at 5.46.17 PM

 
Or, if you clean a Numeric variable, you can use the “Variable by Filters” dialogue (see the “Create” section above) to indicate which data should be ignored (for example, numbers above or below a certain threshold).