### Overview

I’ve been looking at various examples over at Stephen Few’s Perpetual Edge web site and one example (this one) really resonates with me as it deals with how to visualize Likert Scale questions.

For the past five years I’ve used Tableau to analyze literally thousands of survey questions, but I’ve never really been happy with how I presented Likert Scale questions results.

That said, a new version of Tableau has brought new capabilities…

But first, just what is a Likert Scale question?

You’re probably familiar with it, you just may not have known that it had a particular name.  The scale, developed by Rensis Likert (pronounced Lick-ert, not Lie-kert), applies quantitative measures to qualitative answers.  Consider the example below.

The “scale” part of the “Likert Scale” comes from applying values to each of the answers. Here’s a typical application:

Poor = 1
Fair = 2
Average = 3
Good = 4
Excellent = 5

I’ve purposely set up an example that asks ten questions of the survey taker (only six are shown above).  Our challenge will be to come up with a way to sort how the company / employee / product ranks based on responses to the survey.

Note: An interactive dashboard that presents all the different approaches may be found at the bottom of this blog post.

### Approach One – Pie Charts

Yuck.  One pie is bad, but ten pies?

In addition to not being able to fit ten pies on the screen, there isn’t an easy way to visually rank these things.  Sure, we can either label the pie slices or use color highlighting to reveal the percentages, but meaningful revelations will remain hidden.

There are very few cases where a pie chart will be your best bet for conveying information.  If you need convincing, I implore you to read Stephen Few’s Save Pie Charts for Dessert and this most excellent example from the Wikipedia entry on pie charts.

### Approach Two – Stacked Bars

This is somewhat of an improvement over pies in that I can fit everything neatly onto one screen and it’s easy to see really obvious places where the company / person / product is strong and weak. The downside is that we still need a legend and that it’s hard to sort the categories from strongest to weakest.

### Approach Three – Adjacent Bars

This one is easier on the eyes (at least my eyes) than the stacked bars and there’s no need for a color legend, but I can’t fit this all on one screen (even if you change the orientation to vertical) and it’s still not easy to rank from strongest to weakest.

### Approach Four – Percent Indicating Good or Excellent

I admit that I have used this approach (probably too often) as it fits on one screen, is easy to sort, and is easy to, well, “grok”.  It also answers the question “what is the percentage of people that have a favorable impression” of something.

Unfortunately, this presentation is incomplete bordering on dishonest as not only are we combining “Good” and “Excellent” into one measure, we’re ignoring any important variations that might exist on the low end of the scale (Poor, Fair, and Average.)

### Approach Five – Likert Values

Here we take advantage of the “scale” part of “Likert Scale” and apply numeric values to each of the five possible responses, and then take the average of all responses.

This approach fits on one screen, is easy to sort, and easy to understand.  It is essential, however, to include the scale values in the presentation (“Poor = 1”, “Fair = 2”, etc.)

But even with that, I think too much that is important to understanding the data is missing.

### Approach Six – Stacked Bars / Likert Values Combo

Here we show both the details and the roll-up scores. The chart fits on one screen, is easy to rank, and you can explore the details.

For example, if you use the color highlighting capability you can easily see how many people indicated “Excellent” or “Good”.

### Why Do Likert Scales Need to Have Adjacent or Linear Values?

Good question.  It turns out that you may reveal a lot more if you reconsider using values like 1, 2, 3, 4 and 5.  Maybe positive attributes (Excellent and Good) should have positive values and negative attributes (Poor and Fair) should have negative values?  Using Tableau’s way cool Parameter control feature we can set the values as we see fit.  The example below ditches the traditional approach and substitutes the following values:

Excellent = 5
Good = 3
Average = 0
Fair = -3
Poor = -5

Spreading out the scale this way really accentuates the differences.

### Where to Go From Here

An interactive dashboard with each of the visualizations may be found below.  Tableau users are welcome to download the source workbook and see how the visualizations were built.

Stephen Few's Likert example

