Row Options

 

You can specify statistics and other settings for rows using Row Options in Setup|Tables.

 

Note: Use care when selecting multiple rows for editing row options. The row options displayed will apply to all rows selected.

 

Frequency

Displays the number of cases for each cell.

 

Vertical percent

Displays the percent of a cell based to the banner column total.

 

Horizontal percent

Displays the percent of a cell based to the row total.

 

Constant percent

Displays the percent of a cell based to a constant (either a specified constant value or the intersection of a specified banner column and row (Total, Total Answering or Sigma). Specify the Constant value or Banner column and Row (Total, Total Answering or Sigma) intersection using Setup|Banners|Edit Banner|Horizontal /Constant Percents.

 

Sample size for statistic base

Shows the total number of respondents included in the specified calculations.

 

Mean

Reports the sum of all values within a row divided by the number of values. There are several situations where you would want a row mean:

Mean confidence interval - lower

Displays the lower mean confidence interval based on the selected confidence interval level specified using the Select Level option. The confidence interval level specified is used for calculating both the lower and upper mean confidence interval.

 

Mean confidence interval - upper

Displays the upper mean confidence interval based on the selected confidence interval level specified using the Select Level option. The confidence interval level specified is used for calculating both the lower and upper mean confidence interval.

 

Standard deviation

Reports the set of values' variance from the mean.

 

Standard error

Reports the standard error of means. It is calculated by dividing the standard deviation by the square root of the sample size.

 

Median

Reports the middle value of all values. The row median does interpolate if the value falls at exactly 50%.

 

Minimum

Reports the minimum value.

 

Maximum

Reports the maximum value.

 

1st Quartile

Reports the value where 25% of the values fall below that value and 75% of the values fall above it.

 

3rd Quartile

Reports the value where 25% of the values fall above that value and 75% of the values fall below it.

 

Mode

Reports the value that occurs most often.

 

Effective sample size for statistic base

Creates a row on your table displaying the effective sample size used when calculating T-scores for significance testing on means.

 

Mean number of mentions

Reports the total number of responses divided by the total number of respondents for the row.

 

Volumetric

Note: The Volumetric row option cannot be selected with other statistical cell row options.

 

Percentiles

Frequency decimal places

Percent decimal places

Statistic decimal places

Variability decimal places

Show row

Forces a row to print if it would normally be suppressed because Hide blank rows is selected in Table Options in Setup|Tables. For example, you might want to print row text you created to use as a descriptive title, but it has no logic and would be ‘blank,’ and otherwise suppressed.

 

Hide row

Row will not display/print on your report. For example, you might have a row that is necessary for a calculation in a table, but you don't want that row to print.

 

Hide row if blank

Suppress rows without data. For example, you might have a ‘DON'T KNOW’ row that you want to suppress if it is blank.

 

Skip a line after this row

Displays/prints a blank line after the row.

 

Append next row to this row

Will not display/print a blank line after the row. You might use this feature to print an extra line of text for the row above (you would leave the row logic blank). An appended row ‘moves with’ the row it is appended to when that row is ranked.

 

Display this row on a new page

Displays this row on a new page. For example, you might want the first row of a net to print at the top of a new page.

 

Embed the row title (margin release)

If weighted, show this row unweighted

Displays the row unweighted when weighting is being applied to the tables.

 

Do not apply filter to this row

Show dollar sign ($)

Displays dollar signs on rows with dollar values.

 

If ranking, force row to rank

Threshold

Specifies an ‘other’ row, which represents all rows that are less than the minimum percent or frequency that you specify. When you create an ‘other’ row using the Threshold feature, you can you control the row placement and text for the ‘other’ row.

Note: If the Apply across NETs and Subs checkbox is not enabled, the Threshold row option only works on rows that are not included in any net or sub.

 

Underline

You can underline row text with any of five characters.

Frequency

 

Close

Use Close to exit the Row Options dialog. Changes are not saved until you select either Apply Changes to Selected Rows or Apply Changes to All Rows.

 

Cancel

Use Cancel to exit the Row Options dialog without saving changes.

Related topics:

About Row Statistics

Setup|Tables