How to code a questionnaire on Google Forms using Excel and SPSS

📌📌📌 For assistance with data analysis of questionnaires, kindly contact me via this email: [e-mail] or WhatsApp: [phone]
Facebook: / benhima1
Instagram: / medbenhima2015
Linkedin: / mohamed-benhima-6a1087109
Twitter: / mohamed_benhima
WhatsApp: [phone]
E-mail: [e-mail]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get customizable templates developed over eight years of research work experience:
📄✏: Customizable research templates catalogue: redev.gumroad....
📄✏: Likert scale survey 1: Get a Likert scale template customizable in Microsoft Office Word via: redev.gumroad....
📄✏: Likert scale survey 2: Another short version of a five-point Likert scale in MS Word: redev.gumroad....
📄✏: Likert scale survey 3: redev.gumroad....
📄✏: Likert scale reliability report template: redev.gumroad....
📄✏: Lkert scale EFA, CFA, PCA, Eigenvalue, Cronbach alpha reliability, Kaiser-Meyer-Olkin (KMO) Measure of Sampling Adequacy, Bartlett's Test of Sphericity: redev.gumroad....
📄✏: Mediation analysis template: redev.gumroad....
📄✏: Moderation analysis template: redev.gumroad....
📄✏: Ten customizable Likert scale templates: redev.gumroad....
#googleform #likertscale #datacleaning

[@MohamedBenhimaPhD]

📌 For assistance with data analysis, kindly contact me via this email: [e-mail] or WhatsApp: [phone] / 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: [phone] E-mail: [e-mail] 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

[@harmeetchhabra8412]

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

[@krishnadevibonia1542]

Ok

[@classicaltutor1013]

Thank you

[@deborahkhairmode223]

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 😭❤️

[@hayetdriai4216]

What do you do after coding the data , please? I couldn't find the next video.

[@deborahkhairmode223]

@@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.

[@deborahkhairmode223]

@@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.

[@CookieBitter96]

You just saved the lives of 3 desarate college seniors with this! Thank you very good job!

[@notalie7514]

Make that 4❤

[@CookieBitter96]

@@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

[@novemberchizurumoke9556]

Two years down the line and this video is still saving our asses 😂 Thank you ❤❤❤

[@kellyanderson4910]

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

[@tharshinisandaragesan2342]

I was panicking for not being able to use SPSS. But this video deserves a big thumbs up!!!!

[@hanas_340]

I have only one month left for a whole dissertatio and you my dear, just saved my life.

[@VidanelageSashini]

I watched so much videos but couldn't clearly get any, This video saved me it's very clear, Thank you sir!

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form and thanks in advance

[@kwakuklinsman1687]

i don't usually comment on KZbin videos but you just saved me boss thank you

[@MohamedBenhimaPhD]

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

[@TheMushMe]

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.

[@LugandaLearner]

It works I've just tried it

[@thetwistingfox9649]

You just showed me a way to finish the analysis of my MSc dissertation on time. God bless you 🙏🏾

[@LugandaLearner]

Thank you brother. Am to submit my desertion for BMLS Mbarara University you've saved me a science student

[@MohamedBenhimaPhD]

Most welcome

[@kayelidanhog8357]

THIS HELPED A LOT THANK YOU SO MUCH I WAS HAVING A BREAKDOWN BECAUSE OF MY STATISTICS AND THEN THERE IS THIS MIRACLE

[@MohamedBenhimaPhD]

Glad to hear this

[@abaza1428]

yo i love this guy, in the span of 5 min i went from panicking to chilling, keep it up bud✌🏼✌🏼✌🏼✌🏼✌🏼✌🏼

[@josephinewileswarner6549]

Thanks, Mohamed, for sharing this video. You are a life saver.

[@janeben-caleb7418]

You are simply God-sent! Thank you so much! 🤗

[@sonusitu234]

I watched so many videos wasn't clear.... Thank you.... I got cleared how to proceed

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form Thanks in advance for your time

[@bbmeow210]

This is super helpful! Thank you so much for the wonderful tutorial😃

[@vijaykumarmohan4033]

Thank you, Sir. I learned coding from the Google form questionnaire from you..🙏Once again, thank you so much, sir.

[@hdrrecipesandvlogs1234]

Thank you soooo much sir Half of my Research is done after watching ur video It really helped a lot

