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!'.
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.
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.
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.
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?
Question 2 is special, as you know, because the participants may check, one, two or more options at the same time. When coding, split the question into parts (as many parts as there are options), i.e., create one column for each. Let's say you ask about their favorite summer activity and provide three options: swimming, walking and biking. We need three columns in Excel. For each row (remember, one row = one participant), use one digit to indicate that the participant has checked this option. In the video, I use "1". And leave it blank (or use another digit -- in the video I use "2") to indicate that the participant has not. In summary, create columns in Excel, and for each of the columns, enter something :-)
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.
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!
For Excel? Not so much. I only have these two videos: Create a table from survey data: ua-cam.com/video/Kno1gJiO5Dg/v-deo.html Copy & paste tables to Word: ua-cam.com/video/yaeeSzSmicI/v-deo.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?
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
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 ;-)
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: ua-cam.com/video/DjDaNnlYT3s/v-deo.html&t=21m26s
@@kentlofgren Dear sir, I have a question, in my questioner there is a question to select as well as to show their opinions on that, so in this kind of a scenario, how can we do the excel sheet thing
@@kaveeshaliyanage8754 Check out the third video in this series (at the time 21 min. 26 seconds and forward in that third video): ua-cam.com/video/DjDaNnlYT3s/v-deo.html It shows how to code written replies to open questions. It's a lot of work but I don't know any better way. All the Best Wishes!
@@kentlofgren Sir, if I just send you my questionnaire and the excel sheet, can you please check that whether as I have done it correctly? please sir big help
@@kaveeshaliyanage8754 I'm sorry, I don't have the time, but if you go to www.reddit.com/r/excel or perhaps: www.reddit.com/r/sociology maybe they can help you. Good luck with your project.
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.
Нұрбек Ізбасар 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
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 for both the new knowledge and smile! Your assistant is very insistent, love it!
Thanks for watching!
I really like your method of coding the questionnaire. It is very clear and concise.Thank you for sharing your method!
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 (UA-cam settings for each video).
this was the best video I have watched all year
Glad to hear!
Thank you for this easy to follow and clear to understand video. The best.
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.
This is the best tutorial....you just saved a soul...thank you so much
Thank you. That is why I do these video ;-)
Thank you so much!! I've been searching for three days for a solution that I can understand! Plus, I love the kitty :D
Well understood... Thank u and ur calmness makes it easy to follow ur work
Really helpful. Cat is super adorable. Many thanks for your videos sir.
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.
Oh God, this cat is so bad influence of laziness. LOL. I love your videos Mr. Swedish.
I love that the cat kept bugging him lol
Thank you for the simple explanation.
Brilliant, concise, thank you so much.
Thanks for helping me with my research! :) Great job and cute cat!
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
ps I really enjoyed the cat's contribution to the video too - it made me laugh out loud!
Thank you so much for this video. And thank you to your cat.
thank you for sharing this. You do a better job than my research method teacher .
woooow
Explain in a very clear way
I love how you work around your kitty！！ and nice video!
Thank you very much! this was exactly what I was looking for!
You're very welcome!
Absolutely...very helpful and clear to understand. Thanks a lot
Very helpful and clear! Thank you. Also, your cat is awesome (:
You saved my life too! :0) Great method!
Great, thank you so much. Easy to follow, I'm going to your next video!
thanks much as I was out at sea with regards to my research now I get to start.
Thank you so much, this helped with my data collection :)
Excellent, good luck with your project!
Thank you - very useful start up.
I love the simplicity in your teaching. How do you enter the questions on excel before entering the responses?
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.
very useful video, thanks - give your cat a good scratch for me!
My favorite part was the cat just chilling
thanks for the video useful for research work thanks mr. kent lofgren blessings
This was extremely helpful for my english class. and Let me say, I love your cat. Mine does the same.
thanks very much KENT....I REALLY ENJOYED IT
thanks! After 8 years you're still finding an ignorant person like me
Thank you, and good luck w. your project.
thank you, that was super helpful and your cat is awesome
this will be very helpful for my survey thank you so much for making this video!!! 🤗👍😁
Hello @Kent thank you very much for the guidance, i had no idea how to start.
very helpful!!! u safe my life :D Xx greetings from Rotterdam
Appreciated! it is very helpful
I wanna know how I can get the percentages after entering the data !
Thank you, this is really helpful
nice tutorial and lovely cat
Ah this cat is full of attitude. LOL. So cute.
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
as soon as i saw the cat liked it.
Thank you my teacher
thank you very helpful
how do i analyse the data can't seems to find your next video
The cat close ups are very funny.
This was very simple, helpful, and well explained. Thank you. I dropped a like on your video.
really enjoyed the lecture, but will ike to know how to enter the same dataset into Minitab. thanks
Thanks for sharing Kent
Thanks very much for your instructions that help me to continue my survey workout with my own self in my msc career.
Best of luck!
Your voice is music to ears. Btw great explanation.
This has been very helpful, Sir. What do you do about items in the questionnaire that were left unanswered? (for YES/NO items)
I love your cat.
Perfect, I learnt alot, thank you for this.
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?
Same question ?
Question 2 is special, as you know, because the participants may check, one, two or more options at the same time. When coding, split the question into parts (as many parts as there are options), i.e., create one column for each. Let's say you ask about their favorite summer activity and provide three options: swimming, walking and biking. We need three columns in Excel. For each row (remember, one row = one participant), use one digit to indicate that the participant has checked this option. In the video, I use "1". And leave it blank (or use another digit -- in the video I use "2") to indicate that the participant has not. In summary, create columns in Excel, and for each of the columns, enter something :-)
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
thanks alot for this! smart cat too!!
Great.Helpful
Love your cat!
I would give that cat a little spanking for trying to interrupt. lol
You did a great favor for me
A lot of thanks
you made my day
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 helpful, thanks!
Thank you so much. Do you have a video that covers how to handle "other" as a category in a question?
Thank you for this!
useful video and love the helper
Could you help me how to organise questinere in array or categorical data
Thanks for the video. Definately helpfull :D
you are a genius
hahaha love the cat! Nice video.
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!
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: ua-cam.com/video/Kno1gJiO5Dg/v-deo.html
Copy & paste tables to Word: ua-cam.com/video/yaeeSzSmicI/v-deo.html
Good luck with your projects
Is there a program that you scan your surveys in and it automatically populates on Excel for you?
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?
love your cat
Have you tried to digitalized it with a softwares that recognizes each question ans answer? :)
Hi! No, I've never tried that. Great idea.
This is my life! coding with a cat! Glad I'm not the only one :-)
Right?!
Thank U... I hope to do a Post Ph.D. program is digital finance hopefully on Scholarship... Fan from Nigeria
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
do you merge columns 1 and 2?
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 ;-)
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: ua-cam.com/video/DjDaNnlYT3s/v-deo.html&t=21m26s
got it. Thanks Mr. Kent for sharing.
Brilliant - thank you!!!
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
Cat is excellent :)
I think so too!
thank you so so so so so so much
Glad it helped! Good luck with your projects!
@@kentlofgren Dear sir, I have a question, in my questioner there is a question to select as well as to show their opinions on that, so in this kind of a scenario, how can we do the excel sheet thing
@@kaveeshaliyanage8754 Check out the third video in this series (at the time 21 min. 26 seconds and forward in that third video):
ua-cam.com/video/DjDaNnlYT3s/v-deo.html
It shows how to code written replies to open questions. It's a lot of work but I don't know any better way. All the Best Wishes!
@@kentlofgren Sir, if I just send you my questionnaire and the excel sheet, can you please check that whether as I have done it correctly? please sir big help
@@kaveeshaliyanage8754 I'm sorry, I don't have the time, but if you go to www.reddit.com/r/excel or perhaps: www.reddit.com/r/sociology maybe they can help you. Good luck with your project.
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 ua-cam.com/video/DjDaNnlYT3s/v-deo.html
Hi! Are you able to find the coefficient correlation and p-value using the data ? Because I have a similar questionnaire but I need to find those 2
i like to think the cat is narrating it
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
What if there is a response of N/A (Not applicable), then how will we treat it?
The cat stole the show.