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

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

[nabeelakhtarr]

How to analyze Likert Scale questions and create graphs using Excel

[suchismita]

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.

[davidhutchinsinternational]

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!

[HudaRashid]

Thank you so much brother... You've saved the day... Jazak Allah Hu kahairan kaseeran

[shivanidhatwalia]

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?

[cgarrett]

This was AMAZING, thank you so much! VERY helpful!

[sidrashahid]

Salam. I just needed this video so Cant thank you enough! youre an angel 😙

[bezihendrickson]

An excellent presentation. You're a great instructor!

[pathofclouds]

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.

[vivienchime]

Thank you so much. I can now do my task better.

[evanskings_]

Learned a lot from your teachings thank you for the goodwork

[fahiden]

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?

[gtgrandma]

This was VERY Helpful. Thank you so much!

[muhammadomar]

Sir, Please i have a questionnaire but the answers for the questions are different for each question. How can i analyze them??

[jesslove]

Hello, thank you that was very helpful

[akanshakharkwal]

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

[aljeanmarietimonan]

hello, how did you highlight two different columns in making a chart? thank you!

[angelraven]

Hello Sir! I need your help as I am confused with my statistical tool with likert scale data. Can I contact you?

[hasminahmed]

Can we use likert scale without any hypothesis in the study ?

[spongebobby]

Why not use a pivot table to get the totals for each response? Would have saved you alot if time!