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

Подписаться 17 тыс.

Просмотров 405 тыс.

50% 1

📌📌📌 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....
📄✏: 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

Опубликовано:

14 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 163

@MohamedBenhimaPhD 3 года назад

📌 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

@harmeetchhabra8412 3 года назад

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 2 года назад

@classicaltutor1013 7 месяцев назад

Thank you

@deborahkhairmode223 10 месяцев назад

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 6 месяцев назад

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

@deborahkhairmode223 6 месяцев назад

@@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 6 месяцев назад

@@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 3 года назад

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 8 месяцев назад

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

@hanas_340 3 года назад

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

@tharshinisandaragesan2342 3 года назад

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

@VidanelageSashini 3 года назад

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

@05madavan58 2 года назад

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

@kwakuklinsman1687 2 месяца назад

i don't usually comment on RU-vid videos but you just saved me boss thank you

@NameOfNamess 10 месяцев назад

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

@abaza1428 2 года назад

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

@TheMushMe 3 года назад

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

@kayelidanhog8357 2 года назад

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

@MohamedBenhimaPhD 2 года назад

Glad to hear this

@janeben-caleb7418 4 месяца назад

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

@josephinewileswarner6549 Год назад

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

@sonusitu234 3 года назад

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

@05madavan58 2 года назад

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

@yasminasdiary3509 23 дня назад

hi! thank you for such a helpful tutorial! i have a question: if I need to code "agree" as "1" and "don't agree" as "0", which one should be coded first? thanks in advance!!

@MohamedBenhimaPhD 22 дня назад

@@yasminasdiary3509 hi! You can start with "don't agree" as 0

@bbmeow210 2 года назад

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.

@nehalelmesbahy538 4 месяца назад

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?

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

@phoebe1913 7 месяцев назад

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

@DilfuzaKarimova-ty5gv 4 месяца назад

Very useful and easy to follow, thanks a lot.

@searchrightthings.947 2 месяца назад

Thanks jasakala allah kheyr for sharing good knowledge.

@atharvashelke4296 6 месяцев назад

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.

@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 3 месяца назад

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

@Jumana373 Год назад

Thank you, the tutorial was really helpful

@maviaiftikhar4778 3 года назад

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

@elsarehana6336 5 месяцев назад

Is there any video of spss factor analysis?

@sivapri6638 2 года назад

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

@arunamaharjan945 Год назад

Thank you, this is very helpful!

@MohamedBenhimaPhD Год назад

Most welcome

@muskanarora5573 28 дней назад

Facing problem while coding data my replace and find is not working due to error or protected sheet excel says that it can’t change tha data of protected sheet

@subashinishankar9686 3 года назад

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

@us6427 2 года назад

very concise and helpful. Thank you

@MohamedBenhimaPhD 2 года назад

Glad it was helpful!

@us6427 2 года назад

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

@MohamedBenhimaPhD 2 года назад

@@us6427 glad to hear this!

@teyaa.k.2165 2 года назад

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

@05madavan58 2 года назад

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

@Dchallenger. 7 месяцев назад

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

@lekarb1324 6 месяцев назад

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

@soumayaezazaa531 3 года назад

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 3 года назад

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

@soumayaezazaa531 3 года назад

@@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 3 года назад

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

@soumayaezazaa531 3 года назад

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

@elsarehana6336 5 месяцев назад

Thank you... Clearly understood

@angels8688 2 года назад

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

@shivaani1769 2 года назад

Thank you for this helpful video.

@rameshkunwar8730 Год назад

Thank you so much sir

@MohamedBenhimaPhD Год назад

Most welcome

@israezougaret439 6 месяцев назад

sir, what about an open ended question ?

@wizard5021 Год назад

You saved the day broo❤

@BhautikParekh-uf6ze 5 месяцев назад

really very helpful.

@notalie7514 Год назад

Jazakallah Khairan !

@MohamedBenhimaPhD Год назад

Amin

@parvezmussarf6150 3 года назад

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

@prelizatan6740 10 месяцев назад

Thank youuuuu so much, so tons of time

@user-kp8fz8jj7j 2 года назад

Thank you so much, this was super helpful!

