How to analyze checkbox or multiple choice questions from Google Forms and Excel

Поділитися
Вставка
  • Опубліковано 10 сер 2022
  • #googleformstutorial #multiplechoice
    📌 For assistance with data analysis, kindly contact me via this email: datanalysis93@gmail.com or WhatsApp: +212619398603 / wa.link/l6jvny / t.me/DrBenhima
    Facebook: / benhima1
    Instagram: / medbenhima2015
    TikTok: www.tiktok.com/@mohamedbenhim...
    LinkedIn: / mohamed-benhima-phd-6a...
    Google Scholar: scholar.google.com/citations?...
    Twitter: / mohamed_benhima
    WhatsApp: +212619398603 / wa.link/l6jvny
    Telegram: t.me/DrBenhima
    E-mail: Datanalysis93@gmail.com
    UA-cam CHANNEL: / @mohamedbenhimaphd
    ------------------------------------------------------------------------------
    Function of multiple item coding:
    =IF(ISERR(SEARCH(G$1,$F2)),"0",1)
    =IF(ISERROR(search(F$1,$E2)),"",1)
  • Навчання та стиль

КОМЕНТАРІ • 62

  • @roayadiamond
    @roayadiamond 11 місяців тому +3

    I have watched so so so many videos but you are the only one who did it clearly and perfectly, THANKYOU

  • @66235021
    @66235021 Рік тому +2

    This is brilliant thank you! Been looking for a trick like this for ages.

  • @MohamedBenhimaPhD
    @MohamedBenhimaPhD  Рік тому +1

    📌 For assistance with data analysis, kindly contact me via this email: datanalysis93@gmail.com or WhatsApp: +212619398603 / wa.link/l6jvny /
    Facebook: facebook.com/benhima1/
    Instagram: instagram.com/medbenhima2...
    TikTok: www.tiktok.com/@mohamedbenhim...
    LinkedIn: www.linkedin.com/in/mohamed-b...
    Google Scholar: scholar.google.com/citations?...
    Twitter: twitter.com/Mohamed_Benhima
    WhatsApp: +212619398603 / wa.link/l6jvny
    E-mail: Datanalysis93@gmail.com
    UA-cam CHANNEL: ua-cam.com/channels/jlk.html...

  • @binge_magic8618
    @binge_magic8618 11 місяців тому +2

    This formula helped a lot thanks 👍👍👍👍👍👍👍👍!

  • @naaz1699
    @naaz1699 10 місяців тому +1

    So do i separately post this to spss ? Bcs once I post the whole questionnaire the original will be posted?

  • @user-hr6yi6ni9t
    @user-hr6yi6ni9t 4 місяці тому

    Thank you soooo much you save my life ❤❤❤

  • @kevincaratiquit9148
    @kevincaratiquit9148 Рік тому

    wow.. a life saver! ❤

  • @annamarifielpandaug4612
    @annamarifielpandaug4612 Рік тому

    THANK YOU SO MUCH. YOU SAVE ME MAN

  • @rajveersidhu4745
    @rajveersidhu4745 6 місяців тому +1

    Thank you so much. It is very precise and informative. Perfect videos

  • @asmitakhanna4371
    @asmitakhanna4371 Рік тому

    Thank you so much....I am happy after doing it ...a great vdo a great lesson n indeed a great mentor...thnx a lot .
    Lots of best wishes for u

  • @MapperJD
    @MapperJD 2 місяці тому +2

    Thank you so much this is great, can you make a video for how to analyse the 'other' responses?

  • @dr.sushilkumarph.d.8186
    @dr.sushilkumarph.d.8186 Рік тому

    Great Video............Thanks Mohd. Benhima

  • @___Denis___
    @___Denis___ Рік тому

    It worked, thank you Mohamed!

  • @chevrinetelcide2880
    @chevrinetelcide2880 5 місяців тому

    Many thanks🙏🏽

  • @hloniphalisa4632
    @hloniphalisa4632 Рік тому

    Very helpful thanks, but can use the qualitative data to python to code or it’s better to use it as quantitative data and make comments

  • @khanhdo6801
    @khanhdo6801 Рік тому

    Thank you so much🥰

  • @ainsahirah0011
    @ainsahirah0011 Рік тому

    may i know how to use it in spss

  • @dr.abdulghafoorkazi8501
    @dr.abdulghafoorkazi8501 8 місяців тому

    Thank you. 😊

  • @neetustana9968
    @neetustana9968 Рік тому

    thank you sir, very helpful video

  • @omobolaeko
    @omobolaeko Рік тому

    Thank you

  • @Max791-z7l
    @Max791-z7l 2 місяці тому

    To analyse google form or excel is easy?

  • @emjaypascal8024
    @emjaypascal8024 Рік тому +1

    it doesn't work for me..i use macbook

  • @fatimaouttaleb2980
    @fatimaouttaleb2980 3 місяці тому

    thank u

  • @Gharqcouture.
    @Gharqcouture. 11 місяців тому

    I don’t understand the function you used

  • @Lwagze
    @Lwagze Рік тому

    If the form responses are being shared on a regular basis, is there a way the data can be parsed without having to take the data separately every time to analyse?

    • @MohamedBenhimaPhD
      @MohamedBenhimaPhD  Рік тому

      Yes, there are several ways to parse form responses without having to manually collect the data every time. One way is to use a spreadsheet program such as Microsoft Excel or Google Sheets to automatically import the form responses and organize the data into a structured format. This can be done using a tool called "data import" or "data connection" that allows you to connect the spreadsheet to the form and automatically update the data as new responses come in. Another way is to use a data analysis software such as R or Python to automate the process of collecting and analyzing the data. These tools can be programmed to automatically pull the data from the form and perform the necessary calculations and analysis. Additionally, some form builders also have inbuilt data analysis feature which can be used to process the data.

  • @ImEli2215
    @ImEli2215 Рік тому

    So after this how do i send this into the SPSS for analysis?

  • @holamala8691
    @holamala8691 9 місяців тому

    What if the case is reverse? Make the codding data (0/1; yes/no) in to the list of some criteria? Is it possible? If yes, I want some of tutorial of this case please🙏🏻

  • @BK-zi1jv
    @BK-zi1jv Рік тому

    Hi! I try to apply the function you provided us, but after many attempts, it is still not working, all I receive is an Error response. Do you why this keeps happening? Is there another formula we can use instead?
    Thank you in advance for your answer! :)

    • @MohamedBenhimaPhD
      @MohamedBenhimaPhD  Рік тому

      It works properly

    • @BK-zi1jv
      @BK-zi1jv Рік тому +2

      @@MohamedBenhimaPhD
      Hello! I finally found what the issue was, in fact, I needed to use semicolons instead of commas:
      =IF(ISERR(SEARCH(K$1;$B2));"0";1)
      Now it works!
      I also found another way to do it:
      =IF(ISNUMBER(SEARCH(C$1;$B2)); "1";"0")
      Thank you for your video it really saves me a lot of time to code the multiple-choice questions. :)

  • @khawlasalma6488
    @khawlasalma6488 Рік тому +2

    After this step how can I apply it on spss?

    • @hebahussein9423
      @hebahussein9423 11 місяців тому +1

      You can first open the file on spss. Then copy those columns from the spss file to your original spss file

  • @mjk9152
    @mjk9152 Рік тому +1

    Can I use that in spss ?

  • @panosiliopoulos
    @panosiliopoulos 7 місяців тому

    I can't do it. It says that is not possible and maybe there is a syntax error. The phrase is correct and I can't understand what could I do to fix it.

    • @MohamedBenhimaPhD
      @MohamedBenhimaPhD  7 місяців тому

      There should be a way
      The cell number should be accurate

    • @panosiliopoulos
      @panosiliopoulos 7 місяців тому

      @@MohamedBenhimaPhD It is accurate. I don't know what's hapenning

  • @hstevanoski
    @hstevanoski 10 місяців тому +2

    ⚠ To anyone watching this: the shown formula in the video searches substrings, not exact matches!!! For example, "R" will be found in "Crab". That's probably not what you want! The function you need is EXACT, not SEARCH. So, use this formula instead (if it doesn't work with ; try using , instead): =IF(EXACT(B$1;$A2);1;0).
    Also, you can remove duplicate values in a column (Data -> Remove Duplicates) so that you don't filter unique values by hand and you can Paste -> Transpose the cleaned-up data so that you don't have to copy and paste one column header at a time, just like Mohamed does in the video. Great video otherwise, thanks!

  • @aadiicryptotv3002
    @aadiicryptotv3002 11 місяців тому +1

    How can we do it in SPSS?

  • @MizzDiuxXxa
    @MizzDiuxXxa Рік тому +1

    Why do I keep getting the ?NAME# error when its 0?

    • @khadijaaithaddou1579
      @khadijaaithaddou1579 Рік тому +1

      I found the same problem too😢.

    • @sounku7147
      @sounku7147 7 місяців тому +1

      Did u find the solution to that problem?

    • @ihssaneouikhelfen5997
      @ihssaneouikhelfen5997 18 днів тому

      Find(H$1;G2) ou trouve(H$1;G2)
      Les cases contenant des chiffres vous pouvez les remplacer par 1, et les valeurs contenant #VALEUR! Vous pouvez les remplacer par 0

  • @buayamuara6825
    @buayamuara6825 Рік тому +2

    how to make a diagram from this data

  • @youngrichniggabeats6645
    @youngrichniggabeats6645 4 місяці тому

    Hi brother I’ve question: after you’ve done this what next ? Do you delete the other one and keep the coding version for spss?