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 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 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.
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?
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!
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
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.
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?
@@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): ruclips.net/video/DjDaNnlYT3s/видео.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.
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: ruclips.net/video/DjDaNnlYT3s/видео.html&t=21m26s
For Excel? Not so much. I only have these two videos: Create a table from survey data: ruclips.net/video/Kno1gJiO5Dg/видео.html Copy & paste tables to Word: ruclips.net/video/yaeeSzSmicI/видео.html Good luck with your projects
I really like your method of coding the questionnaire. It is very clear and concise.Thank you for sharing your method!
Thank you so much!! I've been searching for three days for a solution that I can understand! Plus, I love the kitty :D
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!
Brilliant, concise, thank you so much.
Well understood... Thank u and ur calmness makes it easy to follow ur work
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 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 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 (RUclips settings for each video).
I love that the cat kept bugging him lol
Very helpful and clear! Thank you. Also, your cat is awesome (:
thank you for sharing this. You do a better job than my research method teacher .
Absolutely...very helpful and clear to understand. Thanks a lot
This was very simple, helpful, and well explained. Thank you. I dropped a like on your video.
Great, thank you so much. Easy to follow, I'm going to your next video!
Really helpful. Cat is super adorable. Many thanks for your videos sir.
this was the best video I have watched all year
Glad to hear!
Thank you for the simple explanation.
I love how you work around your kitty！！ and nice video!
Ah this cat is full of attitude. LOL. So cute.
This is the best tutorial....you just saved a soul...thank you so much
Thank you. That is why I do these video ;-)
You saved my life too! :0) Great method!
Thanks for helping me with my research! :) Great job and cute cat!
thanks very much KENT....I REALLY ENJOYED IT
Hello @Kent thank you very much for the guidance, i had no idea how to start.
woooow
Explain in a very clear way
Thanks for sharing Kent
Thank you, this is really helpful
Thank you - very useful start up.
this will be very helpful for my survey thank you so much for making this video!!! 🤗👍😁
thank you, that was super helpful and your cat is awesome
very helpful!!! u safe my life :D Xx greetings from Rotterdam
Perfect, I learnt alot, thank you for this.
Very helpful. Thank you!
This was extremely helpful for my english class. and Let me say, I love your cat. Mine does the same.
thanks for the video useful for research work thanks mr. kent lofgren blessings
Thank you so much for this video. And thank you to 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.
Thank you, I will
ps I really enjoyed the cat's contribution to the video too - it made me laugh out loud!
Thank you for this!
thanks much as I was out at sea with regards to my research now I get to start.
thanks! After 8 years you're still finding an ignorant person like me
Thank you, and good luck w. your project.
Thanks for the video. Definately helpfull :D
You did a great favor for me
A lot of thanks
thanks alot for this! smart cat too!!
Brilliant - thank you!!!
nice tutorial and lovely cat
love your cat
Thank you very much! this was exactly what I was looking for!
You're very welcome!
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
Love your cat!
I love the simplicity in your teaching. How do you enter the questions on excel before entering the responses?
useful video and love the helper
Oh God, this cat is so bad influence of laziness. LOL. I love your videos Mr. Swedish.
My favorite part was the cat just chilling
Thank you so much, this helped with my data collection :)
Excellent, good luck with your project!
you made my day
you are a genius
hahaha love the cat! Nice video.
very useful video, thanks - give your cat a good scratch for me!
The cat close ups are very funny.
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!
Thank you my teacher
THANK YOU AND THUMBS UP
Great.Helpful
I love your cat.
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.
as soon as i saw the cat liked it.
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 so much. Do you have a video that covers how to handle "other" as a category in a question?
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?
thank you very helpful
how do i analyse the data can't seems to find your next video
This guy's hilarious
This has been very helpful, Sir. What do you do about items in the questionnaire that were left unanswered? (for YES/NO items)
I would give that cat a little spanking for trying to interrupt. lol
Cat is excellent :)
I think so too!
omg the cat
HAHAHA the cat!
I wanna know how I can get the percentages after entering the data !
really enjoyed the lecture, but will ike to know how to enter the same dataset into Minitab. thanks
Your voice is music to ears. Btw great explanation.
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!
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
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
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.
That cat :D
i like to think the cat is narrating it
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?
Thank U... I hope to do a Post Ph.D. program is digital finance hopefully on Scholarship... Fan from Nigeria
This is my life! coding with a cat! Glad I'm not the only one :-)
Right?!
do you merge columns 1 and 2?
Could you help me how to organise questinere in array or categorical data
I like your cat
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):
ruclips.net/video/DjDaNnlYT3s/видео.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.
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: ruclips.net/video/DjDaNnlYT3s/видео.html&t=21m26s
got it. Thanks Mr. Kent for sharing.
The cat stole the show.
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: ruclips.net/video/Kno1gJiO5Dg/видео.html
Copy & paste tables to Word: ruclips.net/video/yaeeSzSmicI/видео.html
Good luck with your projects
Is there a program that you scan your surveys in and it automatically populates on Excel for you?
I came to see that cat!
Cat are special, indeed :-)