@pamelapeter9417 Месяц назад

Thank you so much 💓

@adelalbokhari3260 2 года назад

Sir this video helped a lot, thank you very much

@05madavan58 2 года назад

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

@keishaclements4674 Год назад

How do you create a 5-point likert scale?

@teacherrmor3804 Год назад

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

@paraskaith8073 Год назад

What about reverse coded items in same scale?

@sanjana8357 3 года назад

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

@nikithabenny8927 2 года назад

Sir how to code and set values for rank questions

@cherryberry2366 6 месяцев назад

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

@najlaaalmana9579 4 года назад

Interesting video can we check your second video for running test

@zuhaow2013 Год назад

Thank you so so much

@rmdm5944 2 года назад

My man thank you very much

@judyturel3497 Год назад

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

@MohamedBenhimaPhD Год назад

You can use Excel itself

@conquestech Год назад

what of those ones separated by comma

@ruchivohra 2 года назад

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

@MohamedBenhimaPhD 2 года назад

Most welcome

@art_prati_bimb 3 года назад

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

@05madavan58 2 года назад

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

@aayushishrestha4314 Год назад

What about somewhat disagree?

@MohamedBenhimaPhD Год назад

That is another type of Likert scale

@zaidismael7262 2 года назад

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

@MohamedBenhimaPhD 2 года назад

They can be coded from 1 to 5 Lowest to highest

@humairatajammul2805 3 года назад

its really help full thank U so much

@alizaerom1019 3 года назад

so easy.thanx a lot sir

@nandhiniparthi1640 3 года назад

Very clear to understood thank you sir

@MohamedBenhimaPhD 3 года назад

Welcome!

@05madavan58 2 года назад

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

@pezzergaming963 2 года назад

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

@Bustamamgendut 4 года назад

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

@MohamedBenhimaPhD 4 года назад

what do you mean exactly? Could you explain more?

@Bustamamgendut 4 года назад

@@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 4 года назад

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

@Bustamamgendut 4 года назад

@@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 4 года назад

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

@humairatajammul2805 3 года назад

upload more videos regarding SPPS test

@kamoliddinmannonov261 3 года назад

Thank you Sir, great video

@dohamounir1668 2 года назад

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

@TrenchesBaby-o7e 2 месяца назад

Whats the name of the website

@channeldl143 3 года назад

Learnt something new.thanks

@iqrazafar7941 3 года назад

excellent, much needed video

@fatimazahraahyaoui7327 3 года назад

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

@MohamedBenhimaPhD 3 года назад

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

@05madavan58 2 года назад

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

@umamaheswari4358 3 года назад

Very useful thku🙏👌🏼

@vlad-andreilupu1103 2 года назад

Thank you kindly!

@keulluni1112 2 месяца назад

thank u king

@sreevidyasankarasubramania733 3 года назад

Thank you .

@maysr10 5 месяцев назад

Sir my filen ame is not showing on spss

@nipunirathnasena5184 10 месяцев назад

How coding branching questions

@MohamedBenhimaPhD 9 месяцев назад

Coding can be done on SPSS by find and replace options

@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

@clarathylmesiona6210 Год назад

How to add blank page???

@evangelistesther.o 3 года назад

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

@MohamedBenhimaPhD 3 года назад

Just increase the decimals in the variable view

@evangelistesther.o 3 года назад

@@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 3 года назад

@@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 3 года назад

@@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 3 года назад

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

@jamesmaibale8533 4 года назад

You didn't explain how to make a code book

@kanimozhi5451 2 года назад

How to code for multiple choice question

@MohamedBenhimaPhD 2 года назад

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

@Poojasingh11112 5 месяцев назад

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

@vijeyalakshmis5456 2 года назад

Thanks a lot

@dyey-en8492 2 года назад

Where to get SPSS ?

@sivakumar-zq2df 3 года назад

Thank you sir

@zoulikhamennif8309 11 месяцев назад

thank you

@LaloElGentuzas 2 года назад

buena hermano

@jakezahra7469 Год назад

THANK YOU

@MohamedBenhimaPhD Год назад

Most welcome 🤗

@foodswithlam9952 2 года назад

Thanks 👍

@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