No video

How to analyze data in Excel for Likert Scale Questions | Create graphs for likert scale questions

  Рет қаралды 90,623

Nabeel Akhtar

Nabeel Akhtar

Күн бұрын

Пікірлер: 75
@nabeelakhtarr
@nabeelakhtarr Жыл бұрын
How to analyze Likert Scale questions and create graphs using Excel
@suchismita9081
@suchismita9081 10 ай бұрын
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.
@nabeelakhtarr
@nabeelakhtarr 10 ай бұрын
That’s good to know. I tried to make it as simple as I could. Do consider subscribing. Thank you!
@davidhutchinsinternational6452
@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
@nabeelakhtarr Жыл бұрын
Glad it was helpful!
@HudaRashid19
@HudaRashid19 2 ай бұрын
Thank you so much brother... You've saved the day... Jazak Allah Hu kahairan kaseeran
@nabeelakhtarr
@nabeelakhtarr 2 ай бұрын
JazakAllah khair!
@cgarrett1974
@cgarrett1974 4 ай бұрын
This was AMAZING, thank you so much! VERY helpful!
@nabeelakhtarr
@nabeelakhtarr 4 ай бұрын
I’m glad this helped!
@pathofclouds85
@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
@nabeelakhtarr Жыл бұрын
I’m glad this helped!
@shivanidhatwalia8701
@shivanidhatwalia8701 2 жыл бұрын
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?
@bezihendrickson9935
@bezihendrickson9935 7 ай бұрын
An excellent presentation. You're a great instructor!
@nabeelakhtarr
@nabeelakhtarr 7 ай бұрын
Thanks a lot!
@sidrashahid9913
@sidrashahid9913 2 жыл бұрын
Salam. I just needed this video so baaaaaaaad!! Cant thank you enough! youre an angel 😙
@sidrashahid9913
@sidrashahid9913 2 жыл бұрын
@@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 :)
@vivienchime9544
@vivienchime9544 4 ай бұрын
Thank you so much. I can now do my task better.
@nabeelakhtarr
@nabeelakhtarr 4 ай бұрын
I’m glad this helped!
@evanskings_8
@evanskings_8 Жыл бұрын
Learned a lot from your teachings thank you for the goodwork
@nabeelakhtarr
@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
@samadritanag2524 Жыл бұрын
THANK YOU FOR THIS VIDEO.
@ebonisterling5728
@ebonisterling5728 10 ай бұрын
Informative and easy to follow!
@nabeelakhtarr
@nabeelakhtarr 10 ай бұрын
Glad it helped! Please subscribe. Thanks!
@mohammedinuwabello4007
@mohammedinuwabello4007 5 ай бұрын
Simple and straight
@nabeelakhtarr
@nabeelakhtarr 5 ай бұрын
Thank you! Please subscribe!
@gtgrandma5327
@gtgrandma5327 2 жыл бұрын
This was VERY Helpful. Thank you so much!
@fahiden9441
@fahiden9441 2 жыл бұрын
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
@tyraann2058 Жыл бұрын
This was so helpful thank you
@muhammadomar2798
@muhammadomar2798 2 жыл бұрын
Sir, Please i have a questionnaire but the answers for the questions are different for each question. How can i analyze them??
@TechKnowledgewithAmit
@TechKnowledgewithAmit 11 ай бұрын
Well explained sir😊
@nabeelakhtarr
@nabeelakhtarr 11 ай бұрын
Keep watching
@shaguftafatima2644
@shaguftafatima2644 Жыл бұрын
Thanku very much 🙏
@pauljohnson3317
@pauljohnson3317 Жыл бұрын
Excellent! Thx!
@jesslove8372
@jesslove8372 2 жыл бұрын
Hello, thank you that was very helpful
@nabeelakhtarr
@nabeelakhtarr 2 жыл бұрын
Welcome! 🙂
@akanshakharkwal7370
@akanshakharkwal7370 2 жыл бұрын
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
@aljeanmarietimonan1280
@aljeanmarietimonan1280 2 жыл бұрын
hello, how did you highlight two different columns in making a chart? thank you!
@latiefahmad920
@latiefahmad920 2 жыл бұрын
Sir what when u have put codes like strongly agree=5 agree=4 neutral=3 disagree=2 strongly disagree=1
@nabeelakhtarr
@nabeelakhtarr 2 жыл бұрын
Sorry but I didn’t understand your question.
@latiefahmad920
@latiefahmad920 2 жыл бұрын
@@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 ?
@spongebobby188
@spongebobby188 4 ай бұрын
Why not use a pivot table to get the totals for each response? Would have saved you alot if time!
@nabeelakhtarr
@nabeelakhtarr 4 ай бұрын
I have done that here: kzfaq.info/get/bejne/b96IZJiBtt7XYGQ.htmlsi=3JgkxERzbqWzaOZj
@charlenewolford2887
@charlenewolford2887 2 жыл бұрын
Thank you so much!
@riddhikapadia5205
@riddhikapadia5205 2 ай бұрын
Hello sir when I am trying to apply this method my number show 0
@nabeelakhtarr
@nabeelakhtarr 2 ай бұрын
Check the decimal setting for your cell
@lubnalooz7771
@lubnalooz7771 2 жыл бұрын
Thank you!
@ajeducationnetwork640
@ajeducationnetwork640 3 жыл бұрын
Good job you can do more
@hasminahmed2616
@hasminahmed2616 2 жыл бұрын
Can we use likert scale without any hypothesis in the study ?
@hasminahmed2616
@hasminahmed2616 2 жыл бұрын
@@nabeelakhtarr How can I interpret the results...any video on that Sir.
@vinodarya7451
@vinodarya7451 2 жыл бұрын
Nice Explanation....I need a little help from you
@vinodarya7451
@vinodarya7451 2 жыл бұрын
@@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....
@taherkhan5469
@taherkhan5469 2 жыл бұрын
@Nabeel Akhthar Bhaiya...is there any app where I can reach out to you?
@arunengine
@arunengine 2 жыл бұрын
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
@arunengine
@arunengine 2 жыл бұрын
@@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 ?
@arunengine
@arunengine 2 жыл бұрын
@@nabeelakhtarr thank you sir for ur kind +ve response ...
@entertainment1496
@entertainment1496 2 жыл бұрын
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.
@meeranmalik
@meeranmalik 2 жыл бұрын
Thank you
@meunieralexsandra1754
@meunieralexsandra1754 2 жыл бұрын
Sir, please how to label as % for each question?
@angelraven209
@angelraven209 2 жыл бұрын
Hello Sir! I need your help as I am confused with my statistical tool with likert scale data. Can I contact you?
@khalidmajeed2886
@khalidmajeed2886 4 ай бұрын
sir how it is use in power query
@nabeelakhtarr
@nabeelakhtarr 4 ай бұрын
That is the next video I will be creating 🤓
@nabeelakhtarr
@nabeelakhtarr 4 ай бұрын
Khalid, I just uploaded the video you requested. Please have a look: kzfaq.info/get/bejne/b96IZJiBtt7XYGQ.html
@icyglits1227
@icyglits1227 2 жыл бұрын
what is the blanks?
@riddhikapadia5205
@riddhikapadia5205 2 ай бұрын
How can I fix this ?
@nabeelakhtarr
@nabeelakhtarr 2 ай бұрын
Have a look at this video: support.microsoft.com/en-us/office/display-or-hide-zero-values-3ec7a433-46b8-4516-8085-a00e9e476b03
@ainaafisah
@ainaafisah 7 ай бұрын
Im student, whats mean blanks?
@nabeelakhtarr
@nabeelakhtarr 7 ай бұрын
Tell me the time marker in the video.
@rosemariebarrameda1652
@rosemariebarrameda1652 2 жыл бұрын
what kind of analysis method is this?
@rosemariebarrameda1652
@rosemariebarrameda1652 2 жыл бұрын
is this non-parametric?
@ajeducationnetwork640
@ajeducationnetwork640 3 жыл бұрын
Sir can you teach how to find regression line of this data
@kaaj4604
@kaaj4604 2 жыл бұрын
When I copy to other cells. the formula change
@MDCMANC
@MDCMANC 10 ай бұрын
This is EXACTLY what I have been looking for. OMG, I could kiss you! 💋
@nabeelakhtarr
@nabeelakhtarr 10 ай бұрын
Oh great! I hope it helped. Pls consider subscribing. Thanks!
Master Data Analysis on Excel in Just 10 Minutes
11:32
Kenji Explains
Рет қаралды 2 МЛН
The best way to analyze LIKERT SCALE and INTERPRET the results
13:20
Mohamed Benhima
Рет қаралды 168 М.
PEDRO PEDRO INSIDEOUT
00:10
MOOMOO STUDIO [무무 스튜디오]
Рет қаралды 19 МЛН
Cute kitty gadgets 💛
00:24
TheSoul Music Family
Рет қаралды 17 МЛН
小丑把天使丢游泳池里#short #angel #clown
00:15
Super Beauty team
Рет қаралды 48 МЛН
034. A better way to create Charts for SURVEY RESULTS in EXCEL
8:58
EXCEL WIZARD IN MINUTES
Рет қаралды 56 М.
HOW TO COMPUTE LIKERT SCALE, T-TEST & PEARSON R
15:25
SCIENCE with DR. TESS
Рет қаралды 203 М.
Likert Scale Analysis - Mean and Standard Deviation
6:11
Hamplus Hub
Рет қаралды 331 М.
How to analyze Likert Scale data using a Pivot Table in Excel
6:17
Plotting Likert (agree/disagree) data in Excel
10:33
Chris Armstrong
Рет қаралды 52 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 100 М.
SPSS: How to Analyse and Interpret LIKERT-SCALE Questionnaire Using SPSS
31:03
Likert scale analysis and interpretation for research
15:19
Mohamed Benhima
Рет қаралды 10 М.
Recoding Textual Likert Scale Responses into Numbers
8:16
Mohan Pant
Рет қаралды 108 М.
PEDRO PEDRO INSIDEOUT
00:10
MOOMOO STUDIO [무무 스튜디오]
Рет қаралды 19 МЛН