Multiple Response Analysis in Excel and SPSS

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

thats an awesome presentation. thank you

atomscientist
Автор

Can you send me that function you have used

GLOBALTVKG
Автор

YOUR CODE ISNT WORKING IT ?? NAME ERROR

AchrafMakhloufi
Автор

Everything appears as 0 for me
is there something i did wrong?

francisoti-mensah
Автор

The code is only filling the top box, please help

JoJo-sdwi
welcome to shbcf.ru