How to code a questionnaire on Google Forms using Excel and SPSS
HTML-код
- Опубликовано: 28 авг 2020
- 📌📌📌 For assistance with data analysis of questionnaires, kindly contact me via this email: datanalysis93@gmail.com or WhatsApp: +212619398603
Facebook: / benhima1
Instagram: / medbenhima2015
Linkedin: / mohamed-benhima-6a1087109
Twitter: / mohamed_benhima
WhatsApp: +212619398603
E-mail: Datanalysis93@gmail.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get customizable templates developed over eight years of research work experience:
📄✏: Customizable research templates catalogue: redev.gumroad.com/
📄✏: Likert scale survey 1: Get a Likert scale template customizable in Microsoft Office Word via: redev.gumroad.com/l/hmmwj
📄✏: Likert scale survey 2: Another short version of a five-point Likert scale in MS Word: redev.gumroad.com/l/ptsbz
📄✏: Likert scale survey 3: redev.gumroad.com/l/oxnve
📄✏: Likert scale reliability report template: redev.gumroad.com/l/jdbxdz
📄✏: Lkert scale EFA, CFA, PCA, Eigenvalue, Cronbach alpha reliability, Kaiser-Meyer-Olkin (KMO) Measure of Sampling Adequacy, Bartlett's Test of Sphericity: redev.gumroad.com/l/cynbjf
📄✏: Mediation analysis template: redev.gumroad.com/l/yeaff
📄✏: Moderation analysis template: redev.gumroad.com/l/atsdw
📄✏: Ten customizable Likert scale templates: redev.gumroad.com/l/qcamn
#googleform #likertscale #datacleaning 
Хобби
📌 For assistance with data analysis, kindly contact me via this email: datanalysis93@gmail.com or WhatsApp: +212619398603 / or follow this link wa.link/l6jvny
Facebook: facebook.com/benhima1/
Instagram: instagram.com/medbenhima2015/
Linkedin: www.linkedin.com/in/mohamed-benhima-6a1087109/
Twitter: twitter.com/Mohamed_Benhima
WhatsApp: +212619398603
E-mail: Datanalysis93@gmail.com
Zoom: us05web.zoom.us/j/5038752034?pwd=SDVjZGZXaEl5b0d2bVJ2c3M2VzVWUT09
Google Meet: meet.google.com/tgr-vmww-aoj
GoogleClassroom: classroom.google.com/c/MzI0MDc1MjM4NDI0?cjc=s2vuft2
Code: s2vuft2
Telegram Research Support Group: t.me/joinchat/FqMy6gQ-xRU6bgLg
If my questionnaire contains a yes or no question and if the respondent answers yes he moves to a certain section of the questionnaire and if he answers no then he moves to a different section how to enter data of such type to be used in smartpls
Ok
Thank you
You have no idea that you saved a student in her research. Basically left to fend for myself by my guide and you came in like an angel 😭❤️
What do you do after coding the data , please? I couldn't find the next video.
@@hayetdriai4216 So basically you change your "Always" to 5 and your "Never" to 1. Exactly how it's mentioned in the video. Then you start to add the values up. So say, Body Image Concern Inventory has 19 questions, and their score can reach from 19 (where someone selects 'Never' for every question) to 98 (where they select 'Always' for every question).
What you do is, you make the sum of the scores for the questions. Then select the + sign and drag it down to get the sum of the scores for all the responses for whichever particular questionnaire you've used.
For something like Rosenberg's Self-esteem Scale, you'll have to follow the scoring mentioned.
Hope this helps!
P.S. Love the Arietty pfp.
@@hayetdriai4216 So you just sum them up. Because since you have numbers now it becomes easier to score the data. Basically you need scores for each response right? After turning those 'Always' to 5 and 'Never' to 1 you can now do the scoring. Depends on the tool you're using and whether you're on a five-point or a four-point Likert scale.
P.S. Love the Arietty pfp.
Two years down the line and this video is still saving our asses 😂
Thank you ❤❤❤
You just saved the lives of 3 desarate college seniors with this! Thank you very good job!
Make that 4❤
@@notalie7514 By now it's actually way more! We send this to the new senior students now that we graduated so we can help them. Thank you! :D
I have only one month left for a whole dissertatio and you my dear, just saved my life.
I was panicking for not being able to use SPSS. But this video deserves a big thumbs up!!!!
God bless you, you literally saved my life. There was a problem with my coding and I couldn’t figure out what it was. I used your list of codes and my analysis is fine now
You just showed me a way to finish the analysis of my MSc dissertation on time. God bless you 🙏🏾
Thanks, Mohamed, for sharing this video. You are a life saver.
yo i love this guy, in the span of 5 min i went from panicking to chilling, keep it up bud✌🏼✌🏼✌🏼✌🏼✌🏼✌🏼
You are simply God-sent!
Thank you so much!
🤗
This is super helpful! Thank you so much for the wonderful tutorial😃
Thank you, Sir. I learned coding from the Google form questionnaire from you..🙏Once again, thank you so much, sir.
I watched so much videos but couldn't clearly get any,
This video saved me it's very clear,
Thank you sir!
docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link
Please fill this form and thanks in advance
excellent, much needed video
Thank you so much, this was super helpful!
Thank you, the tutorial was really helpful
Thank you for this helpful video.
Thank you Sir, great video
Very useful and easy to follow, thanks a lot.
its really help full thank U so much
Thank you... Clearly understood
You saved the day broo❤
I watched so many videos wasn't clear.... Thank you.... I got cleared how to proceed
docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link
Please fill this form
Thanks in advance for your time
My man thank you very much
so easy.thanx a lot sir
really very helpful.
Learnt something new.thanks
For the Male and Female issues, one could also click the "Options >>" button in the prompt and then select the Match to all case. This will ensure only Male is replaced into 1 and not Female as Fe1.
It works I've just tried it
Very useful thku🙏👌🏼
THIS HELPED A LOT THANK YOU SO MUCH I WAS HAVING A BREAKDOWN BECAUSE OF MY STATISTICS AND THEN THERE IS THIS MIRACLE
Glad to hear this
Thank you soooo much sir
Half of my Research is done after watching ur video
It really helped a lot
All the best!
Thank you so much, this was extremely helpful and well explained!
Thank you brother.
Am to submit my desertion for BMLS Mbarara University you've saved me a science student
Most welcome
Thank you so much sir, you really made it simple!
Most welcome
Thank youuuuu so much, so tons of time
WAW IT WORKED FOR ME AMAZING THANK YOU!!!!!!!!
docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link
Please fill this form
Thanks in advance for your time
Thank you, this is very helpful!
Most welcome
Thank you so much
Thank you kindly!
It's helpful for me... Thanks a lot
docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link
Please fill this form
Thanks in advance for your time
Thank you so so much
Thank u so much sir
Jazakallah Khairan !
Amin
Thank you sir
Thank you!!!
Sir this video helped a lot, thank you very much
docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link
Please fill this form and thanks in advance
Thank you .
Interesting video can we check your second video for running test
very concise and helpful. Thank you
Glad it was helpful!
@@MohamedBenhimaPhD Yes, basically i succeeded at my qualitative research because of you. Once again thank you
@@us6427 glad to hear this!
Thanks a lot
upload more videos regarding SPPS test
Very clear to understood thank you sir
Welcome!
docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link
Please fill this form and thanks in advance
Thank you so much sir
Most welcome
Get customizable templates developed over eight years of research work experience:
📄✏: Customizable research templates catalogue: redev.gumroad.com/
📄✏: Likert scale survey 1: Get a Likert scale template customizable in Microsoft Office Word via: redev.gumroad.com/l/hmmwj
📄✏: Likert scale survey 2: Another short version of a five-point Likert scale in MS Word: redev.gumroad.com/l/ptsbz
📄✏: Likert scale survey 3: redev.gumroad.com/l/oxnve
📄✏: Likert scale reliability report template: redev.gumroad.com/l/jdbxdz
📄✏: Lkert scale EFA, CFA, PCA, Eigenvalue, Cronbach alpha reliability, Kaiser-Meyer-Olkin (KMO) Measure of Sampling Adequacy, Bartlett's Test of Sphericity: redev.gumroad.com/l/cynbjf
📄✏: Mediation analysis template: redev.gumroad.com/l/yeaff
📄✏: Moderation analysis template: redev.gumroad.com/l/atsdw
📄✏: Ten customizable Likert scale templates: redev.gumroad.com/l/qcamn
Thanks 👍
thanks a lot
Thank you sir for the vedio.Is it possible to enter qualitative data in Excel and code them
thank you
Is there any video of spss factor analysis?
How do you create a 5-point likert scale?
Sir how to code and set values for rank questions
After coding how to enter those data into pivot table please can you help ?
how to I extract code of questionaire, it has to be done manually or there is method to download from google form responses?
What about reverse coded items in same scale?
where can i find part 2 or way forward to this video?
Where is the other video for the other analysis plz??
Best vedio... Aik bt poochni h k jo coding hm dy rhy responses ko smj a gai h kesy krna h pr yhan pr ap ne sb se phly strongly agree ko 5 kha or strongly disagree ko 1 to agr hm phly replace kren strongly Disagree ko 1 se or end
Pr strongly agree ko 5 to koi frq to mi prta??
buena hermano
sir, what about an open ended question ?
Can I ask? Thru changing the gender in numerical value, can I apply other descriptive tool to find more data?
what of those ones separated by comma
THANK YOU
Most welcome 🤗
Hello sir pls I need d exact questionaire questions u used for this particular explanation can I get it
How to enter the 5 th question (multiple answers)?
Professor, is it necessary to use SPSS when analyzing data? Can’t we just use the graphs from the google form and analyze them directly?
What about questionnaires from printed paper and not google form.??? How to do it??
How to add blank page???
What about épi info ?? How to use it with Google forms ?? Please answer..
Sir we have a query, we asked 25 questions to 400, and there is 4 category in age groups 20-25, 25-30, 30-35, we want to calculate mean and standard deviations of opinion of each age group.
Sir my filen ame is not showing on spss
Hi Sir, how can I get your SpSS? Need Help,
Thank you
Where to get SPSS ?
How coding branching questions
Coding can be done on SPSS by find and replace options
You didn't explain how to make a code book
What about somewhat disagree?
That is another type of Likert scale
How to code for multiple choice question
You can code them as 0 and 1 (chosen or not chosen)
How to code for example age below 20
from 20 to 30 ,
from 31 to 40
from 41 to 50
above 50
They can be coded from 1 to 5
Lowest to highest
What if you don’t have access to spss is there anyway to do it without
You can use Excel itself
Hello !! How can code my data if I have multiple dependent variables and multiple independent variables !! For example have 10 DV that depends on 5 depending variables each !!!!is there an easy way to code the answers for Spss.
Select them all, find and replace the values with numbers for each similar variables
@@MohamedBenhimaPhD so that was a quick response !! Well what if 100 people answers differently for the 10 dependent variables that are impacted by 5 IV and the answers were multiple choice !!! I got the answer in google sheet but it is very hard to convert to spss it is taking me forever to code it ... idk if u understood what I mean . Thank you anywya
if you hqve qualitative data. It is hard to do it. Contact me via Whatsapp +212619398603, and take screenshots for me to tell you what to do@@soumayaezazaa531
@@MohamedBenhimaPhD omg I didn’t expect ur answer !!! I will text you right away !!! Thank you alot
How about open ended questionnaires. How can I score them and code them in SPSS ??
You can use thematic analysis of open-ended questions by looking for recurrent themes
docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link
Please fill this form
Thanks in advance for your time
What if the part strongly disagree part has already been existed as numeric?
what do you mean exactly? Could you explain more?
@@MohamedBenhimaPhD i just found out from my friend. I should make an adjustment on my Excel since I copied from Excel, then to SPSS
If you have five point likert scale follow this method. There are other methods in the channel, check them out
@@MohamedBenhimaPhD the difference is your content for Strongly Disagree - Strongly Agree didn't yet numbered as 1-5 at the first place while mine already being numbered as 1-5.
You can number them the way you like. It is based on personal choice. Just report that
My Excel file didn't not open in spss it is showing empty 🥺😭😭
thank you so much but where is part 2 video haha
Most welcome
Kindly check the channel to see what tests to use
do you know how to put in billions and millions (large number values) into SPSS?
Just increase the decimals in the variable view
@@MohamedBenhimaPhD ok so for 2.46 billion I would put 2.46 in the value column and then put 8 in the decimal column representing 8 decimal places?
@@evangelistesther.o this is what I think. You can make sure of that. You can also just normalise the numbers per 10000 for example
@@MohamedBenhimaPhD sorry can you explain a bit better I’m a little confused at what you mean can you give me an example for let’s say 2.46 billion and 2.46 trillion how would I put those ones in ?
@@evangelistesther.o you normalise per billions for instance and enter the numbers into spss
You could code Fe1 with 2 hahaha
Thank you so much