Thank you very much for this video! It explains everything I need to know! This video is so peacful and easy to understand and really funny because of your cat.
Could you please explain the q2 a, b and c and how you coded them? I have a question in which respondents may choose more than one answer and I do not know how to deal with that part. There are 8 options concerning that question. So, question 3..q3a,b..h but the problem I encountered is how can I code them as you did?
Dear Kent! I can't tell you how delighted I have been today after looking at this video 'entering questionnaire onto a spreadsheet'! I arrived for my regular volunteer session today and the manager asked me if I would be able to put data from a questionnaire onto a spreadsheet - I said 'I'm not sure - I've not done it before but I'll give it a go - I'll look on youtube!'. I found this video; which has been quite perfect! very clear, very well paced and exactly what I needed to know to do the task! It's has given such a sense of achievement and satisfaction at the end of my session to have created the spreadsheet and entered the first of many batches of questionnaires. The ability of the organisation to be able to use the results of this survey are critical in achieving an important objective next year. I just wanted to say 'thank you!'.
For Excel? Not so much. I only have these two videos: Create a table from survey data: th-cam.com/video/Kno1gJiO5Dg/w-d-xo.html Copy & paste tables to Word: th-cam.com/video/yaeeSzSmicI/w-d-xo.html Good luck with your projects
thank you for the enlightenment, but a situation that I have questions like strongly agreed (SA), Agreed(A), Strongly Disagree (SD) Disagree(D), how do I go about it?
Hi please can you explain what this method is called for the purpose of writing up a dissertation, and also the second video where figures are created. Thanks.
i do not know why i did not do this in school. but this is very informative and straigh to the point. working on my first ever survey!!!! i am now going to be your biggest fan.
Can anyone pls explain to me: Why yes = 1 and no = 2. why not no = 0? Besides, in my questionnaire I have 3 options: Yes/ No/ No opinion, how should I put the numbers? Thank u so much for your help ^^
Hường Bùi hi there, it does not matter what you use to represent a “Yes” and what you use to represent a “No”. As long as you are consistent, it really does not matter. What matters is that you have something to count by. One can use a “Y” for Yes, and a “N” for No, but traditionally 1 has been used to represent the “On” state, and 0 (Zero) was used to represent the “Off” state. As you also may know computers use a binary system to work.
Hường Bùi Sorry I had to chop the answer into two. For a 3-answers question try 1 for Yes, 0 for No, and -1 for No Opinion. Again it could be A, B, C respectively or Y, N, O for the coding does not matter really. WhT matters is that it is consistent across the survey.
Hum! I have many questions: 1) Why not code the papers with ID starting at 2 to match row to paper? 2) Why not use a 0 for a non-answer? I think this might make it easier to find out what questions were missed/unanswered? 3) Do I need a cat to make this work properly :-) Why did you not remove the cat so that he/she will not distract from the task at hand? 4) What if you have 20,000 paper surveys? You for got to mention that this process is good for small surveys and not humongous ones. 5) Where is the explanation of what you do with the verbatim question? Why did you end the video without explaining that? You know, you could have paused the recording of the video, finished this small survey, and then started recording with the data all entered. Don’t you think this would have been a better approach? Thanks for making this, I hope you accept this as constructive criticism.
It is a useful clip and deserve more like. Your clip helps me to prepare my data. I will try doing it my own. Please continue doing good clips like this one.
Question 5 is an open-ended question and the respondents write their answers in plain language. These written replies are written into column q5a. As you know, these type of data requires some interpretation from the researcher (me). I code the replies into a couple of cathegories (or themes), and I give each of these chategories a numerical value (1, 2, 3 and so on). I write these numbers into column q5b. See my other video: th-cam.com/video/DjDaNnlYT3s/w-d-xo.html&t=21m26s
Oh, I just enter the number 2 for "no checkmark" in question 2 for no particular reason. Question 2 (at 1:24 in the video) is special because the respondent could select two or more boxes. Therefore we must treat each box as a separate variable (each with its own column in Excel), as you know. In this video, I decided to code "Yes" with the digit 1 and "No" with 2. However, I could have coded "Yes" with 2, and "No" with 1. It does not matter if you ask me ;-)
Нұрбек Ізбасар hello did you u understand how to enter a lot of data from pen-and-paper questionnaire with several variables into excel? Just i wanna know how did u solve this, I facing this problem. Please help me
Thanks for posting the video. I have a question. I have 30 items in my questionnaire and 7 items for background information. Should I enter all in the same sheet? TIA
Kent, I would love to know how you would code in the response to a question where someone may select more than one response, but if they select more than 1 then they must rank them in order of importance? I'm stumped on how I could best do this!
Hello! His name was Zhimba but he was old so we have to put him to sleep. Very sad. However, we have a new cat, Mr. Corre: th-cam.com/video/SGk0kdckdx4/w-d-xo.html
like for cat close up :p
PytoX He looks sooo bored :-)
Only because he knows all of this already.
@@ryanmichaelhaley lol i bet he does
I love the simplicity in your teaching. How do you enter the questions on excel before entering the responses?
Thank you very much for this video! It explains everything I need to know! This video is so peacful and easy to understand and really funny because of your cat.
I love that the cat kept bugging him lol
I really like your method of coding the questionnaire. It is very clear and concise.Thank you for sharing your method!
ps I really enjoyed the cat's contribution to the video too - it made me laugh out loud!
thanks much as I was out at sea with regards to my research now I get to start.
Very helpful and clear! Thank you. Also, your cat is awesome (:
Could you please explain the q2 a, b and c and how you coded them? I have a question in which respondents may choose more than one answer and I do not know how to deal with that part. There are 8 options concerning that question. So, question 3..q3a,b..h but the problem I encountered is how can I code them as you did?
Great, thank you so much. Easy to follow, I'm going to your next video!
Thank you very much! this was exactly what I was looking for!
You're very welcome!
Dear Kent! I can't tell you how delighted I have been today after looking at this video 'entering questionnaire onto a spreadsheet'! I arrived for my regular volunteer session today and the manager asked me if I would be able to put data from a questionnaire onto a spreadsheet - I said 'I'm not sure - I've not done it before but I'll give it a go - I'll look on youtube!'. I found this video; which has been quite perfect! very clear, very well paced and exactly what I needed to know to do the task! It's has given such a sense of achievement and satisfaction at the end of my session to have created the spreadsheet and entered the first of many batches of questionnaires. The ability of the organisation to be able to use the results of this survey are critical in achieving an important objective next year. I just wanted to say 'thank you!'.
Thank you so much!! I've been searching for three days for a solution that I can understand! Plus, I love the kitty :D
You saved my life too! :0) Great method!
thank you, that was super helpful and your cat is awesome
Ah this cat is full of attitude. LOL. So cute.
I wanna know how I can get the percentages after entering the data !
Mr. Kent, are we going to use multiple regression analysis after these? Anyways, the video presentation was very awesome. It helps a lot.. Thank you
Thank you for the nice and lucid video, really appreciate that. Is there a video where you show how you analyzed the data?
For Excel? Not so much. I only have these two videos:
Create a table from survey data: th-cam.com/video/Kno1gJiO5Dg/w-d-xo.html
Copy & paste tables to Word: th-cam.com/video/yaeeSzSmicI/w-d-xo.html
Good luck with your projects
The cat is distracting me.. help
Thanks for helping me with my research! :) Great job and cute cat!
Thank U... I hope to do a Post Ph.D. program is digital finance hopefully on Scholarship... Fan from Nigeria
very helpful!!! u safe my life :D Xx greetings from Rotterdam
I love how you work around your kitty！！ and nice video!
Really helpful. Cat is super adorable. Many thanks for your videos sir.
this will be very helpful for my survey thank you so much for making this video!!! 🤗👍😁
thank you very helpful
how do i analyse the data can't seems to find your next video
I would give that cat a little spanking for trying to interrupt. lol
My teacher give as a work to discuss my learnings about this video but im distracted to the cat hahahaha so cute
He he, it's a nice cat, yes! By the way, say "Hi!" to your teacher from me. Also, good luck with your studying.
Well understood... Thank u and ur calmness makes it easy to follow ur work
love your cat
thanks alot for this! smart cat too!!
This has been very helpful, Sir. What do you do about items in the questionnaire that were left unanswered? (for YES/NO items)
Brilliant, concise, thank you so much.
Thank you for both the new knowledge and smile! Your assistant is very insistent, love it!
Thanks for watching!
Why do you put a 2 on Q2B if the respondent did not select it? Wouldn't you leave it blank or no? Help pleaseeee :)
nevermind i figured it out hehe
My favorite part was the cat just chilling
Is there a program that you scan your surveys in and it automatically populates on Excel for you?
Could you help me how to organise questinere in array or categorical data
Have you tried to digitalized it with a softwares that recognizes each question ans answer? :)
Hi! No, I've never tried that. Great idea.
thank you for the enlightenment, but a situation that I have questions like strongly agreed (SA), Agreed(A), Strongly Disagree (SD) Disagree(D), how do I go about it?
this was the best video I have watched all year
Glad to hear!
Thanks for the video. Definately helpfull :D
Appreciated! it is very helpful
Hi please can you explain what this method is called for the purpose of writing up a dissertation, and also the second video where figures are created.
Thanks.
very useful video, thanks - give your cat a good scratch for me!
This was extremely helpful for my english class. and Let me say, I love your cat. Mine does the same.
really enjoyed the lecture, but will ike to know how to enter the same dataset into Minitab. thanks
i do not know why i did not do this in school. but this is very informative and straigh to the point. working on my first ever survey!!!! i am now going to be your biggest fan.
How to enter survey data in to excel:
*Get a cat 🐱 and let it do it for you* ❤️😄
Thank you so much for this video. And thank you to your cat.
thanks for the video useful for research work thanks mr. kent lofgren blessings
useful video and love the helper
woooow
Explain in a very clear way
Hahah the cat got so bored
The cat close ups are very funny.
Thank you my teacher
Can anyone pls explain to me: Why yes = 1 and no = 2. why not no = 0? Besides, in my questionnaire I have 3 options: Yes/ No/ No opinion, how should I put the numbers? Thank u so much for your help ^^
Hường Bùi hi there, it does not matter what you use to represent a “Yes” and what you use to represent a “No”. As long as you are consistent, it really does not matter. What matters is that you have something to count by. One can use a “Y” for Yes, and a “N” for No, but traditionally 1 has been used to represent the “On” state, and 0 (Zero) was used to represent the “Off” state. As you also may know computers use a binary system to work.
Hường Bùi Sorry I had to chop the answer into two. For a 3-answers question try 1 for Yes, 0 for No, and -1 for No Opinion. Again it could be A, B, C respectively or Y, N, O for the coding does not matter really. WhT matters is that it is consistent across the survey.
you look like john green
Thank you for the simple explanation.
Hum! I have many questions: 1) Why not code the papers with ID starting at 2 to match row to paper? 2) Why not use a 0 for a non-answer? I think this might make it easier to find out what questions were missed/unanswered? 3) Do I need a cat to make this work properly :-) Why did you not remove the cat so that he/she will not distract from the task at hand? 4) What if you have 20,000 paper surveys? You for got to mention that this process is good for small surveys and not humongous ones. 5) Where is the explanation of what you do with the verbatim question? Why did you end the video without explaining that? You know, you could have paused the recording of the video, finished this small survey, and then started recording with the data all entered. Don’t you think this would have been a better approach? Thanks for making this, I hope you accept this as constructive criticism.
watch here th-cam.com/video/DjDaNnlYT3s/w-d-xo.html
This was very simple, helpful, and well explained. Thank you. I dropped a like on your video.
It is a useful clip and deserve more like. Your clip helps me to prepare my data. I will try doing it my own. Please continue doing good clips like this one.
Thank you, I will
Thank you, this is really helpful
Hello Kent, What purpose you added up "q5b"?
Btw, you explanation is really awesome!
Nazrin, Malaysia.
Question 5 is an open-ended question and the respondents write their answers in plain language. These written replies are written into column q5a. As you know, these type of data requires some interpretation from the researcher (me). I code the replies into a couple of cathegories (or themes), and I give each of these chategories a numerical value (1, 2, 3 and so on). I write these numbers into column q5b.
See my other video: th-cam.com/video/DjDaNnlYT3s/w-d-xo.html&t=21m26s
got it. Thanks Mr. Kent for sharing.
thanks! After 8 years you're still finding an ignorant person like me
Thank you, and good luck w. your project.
This video is so relaxing to watch! It's very therapeutic.
It is a bit too slow for my taste ;-) But I guess you can always speed up the video (TH-cam settings for each video).
Great.Helpful
LOVE THIS! I do have a question, why did you enter the number 2 for no checkmark in question 2?
Oh, I just enter the number 2 for "no checkmark" in question 2 for no particular reason. Question 2 (at 1:24 in the video) is special because the respondent could select two or more boxes. Therefore we must treat each box as a separate variable (each with its own column in Excel), as you know. In this video, I decided to code "Yes" with the digit 1 and "No" with 2. However, I could have coded "Yes" with 2, and "No" with 1. It does not matter if you ask me ;-)
HAHAHA the cat!
omg the cat
That cat :D
Thank you - very useful start up.
thank you for sharing this. You do a better job than my research method teacher .
Thank you so much, this helped with my data collection :)
Excellent, good luck with your project!
How can I enter 2500 data from pen-and-paper questionnaires with over 60 variables fast into excel? Please, help!
Hire an intern
Нұрбек Ізбасар hello did you u understand how to enter a lot of data from pen-and-paper questionnaire with several variables into excel? Just i wanna know how did u solve this, I facing this problem. Please help me
I guess it's better to do surveymonkey for big questionares instead of pen&paper, all results will be digitalised already and saves time
as soon as i saw the cat liked it.
What if there is a response of N/A (Not applicable), then how will we treat it?
hahaha love the cat! Nice video.
This is the best tutorial....you just saved a soul...thank you so much
Thank you. That is why I do these video ;-)
Absolutely...very helpful and clear to understand. Thanks a lot
How to add 40 questions given the alphabet is limited to Z?
I came to see that cat!
Cat are special, indeed :-)
Your voice is music to ears. Btw great explanation.
Thanks for posting the video. I have a question. I have 30 items in my questionnaire and 7 items for background information. Should I enter all in the same sheet? TIA
I love your cat.
I like your cat
do you merge columns 1 and 2?
Where is the followup video explaining q5?
Here my friend: th-cam.com/video/DjDaNnlYT3s/w-d-xo.html
Oh God, this cat is so bad influence of laziness. LOL. I love your videos Mr. Swedish.
Kent, I would love to know how you would code in the response to a question where someone may select more than one response, but if they select more than 1 then they must rank them in order of importance? I'm stumped on how I could best do this!
nice tutorial and lovely cat
Whats the name of the cat?
Hello! His name was Zhimba but he was old so we have to put him to sleep. Very sad. However, we have a new cat, Mr. Corre: th-cam.com/video/SGk0kdckdx4/w-d-xo.html
THANK YOU AND THUMBS UP
Cat is excellent :)
I think so too!
thanks very much KENT....I REALLY ENJOYED IT
Hello @Kent thank you very much for the guidance, i had no idea how to start.
Thank you for this!
you are a genius
Thanks for sharing Kent