How to analyze Likert-Scale Survey Data Using Excel: Part 1 (Advanced)
Вставка
- Опубліковано 11 бер 2021
- This video shows you how to make a template for analyzing survey data. With the template, you can add more data and the results will automatically update.
You may or may not have noticed that I misspelled "strongly disagree," which is why all of those were zero. After I noticed it, I didn't want to stop and go back. Later, I fixed it and those numbers updated. This is why you have to check everything or cut/paste from the previous page--and don't write while talking.
Wow,this video has really assisted me.Thank you.
Glad it helped
How do i use excel to get mean and standard deviation for likert scale
the first step of copy pasting of question no. 1 doesn't work in my computer, why?
how to calculate correlation cofficent using same data...
great
SWOT analysis ke lie ye chaeye 🙂
I can't see filter results in corner @11:31. How can i know my results? My excel is showing accessibility instead of result numbers.
This is just for a check to make sure your formulas are correct. I don't know why Excel wouldn't show you the count of the filter, but you can check some other way. For example, find an empty cell and write a formula of =countif(A3:A200,"Strongly Agree") if the data is in A3:A200. That will count them so you can check. It is just a lot easier if Excel will just tell you. I've had that happen. Close and reopen, and see if Excel starts behaving.
I still get dollar signs @5:30. What can I do?
Don't put a $ in. Just type = then go to the tab that has the items and click on the first question. That should bring the question into this new tab. Then either copy/paste that or pull it across.
This may be a silly question, but wouldn't this whole process be easier to do with a pivot table?
It depends. We were setting up a template to analyze the data for several schools, many different times. We wanted to set this up so that we can dump the data in each time and get nice graphs to put into reports for the schools. I actually made this video for my interns to show so they could go back and watch it if need be while they made some of these templates for various surveys that we give repeatedly. If you are analyzing one time only, a pivot table would probably be easier.
Actually, you probably could use pivot tables. Sometimes we do that and generate the charts off of them. I don't like the pivot charts. I thought this would be simpler for some interns I had and I wanted them to learn more about Excel. I just made it public for the heck of it. I didn't expect anyone else to watch it. Since this, we have run into Jamovi and learned to use Power Querry in Excel. There are probably many better ways to do this.
@@edstaranalyticsinc.52 Thank you so much, I am currently working as a data analyst and I am trying to incorporate other methods besides throwing my data in pivot tables :) your information was very helpful, I hope to see more of your videos :)
@@elijahd.spragueph.d8905 I enjoy making these. We recently discovered Jamovi, which is open-source. I love it. The tool doesn't get in the way of thinking about what you are doing. I've been too busy to make many videos for it, but if I get caught up, I'll make more. Here is one: ua-cam.com/video/JkU9SPVQbPc/v-deo.html. We still use Excel daily. We make things pretty in Excel. I think we used Pivot tables but did more with them in this one: ua-cam.com/video/srm5lvhhGHo/v-deo.html
I am busy right now tutoring 3rd grade math for Americorps via Zoom. If you need any "how to tutor 3rd graders, I am making those right now: ua-cam.com/video/PH1p9LoBrRs/v-deo.html
I have used five point likert scale in dissertation questionnaire
And i have collected 40 samples how i analyse data
We have several more basic videos: ua-cam.com/video/fdNhvT9dz0I/v-deo.html
@@edstaranalyticsinc.52 Thank you
@@edstaranalyticsinc.52 after clicking the link "This video isn't available anymore." people wanted to know more from you but...