A rating scale question typically includes at least 5 points, however an analysis of the results can be harder to interpret if all 5 categories are charted. That’s where a chart showing only the positive responses can be useful.
Neutral and negative categories are excluded, leaving only the positive responses – enabling quick comparison between different questions or subgroups.
This worksheet shows how to:
- Recategorise responses as ‘Positive’, ‘Neutral’ or ‘Negative’
- Create a horizontal bar chart using the new categories
- Exclude ‘Neutral’ and ‘Negative’ categories, leaving only the ‘Positive’ category
Step 1: Recategorise responses as ‘Positive’, ‘Neutral’ or ‘Negative’
In this example, participants rate aspects of service on a 5 point scale ranging from ‘Very Good’ to ‘Very Poor’. Derived Variables are used to sort ‘Very Good’ and ‘Good’ responses into a new ‘Positive’ category, ‘OK’ responses into a new ‘Neutral’ category, and ‘Poor’ and ‘Very Poor’ responses into a new ‘Negative’ category.
- Click to display the Variables Window.
- Click to add a new variable.
- Specify the Variable details as follows:
Label: Quality of product (this will be displayed on the chart)
Type: Derived (the variable will derive its data from other existing variables)
Response: Single (each respondent will only fall into one of the new codes)
- Specify in the ‘Value’ column, how counts should be redistributed among the new categories. For example, to categorise points 1 and 2 on the scale (‘Very Poor’ and ‘Poor’) as ‘Negative’ type ‘Q8a=(1,2)’ in the Value field for the ‘Negative’ category.
- Click to save the variable.
- Click on the Variables Window toolbar to copy the variable you have just created. Change ‘Q8.a’ to ‘Q8.b’ throughout, and update the label.
- Click to save.
- Repeat for any other questions in the grid.
Step 2: Create a horizontal bar chart using the new ‘derived’ categories
Now you can use the new Derived Variables to create a stacked bar chart of Positive, Neutral, and Negative results.
- Click to build a chart.
- Select the Style ‘Horizontal Stacked Bar Percent Transposed’.
- Type the grid questions into the analysis field.
- Select the option Analysis Percents.
- Select ‘Transpose’.
- Click ‘Apply‘. Your chart should look like this:
- Click to save the chart.
Step 3: Show only the positive ratings
To create a percent positive chart, the negative and neutral values can now be excluded (you could also exclude the positive and neutral values to create a percent negative chart.) This is achieved using the Chart Designer.
- Open your analysis window if it is not already open.
- Double-click the ‘Negative‘ bar to open the Chart Designer. It will open with Series selected on the left-hand side.
- Select ‘Negative‘ in the Series list and select ‘Exclude Series‘ in the options.
- Do the same for the ‘Neutral‘ category.
- Click ‘OK‘ to close the Chart Designer. Your chart will now show only the positive ratings.
Note: This worksheet uses the style ‘Horizontal Stacked Bar Percent Transposed’, other styles are available and can be adapted to fit your specific needs.
For a detailed introduction to analysis in Snap, including a description of all variable types, how to create data filters and more, view the ‘Analysis Essentials’ interactive tutorial. If you’d like to learn more about reporting your survey results, including how to add your own analyses to the default reports, watch the ’Viewing, customising the default Questionnaire and Summary reports’ interactive tutorial.
Other worksheets you may be interested in
- Summarise rating scale responses with Group Variables
- Change the colour of bar chart categories
- Working with rating scale questions
Find more resources in the ‘Analysing Rating Scale Questions’ section.