Tables and charts showing means and differences

Tables and charts of means and differences can be built. For example, in the Crocodile Rock Cafe survey it might be required to see how much is spent by men and women of different age groups in comparison with each other. This can be either comparing men and women of the same age group or comparing all men in the different age groups and separately all women in the different age groups. This is the same table we showed in the example of means and significances but this time rather than seeing if there is a significant difference, we are calculating what the difference in the means is.

The only response types that can be used in means and differences tables/charts are Single Response and Quantity Response.

  1. Click AnalysisTblIcon.png to open the Analysis Definition window to build a table.
  2. Specify the Analysis variable for the table or chart as Q11 (age categories).
  3. Specify the Break variable for the table or chart as Q12 (gender).
  4. Select Means & Differences as the Calculate option.
  5. Specify the Calculate variable as Q5 (amount spent).
  6. The Show options on the Analysis Definition change to difference options.
    • Choose Analysis Difference if you want to see a comparison of the means and difference of men and women of each age group.
    • Choose Break Difference if you want to see a comparison of the means and difference of men in each age category and a separate comparison of the means and difference of women in each of the age groups.
    • Choose Base Difference if you want to see a comparison of the means of each cell with the base mean.
Analysis Definition showing mean values
  1. Click OK to build the table.
Table showing the amount spent by age and gender

This example displays Break Difference so you can see the mean amount spent by men of each age category compared with the overall mean of amount spent for men. We can also see the mean amount spent by women of each age category compared with the overall mean of amount spent for women.

Converting to a chart

The difference values can usefully be displayed in the form of a 2D bar chart:

  1. Click VariablePropsIcon.png to re-define the table and change the form to have the Bar Counts style.
  2. Uncheck the Means box and click OK to build the chart.
Chart showing the amount spent by age and gender
Updated
Contents

Cookie settings

You can decide which cookies you wish to allow and can change your settings at any time. You cannot prevent our use of strictly necessary cookies. For more information about the cookies we use, please see our cookie policy.

With the slider, you can enable or disable different types of cookies:

This website will:

  • Remember which cookies group you accepted
  • Strictly necessary: remember your cookie permission setting
  • Strictly necessary: allow session cookies
  • Strictly necessary: authenticate that you are logged into your user account

This website won't:

  • Functionality: remember your online chat ID
  • Analytics: keep track of your visited pages and interaction taken
  • Analytics: keep track of your location and region based on your partial IP number
  • Analytics: keep track of the time spent on each page and the videos you watch
  • Analytics: identify the device you are using
  • Targeting: identify if you contacted or called us as a result of one of our adverts

This website will:

  • Remember which cookies group you accepted
  • Strictly necessary: remember your cookie permission setting
  • Strictly necessary: allow session cookies
  • Strictly necessary: authenticate that you are logged into your user account
  • Functionality: remember your online chat ID

This website won't:

  • Analytics: keep track of your visited pages and interaction taken
  • Analytics: keep track of your location and region based on your partial IP number
  • Analytics: keep track of the time spent on each page and the videos you watch
  • Analytics: identify the device you are using
  • Targeting: identify if you contacted or called us as a result of one of our adverts

This website will:

  • Remember which cookies group you accepted
  • Strictly necessary: remember your cookie permission setting
  • Strictly necessary: allow session cookies
  • Strictly necessary: authenticate that you are logged into your user account
  • Functionality: remember your online chat ID
  • Analytics: keep track of your visited pages and interaction taken
  • Analytics: keep track of your location and region based on your partial IP number
  • Analytics: keep track of the time spent on each page and the videos you watch
  • Analytics: identify the device you are using

This website won't:

  • Targeting: identify if you contacted or called us as a result of one of our adverts

This website will:

  • Remember which cookies group you accepted
  • Strictly necessary: remember your cookie permission setting
  • Strictly necessary: allow session cookies
  • Strictly necessary: authenticate that you are logged into your user account
  • Functionality: remember your online chat ID
  • Analytics: keep track of your visited pages and interaction taken
  • Analytics: keep track of your location and region based on your partial IP number
  • Analytics: keep track of the time spent on each page and the videos you watch
  • Analytics: identify the device you are using
  • Targeting: identify if you contacted or called us as a result of one of our adverts

This website won't:

Save & Close