Defining cell contents
The cell contents that have been defined for a table are listed at the top of the Preferences tab. They are listed in the order in which they will appear in the cells of the table. To add, reorder, or delete the cell contents that are defined for the table, click the
Modify button that is just above the list of cell contents. This opens the Modify Cells dialog box: see
Modify Cell Items dialog box.
Options
For each cell content type, you can select one or more of the following options, depending on the type:
Decimal places
Available for all types of cell contents. Specify the number of decimal places with which you want the values to be shown.
Based on
For the summary statistics of a numeric variable, this enables you to choose the numeric variable to use. For indices, residuals, expected values, and any of the percentage options, you can choose to base the figures on counts or on the sums of a numeric variable if they have been specified for this table. The default is counts. If the table is weighted, these are the weighted counts. If you want to base the figures on the unweighted counts, you must remove the weighting from the table.
Additional
Available for percentiles only, this enables you to choose the required percentile; for example, enter 25 for the 25th percentile.
Prefix
You can add text, for example, a currency symbol, before the cell contents. Type the text in the Prefix text box.
Suffix
You can add text after the contents of a cell. For example, you could include a brief description of the cell contents. Type the text in the Suffix text box.
Preferences tab: Menu commands
Copy
Copies all of the settings on the Preferences tab to the UNICOM Intelligence Reporter - Survey Tabulation clipboard. This means that you can copy the settings to another table.
Paste
Overwrites all of the options on the Preferences tab with the contents of the UNICOM Intelligence Reporter - Survey Tabulation clipboard.
Set as default
Select this option if you want to define these preferences for several tables. Any new tables that you create will automatically have the same types of cell content and all of the other options defined on the Preferences tab for this table.
Apply to all tables
Select this option if you want to apply these preferences to all of your tables.
See
See also