Plotting Likert (agree/disagree) data in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 ธ.ค. 2024

ความคิดเห็น • 14

  • @mlo9987
    @mlo9987 ปีที่แล้ว +2

    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!

  • @alisonhill4892
    @alisonhill4892 2 หลายเดือนก่อน

    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.

  • @jameselliott4911
    @jameselliott4911 9 หลายเดือนก่อน

    Excellent explanation! Thank you! It's a wonder that Excel doesn't do this already.

    • @ChrisArmstrongChemistry
      @ChrisArmstrongChemistry  9 หลายเดือนก่อน

      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.

  • @YTFC2008
    @YTFC2008 ปีที่แล้ว +8

    I likert very much, thank you!

  • @HRUMS
    @HRUMS 2 ปีที่แล้ว +2

    thank you very much. I have learned a lot from your presentation.

  • @carmenalns4156
    @carmenalns4156 6 หลายเดือนก่อน

    This was such a life saver, thank you so much!!

  • @carok6673
    @carok6673 11 หลายเดือนก่อน

    genius! exactly what I needed, thanks a lot!

  • @yumnamoussa8165
    @yumnamoussa8165 ปีที่แล้ว +1

    thank you!!! this was so helpful

  • @hs0008
    @hs0008 ปีที่แล้ว

    Thanks for your help Chris

  • @AnnaRiling
    @AnnaRiling ปีที่แล้ว

    How would you visualize a "NA/Don't know" response? Would that be a 2nd axis?

  • @nobuenomonkey478
    @nobuenomonkey478 2 ปีที่แล้ว

    Thank you for this video. I’ve trying to figure out how to properly display my data from my surveys

    • @ChrisArmstrongChemistry
      @ChrisArmstrongChemistry  2 ปีที่แล้ว +1

      It's probably slightly easier in R, but once you have a template set up, may as well keep with a spreadsheet.