SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only

  • 1.  Multiple Response

    Posted Tue April 08, 2025 09:20 AM

    Hello,

    Respondents were asked to provide their associations with the different types of meat they have consumed in the last 1 month (multiple) across the same list of associations (also multiple). How do I generate the following multiple response table using SPSS syntax?

      Chicken Beef Fish 
    Base: Consumed in the Last 1 month n=351 n=282 n=225
     Has a high nutritional value  297 223 204
     It has a great taste  257 192 165
     Its is affordable  140 155 118
    Is readily available  152 146 98


    ------------------------------
    Edward Ihaji
    ------------------------------


  • 2.  RE: Multiple Response

    Posted Tue April 08, 2025 09:22 AM
    crosstabs



    Original Message


  • 3.  RE: Multiple Response

    Posted Tue April 08, 2025 12:06 PM

    Cross tabs would assume single responses. In this case, I have multiple mentions on the rows and also multiple mentions on columns. See the questions below.

    Q1: Which different types of meat products have you consumed in the last 1 month? Tick all that apply

    1. Chicken
    2. Beef
    3. Fish

    Q2: For each of the meat you have consumed in the last 1 month (in Q1), which of the following statements apply? Tick all that apply

    1. Has a high nutritional value 
    2. It has a great taste 
    3. Its is affordable 
    4. Is readily available 

    I hope this provides more clarity of the issue I have



    ------------------------------
    Edward Ihaji
    ------------------------------

    Original Message


  • 4.  RE: Multiple Response

    Posted Tue April 08, 2025 12:13 PM
    How is the data structured?  You might have 12 dichotomous variables or fewer with multiple records per respondent. 

    Depending on the structure, create a multiple response set for meat and another for statement.  Use Analze > Tables > Multiple Response Sets

    Then tabulate these using Anayze > Tables > Custom Tables




    --



    Original Message


  • 5.  RE: Multiple Response

    Posted Tue April 08, 2025 12:35 PM
    Edited by Edward Ihaji Tue April 08, 2025 12:39 PM

    Thanks Jon,

    The data structure is 1 record per respondent, with Q1 having 3 dichotomous variables (Q1.1 to Q1.3) and Q2, having 12 dichotomous variables (Q2.1.1 to q2.1.4, Q2.2.1 to Q2.2.4, Q2.3.1 to Q2.3.4). The focus should be in Q2 variables since they are routed from Q1.

    Will the custom table solution work with this structure or I need to restructure the data to have multiple records per respondent?



    ------------------------------
    Edward Ihaji
    ------------------------------

    Original Message


Related Content