This video describes the procedure of tabulating and analyzing the likert scale survey data using Microsoft Excel. This video also explains how to prepare graph from the tabulated data. Photo courtesy: littlevisuals.co/
You, sir, are a God-send! You are such a generous person. You have no idea how much this has helped me. I'm starting my masters in Psychology and have a paper due based on a self-study and had NO idea how to transmit my data into a graph. Your video is tremendously helpful. God bless you!
This has been tremendously helpful and thorough guide for me to comprise my questionnaire linkert data analysis and bar graph deliberation.I find myself total naive when it comes to excel and formulas Thankyou so much ,I 've had religiously followed and today fortunately I'd submitted in to my supervisor.
Very excellent. First time ever I calculate and put the data in excel sheet because I was facing much difficulties to sort out data for my research study data analyzing process. Thank you so very much.
This is so amazing. i was able to follow through even though this was my firt time using excel to analye data. thanks a lot and much love and blessings
Thank you for the awesome walkthrough! Question, is there a way to take this method a step further and have excel tabulate correlations between answers? For example, respondents that answered strongly agree on question 1 were more likely to answer disagree on question 7. Any assistance would be appreciated! Thank you again for this video!!!
Although I have a PhD, I always say when it comes to stat analysis, "speak to me as if I were a child." LOL! THANK YOU for this!!! It was so incredibly easy to follow and understand!!! Even for a right brained social worker like me that hates math!
Sir, it is with no doubt that your video will greatly help in analyzing results and tabulating data. Thank you. Sir, i have been reading about statistical tools for likert scales. But it seems i cannot understand why or is it always necessary to compute the mean and standard deviation? I hope you will answer my query. Thank you.
Standard deviation and variance are the indicators of how spread your data is, Watch my next video. Thank you very much. Subscribe and Click on Bell icon for the alert of my new videos.
Thank you sir for this short and simple explanation, i have a question, Can we make a cumulative graph for the whole result that shows the likerts percentages ?! ( the total strongly agree % for all 10 questions) can we do sth loke that , because i want to compare two likert scales !!
Sir, thank you so much for such an informative video. I am struggling with the second lot of calculations: strongly agree etc. I am adding the formula but an error occurs. After completing the Formula of=countif then I choose the range enter strongly but I get an error. I can't make out what you are saying rookie? Or are you pressing enter?
Thank you for the video. Everything is well explained and tone of voice/ speed overall the video is easy to understand. I appreciate this. keep making more tutorial videos like this. Namaste~ from Nepal.
Wow. Very useful!! Thank you very much. But, I wonder how to create graph for each of the questions? When I have created graph for question 1, I can't create the second and the next one. I mean, I don't know how to block the title and the second question. Would mind showing me how?
Hello sir thank you so much for such insightful video. Really help me in doing my little research. However, I have a concern regarding when we want to make the chart part. Is it possible tho to visualize all the data into a single chart? If so, what is the best chart do you think good to represent the data? Your assistance is very much appreciated
Very useful. Thank you for making this vid. Do you have any more vids on how to get mean, median, and mode from the tabulated results. If any, can you paste a link here. Thanks
This was helpful in a lot of ways but there is one spot I am stuck on. If there is a blank response to any of the questions, do we still use the total of 40 or do we do something different? The blanks will lower the percentages a decent amount depending on how many responses there are.
Thank you very much for this helpful video. May I know when to use this simple approach and when to use a statistical test? I am working on a data that is the first kind and not comparing with previous data to see if there are any variance. Do I use your approach to plot my graph or I have to consider ANOVA?
Normally ANOVA is used for variance analysis. You can use different statistical tests depends on the data type that you are used. (Nominal, Ordinal, Interval, Ratio)