Plotting Likert (agree/disagree) data in Excel
Vložit
- čas přidán 11. 09. 2024
- If you're processing survey data that includes scales from strongly agree to strongly disagree, or similar, you probably want to plot it rather than try to compress it to a single number -- I know people who would get very, very angry if you did that. This gives a nice visualisation of your results, which doesn't hide any distributions or make assumptions about what "neither" might mean. This tutorial covers how to build such a plot in Excel. Alternatives are available, obviously. It's probably in R, too, but you can build a spreadsheet template and drop your data into it again and again and have it update instantly.
Thank you very much for this! I've re-watched it many times and its helped me make excellent charts for my Masters coursework. The way you explained it was excellent and very easy to follow.
Thank you. It took me a while to find as most videos out there are on how to create an initial Likert scale, not on how to display the results. I am grateful that I came across your video!
I likert very much, thank you!
Excellent explanation! Thank you! It's a wonder that Excel doesn't do this already.
It can do stacked bar charts that are scaled to 100%. That's perfectly acceptable for most uses, especially if the number of responses is comparable between questions, and works "out of the box" with no modifications. But those can be a little harder to see exactly where the central tendency is. It'll come down to preference and what you want to show.
This was such a life saver, thank you so much!!
thank you very much. I have learned a lot from your presentation.
genius! exactly what I needed, thanks a lot!
thank you!!! this was so helpful
Thanks for your help Chris
Thank you for this video. I’ve trying to figure out how to properly display my data from my surveys
It's probably slightly easier in R, but once you have a template set up, may as well keep with a spreadsheet.
How would you visualize a "NA/Don't know" response? Would that be a 2nd axis?
I don't think I've seen N/A used with this style.