Excel and Questionnaires: How to enter the data and create the charts
HTML-код
- Опубликовано: 13 фев 2013
- This is a tutorial on how to enter the results of your questionnaires in Excel 2010. It then shows you how to create frequency tables (using the countif function not the frequency function).
The next stage is creating charts.
Have been struggling for a week to find a way in Excel to compare data from my masters thesis research project. This video was a life saver!
Very Helpful, Appreciated.
Thank you. I am working to compile data for a research project and was unsure how to do this. Your tutorial was exactly what I needed!
9 years and this vid helps me with my assignment today.
Thank you so much for this. I was confused on how to enter data from questionnaires into Excel but your tutorial just made it so clear for me.
Art is an EXPLOSION......
Excellent help, thank you so much for the speed and details of the lesson. You were a huge help!
Hi
I am working on my dissertation and I was very stressed about this part. Your video was of great help. Thank you so very much.
Thank you so much.Ur tutorial is exactly what I needed!
Can not explain how much this vide help! I actually created a youtube account just to say thanks ! was excellent ! deadline day tomorrow you saved the day.
nice lesson, thanks for sharing
thanks a lot. the video is excellent and you teach it in a very easy way. God bless you
This helps me so much with my 40 pre-coded questions i have to convert from the surveys i received back and now i can put them into a excel spreadsheet like your example!! THANK YOU! This is for my college research project on my company.
Great.
Thank you SO much for posting this!!!!!
Excellent presentation. Thanks alot.
I learn a lot from here.Thank you so much
This was extremely helpful. Thanks a lot!!
I'm currently processing my undergraduate questionnaire information for my dissertation, I chose to use excel because I couldn't understand SPSS.
This video was of sensational help, and I wanted to say thank you very much.
SPSS is very simple to use
This was really helpful! Great expectations, thanks a lot !🙌😀
Super.. Now im learning some basic of data analysis
Thank you so much. Very clear and to the point.
Your instructions were very helpful. I learned a lot! Glad I can do this on my own in the future.
Mindy Ciofani Great.
Thank you for the upload. This is very helpful. So nice.
Thanking for saving my MARKS!! Great job done explaining this matter
thank you so much , your video is very relevent !
Big help! Thank you very much.
Thank you so much. I was really in need of some help in creating the chart. Your video gave me proper guidance as to how I should proceed further.
You are very welcome
Thank you sooooo much for this video, it was super helpful.
Thank you a lot, it was very helpful for a survey that I did for my thesis!
This was a huge help! Excellent work mam.
Thank you for making my life so much easier. You’re an angel
Dolores. Glad I could help .
thank you. helped a lot with quickly crunching some survey data
Really thankful for this video...It has helped me alot..
Thank you this was very helpful allowed for me to complete my assignment
Best video ever
i liked the easy way you explained many thanks for your contribution to our career may Allah guide you to the wright path.
This video was very useful, Thank you .
This was really helpful. Thank you.
Its a great tutorial. Thank you!
Best Tutorial Thank u. :)
thanks for this! Has really helped!
Thank you very much, that was very helpful
Thank you, this was helpful
tks. very clear and helpful. COUNTIF, lookup, sumproduct, pivot table, all are powerful.
Excellent...Thank You very much
thanks. its help a lot.
Fentastic video👌, its really good and very useful for students👏, I am really like❤ this video Tnq....... Vry much guy...😊😊😊
this is quite helpful , thanks a lot
Thank you, excellent!
I love u so much ur video was my last minute saviour❤️❤️
Thanks a mill
Amazing and helpful
Thank you for sharing the knowledge :)
Glad to help..
thank you so much for the info..this is really helpful. i wonder where can i find your other videos pls? thank you
Wow, thanks! Not afraid of Excel any more!:))
Thanks it was helpful 👍🏻
Wow what a good tutorial! Thank you so much for posting it, believe it'll help me a lot!!
Do you have any tips on coding an open question..?
Extremely good!
It's helpful to whom it may concerns
Thank You very much
Wow! thank you so much
Thank you so much. it helped me to do my research project
+Loshiye Sindiyo Great.
Thank you madam,
thanks,,,,very understandable:)
waoh thanks i am so grateful
you saved my day, I would have failed my exams. Thanks a ton
Great
Great teacher!
Jose Rodrigo Nino Nieto thanks
Thanks a ton .
thanks for y lesson
THANK YOU ALOT.......
I want to tell you something, these answers on the sheets could be entered by the user behind the scene. Example: when the user is answering the survey, answers would populated plus calculation at the same time. Then when you need to open/visible the answers, you open it with a password. I made a project like that 20 years ago. I lost the file, backup when I moved to another dept at my job and I don't have the file. All I remember was al lot work, but very rewarding. I had to transform the questionnaire in word into excel, exactly the way it was, then I applied codes to feed the behind scene answers sheet. The result is a breeze. I think the code was like this: if q1 is 1, or 2, 3 than do this, if q2 is this and that insert this and that.
Thank You Ma'am
I like it - Thank You. I'd like to invite You to my alternative approach to survey management.
nice presentation
i am disappointed that such a wonderful video has such few likes😢😢
You are too kind :)
Thank you so much Deidre Macnamara. it helped me alot in doing my research project.
research projects can be tough so glad to help.
thank you ...... thank you
thank you miss
Huge help! Great job.
Just want to ask, im doing a questionnaire and i have one question where they rank three options from 1-3, how do i pu t that in a questoinnaire because its not just one answer, they all put three topics in a ranking order from 1-3 (3 being highest)
thanks a lot
It's perfect
Thank you soo much
+Hasani Harishchandra Good to know it helped.
Deirdre
Thanks!
Thanks a lot. Just what I need to start my analysis. Any video on comparative analysis please?
No, afraid not.
Thank you
Deidre, as already echoed below, thank you for this easy to follow tutorial. Question for you though, do you have an equally easy to follow tutorial for instances where respondents may choose more than one option?
No. Afraid not. Each option should be stored in a separate column. I think the only easy way to do that is to show each option as a separate chart or just chart the totals for each option. Hope that helps.
This was really helpful! Thank you so much.
I just had a question: If I wanted to do a further analysis e.g. chi2 test, can you use the numerical equivalent e.g. father q1: 1= No education compared with Q3 sibling 1=yes ?
Would the numerical number be valid when doing correlation test e.g. does having your father have an undergraduate degree mean your sibling is also more likely to as well?
+rpk12 You would have to run the chi squared test to tell whether it was more likely. See this video ruclips.net/video/yoRQEZVKrJw/видео.html
Can this be done for demographic questionnaires?
Many Thanks.
This was helpful indeed.
Is there a method/formula to compile all the different sheet (questions) into one data or table?
Will be good to know.
Regards.
Not quite sure what you mean Sunil. At 1.37 on the video there is a table with all the results.
There is no way to chart all data in some sort of chart that I know of.
Maybe I am misunderstanding your question.
Regards,
Deirdre
Great video! I was able to use this at work. Question what formula would I use if I wanted to know the names of the people who for example rated question 1 a 4=strongly agree. Any help would be greatly appreciated.
Hi I think what you are looking for is some of the database tools so you could use the "Data" | "Filter" option and just select Strongly agree. D
Hi Deirdre! Thanks for your help. Q: What do you do if your survey responses are not mutually exclusive?
I have a survey question that reads: "Which community groups are you active in, check all that apply" and I coded each community group with a number. When I code a response "1,2," for example, the countif function doesn't count any community groups at all / pick up the response.
Any advice or follow up tutorials on this would be wonderful! Thanks!
Hi Melissa
I would have a seperate column for each possible group and only 2 options 1 for yes and 0 for no. then you can just sum all the yes answers.
Hope that helps
Hey, I wanna analyze data for 10 participants ,compare right , left foot to find out which foot is better , in antropostero ,mediolateral,
can help me how begin analyze this data ?
When i put on the filters in data and filter out certain things the pdata in the charts doesnt change. What am I doing wrong?
Thank you so much for this tutorial.
What if there are multiple answers for one question, how should i enter data then?
treat them as separate questions
Thanks... It helped me a lot. This is a great tutorial. I have a urgent quarry... Here you demonstrated us about one answer against one question. Please would you tell me that, if there is more than one answer against one question how to input those value and process data...
If will be a great help to me if you reply shortly.
+Tanvir Klion
I will also like to know how to input those with more than one answer and process the data.Did you come across the video? if you did please share. I really need that.
Thankss
thx
Hi Deidre,
I agree with everything here, but when you are naming those columns at 4:20 onwards in this video, my heart broken seeing you naming all those columns one by one.
Instead you can select all those columns i.e. B1:O26 whatever and press Ctrl + Shift + F3, it will ask you whether you want to name those columns using their respective headers, say OK for that. Bang...you already named 15 columns automatically without wasting time on selections and naming.
Very useful video. Thanks...cheeers from India.
I have been using using a iii