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.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PH1p9LoBrRs.html
