How to analyze Likert Scale questions and create graphs using Excel
@suchismita908110 ай бұрын
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.
@nabeelakhtarr10 ай бұрын
That’s good to know. I tried to make it as simple as I could. Do consider subscribing. Thank you!
@davidhutchinsinternational6452 Жыл бұрын
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!
@nabeelakhtarr Жыл бұрын
Glad it was helpful!
@HudaRashid192 ай бұрын
Thank you so much brother... You've saved the day... Jazak Allah Hu kahairan kaseeran
@nabeelakhtarr2 ай бұрын
JazakAllah khair!
@cgarrett19744 ай бұрын
This was AMAZING, thank you so much! VERY helpful!
@nabeelakhtarr4 ай бұрын
I’m glad this helped!
@pathofclouds85 Жыл бұрын
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.
@nabeelakhtarr Жыл бұрын
I’m glad this helped!
@shivanidhatwalia87012 жыл бұрын
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?
@bezihendrickson99357 ай бұрын
An excellent presentation. You're a great instructor!
@nabeelakhtarr7 ай бұрын
Thanks a lot!
@sidrashahid99132 жыл бұрын
Salam. I just needed this video so baaaaaaaad!! Cant thank you enough! youre an angel 😙
@sidrashahid99132 жыл бұрын
@@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 :)
@vivienchime95444 ай бұрын
Thank you so much. I can now do my task better.
@nabeelakhtarr4 ай бұрын
I’m glad this helped!
@evanskings_8 Жыл бұрын
Learned a lot from your teachings thank you for the goodwork
@nabeelakhtarr Жыл бұрын
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’
@samadritanag2524 Жыл бұрын
THANK YOU FOR THIS VIDEO.
@ebonisterling572810 ай бұрын
Informative and easy to follow!
@nabeelakhtarr10 ай бұрын
Glad it helped! Please subscribe. Thanks!
@mohammedinuwabello40075 ай бұрын
Simple and straight
@nabeelakhtarr5 ай бұрын
Thank you! Please subscribe!
@gtgrandma53272 жыл бұрын
This was VERY Helpful. Thank you so much!
@fahiden94412 жыл бұрын
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?
@tyraann2058 Жыл бұрын
This was so helpful thank you
@muhammadomar27982 жыл бұрын
Sir, Please i have a questionnaire but the answers for the questions are different for each question. How can i analyze them??
@TechKnowledgewithAmit11 ай бұрын
Well explained sir😊
@nabeelakhtarr11 ай бұрын
Keep watching
@shaguftafatima2644 Жыл бұрын
Thanku very much 🙏
@pauljohnson3317 Жыл бұрын
Excellent! Thx!
@jesslove83722 жыл бұрын
Hello, thank you that was very helpful
@nabeelakhtarr2 жыл бұрын
Welcome! 🙂
@akanshakharkwal73702 жыл бұрын
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
@aljeanmarietimonan12802 жыл бұрын
hello, how did you highlight two different columns in making a chart? thank you!
@latiefahmad9202 жыл бұрын
Sir what when u have put codes like strongly agree=5 agree=4 neutral=3 disagree=2 strongly disagree=1
@nabeelakhtarr2 жыл бұрын
Sorry but I didn’t understand your question.
@latiefahmad9202 жыл бұрын
@@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 ?
@spongebobby1884 ай бұрын
Why not use a pivot table to get the totals for each response? Would have saved you alot if time!
@nabeelakhtarr4 ай бұрын
I have done that here: kzfaq.info/get/bejne/b96IZJiBtt7XYGQ.htmlsi=3JgkxERzbqWzaOZj
@charlenewolford28872 жыл бұрын
Thank you so much!
@riddhikapadia52052 ай бұрын
Hello sir when I am trying to apply this method my number show 0
@nabeelakhtarr2 ай бұрын
Check the decimal setting for your cell
@lubnalooz77712 жыл бұрын
Thank you!
@ajeducationnetwork6403 жыл бұрын
Good job you can do more
@hasminahmed26162 жыл бұрын
Can we use likert scale without any hypothesis in the study ?
@hasminahmed26162 жыл бұрын
@@nabeelakhtarr How can I interpret the results...any video on that Sir.
@vinodarya74512 жыл бұрын
Nice Explanation....I need a little help from you
@vinodarya74512 жыл бұрын
@@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....
@taherkhan54692 жыл бұрын
@Nabeel Akhthar Bhaiya...is there any app where I can reach out to you?
@arunengine2 жыл бұрын
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
@arunengine2 жыл бұрын
@@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 ?
@arunengine2 жыл бұрын
@@nabeelakhtarr thank you sir for ur kind +ve response ...
@entertainment14962 жыл бұрын
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.
@meeranmalik2 жыл бұрын
Thank you
@meunieralexsandra17542 жыл бұрын
Sir, please how to label as % for each question?
@angelraven2092 жыл бұрын
Hello Sir! I need your help as I am confused with my statistical tool with likert scale data. Can I contact you?
@khalidmajeed28864 ай бұрын
sir how it is use in power query
@nabeelakhtarr4 ай бұрын
That is the next video I will be creating 🤓
@nabeelakhtarr4 ай бұрын
Khalid, I just uploaded the video you requested. Please have a look: kzfaq.info/get/bejne/b96IZJiBtt7XYGQ.html
@icyglits12272 жыл бұрын
what is the blanks?
@riddhikapadia52052 ай бұрын
How can I fix this ?
@nabeelakhtarr2 ай бұрын
Have a look at this video: support.microsoft.com/en-us/office/display-or-hide-zero-values-3ec7a433-46b8-4516-8085-a00e9e476b03
@ainaafisah7 ай бұрын
Im student, whats mean blanks?
@nabeelakhtarr7 ай бұрын
Tell me the time marker in the video.
@rosemariebarrameda16522 жыл бұрын
what kind of analysis method is this?
@rosemariebarrameda16522 жыл бұрын
is this non-parametric?
@ajeducationnetwork6403 жыл бұрын
Sir can you teach how to find regression line of this data
@kaaj46042 жыл бұрын
When I copy to other cells. the formula change
@MDCMANC10 ай бұрын
This is EXACTLY what I have been looking for. OMG, I could kiss you! 💋
@nabeelakhtarr10 ай бұрын
Oh great! I hope it helped. Pls consider subscribing. Thanks!