[@MohamedBenhimaPhD]

All the best!

[@searchrightthings.947]

Thanks jasakala allah kheyr for sharing good knowledge.

[@DilfuzaKarimova-ty5gv]

Very useful and easy to follow, thanks a lot.

[@us6427]

very concise and helpful. Thank you

[@MohamedBenhimaPhD]

Glad it was helpful!

[@us6427]

@@MohamedBenhimaPhD Yes, basically i succeeded at my qualitative research because of you. Once again thank you

[@MohamedBenhimaPhD]

@@us6427 glad to hear this!

[@Jumana373]

Thank you, the tutorial was really helpful

[@arunamaharjan945]

Thank you, this is very helpful!

[@MohamedBenhimaPhD]

Most welcome

[@pamelapeter9417]

Thank you so much 💓

[@lavanya7081]

Should I create google form to code the data? Is it necessary.? I have data in pencil paper form.. please can someone tell me about this

[@JanhaZ013]

what shall be the order of replacement when using 7 point likert scale ?

[@shivaani1769]

Thank you for this helpful video.

[@teyaa.k.2165]

WAW IT WORKED FOR ME AMAZING THANK YOU!!!!!!!!

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form Thanks in advance for your time

[@BhautikParekh-uf6ze]

really very helpful.

[@rameshkunwar8730]

Thank you so much sir

[@MohamedBenhimaPhD]

Most welcome

[@notalie7514]

Jazakallah Khairan !

[@MohamedBenhimaPhD]

Amin

[@iqrazafar7941]

excellent, much needed video

[@elsarehana6336]

Thank you... Clearly understood

[@atharvashelke4296]

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.

[@phoebe1913]

Can I ask? Thru changing the gender in numerical value, can I apply other descriptive tool to find more data?

[@nehalelmesbahy538]

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?

[@user-kp8fz8jj7j]

Thank you so much, this was super helpful!

[@wizard5021]

You saved the day broo❤

[@adelalbokhari3260]

Sir this video helped a lot, thank you very much

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form and thanks in advance

[@prelizatan6740]

Thank youuuuu so much, so tons of time

[@zuhaow2013]

Thank you so so much

[@ruchivohra]

Thank you so much sir, you really made it simple!

[@MohamedBenhimaPhD]

Most welcome

[@elsarehana6336]

Is there any video of spss factor analysis?

[@alizaerom1019]

so easy.thanx a lot sir

[@art_prati_bimb]

It's helpful for me... Thanks a lot

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form Thanks in advance for your time

[@kamoliddinmannonov261]

Thank you Sir, great video

[@rmdm5944]

My man thank you very much

[@channeldl143]

Learnt something new.thanks

[@umamaheswari4358]

Very useful thku🙏👌🏼

[@humairatajammul2805]

its really help full thank U so much

[@Dchallenger.]

Hello sir pls I need d exact questionaire questions u used for this particular explanation can I get it

[@maviaiftikhar4778]

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??

[@nandhiniparthi1640]

Very clear to understood thank you sir

[@MohamedBenhimaPhD]

Welcome!

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form and thanks in advance

[@keulluni1112]

thank u king

[@vlad-andreilupu1103]

Thank you kindly!

[@sreevidyasankarasubramania733]

Thank you .

[@angels8688]

What about épi info ?? How to use it with Google forms ?? Please answer..

[@lekarb1324]

where can i find part 2 or way forward to this video?

[@sivapri6638]

Thank you sir for the vedio.Is it possible to enter qualitative data in Excel and code them

[@subashinishankar9686]

how to I extract code of questionaire, it has to be done manually or there is method to download from google form responses?

[@zaidismael7262]

How to code for example age below 20 from 20 to 30 , from 31 to 40 from 41 to 50 above 50

[@MohamedBenhimaPhD]

They can be coded from 1 to 5 Lowest to highest

[@dohamounir1668]

Thank you so much, this was extremely helpful and well explained!

[@cherryberry2366]

What about questionnaires from printed paper and not google form.??? How to do it??

[@upamamitra5310]

Develop a excel with all the questions and the respective response for each question. Just like the one Google form generates for their responses. You just have to do it manually

[@israezougaret439]

sir, what about an open ended question ?

[@soumayaezazaa531]

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.

[@MohamedBenhimaPhD]

Select them all, find and replace the values with numbers for each similar variables

