Table appearance
You can control the appearance of an analysis table by changing fonts, colours, grids, highlights and sizing. You can save your style for later use. You make the changes from the table style menu: Edit Styles, Separators, Sizing, Options, Load Style and Save Style. There are two ways to open the menu from the Table […]
Statistical significance in tables (z-test)
The z-test is used to compare two percentage scores to see if the difference between them is statistically significant. This means: Is the difference in percentage scores in the table purely a result of the sample used, or does it indicate a real difference in percentages in the target population? For each row in a […]
Creating a table using a scoring system
The example shows how to apply a score to calculate the mean value of a service. It is applied to a single rating question (with a Single Response) in a cross-tabulation. The different ratings are labelled as Very good (scored as +2) down to Very poor (scored as -2). This example assumes that you have […]
Confidence intervals in tables
You can display confidence statistics in tables. These show how confident you can be that a specified proportion of the population lie within a calculated range. The confidence intervals are available in the Summary Statistics tab of the Analysis Tailoring dialog. Confidence intervals on percentage values The most common use of confidence intervals is when […]
Creating a satisfaction scale (or other ratings scale)
You can use the Confidence Top box and Confidence Bottom box statistics to group the responses at the top and bottom ends of the scales. For example, to show how many people were satisfied or dissatisfied with a particular service, or who used it in the first or last five months of a year. The […]
Displaying statistics in a cross-tabulation or frequency table
You can add a subset of the descriptive statistics to give more details about the statistical analysis of the figures in a table. These allow you to: identify a typical value (the mean, median or mode) display how much the figures are likely to vary depending on the sample (standard deviation, standard error, variance, confidence) […]
Creating a descriptive statistics table
Descriptive Statistics tables are most meaningful when used on questions with a quantity response. Click to display the Analysis Definition dialog box. Type the required variables names for the statistics in the Analysis field, separated by commas. For example Q11, Q12. Select Statistics table from the dropdown list in the Break field (or type STATS […]
Creating a holecount table
Holecount Tables are a way of viewing the counts of the variables, as the code labels are shown as generic values of Code 1, Code 2 etc. They are a useful and quick method of checking the accuracy of data entry and a simple way of highlighting areas with possible errors prior to full analysis […]
Creating a grid table
Many questionnaires contain groups of questions with an identical range of possible answers. These are generally attitude questions and the replies are typically “Very good” to “Very poor”, or “Strongly agree” to “Strongly disagree”. Such groups are called Grids. Each question is set up as a separate variable, but at the analysis stage, they are […]
Creating a cross-tabulation
An analysis table can be created to analyse one question against a number of other questions, producing cross-tabulations. Tabulations of up to five million cells are possible, with a maximum of either 2,000 rows or 2,000 columns. Each table can be made up of a number of variables, and, using commands such as WITH and PER, […]