Analyses of mean values

Tables, charts and Maps of mean values can be built. Maps can only be used to display a single row or column of data.

The example describes how to display a table using the data in the Crocodile Rock Cafe survey showing the average amount spent (Q5) broken down by frequency of visit (Q2) and gender of the respondent (Q12).

  1. Click AnalysisTblIcon.png to open the Analysis Definition dialog to build a table.
  2. Specify the Analysis variable for the table or chart as Q2 (frequency of visit).
  3. Specify the Break variable for the table or chart as Q12 (gender).
  4. Set Calculate to either Means & Differences or Means & Significances. Only the means are required for this table; differences or significances will not be shown, as only the Means option is ticked.
  5. Specify the Calculate variable as Q5 (amount spent).
Analysis Definition showing mean values
  1. Click OK to build the table.
Table showing frequency of visit by gender showing mean amount spent

Each cell in the table shows the average amount spent. For example, the average amount spent by males who visit the restaurant daily is 15.17.

To convert this table to a chart format

  1. Click on VariablePropsIcon.png in the table window.
  2. Change the form from Table to Chart.
  3. Click Browse by the Style field, and select the style Bar Counts from the drop-down list.
  4. Click OK to build the chart.
Chart showing frequency of visit by gender showing mean amount spent
Contents