The calculation properties window allows you to define the details of a specific calculation type that is used in your analyses. To reach the calculation properties window, right-click a calculation in the general tab of chart/table definition, and select properties.
The following properties are available:
| OPTION | DESCRIPTION |
|---|---|
|
Caption |
Determines the caption that will be displayed to describe the calculation. |
|
Calculation type |
Allows you to change the underlying calculation type. A drop-down menu of all available calculation types will be shown for you to select from. |
|
Sub-population |
Sets the sub-population to be used by the calculation. Note that you can drag and drop questions from the left-hand pane into this box, in order to create a temporary sub-population. |
|
Universe |
Sets the sub-population to be used by the calculation. Note that you can drag and drop questions from the left-hand pane into this box, in order to create a temporary universe. |
|
Weighting |
Sets the weighting variable to be used by the calculation. |
|
Level |
Sets the level to be used by the calculation. |
|
Visibility |
Determines if the calculation will be displayed all of the time, only when it is weighted, or only when it is unweighted. |
|
Display calculation at the intersection of rows and columns |
If selected, the calculation appears at the intersection of rows and columns. This option is available only for crosstab calculations. |
|
Display calculation in rows |
If selected, the calculation appears in table rows. This option is available only for crosstab calculations. |
|
Display a calculation with the questions |
If selected, the calculation appears on any total rows with questions displayed in the row (as set in the total and caption tab of the table settings dialog). This option is available only for crosstab calculations. If this is the only item selected, the calculation will appear only in the question total row. This can be used, for example, to show Base and Effective Base adjacently, to help judge the effects of weighting. |
| Display calculation in columns | If selected, the calculation appears in table columns. This option is available only for crosstab calculations. |
| The calculations of the total are defined by the crosstab |
If this option is cleared (de-selected), non-contextual totals will be used (i.e. the total will not necessarily correspond to the sum of counts present in the intersection of the cells). The total in row and total in column tabs will be accessible. You can then choose the calculation type, and the custom settings. This option is available only for crosstab calculations. |
| Run the totals in the sub-level |
This option determines the analysis level to be used when a table where a level includes questions from a loop which are crossed-tabulated with questions outside a loop, or questions from different levels within two or more nested loops. When selected, totals will be accumulated by counting only those cases which logically intersect at the lowest level. If left clear, the totals will be accumulated at the highest level, and will include answers from other sub-levels for each respondent that fall into the same intersection. For example, if a survey has two levels, namely household and within that a sub-level of individuals, selecting this option will ensure that the totals reflect the answers for individuals. Using the same example, if the option is not selected, then the intersection will include additional responses from other members of the same household who meet the same selection criteria. |
| Make the question total an "All selected responses" |
This option changes how the question total is calculated. By default, the total is calculated by considering all the response options, including those not shown, after excluding any designated NA or DK/NR responses. If this option is selected, then only options selected for display in the Rows/Columns/Edge tab will be included in the calculated total, provided that the Universe is set to |
| Hide this calculation (but leave it available for arithmetic or conditional formatting) |
If selected, this option causes the calculation to be hidden in charts and tables. However, it can still be used as the basis of further calculations (using calculation arithmetic), or in conditional formatting. It is useful when you want calculation arithmetic to carry out calculations, but where you want the intermediate calculations to be displayed. To set up a calculation based on another calculation, select a calculation type of calculation arithmetic (number) or calculation arithmetic (string). |
| Ranking | Allows you to set ranking options. The Ranking options dialog appears. |
| Advanced options... |
Allows you to set advanced options (only available for certain calculation types). The Advanced calculations options dialog appears. Note: advanced options are available only for significance, percentile and script calculations.
|
| Number formatting... | Allows you to control how the numbers in the calculation result will be displayed. The Number formatting dialog appears. |
| Script | Allows you to set a script on the calculation. The Script on calculation dialog appears. Note: this command is available only for certain calculation types (e.g. those that indicate "script" in their name). |
See also the specific calculation options for: