Тёмный

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

Edifo
Подписаться 6 тыс.
Просмотров 445 тыс.
50% 1

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/

Опубликовано:

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 673   
@bethmcneill3310
@bethmcneill3310 6 лет назад
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!!
@gfilip1
@gfilip1 5 лет назад
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.
@anamfatimaann8785
@anamfatimaann8785 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 года назад
Great. Keep Learning.....
@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!
@lisabyers6982
@lisabyers6982 4 года назад
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!
@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....
@3614poo
@3614poo 2 года назад
Hello... Here Pooja From India..... Thank you so much for the video.... Very easily explained...... Excellent 👌👌
@edifo
@edifo 2 года назад
My pleasure 😊
@carolinesimon2669
@carolinesimon2669 4 года назад
I am not good at quantitative analysis, so this REALLY REALLY helped! Thanks a lot man
@edifo
@edifo 4 года назад
Glad it helped!
@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!
@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 года назад
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 6 лет назад
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 5 лет назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nbYi2x84EW0.html
@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....
@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.
@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
@madinahel-amin9742
@madinahel-amin9742 6 лет назад
This was one of the mist helpful videos I watched!
@edifo
@edifo 6 лет назад
Thank you !!!!
@sariw2009
@sariw2009 22 дня назад
This was so helpful and easy to follow, thank you!!!!
@prebhamanickam704
@prebhamanickam704 4 года назад
very helpful video. U were crisp and clear in your explanation
@edifo
@edifo 4 года назад
Thank you 🙂
@karabogaffane1915
@karabogaffane1915 6 лет назад
this is such an excellent video..it was my first time to tabulate data, but now i'm Mastering it..thank you
@nooreaain1978
@nooreaain1978 2 года назад
Very good presentation and excellent explanation sir.... Thanks a lot
@edifo
@edifo 2 года назад
You are most welcome
@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!
@jainypm8046
@jainypm8046 6 лет назад
This was very helpful,i could do my project data analysis by following it....thankuuuuuuuuuuu so muchhhhhhhhhhhh
@edifo
@edifo 6 лет назад
Thank you !!!!
@screenrecorder1317
@screenrecorder1317 5 лет назад
it's a celebration every time you say "YES".
@slykhajiit2
@slykhajiit2 3 года назад
yes. look good
@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 😊
@spatton968
@spatton968 3 года назад
Thank you so much. This helped me create a table for survey responses from a recent career fair.
@edifo
@edifo 2 года назад
Keep Learning...
@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 года назад
Glad it was helpful!
@thisaripiusha5338
@thisaripiusha5338 4 года назад
Good Explanation, new student can understand very well.
@edifo
@edifo 4 года назад
Keep watching
@matchagirl19
@matchagirl19 9 месяцев назад
Thank you so much! I've been scouring the internet for exactly this!
@edifo
@edifo 7 месяцев назад
Glad I could help!
@mosekelvin7810
@mosekelvin7810 3 года назад
You are a life saver bro.!!! not all heroes wear capes.!!
@edifo
@edifo 3 года назад
Thank you. Keep Learning...
@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!
@danip113
@danip113 4 года назад
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 года назад
@@edifo Yes, Done it! Thanks a million!!!!! ;)
@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 года назад
Glad it was helpful!
@sithlayesuaybaguio1987
@sithlayesuaybaguio1987 2 года назад
this is soo helpful ,i was looking for any likert scale analysis but may i know what statistical tool you use in this video sir ?
@edifo
@edifo 2 года назад
Statistical Tool?
@aneeshakakara5056
@aneeshakakara5056 3 года назад
Sir the way u explained is amazing
@edifo
@edifo 3 года назад
Thank you... Keep watching... Keep Learning...
@user-cj1ek5np8d
@user-cj1ek5np8d 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.
@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!
@reetarai7483
@reetarai7483 3 года назад
Thank you very much for your explicit explanation.
@edifo
@edifo 3 года назад
You are welcome!
@katrinalouisepal3000
@katrinalouisepal3000 6 лет назад
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.
@the_singing_therapist
@the_singing_therapist 5 лет назад
This was so helpful! Please make more Excel tutorials!!!
@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.
@ahmed3820
@ahmed3820 3 года назад
Thank you sir for this short and simple explanation, i have a question, Can we make a cumulative graph for the whole result that shows the likerts percentages ?! ( the total strongly agree % for all 10 questions) can we do sth loke that , because i want to compare two likert scales !!
@edifo
@edifo 3 года назад
There is no need of plotting a cumulative graph. You can depict the cumulative statistics in separate table.
@zakkha2853
@zakkha2853 4 года назад
a very helpful video thank you, but are there any possibility to apply these numbers on the SPSS?
@edifo
@edifo 4 года назад
Sure you can. You can copy the data from Excel and paste it in the SPSS file.
@shabnamkhan5647
@shabnamkhan5647 4 года назад
Really very helpful to understand ..thanks for your video
@edifo
@edifo 4 года назад
Thank you..
@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.
@mayeramalik8311
@mayeramalik8311 2 года назад
Very helpful video it makes my work so easy thank you ❤️
@edifo
@edifo 2 года назад
You’re welcome 😊
@haydenkika
@haydenkika 2 года назад
Sir, thank you so much for such an informative video. I am struggling with the second lot of calculations: strongly agree etc. I am adding the formula but an error occurs. After completing the Formula of=countif then I choose the range enter strongly but I get an error. I can't make out what you are saying rookie? Or are you pressing enter?
@edifo
@edifo Год назад
Please specify your problem clearly, then I can Help you.
@elinan.1498
@elinan.1498 6 лет назад
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.
@vishnuk8549
@vishnuk8549 2 года назад
Very helpfull analysing data for my project. Thank you so much
@edifo
@edifo Год назад
Glad it was helpful!
@madhurimachaudhuri3282
@madhurimachaudhuri3282 3 года назад
It is extremely useful. Nicely demonstrated.
@edifo
@edifo 3 года назад
Glad it was helpful! Keep Learning....
@sonamyangden5207
@sonamyangden5207 2 года назад
Thank you so much 😊 So comprehensive and helpful.
@edifo
@edifo 2 года назад
Glad it was helpful!
@shamineywalsh-dupuis6520
@shamineywalsh-dupuis6520 2 года назад
Thank you so very much. This was very informative and helpful
@edifo
@edifo 2 года назад
Glad it was helpful!
@pujagupta3861
@pujagupta3861 Год назад
Very Helpful sir..Neat and Clear👍👍👍
@edifo
@edifo Год назад
Thanks and welcome
@s36a1
@s36a1 5 лет назад
Super video, step by step very useful. Thank you.
@edifo
@edifo 5 лет назад
Most Welcome. Subscribe this channel for more videos.
@jeffmusyoka1876
@jeffmusyoka1876 4 года назад
God bless you alot Sir. you have saved me big time
@edifo
@edifo 4 года назад
You are most welcome
@enkelejdaskarra
@enkelejdaskarra 4 года назад
very useful.,an excellent explanation..👏👏👏...how can I save formulas as I need to add datas.please?
@edifo
@edifo 4 года назад
You can directly apply the formula in excel cell.
@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...
@rufuspaul3654
@rufuspaul3654 2 года назад
Thank you so much. It is very clear and easy to understand.
@edifo
@edifo 2 года назад
Glad it was helpful!
@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...
@ibukunokunoye4795
@ibukunokunoye4795 2 года назад
Thank you very much making this video! It was very helpful!
@edifo
@edifo 2 года назад
Glad it was helpful!
@mariyamshazna3168
@mariyamshazna3168 2 года назад
the best tutorial ever!!! Thank you so much!
@edifo
@edifo 2 года назад
You're welcome!
@asaduzzamansikder7660
@asaduzzamansikder7660 3 года назад
Thank you so much for this video! It helped me a lot as a beginner!
@edifo
@edifo 3 года назад
Glad it was helpful! Keep Learning
@kawsuceesay1452
@kawsuceesay1452 5 лет назад
Wow!!! this helped me a lot in analyzing my Dissertation questionnaires. Thanks so much
@edifo
@edifo 5 лет назад
Thank you and Most Welcome. Subscribe this channel for more videos.
@sunu6924
@sunu6924 4 года назад
very nice presentation. really helpful
@edifo
@edifo 4 года назад
Glad it was helpful! Keep Watching.....
@sarayvegapulido1822
@sarayvegapulido1822 2 года назад
Thank you very much for this excellent tutorial!
@edifo
@edifo 2 года назад
You're very welcome!
@NandishPatelV
@NandishPatelV 2 года назад
Thanks! Quite useful. Simple and clear.
@edifo
@edifo 2 года назад
Glad it was helpful!
@mayakhani4555
@mayakhani4555 3 года назад
that was really great, I used it for my thesis analysis, thank U.
@edifo
@edifo 3 года назад
Glad it was helpful!
@fadwafraih768
@fadwafraih768 3 года назад
very helpful, straight forward and very clear! Thank you!
@edifo
@edifo 3 года назад
Thank you.... Keep Watching.... Keep Learning...
@donnettdixon6825
@donnettdixon6825 Год назад
Thank you very much, I really do appreciate this video very detail and clear. Blessings.😊
@edifo
@edifo 11 месяцев назад
Glad it was helpful!
@suzannekobeisse629
@suzannekobeisse629 3 года назад
Thank you very much! very useful and clear tutorial to follow
@edifo
@edifo 3 года назад
Glad it helped! Keep watching....
@suzannekobeisse629
@suzannekobeisse629 3 года назад
@@edifo Any idea how to calculate the median and standard deviation for Likert scale please?
@gracenabas3928
@gracenabas3928 7 лет назад
this was very helpful- I was able to quickly process the data. Thank you!
@edifo
@edifo 7 лет назад
Thank you.
@PrasanthKumarM
@PrasanthKumarM 6 лет назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-eza1XbeD2Hc.html
@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
@faarehasalman5334
@faarehasalman5334 3 года назад
YOU ARE AN ABSOLUTE GENIUS! THANK YOU FOR THIS!
@edifo
@edifo 3 года назад
You're welcome! Keep Learning.... Keep watching...
@khicks4819
@khicks4819 4 года назад
Thank you for sharing this Excel tutorial! Very helpful.
@edifo
@edifo 4 года назад
Glad it was helpful!
@tessemareta5919
@tessemareta5919 4 года назад
It is very interesting and keep in touch
@edifo
@edifo 4 года назад
Thank you
@bikashdas1937
@bikashdas1937 3 года назад
It's really helpful for me. Thank you so much
@edifo
@edifo 3 года назад
You are most welcome Keep Learning...
@CanalConsidere
@CanalConsidere 3 года назад
Incredibly helpful. thank you so much.
@edifo
@edifo 3 года назад
Glad it was helpful!
@aliceebaee
@aliceebaee 2 года назад
Good explanation. Thanks!
@edifo
@edifo 2 года назад
Glad it was helpful!
@septrianinidi9381
@septrianinidi9381 4 года назад
Wow. Very useful!! Thank you very much. But, I wonder how to create graph for each of the questions? When I have created graph for question 1, I can't create the second and the next one. I mean, I don't know how to block the title and the second question. Would mind showing me how?
@edifo
@edifo 4 года назад
You can create a consolidated graph for the entire scale or you can create a separate graph for each variable (Question)
@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.
@sehib1090
@sehib1090 2 года назад
Hello sir thank you so much for such insightful video. Really help me in doing my little research. However, I have a concern regarding when we want to make the chart part. Is it possible tho to visualize all the data into a single chart? If so, what is the best chart do you think good to represent the data? Your assistance is very much appreciated
@edifo
@edifo 2 года назад
You can use line chart OR Bar Charts
@zamiphilicknnox6720
@zamiphilicknnox6720 4 года назад
Extremely helpful. Helped a lot for my seminar, Thank you.🙏
@edifo
@edifo 4 года назад
Glad it helped!
@lukebelotindos2597
@lukebelotindos2597 5 лет назад
Very useful. Thank you for making this vid. Do you have any more vids on how to get mean, median, and mode from the tabulated results. If any, can you paste a link here. Thanks
@edifo
@edifo 5 лет назад
Thank you and Most Welcome. Subscribe this channel for more videos.
@kevinreed95
@kevinreed95 2 года назад
This is exactly what I was looking for. Thank you!
@edifo
@edifo 2 года назад
Glad it was helpful!
@yuginirt
@yuginirt 6 лет назад
thank you for this wonderful video....it has really helped me in my dissertation format....keep it up
@edifo
@edifo 6 лет назад
Thank you !!!
@ChiTwnCutie
@ChiTwnCutie 3 года назад
FANTASTIC!! Thank you so much for an extremely helpful video!
@edifo
@edifo 3 года назад
Glad it was helpful!
@titasalas2572
@titasalas2572 5 лет назад
excellent, thank you. It was easy to understand and I'm going to use it in my thesis process.
@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!
@vman4524
@vman4524 4 года назад
This was helpful in a lot of ways but there is one spot I am stuck on. If there is a blank response to any of the questions, do we still use the total of 40 or do we do something different? The blanks will lower the percentages a decent amount depending on how many responses there are.
@edifo
@edifo 4 года назад
Before you conduct the analysis, avoid missing responses.
@jkaeqpo400
@jkaeqpo400 5 лет назад
Hello, I was just asking what data analysis should I use for this kind of questionnaire? Thank You
@edifo
@edifo 5 лет назад
Thank you and Most Welcome. Subscribe this channel for more videos.
@georgiennarosedakay9390
@georgiennarosedakay9390 4 года назад
thank you. it is very informative and helpful.
@edifo
@edifo 4 года назад
Glad it was helpful!
@mirachristy4060
@mirachristy4060 3 года назад
THANK YOU FOR SAVING A COLLEGE STUDENT'S LIFE T_T
@edifo
@edifo 3 года назад
Keep Watching..... Keep Learning....
@2.0_two5
@2.0_two5 3 года назад
You just saved my dissertation. Thank youuu x
@edifo
@edifo 3 года назад
I'm so glad! Keep Learning
@iqrarana8987
@iqrarana8987 5 лет назад
Thanks a lot.. :) very informative and easy to learn
@pollyjewel-ripp3051
@pollyjewel-ripp3051 2 года назад
This was exactly what I was looking for! Very helpful! You made my day!!
@edifo
@edifo 2 года назад
Glad I could help!
@RohanSharma-ue8tc
@RohanSharma-ue8tc 4 года назад
Was very Helpful. Thankyou so much !
@edifo
@edifo 4 года назад
You're welcome!
@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....
@danip113
@danip113 5 лет назад
I think you helped me to pass my assignment !! Thanks once more!!
@amatusniminye4835
@amatusniminye4835 6 лет назад
Thank you very much for this helpful video. May I know when to use this simple approach and when to use a statistical test? I am working on a data that is the first kind and not comparing with previous data to see if there are any variance. Do I use your approach to plot my graph or I have to consider ANOVA?
@edifo
@edifo 6 лет назад
Normally ANOVA is used for variance analysis. You can use different statistical tests depends on the data type that you are used. (Nominal, Ordinal, Interval, Ratio)
@gertrudegonzales3796
@gertrudegonzales3796 4 года назад
Thank you sir it is very helpful 😊. Godbless
@edifo
@edifo 4 года назад
Welcome 😊
@rahatparveen6339
@rahatparveen6339 4 года назад
very very thanks for this video..this is to much help full
@edifo
@edifo 4 года назад
You are most welcome
Далее
Seja Gentil com os Pequenos Animais 😿
00:20
Просмотров 19 млн
Analysing Questionnaires
9:52
Просмотров 321 тыс.
How to analyse Multiple Selection Question using SPSS?
25:15
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
Seja Gentil com os Pequenos Animais 😿
00:20
Просмотров 19 млн