How to analyze data in Excel for Likert Scale Questions | Create graphs for likert scale questions
HTML-код
- Опубликовано: 6 июл 2024
- Buy me coffee: ko-fi.com/supportnabeel
This clip is a step-by-step tutorial on how to analyze Likert type questions in Excel. It also shows you how to create graphs using the data. You will learn how to analyze data in excel for Likert scale questions or Likert scale type questions. Also learn how to create graphs from Likert scale questions.
00:00 - Intro to Likert type questions
00:34 - Create the data model with sample data
02:20 - Setup the Count table
05:24 - Verify the data count
05:44 - Copy the count formula for the rest of the variables
06:01 - Calculate the percentages for each variable
07:47 - Copy the text of each variable
08:43 - Create a column chart for a variable
ko-fi.com/supportnabeel
How to analyze Likert Scale questions and create graphs using Excel
This was VERY Helpful. Thank you so much!
Thank you so much brother... You've saved the day... Jazak Allah Hu kahairan kaseeran
JazakAllah khair!
sir what about the numbers that are linked with attributes such as strongly agree=5, agree=4 and so on. How to analyze data that way? How to show overall positive and negative attitude?
thank you. I have watched more than 50 videos but the way you explained is very beginner friendly. It has made me clear rather than confusing like the previous 50s.
That’s good to know. I tried to make it as simple as I could. Do consider subscribing. Thank you!
I would like to thank you for this. It is excellent. I had learned this a long time ago but had largely forgotten it. As I watched your presentation it all clicked back into place!
Glad it was helpful!
THANK YOU FOR THIS VIDEO.
This was so helpful thank you
Hi, thank you for the video. how I can mix this Likert scale with the pivot table? To analyze the results by gender or education?
Excellent! Thx!
This was AMAZING, thank you so much! VERY helpful!
I’m glad this helped!
Thank you so much!
Salam. I just needed this video so baaaaaaaad!! Cant thank you enough! youre an angel 😙
@@nabeelakhtarr Can you please make a video on RACI Charts? I am doing my PhD and I want to create a RACI Chart as well. Please Help :)
hello, how did you highlight two different columns in making a chart? thank you!
Thank you!
Thanku very much 🙏
That was great! I did not create individual charts and ended up making one 100% stacked histogram. But the video helped me organize the dataset and was very useful in doing the initial steps of count and % before making the charts.
I’m glad this helped!
An excellent presentation. You're a great instructor!
Thanks a lot!
Informative and easy to follow!
Glad it helped! Please subscribe. Thanks!
Thank you
Good job you can do more
Sir i need to know can we apply chi square test for this set of data... Plz let me help with this.. I have same set of data... But i m struggling with what type of statistical test can be applied to this data
Thank you so much. I can now do my task better.
I’m glad this helped!
Sir, Please i have a questionnaire but the answers for the questions are different for each question. How can i analyze them??
Learned a lot from your teachings thank you for the goodwork
Glad to hear it! Let me know what other lessons you would like. I have recently uploaded an MS-Word lesson on ‘how to handle long documents’
Hello, thank you that was very helpful
Welcome! 🙂
Simple and straight
Thank you! Please subscribe!
Sir, please how to label as % for each question?
Hello everyone i need to ask i am using a likert scale but as can i see in Likert-type scale no scoring so any one know how to measure data after gather ? No scoring in scale.
Hello Sir! I need your help as I am confused with my statistical tool with likert scale data. Can I contact you?
Well explained sir😊
Keep watching
Thanks for video, if i want to know how the question no 2 responses related to question no 5, means any relation or dependence one question to another" how I can do? Kindly clarify
@@nabeelakhtarr sir, I want to know one question reposne have any relation or dependence on another question responses...how i ll calculate in excel ? What kind of test ll be best ?
@@nabeelakhtarr thank you sir for ur kind +ve response ...
what is the blanks?
Sir can you teach how to find regression line of this data
Can we use likert scale without any hypothesis in the study ?
@@nabeelakhtarr How can I interpret the results...any video on that Sir.
Nice Explanation....I need a little help from you
@@nabeelakhtarr sir I have to analyze my likert scale data.... I m little confused in it. Can I have your Whatsapp no. there I can explain it in a better way....
@Nabeel Akhthar Bhaiya...is there any app where I can reach out to you?
what kind of analysis method is this?
is this non-parametric?
Hello sir when I am trying to apply this method my number show 0
Check the decimal setting for your cell
sir how it is use in power query
That is the next video I will be creating 🤓
Khalid, I just uploaded the video you requested. Please have a look:
ruclips.net/video/9xX15PQxs00/видео.html
How can I fix this ?
Have a look at this video: support.microsoft.com/en-us/office/display-or-hide-zero-values-3ec7a433-46b8-4516-8085-a00e9e476b03
Sir what when u have put codes like strongly agree=5 agree=4 neutral=3 disagree=2 strongly disagree=1
Sorry but I didn’t understand your question.
@@nabeelakhtarr .. sir we give code to strongly agree as 5 and agree as 4 neutral as 3 and so on instead of writing strongly agree, disagree, strongly disagree etc ?? How can we analyse that ?
Im student, whats mean blanks?
Tell me the time marker in the video.
This is EXACTLY what I have been looking for. OMG, I could kiss you! 💋
Oh great! I hope it helped. Pls consider subscribing. Thanks!
Why not use a pivot table to get the totals for each response? Would have saved you alot if time!
I have done that here: ruclips.net/video/9xX15PQxs00/видео.htmlsi=3JgkxERzbqWzaOZj
When I copy to other cells. the formula change