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

Glad it helped!

Glad it helped!

Glad it was helpful!

Most weclome

Thanks for the encouragement, too

Most welcome!

Most welcome

LIFESAVER !!1

Thank you! How would you display other options as Mohammed did not show that

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

Yes, as you suggested

There should be a way The cell number should be accurate

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

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.

I found the same problem too😢.

Did u find the solution to that problem?

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

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5AbOHjQRNwY.html

@@MohamedBenhimaPhD Thanks Alot

It works properly

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

Am using office 36 and hp the formula is not working for me any assistance.

Yes, but after you do it in excel

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5AbOHjQRNwY.html

You can make a bar graph using excel