Note: I know that Stephen Few has built some examples that I like even more than the combo chart.  The problem is that they are difficult (but not impossible) to render using my visualization tool of choice.  I’ve chosen instead to only show things that are easy to build using Tableau.

I’d be delighted to see any and all alternatives people come up with.  Please share!

#### [suffusion-the-author]

[suffusion-the-author display='description']

### 15 Responses to “The Likert Question Question”

1. This is great stuff. I’m in the process of doing some survey analysis right now.

I am really impressed with your dual axis Likert Score/Stacked bar dashboard. I particularly like the way you’ve used highlight labels to interact with the Color Legend. I think I shall use that technique myself!

Great work – looking forward to seeing more from this blog!

Andy

2. Andy, thank you for the kind words.

For me it’s the advent of combo charts (and to a smaller extent, parameters) that make all the difference for presenting Likert data with Tableau. While not as elegant as Stephen Few’s prototype design, the Likert score blobs atop stacked bars are good enough for me.

Steve

3. Steve:

This is a nice overview. My one suggestion is that whatever presentation you use should really draw the reader’s attention to the top-box score, since that tends to be the driver for business goals. If you cross-tabulate satisfaction against loyalty, intent to repurchase, NPI, or any other business outcome, you almost always see a huge gap between customers who gave top-box satisfaction and second-box satisfaction.

My theory is that most people will routinely give the best possible score unless they have some problem or issue. The problem might be small, but it’s enough to give customers a reason to explore other options. So it’s really worth finding out what’s driving the “almost but not quite Very Satisfied” customers

4. Peter,

I’m not sure I’m quite following you about the “top-box” score. Do you mean really focusing on the folks that give the highest “grade”, as it were?

That said, one approach (that I’ve used) is to have sliders instead of radio buttons. That is, you can move a slider from 1 to 10 and have notched points along the way. This way you can give rate something as 9.7 (meaning very high, but not quite perfect). The downside is that you are asking people to make more studied decisions. With radio buttons there are only five choices(assuming a five-point Likert scale). With a slider with notched points there might be 100 choices.

Another benefit of the sliders is that you have a full scale rather than five specific points. It allows you to do some cool scatterplot stuff.

Steve

5. I appreciate the shared information and easy to see and understand examples.  This is  helpful as we design reports based on 5-point Likert agreement scale that will be used to measure satisfaction and (optionally) knowledge gain (pre/post) and implementation “efforts.”  Different measures will be administered over time.  Using a standardized agreement scale across all items in satisfaction/knowledge gain/implementation allows for easier comparisons across all measures.

I’ve always been partial to stacked bars (vert or horz) with means and N shown above or on the side.  The  model you show is very nice.  Your negative attributes option is an interesting one . . . Can I assume you show those alternative values to the respondents at time of administration?  That is, it wouldn’t seem right to change the values post administration (except possibly for some internal, non published, analysis.)

I still like pies . . . at Thanksgiving.

Bruce

6. How did you get this kind of diagram like this: Approach Three – Adjacent Bars.
I tried many times, but always I have not get the names of columns (Customers Skiils, Focus, Leader…..) at this place.

Jan

• Jan,

I’m not sure why you would want to use that view, but the post contains the packaged workbook that you can download and see how the visualization is built. You’ll find the dashboard at the end of the post and you can download it.

Steve

I want to learn from you create such a diagram PivotTable without legend.
I did what you recommended, but I still do not see how instead the legend youn receive the column names. This type of graph I really like and would like to be able to create. I can build a pivot table and select the diagram but how to get the effect as your? Could I still spend your time and show me it to any data?
Jan

8. I realized that I build pivot tables in Excel only;
I do not know Access. Is there a solution for my problem?

• Jan,

I’m not following what it is that you want to do. Please feel free to send me screen shots / examples. You may send them to my e-mail at swexler@datarevelations.com.

Steve

9. You say, “Tableau users are welcome to download the source workbook and see how the visualizations were built.” How do I do that?
Thanks!

• Kathryn,