Survey Tabulation > Cell contents
 
Cell contents
When you build a table, generally the main information that you are trying to convey is the figures in the cells. The figures in the cells are called the cell contents. These are the different types of cell contents:
Counts and unweighted counts
These show the number of cases that satisfy the row and column conditions for each cell. If the table is weighted, the counts are the weighted counts.
In a weighted table, these are the unweighted counts. In an unweighted table, the counts and the unweighted counts are identical.
See Counts and unweighted counts.
Percentages
These express the count or sum of a numeric variable as a percentage of the base for the column, row, or table. Expressing figures as percentages can make it easier to interpret and compare the data in a table. You can optionally choose to express row and column percentages as cumulative percentages.
See Percentages.
Indices
These are calculated for each cell by dividing the row percentage in the cell by the row percentage for the same column in the base row. Indices show how closely row percentages in a row reflect the row percentages in the base row. The nearer a row's indices are to 100%, the more closely that row mirrors the base row.
See Indices.
Summary statistics of a numeric variable
You can show a summary statistic of a numeric variable for the cases in each cell. For example, in a table of age by gender, you can use the visits numeric variable to show the sum of the number of previous visits made to the museum by the respondents in each cell. Alternatively you can show the mean number of previous visits made by the respondents in each cell. Other options include the minimum value, maximum value, range, mode, median, percentile, standard deviation, standard error, and variance.
See Summary statistics of numeric variables.
Expected values
These show the count or sum of a numeric variable that would be expected in the cell if the row and column variables are statistically independent or unrelated to each other.
See Expected values and residuals.
Residuals
These show the difference between the count or sum of a numeric variable and the expected values. Large absolute values for the residuals indicate that the observed values are very different from the predicted values.
See Expected values and residuals.
You can specify the number of decimal places with which you want the cell contents to be shown: see Rounding values.
See also
Weighting
Statistical formulae
Sorting rows and columns
Suppressing rows and columns
Defining cell contents
General "How to" information