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.
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!
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.
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?
I recommend using SPSS. In this case, your measures of central tendency should be the mode and median. Avoid using the mean and standard deviation, as Likert data is categorized as categorical rather than continuous. Using mean and SD is more sensitive for those categorical data.
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
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 ?
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.
@@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....
@@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 ?
How to analyze Likert Scale questions and create graphs using Excel
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 so much brother... You've saved the day... Jazak Allah Hu kahairan kaseeran
JazakAllah khair!
Really superb explanation...
Thanks for the encouraging words. Hope the video was helpful.
This was AMAZING, thank you so much! VERY helpful!
I’m glad this helped!
An excellent presentation. You're a great instructor!
Thanks a lot!
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 :)
Sir, I m very grateful to you 🙏.
Most welcome 🤗
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!
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’
Informative and easy to follow!
Glad it helped! Please subscribe. Thanks!
Thank you so much. I can now do my task better.
I’m glad this helped!
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?
I recommend using SPSS. In this case, your measures of central tendency should be the mode and median. Avoid using the mean and standard deviation, as Likert data is categorized as categorical rather than continuous. Using mean and SD is more sensitive for those categorical data.
THANK YOU FOR THIS VIDEO.
This was VERY Helpful. Thank you so much!
Simple and straight
Thank you! Please subscribe!
Well explained sir😊
Keep watching
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
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:
th-cam.com/video/9xX15PQxs00/w-d-xo.html
hello, how did you highlight two different columns in making a chart? thank you!
Sir, Please i have a questionnaire but the answers for the questions are different for each question. How can i analyze them??
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?
Thanku very much 🙏
Excellent! Thx!
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
Hello, thank you that was very helpful
Welcome! 🙂
what is the blanks?
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 ...
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.
Thank you so much!
Can we use likert scale without any hypothesis in the study ?
@@nabeelakhtarr How can I interpret the results...any video on that Sir.
Thank you!
what kind of analysis method is this?
is this non-parametric?
Good job you can do more
Hello Sir! I need your help as I am confused with my statistical tool with likert scale data. Can I contact you?
Thank you
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?
Im student, whats mean blanks?
Tell me the time marker in the video.
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 ?
Sir, please how to label as % for each question?
Sir can you teach how to find regression line of this data
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: th-cam.com/video/9xX15PQxs00/w-d-xo.htmlsi=3JgkxERzbqWzaOZj
When I copy to other cells. the formula change
This is EXACTLY what I have been looking for. OMG, I could kiss you! 💋
Oh great! I hope it helped. Pls consider subscribing. Thanks!