How to tabulate, analyze, and prepare graph from Likert Scale questionnaire data using Ms Excel.

Поділитися
Вставка
  • Опубліковано 4 жов 2024
  • This video describes the procedure of tabulating and analyzing the likert scale survey data using Microsoft Excel. This video also explains how to prepare graph from the tabulated data.
    Photo courtesy: littlevisuals.co/

КОМЕНТАРІ • 673

  • @gfilip1
    @gfilip1 5 років тому +4

    You, sir, are a God-send! You are such a generous person. You have no idea how much this has helped me. I'm starting my masters in Psychology and have a paper due based on a self-study and had NO idea how to transmit my data into a graph. Your video is tremendously helpful. God bless you!

    • @edifo
      @edifo  5 років тому

      Most Welcome. Subscribe this channel for more videos.

  • @bethmcneill3310
    @bethmcneill3310 6 років тому +37

    Very thorough and comprehensive. This was my first time ever putting any calculations into Excel. Thanks for creating this tutorial.

    • @edifo
      @edifo  6 років тому

      Most Welcome!!

  • @anamfatimaann8785
    @anamfatimaann8785 2 роки тому +2

    This has been tremendously helpful and thorough guide for me to comprise my questionnaire linkert data analysis and bar graph deliberation.I find myself total naive when it comes to excel and formulas Thankyou so much ,I 've had religiously followed and today fortunately I'd submitted in to my supervisor.

    • @edifo
      @edifo  2 роки тому +1

      Great.
      Keep Learning.....

  • @lisabyers6982
    @lisabyers6982 4 роки тому +1

    SUPER helpful, probably one of the most straightforward videos for these types of tutorials. Thank you so much!

    • @edifo
      @edifo  4 роки тому

      Glad it was helpful!

  • @carolinesimon2669
    @carolinesimon2669 4 роки тому +4

    I am not good at quantitative analysis, so this REALLY REALLY helped! Thanks a lot man

    • @edifo
      @edifo  4 роки тому

      Glad it helped!

  • @dee88dub
    @dee88dub 4 роки тому

    At first, I was taken back from watching this video because of it's age. I decided to give it a shot and it tremendously helped me! Thank you, sir!

    • @edifo
      @edifo  4 роки тому

      Thank you....

  • @madinahel-amin9742
    @madinahel-amin9742 6 років тому +12

    This was one of the mist helpful videos I watched!

    • @edifo
      @edifo  6 років тому

      Thank you !!!!

  • @aal5h
    @aal5h 5 років тому

    perfect perfect and perfect. From zero knowledge in Excel to full analysis of my data.
    Thank you really.

    • @edifo
      @edifo  5 років тому

      Thank you and Most Welcome. Subscribe this channel for more videos.

  • @karfallasalydiakite719
    @karfallasalydiakite719 2 роки тому +1

    This is what I have been looking for. Thank you so much sir for providing such knowledge to the scientific world.

    • @edifo
      @edifo  2 роки тому

      You are most welcome..
      Keep Watching...
      Keep Learning...

  • @mohamedjuma1384
    @mohamedjuma1384 5 років тому +1

    I cant find the words to express my gratitude for you .Your tutorial video is truly helpful and informative.This is what I've been looking for.

    • @edifo
      @edifo  5 років тому

      Thank you and Most Welcome. Subscribe this channel for more videos.

    • @Basic-Lessons-in-Computer
      @Basic-Lessons-in-Computer 4 роки тому

      ua-cam.com/video/nbYi2x84EW0/v-deo.html

  • @screenrecorder1317
    @screenrecorder1317 5 років тому +10

    it's a celebration every time you say "YES".

  • @karabogaffane1915
    @karabogaffane1915 6 років тому +1

    this is such an excellent video..it was my first time to tabulate data, but now i'm Mastering it..thank you

  • @sarathps223
    @sarathps223 6 років тому

    Wonderful. I had no idea how to finish my data analysis in 3 days. You saved my life. Thank you

    • @edifo
      @edifo  6 років тому

      Thank you very much.

  • @jainypm8046
    @jainypm8046 6 років тому +8

    This was very helpful,i could do my project data analysis by following it....thankuuuuuuuuuuu so muchhhhhhhhhhhh

    • @edifo
      @edifo  6 років тому

      Thank you !!!!

  • @zulfiqarali1376
    @zulfiqarali1376 2 роки тому

    Very excellent. First time ever I calculate and put the data in excel sheet because I was facing much difficulties to sort out data for my research study data analyzing process. Thank you so very much.

    • @edifo
      @edifo  2 роки тому

      Glad it helped!

  • @danip113
    @danip113 4 роки тому +1

    Thanks for posting suck a super useful tables, as this helps me alot to do my masters in data analytics and marketing. Thanks a million. Dan xx

    • @edifo
      @edifo  4 роки тому

      You are most welcome. Subscribe my channel for latest update

    • @danip113
      @danip113 4 роки тому +1

      @@edifo Yes, Done it! Thanks a million!!!!! ;)

  • @nhlanhlankambule1791
    @nhlanhlankambule1791 2 роки тому

    A very easy to follow step by step sessions, thank you very much for making work much easier.

    • @edifo
      @edifo  2 роки тому

      Glad it was helpful!

  • @mosekelvin7810
    @mosekelvin7810 3 роки тому

    You are a life saver bro.!!! not all heroes wear capes.!!

    • @edifo
      @edifo  3 роки тому

      Thank you.
      Keep Learning...

  • @spatton968
    @spatton968 2 роки тому

    Thank you so much. This helped me create a table for survey responses from a recent career fair.

    • @edifo
      @edifo  2 роки тому

      Keep Learning...

  • @matchagirl19
    @matchagirl19 8 місяців тому

    Thank you so much! I've been scouring the internet for exactly this!

    • @edifo
      @edifo  7 місяців тому

      Glad I could help!

  • @sergioberlin332
    @sergioberlin332 4 роки тому

    Thanks a lot sir
    You are better in the explanation than my supervisor or even research lecturer at the university

    • @edifo
      @edifo  4 роки тому

      It's my pleasure

    • @edifo
      @edifo  4 роки тому

      Subscribe my channel for latest update

  • @teshomenegede5677
    @teshomenegede5677 3 роки тому

    It was good and easy to understand the presentation and helped me to prepare my Thesis with a Likert Scale questionnaire.

    • @edifo
      @edifo  3 роки тому

      Glad it was helpful!
      Keep Learning...
      Keep Watching....

  • @crazypumpkin738
    @crazypumpkin738 2 роки тому

    Best video I've seen on this topic. So grateful you taught us this. Thank you for the upload

    • @edifo
      @edifo  2 роки тому +1

      Glad it was helpful!

  • @kawsuceesay1452
    @kawsuceesay1452 5 років тому +1

    Wow!!! this helped me a lot in analyzing my Dissertation questionnaires. Thanks so much

    • @edifo
      @edifo  5 років тому +1

      Thank you and Most Welcome. Subscribe this channel for more videos.

  • @ceciliamaina6295
    @ceciliamaina6295 2 роки тому

    This is so amazing. i was able to follow through even though this was my firt time using excel to analye data. thanks a lot and much love and blessings

    • @edifo
      @edifo  2 роки тому

      Glad it helped!

  • @elinan.1498
    @elinan.1498 6 років тому +2

    Thank you for the video. Everything is well explained and tone of voice/ speed overall the video is easy to understand. I appreciate this. keep making more tutorial videos like this. Namaste~ from Nepal.

    • @edifo
      @edifo  6 років тому

      Thank you very much. Subscribe and Click on Bell icon for the alert of my new videos.

  • @allenjoyasistido86
    @allenjoyasistido86 5 років тому

    Thank you for teaching us on how to tabulate the data. It really helps for my research study. THANK YOU AND KEEP IT UP SIR.

  • @the_singing_therapist
    @the_singing_therapist 5 років тому +7

    This was so helpful! Please make more Excel tutorials!!!

  • @micheleverdi-knapp8901
    @micheleverdi-knapp8901 3 роки тому

    Although I have a PhD, I always say when it comes to stat analysis, "speak to me as if I were a child." LOL! THANK YOU for this!!! It was so incredibly easy to follow and understand!!! Even for a right brained social worker like me that hates math!

    • @edifo
      @edifo  3 роки тому

      You are so welcome!

  • @kaygee1293
    @kaygee1293 6 років тому

    This is an excellent video. It really helped me prepare an organized and professional survey analysis! THANK YOU!

    • @edifo
      @edifo  6 років тому

      Thank you very much. Subscribe and Click on Bell icon for the alert of my new videos.

  • @arthellavallarta6058
    @arthellavallarta6058 4 роки тому

    This helped me write my methodology for my thesis proposal. Thank you so much!

    • @edifo
      @edifo  4 роки тому

      You are very welcome. Subscribe my channel...

  • @sylvabiam1438
    @sylvabiam1438 2 роки тому

    Thanks for this excellent and instructive guide. I've found it really useful in running analysis for my ongoing research data

    • @edifo
      @edifo  2 роки тому +1

      Glad it was helpful!

  • @3614poo
    @3614poo 2 роки тому

    Hello... Here Pooja From India..... Thank you so much for the video.... Very easily explained...... Excellent 👌👌

    • @edifo
      @edifo  2 роки тому

      My pleasure 😊

  • @sariw2009
    @sariw2009 12 днів тому

    This was so helpful and easy to follow, thank you!!!!

  • @shizualaska
    @shizualaska 5 років тому

    Thank you for this Sir,
    I just survived my research paper because of this tutorial. ❤️

    • @edifo
      @edifo  4 роки тому

      Thank you very much. Subscribe my channel and click the bell icon for further update. Keep Moving

  • @prebhamanickam704
    @prebhamanickam704 4 роки тому

    very helpful video. U were crisp and clear in your explanation

    • @edifo
      @edifo  4 роки тому

      Thank you 🙂

  • @gracenabas3928
    @gracenabas3928 7 років тому +4

    this was very helpful- I was able to quickly process the data. Thank you!

    • @edifo
      @edifo  7 років тому

      Thank you.

    • @PrasanthKumarM
      @PrasanthKumarM 6 років тому

      ua-cam.com/video/eza1XbeD2Hc/v-deo.html

  • @thisaripiusha5338
    @thisaripiusha5338 4 роки тому

    Good Explanation, new student can understand very well.

    • @edifo
      @edifo  4 роки тому

      Keep watching

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

    Thank you so much for this tutorial. It helps me in my research data analysis 🥰

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

      Glad it was helpful!

  • @reetarai7483
    @reetarai7483 3 роки тому

    Thank you very much for your explicit explanation.

    • @edifo
      @edifo  3 роки тому

      You are welcome!

  • @danip113
    @danip113 5 років тому +1

    I think you helped me to pass my assignment !! Thanks once more!!

  • @lucasowuor-omondi82
    @lucasowuor-omondi82 7 років тому +1

    Well articulated and user friendly. Kudos for you

    • @edifo
      @edifo  7 років тому

      +Lucas Owuor-Omondi Thank you very much !!!

  • @titasalas2572
    @titasalas2572 5 років тому +4

    excellent, thank you. It was easy to understand and I'm going to use it in my thesis process.

  • @yuginirt
    @yuginirt 6 років тому +3

    thank you for this wonderful video....it has really helped me in my dissertation format....keep it up

    • @edifo
      @edifo  6 років тому

      Thank you !!!

  • @mesquitacassandra
    @mesquitacassandra 4 роки тому +1

    Thank you so much for this video! It was extremely helpful and very straightforward, super easy to follow. Thanks again!

    • @edifo
      @edifo  4 роки тому

      Thank you very much. Subscribe my channel and click the bell icon for further update.

  • @jeypi__
    @jeypi__ 5 років тому

    We finished our thesis thanks to this video

  • @genearupertclaire7414
    @genearupertclaire7414 3 роки тому

    You are a life-saver! Keep it up! Thank you very much.

    • @edifo
      @edifo  3 роки тому

      Glad it helped!
      Keep Learning...
      Keep Watching...

  • @Skycolor94
    @Skycolor94 6 років тому +1

    Thank you. Great video - to the point without too much fuss!

    • @edifo
      @edifo  6 років тому

      Thank you very much. Subscribe and Click on Bell icon for the alert of my new videos.

  • @mayakhani4555
    @mayakhani4555 3 роки тому

    that was really great, I used it for my thesis analysis, thank U.

    • @edifo
      @edifo  3 роки тому

      Glad it was helpful!

  • @elsiegen3579
    @elsiegen3579 3 роки тому

    It is really amazing!!!Thank you so much. This is very informative and helpful. This is what I'm looking for my thesis.

    • @edifo
      @edifo  3 роки тому

      Glad it was helpful!

  • @zamiphilicknnox6720
    @zamiphilicknnox6720 4 роки тому

    Extremely helpful. Helped a lot for my seminar, Thank you.🙏

    • @edifo
      @edifo  4 роки тому

      Glad it helped!

  • @monicat7584
    @monicat7584 5 років тому

    This was just what i needed. Very well done, easy to follow and understand. Thanks much.

    • @edifo
      @edifo  2 роки тому

      Thank you

  • @ordinarygirl1087
    @ordinarygirl1087 6 років тому +1

    sir may god bless you , i thannk you from the bottom of my heart for helping me .

    • @edifo
      @edifo  6 років тому

      Thank you very much !!!

  • @aneeshakakara5056
    @aneeshakakara5056 3 роки тому

    Sir the way u explained is amazing

    • @edifo
      @edifo  3 роки тому

      Thank you...
      Keep watching...
      Keep Learning...

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

    very helpful, straight forward and very clear! Thank you!

    • @edifo
      @edifo  3 роки тому

      Thank you....
      Keep Watching....
      Keep Learning...

  • @madhurimachaudhuri3282
    @madhurimachaudhuri3282 3 роки тому

    It is extremely useful. Nicely demonstrated.

    • @edifo
      @edifo  3 роки тому

      Glad it was helpful!
      Keep Learning....

  • @preethamanoj2735
    @preethamanoj2735 4 роки тому

    Thank you very much sir. It's very helpful for me. Your detailing is amazing. Waiting for next video.

    • @edifo
      @edifo  4 роки тому

      Most welcome 😊

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

    Very helpfull analysing data for my project. Thank you so much

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

      Glad it was helpful!

  • @angelarixx9984
    @angelarixx9984 5 років тому +1

    Thank you very informative! I learned the shortcut making it easier for me to accomplish my work. Great job!

  • @roneltoling7289
    @roneltoling7289 5 років тому +1

    This is very useful
    in our presentation of data thank you

  • @faarehasalman5334
    @faarehasalman5334 3 роки тому

    YOU ARE AN ABSOLUTE GENIUS! THANK YOU FOR THIS!

    • @edifo
      @edifo  3 роки тому

      You're welcome!
      Keep Learning....
      Keep watching...

  • @jeffmusyoka1876
    @jeffmusyoka1876 4 роки тому

    God bless you alot Sir. you have saved me big time

    • @edifo
      @edifo  4 роки тому +1

      You are most welcome

  • @sonamyangden5207
    @sonamyangden5207 2 роки тому

    Thank you so much 😊 So comprehensive and helpful.

    • @edifo
      @edifo  2 роки тому

      Glad it was helpful!

  • @rufuspaul3654
    @rufuspaul3654 2 роки тому

    Thank you so much. It is very clear and easy to understand.

    • @edifo
      @edifo  2 роки тому

      Glad it was helpful!

  • @nooreaain1978
    @nooreaain1978 2 роки тому

    Very good presentation and excellent explanation sir.... Thanks a lot

    • @edifo
      @edifo  2 роки тому

      You are most welcome

  • @khicks4819
    @khicks4819 4 роки тому

    Thank you for sharing this Excel tutorial! Very helpful.

    • @edifo
      @edifo  4 роки тому

      Glad it was helpful!

  • @Mel-mj9ph
    @Mel-mj9ph 6 років тому +7

    It help me for finding survey results, thank you so much

    • @edifo
      @edifo  6 років тому +1

      Thank you !!!!

    • @marys3738
      @marys3738 5 років тому +1

      Omg! My boss just asked me to analyze the results of our surveys in Excel and I had no idea how to do it with ordinal data. I've never worked with ordinal data before. Thank you from the bottom of my heart.

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

    You just saved my dissertation. Thank youuu x

    • @edifo
      @edifo  3 роки тому

      I'm so glad!
      Keep Learning

  • @asaduzzamansikder7660
    @asaduzzamansikder7660 3 роки тому

    Thank you so much for this video! It helped me a lot as a beginner!

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

      Glad it was helpful!
      Keep Learning

  • @mariyamshazna3168
    @mariyamshazna3168 2 роки тому

    the best tutorial ever!!!
    Thank you so much!

    • @edifo
      @edifo  2 роки тому

      You're welcome!

  • @devd7913
    @devd7913 6 років тому

    I hugely appreciate your work. I understood in one time watch. Thanks a lot.

    • @edifo
      @edifo  6 років тому +1

      Thank you very much !!

  • @ChiTwnCutie
    @ChiTwnCutie 3 роки тому

    FANTASTIC!! Thank you so much for an extremely helpful video!

    • @edifo
      @edifo  3 роки тому

      Glad it was helpful!

  • @mayrukiye6406
    @mayrukiye6406 4 роки тому

    Thank you so much for your complete explanation. It was really helpful for me.

    • @edifo
      @edifo  4 роки тому

      Most Welcome

  • @ephraimdaka7954
    @ephraimdaka7954 4 роки тому

    Great, very good class, I have learnt alot in this short time of the video, thumbs up!

    • @edifo
      @edifo  4 роки тому

      Thank you very much. Subscribe my channel and click the bell icon for further update.

  • @pollyjewel-ripp3051
    @pollyjewel-ripp3051 2 роки тому

    This was exactly what I was looking for! Very helpful! You made my day!!

    • @edifo
      @edifo  2 роки тому +1

      Glad I could help!

  • @s36a1
    @s36a1 5 років тому

    Super video, step by step very useful. Thank you.

    • @edifo
      @edifo  5 років тому

      Most Welcome. Subscribe this channel for more videos.

  • @mayeramalik8311
    @mayeramalik8311 2 роки тому

    Very helpful video it makes my work so easy thank you ❤️

    • @edifo
      @edifo  2 роки тому +1

      You’re welcome 😊

  • @shamineywalsh-dupuis6520
    @shamineywalsh-dupuis6520 2 роки тому

    Thank you so very much. This was very informative and helpful

    • @edifo
      @edifo  2 роки тому

      Glad it was helpful!

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

    Thank you very much, I really do appreciate this video very detail and clear. Blessings.😊

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

      Glad it was helpful!

  • @sarayvegapulido1822
    @sarayvegapulido1822 2 роки тому

    Thank you very much for this excellent tutorial!

    • @edifo
      @edifo  2 роки тому

      You're very welcome!

  • @hesellfabellon5207
    @hesellfabellon5207 6 років тому

    Thank you. Very clear and easy to follow instructions

    • @edifo
      @edifo  6 років тому

      Thank you very much !!

    • @PrasanthKumarM
      @PrasanthKumarM 6 років тому

      ua-cam.com/video/eza1XbeD2Hc/v-deo.html

  • @suzannekobeisse629
    @suzannekobeisse629 3 роки тому

    Thank you very much! very useful and clear tutorial to follow

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

      Glad it helped! Keep watching....

    • @suzannekobeisse629
      @suzannekobeisse629 3 роки тому

      @@edifo Any idea how to calculate the median and standard deviation for Likert scale please?

  • @NandishPatelV
    @NandishPatelV 2 роки тому

    Thanks! Quite useful. Simple and clear.

    • @edifo
      @edifo  2 роки тому

      Glad it was helpful!

  • @zephirothia
    @zephirothia 4 роки тому

    this is so freaking helpful, thanks so much , ur voice sounds like amitabh bachan..feeling like im sitting in his class in gurukul

    • @edifo
      @edifo  4 роки тому

      Thank you very much....

  • @shabnamkhan5647
    @shabnamkhan5647 4 роки тому

    Really very helpful to understand ..thanks for your video

    • @edifo
      @edifo  4 роки тому

      Thank you..

  • @shermohammadatif7644
    @shermohammadatif7644 5 років тому

    Wow! it was nice and informative video. I enjoyed a lot. Now I can analyze my data and make a graph through learning this video. Thank you so much.

    • @edifo
      @edifo  5 років тому

      Most Welcome. Subscribe this channel for more videos.

  • @CanalConsidere
    @CanalConsidere 3 роки тому

    Incredibly helpful. thank you so much.

    • @edifo
      @edifo  3 роки тому

      Glad it was helpful!

  • @withneylimbu6837
    @withneylimbu6837 6 років тому +2

    Thank you so much for the video. saved my life!!

    • @edifo
      @edifo  6 років тому

      Thank you very much !!

  • @sarahreid1729
    @sarahreid1729 4 роки тому +1

    That was brilliant! Exactly what I was looking for, and so helpful. Thankyou.

    • @edifo
      @edifo  4 роки тому

      Thank you very much. Subscribe my channel and click the bell icon for further update.

  • @ibukunokunoye4795
    @ibukunokunoye4795 2 роки тому

    Thank you very much making this video! It was very helpful!

    • @edifo
      @edifo  2 роки тому

      Glad it was helpful!

  • @kevinreed95
    @kevinreed95 2 роки тому

    This is exactly what I was looking for. Thank you!

    • @edifo
      @edifo  2 роки тому

      Glad it was helpful!

  • @mirachristy4060
    @mirachristy4060 3 роки тому

    THANK YOU FOR SAVING A COLLEGE STUDENT'S LIFE T_T

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

      Keep Watching..... Keep Learning....

  • @veronicaspyridonos608
    @veronicaspyridonos608 4 роки тому

    Great tutorial, thank you so much! Simple and easy to follow!

    • @edifo
      @edifo  4 роки тому

      Glad it was helpful!

  • @snehajpraj9100
    @snehajpraj9100 5 років тому +1

    It saved a lot of time. Thanks a Lot....

  • @naimaaqeel8092
    @naimaaqeel8092 5 років тому

    Thank you so much sir.. this video helps me a lot in my thesis....

  • @bikashdas1937
    @bikashdas1937 3 роки тому

    It's really helpful for me. Thank you so much

    • @edifo
      @edifo  3 роки тому

      You are most welcome
      Keep Learning...

  • @user-cj1ek5np8d
    @user-cj1ek5np8d 3 роки тому +3

    Thank you for the awesome walkthrough! Question, is there a way to take this method a step further and have excel tabulate correlations between answers? For example, respondents that answered strongly agree on question 1 were more likely to answer disagree on question 7. Any assistance would be appreciated! Thank you again for this video!!!

    • @edifo
      @edifo  3 роки тому

      Thank you.
      You can conduct correlation in excel.
      In your scenario, consider, this answer as categorical data.

  • @danip113
    @danip113 5 років тому

    Super useful! Thanks for helping in my data analytics!!!!!

    • @edifo
      @edifo  5 років тому

      Thank you and Most Welcome. Subscribe this channel for more videos.

  • @katrinalouisepal3000
    @katrinalouisepal3000 6 років тому +2

    Sir, it is with no doubt that your video will greatly help in analyzing results and tabulating data. Thank you. Sir, i have been reading about statistical tools for likert scales. But it seems i cannot understand why or is it always necessary to compute the mean and standard deviation? I hope you will answer my query. Thank you.

    • @edifo
      @edifo  6 років тому

      Standard deviation and variance are the indicators of how spread your data is, Watch my next video.
      Thank you very much. Subscribe and Click on Bell icon for the alert of my new videos.

  • @aliceebaee
    @aliceebaee 2 роки тому +1

    Good explanation. Thanks!

    • @edifo
      @edifo  2 роки тому

      Glad it was helpful!