I think the way you could deal with this difficulty is to introduce two
items for "Yes". Thus it could be : I=Yes spontaneous, 2=Yes cited 3=No
4=DK. For each radio, if it is cited by the respondent by himself one will
choose 1. A fter that, if the investiguator asks if s/he knows a given
radio that has not been cited previously, it will 2.
···
Le jeudi 1 décembre 2016 05:57:22 UTC, Rod a écrit :
>
> Dear all,
>
> Please help....I have four below questions and I want help on how I can do
> choice filters in excel.
>
> *A1. First, please tell me the name of any radio stations that you have
> heard of? *
>
> DO NOT READ OUT THE NAMES OF RADIO STATIONS IN THE GRID. CODE TO
> APPROPRIATE CATEGORY.
>
>
>
> Radio 1
>
> Radio 2
>
> God radio
>
> youth radio
>
> old radio
>
> other radio
>
>
>
> 1=Yes
>
> 2=No
>
> 3=DK
>
>
>
> *A2. Have you ever heard of [radio stations not mentioned by the
> respondent at A1]? *
>
> Populate radio stations that were not mentioned at A1
>
>
> 1=Yes
>
> 2=No
>
> 3=DK
>
>
>
> *A3. And have you ever listened to [radio stations mentioned at A1 OR A2]?*
>
> Pupulate radio stations mentioned at A1 & A2
>
>
>
>
> 1=Yes
>
> 2=No
> 3=DK *E11. Apart from today, when was the last time you listened to
> [radio stations mentioned at A3=Yes]?*
>
>
> 1=yesterday
>
> 2=last 7 das
>
> 3=last 4 weeks
>
> 8=DK
>