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.
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.
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.
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: ruclips.net/video/JkU9SPVQbPc/видео.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: ruclips.net/video/srm5lvhhGHo/видео.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: ruclips.net/video/PH1p9LoBrRs/видео.html
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.
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.
the first step of copy pasting of question no. 1 doesn't work in my computer, why?
How do i use excel to get mean and standard deviation for likert scale
Wow,this video has really assisted me.Thank you.
Glad it helped
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.
how to calculate correlation cofficent using same data...
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: ruclips.net/video/JkU9SPVQbPc/видео.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: ruclips.net/video/srm5lvhhGHo/видео.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: ruclips.net/video/PH1p9LoBrRs/видео.html
SWOT analysis ke lie ye chaeye 🙂
great
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: ruclips.net/video/fdNhvT9dz0I/видео.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...