How to analyze Likert Scale using Excel

Поділитися
Вставка
  • Опубліковано 5 лют 2025

КОМЕНТАРІ • 23

  • @MohamedBenhimaPhD
    @MohamedBenhimaPhD  3 роки тому +1

    📌 For assistance with data analysis, kindly contact me via this email: datanalysis93@gmail.com or WhatsApp: +212619398603 / wa.link/l6jvny
    Facebook: facebook.com/benhima1/
    Instagram: instagram.com/medbenhima2015/
    Linkedin: www.linkedin.com/in/mohamed-benhima-6a1087109/
    Twitter: twitter.com/Mohamed_Benhima
    WhatsApp: +212619398603
    E-mail: Datanalysis93@gmail.com
    Zoom: us05web.zoom.us/j/5038752034?pwd=SDVjZGZXaEl5b0d2bVJ2c3M2VzVWUT09
    Google Meet: meet.google.com/tgr-vmww-aoj
    GoogleClassroom: classroom.google.com/c/MzI0MDc1MjM4NDI0?cjc=s2vuft2
    Code: s2vuft2
    Telegram Research Support Group: t.me/joinchat/FqMy6gQ-xRU6bgLg

  • @Junecode
    @Junecode 7 місяців тому +6

    Is it just me, or should this analysis be done per question? Quick question, does column A represent per response/ respondent?

    • @pdobey
      @pdobey 5 місяців тому +2

      Yes it should be calculated vertically. :)

    • @dickenshonest
      @dickenshonest 5 місяців тому +1

      yes, it was supposed to be per question or per statement you have in the table

  • @Bonu9
    @Bonu9 11 місяців тому +1

    Sir good day!
    In my likert 5-scale for each item I have four or five questions and in what order to include the order of answers and calculate them?
    Thanks in advance

  • @gracelynauman1718
    @gracelynauman1718 9 місяців тому

    Hello I have a question our likert scale is decimals.how do we interpret it using p-value?

  • @pdobey
    @pdobey 5 місяців тому +1

    I think the calculations needs to be done vertically - not horizontally.

  • @chandrasekaranr6607
    @chandrasekaranr6607 11 місяців тому

    Sir I am doing a KAP study between working women and Housewives..for that how to choose formula for t test in excel..

  • @Bonu9
    @Bonu9 10 місяців тому

    Dear sir how to calculate if I have three or four questions for each attribute?

    • @MohamedBenhimaPhD
      @MohamedBenhimaPhD  10 місяців тому

      You need to check Cronbach alpha reliability

    • @Bonu9
      @Bonu9 10 місяців тому

      @@MohamedBenhimaPhD to check which attribute is most important and less important I used likert 5scale. And made three or four questions for each attribute so in case also I need to check cronbach alpha realisability?
      Thanks sir in advance

  • @SARMIENTOMarielleDelaCruz
    @SARMIENTOMarielleDelaCruz Рік тому

    Hi, Sir! How to correlate that data with grades?

  • @blessingakan
    @blessingakan Рік тому

    What is the formula if you want to calculate standard deviation manually

  • @Leelavathi_2023
    @Leelavathi_2023 2 роки тому +3

    Sir, How to code likert scale?

  • @ayandapeter1681
    @ayandapeter1681 6 місяців тому

    I didn't find this useful at all, how do I interpret the data??

  • @yongjing-z5v
    @yongjing-z5v Рік тому

    Good Afternoon Sir, does the average means mean?

  • @viperplays4888
    @viperplays4888 Рік тому

    how to do regersion of this

  • @Oke-n3e
    @Oke-n3e 5 місяців тому

    I'll be blunt with you. As far as data analysis is concerned the calculations in this video are meaningless at best