cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
Survey Analysis (Cross Tabulation)

Categorial platform provides myriad tools to tabulate and analyze multivariable categorical data, such as that which would come from surveys. Commonly referred to as cross-tabulation, these analysis methods can be used to compare responses across multiple factors and uncover relationships between categories. 

Categorical

Note: The results displayed in the analysis demonstrated will be easier to interpret if “Agree” instead of “Disagree” is the target level. Do this by changing the value order for each answer column. Select the columns: ‘I am working on my career’ , ‘I want to see the world’, ‘My home needs some major improvements’ , ‘I have vast interests outside of work’ , and ‘I want to get my debt under control’. Select Cols > Standardize Attributes. Under Standarize Properties, select Value Order. Change the value order so that “Agree” is listed last.

  1. From an open JMP® data table, select Analyze > Consumer > Research > Categorical.
    Note: There are many options on the types of of analyses and the format of the data that can performed with this platform. This guide illustrates just one of those – comparing binary outcomes (“Agree” or “Disagree”) across a multiple response survey from different types of responders.

  2. Select the Multiple tab. Select the set of variables representing the “Agree/Disagree” questions. Choose Indicator Group as the answers in this survey are binary.

  3. Select one or more variables defining the types of responders and place in the X, Grouping Category role. Click OK. A Cross-tabulation table and visualization is the default output.

 

  1. Select Test Multiple Responses > Count Test, Poisson under the top red triangle to test for equality across the type of responders.
    Note: This test is chosen since each responder can answer “Agreed” to more than one question.

 

  1. Select Compare Each Cell under the red triangle to perform all pairwise comparisons between the types of responders for each question.

Consumer Preferences.jmp (Help > Sample Data Folder)Consumer Preferences.jmp (Help > Sample Data Folder)

 

gail_massari_2-1754587950849.png

Intepretation:
The Total Responses is the total number of “Agreed” that occurred across all questions for each type of responders (‘Single Status’ and ‘School Age Children’). Total Cases is the number of responders of each type. Total Cases Responding is the number of responders who answered “Agreed” to at least one question. Each count in the cells is the number of responders who “Agreed” to each question. The first set of percents are the percentage of responders who answered “Agreed” to each question per Total Responses. The second set of percents are the percentage of responders who answered “Agreed” per Total Cases.

 

gail_massari_3-1754587987759.png

 

gail_massari_5-1754588036827.png

 

Visit Consumer Research > Categorical in JMP Help to learn more.

Recommended Articles