[@soumayaezazaa531]

@@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

[@MohamedBenhimaPhD]

if you hqve qualitative data. It is hard to do it. Contact me via Whatsapp [phone], and take screenshots for me to tell you what to do@@soumayaezazaa531

[@soumayaezazaa531]

@@MohamedBenhimaPhD omg I didn’t expect ur answer !!! I will text you right away !!! Thank you alot

[@parvezmussarf6150]

After coding how to enter those data into pivot table please can you help ?

[@paraskaith8073]

What about reverse coded items in same scale?

[@keishaclements4674]

How do you create a 5-point likert scale?

[@sanjana8357]

Where is the other video for the other analysis plz??

[@sivakumar-zq2df]

Thank you sir

[@pezzergaming963]

How to enter the 5 th question (multiple answers)?

[@najlaaalmana9579]

Interesting video can we check your second video for running test

[@maysr10]

Sir my filen ame is not showing on spss

[@vijeyalakshmis5456]

Thanks a lot

[@nikithabenny8927]

Sir how to code and set values for rank questions

[@conquestech]

what of those ones separated by comma

[@humairatajammul2805]

upload more videos regarding SPPS test

[@teacherrmor3804]

Hi Sir, how can I get your SpSS? Need Help, Thank you

[@foodswithlam9952]

Thanks 👍

[@zoulikhamennif8309]

thank you

[@dynur4568]

thank you so much but where is part 2 video haha

[@MohamedBenhimaPhD]

Most welcome

[@MohamedBenhimaPhD]

Kindly check the channel to see what tests to use

[@nipunirathnasena5184]

How coding branching questions

[@MohamedBenhimaPhD]

Coding can be done on SPSS by find and replace options

[@aayushishrestha4314]

What about somewhat disagree?

[@MohamedBenhimaPhD]

That is another type of Likert scale

[@Bustamamgendut]

What if the part strongly disagree part has already been existed as numeric?

[@MohamedBenhimaPhD]

what do you mean exactly? Could you explain more?

[@Bustamamgendut]

@@MohamedBenhimaPhD i just found out from my friend. I should make an adjustment on my Excel since I copied from Excel, then to SPSS

[@MohamedBenhimaPhD]

If you have five point likert scale follow this method. There are other methods in the channel, check them out

[@Bustamamgendut]

@@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.

[@MohamedBenhimaPhD]

You can number them the way you like. It is based on personal choice. Just report that

[@LaloElGentuzas]

buena hermano

[@Poojasingh11112]

My Excel file didn't not open in spss it is showing empty 🥺😭😭

[@judyturel3497]

What if you don’t have access to spss is there anyway to do it without

[@MohamedBenhimaPhD]

You can use Excel itself

[@fatimazahraahyaoui7327]

How about open ended questionnaires. How can I score them and code them in SPSS ??

[@MohamedBenhimaPhD]

You can use thematic analysis of open-ended questions by looking for recurrent themes

[@05madavan58]

docs.google.com/forms/d/e/1FAIpQLSe0vOzBP6BVh1FZl5FDCZz4gf5ZwH2BwXhCy_V57ao52SvHAw/viewform?usp=sf_link Please fill this form Thanks in advance for your time

[@jakezahra7469]

THANK YOU

[@MohamedBenhimaPhD]

Most welcome 🤗

[@TrenchesBaby-o7e]

Whats the name of the website

[@jamesmaibale8533]

You didn't explain how to make a code book

[@clarathylmesiona6210]

How to add blank page???

[@kanimozhi5451]

How to code for multiple choice question

[@MohamedBenhimaPhD]

You can code them as 0 and 1 (chosen or not chosen)

[@evangelistesther.o]

do you know how to put in billions and millions (large number values) into SPSS?

[@MohamedBenhimaPhD]

Just increase the decimals in the variable view

[@evangelistesther.o]

@@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?

[@MohamedBenhimaPhD]

@@evangelistesther.o this is what I think. You can make sure of that. You can also just normalise the numbers per 10000 for example

[@evangelistesther.o]

@@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 ?

[@MohamedBenhimaPhD]

@@evangelistesther.o you normalise per billions for instance and enter the numbers into spss

[@dyey-en8492]

Where to get SPSS ?

[@happysingle9204]

You could code Fe1 with 2 hahaha

[@Deepumohan-fp7id]

Thank u so much sir