Options tab (Edit Banner)

Select Setup|Banners|Edit Banner and choose the Options tab to specify Statistics and/or Display Options for selected columns.

For information about mean summaries and for summary statistics when values are ranges, see Row Options.

Select the column(s) from the Columns list box or choose Select All to select all of the columns at one time.

Select the Statistics you want displayed for the selected column(s):

Mean - report the sum of all values of a column divided by its number of values.
Standard deviation - report the standard deviation from the mean.
Standard error - report the variance from the mean.
Statistics base - show the total number of respondents included in the specified calculations.
Median - report the middle value of all values; half the values of the variable fall below the median and half fall above.

Select the Display Options for the selected column(s):

Show sigma - report the sum of all the columns in a banner.
Hide column - prevent the column from displaying/printing on your report.
New page before column - allows you to specify a page break for banners that, when printing, will span multiple pages.
Background column color - allows you to assign a background color to a selected banner column(s).
Select the color box to open the Set Background Column Color dialog.
Choose Clear to clear the background color assigned to a selected banner column(s).
Hide frequency - do not display the frequency.
Hide vertical percent - do not display the vertical percent.
Hide horizontal percent - do not display the horizontal percent.
Hide constant percent - do not display the constant percent.
Hide percent sign - do not display the percent sign.
CALC Options - allows for showing/supressing statistics when using CALC as logic for the specific column.

CHMN - Hide mean
CHSD - Hide Standard Deviation
CHSE - Hide Standard Error
CH2Q - Hide Median
CHMI - Hide Minimum
CHMX - Hide Maximumn
CH1Q - Hide 1ST Quartile
CH3Q - Hide 3RD Quartile
CHMD - Hide Mode
CHSB - Hide Statistic Base
CHEF - Hide Effective Sample Size
CHML - Hide Mean Confidence Lower
CHMU - Hide Mean Confidence Upper
CHMM - Hide Mean Mentions
CHMP - Hide Percentiles

IMPORTANT: When statistical testing is specified for banner columns that are hidden - hidden banner columns will be removed from any comparison group assignments. A comparison group will be deleted if the result of hidden banner columns results in less than 2 banner columns in a comparison group.

If default significance indicators (i.e. capital letters (A, B, C, D, E, etc.)) are used for comparison groups and a banner column is hidden, the significance indicators will be adjusted to maintain the alphabetic increment and order of the remaining banner columns. The significance indicator adjustments will be reflected on both the table and footnote.

If the significance indicators are changed in any way from the defaults (e.g small letters (a, b, c...), numbers (1,2,3...), 2 or 3 character indicators (P1, MAL, phx...), etc.) the remaining banner columns will maintain the significance indicator that was assigned to that banner column on both the table and the footnote.

IMPORTANT: Background column color for banner columns overrides colors selected for comparison group columns using the Background Colors options of Setup|Job Settings|Enhanced Text Reports or Run|Tables|Excel Options.

Select the Decimal placed for the selected column(s):

Frequency: - override job settings and choose beetwen 0, 1, 2, or 3 decimal places for the column Frequency.

F0 = 0 decimal places shown.
F1 = 1 decimal place shown.
F2 = 2 decimal places shown.
F3 = 3 decimal places shown.

Percent: - override job settings and choose beetwen 0, 1, 2, or 3 decimal places for the column Percent.

P0 = 0 decimal places shown.
P1 = 1 decimal place shown.
P2 = 2 decimal places shown.
P3 = 3 decimal places shown.

Statistic: - override job settings and choose beetwen 0, 1, 2, or 3 decimal places for the column Statistic.

S0 = 0 decimal places shown.
S1 = 1 decimal place shown.
S2 = 2 decimal places shown.
S3 = 3 decimal places shown.

Variability: - override job settings and choose beetwen 0, 1, 2, or 3 decimal places for the column Variability.

V0 = 0 decimal places shown.
V1 = 1 decimal place shown.
V2 = 2 decimal places shown.
V3 = 3 decimal places shown.

Apply to Selected Columns applies the options specified to the appropriate columns.