How to analyze select all the apply, check multiple options or select many options using Excel and SPSS
Create multiple columns, each corresponding to each option;
Copy and paste the excel formulae to code them in binary coding as 0 and 1
Import data to SPSS and run frequency, percentage and cross-tabulation in addition to the other tests like regression and correlation.
Google Forms, Microsoft Forms and Qualtrics
-------------------------------------------------------------
Excel formulae for multiple selection question: =IF(ISERR(SEARCH(B$1,$A4)),"0",1)
--------------------------------------------------------------
Mohamed Benhima, PhD
WhatsApp: +212619398603 / wa.link/l6jvny ‎
Mohammed V University, Rabat, Morocco ( [email protected] )‎