0 votes
in Datenauswertung by s086953 (120 points)

I am looking for a function for a true false query. I already have the data but can't download it yet and do it in excel since I still have the survey online (Prolific). I need this for the attention checks. The program should automatically mark the cell with a value >2 in the Attention Checks (for example, blue) or mark the subjects who answered two Attention Checks incorrectly (for example, completely black).

1 Answer

0 votes
by SoSci Survey (289k points)

A-priori to data collection, you can create an internal variable in SoSci Survey and use a simple PHP filter on a page following the attention check to store the code:

if (value('AB01_01') > 2) {
  put('IV01_01', 1);
} else {
  put('IV01_01', 0);

If you already started data collection, you will need a little IF in excel.

=IF(A1 > 2; 1; 0)

Willkommen im Online-Support von SoSci Survey.

Hier bekommen Sie schnelle und fundierte Antworten von anderen Projektleitern und direkt von SoSci Survey.

→ Eine Frage stellen

Welcome to the SoSci Survey online support.

Simply ask a question to quickly get answers from other professionals, and directly from SoSci Survey.

→ Ask a Question