Profile Settings|Statistics Rows

Note: Changes made to Profile Settings only apply to "new" jobs created using the modified profile and will have no effect on "existing" job files. Use Setup|Job Settings or Setup|Globally Modify Tables to make changes to existing job files.

In Setup|Profile Settings, you can specify statistics row settings for your tables using the Statistics Rows tab.

Statistics row display - Choose which of the statistics rows will be displayed:

Sample size for statistic base - displays the base for statistics, which is the total sample minus any 'no answers' and any rows specifically excluded from the statistics base.
Mean - specifies the values to use in calculating any descriptive statistics: the mean, standard deviation and standard error. The mean is the sum of the values divided by the number of values, so the values in all rows are used in calculating these statistics for tables. When row values are defined with ranges, you must use a row mean. You specify a row mean using Row Options.
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 - measures the variance for a set of values from the mean.
Standard error - measures the standard deviation 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; half the values of the variable fall below the median and half fall above. For tables with ranges of values, use a Grouped median.

Changing values for statistics

Grouped median - when row values are defined with ranges, you can specify a grouped median. If the values are not in a range and you want to do a group median, you can edit the row logic and use the @ symbol to change a single value to a range.

The @ symbol is used only for grouped medians. The grouped median is used on tables that have a range of values represented by a single value.

The regular median is used on tables where the median can be calculated on the actual values. The regular median might be used, for example, on a table that represents a questions in which a respondent was asked to state his or her age in years. The @ is not used for the regular median. When a regular median is calculated, it uses the value in parentheses (or the # symbol, described above, can be used to specify a different value for the calculation).

The grouped median is used on tables, for example, where a respondent is asked the range in which his or her age falls. Another example of a question type that would call for a grouped median in a tables is income, where respondents are asked to indicate an income range rather than a precise dollar value.

To calculate the grouped median, you need to specify mutually exclusive ranges using the @ symbol. For example, for the following five age categories, you could use ranges in place of the original category values (1-5):

UNDER 25	AGE (1) @15-24.9
25-34 AGE	AGE (2) @25-34.9
35-44 AGE	AGE (3) @35-44.9
45-54 AGE	AGE (4) @45-54.9
55-64 AGE	AGE (5) @55-64.9

For example, UNDER 25 would use the range 15-24.9 rather than the original value of 1; 25-34 would use the range 25-34.9 rather than the original value of 2 and so on.

To calculate both the grouped median and use a different value for the mean (described above), you could specify:

UNDER 25	AGE (1) #17.5 @15-24.9
25-34 AGE	AGE (2) #29.5 @25-34.9
35-44 AGE	AGE (3) #39.5 @35-44.9
45-54 AGE	AGE (4) #49.5 @45-54.9
55-64 AGE	AGE (5) #59.5 @55-64.9

1st Quartile - represents a value where 25% of the values fall below and 75% fall above it.
3rd Quartile - represents a value where 25% of the values fall above and 75% fall below it.
Mode - reports the value that occurs most often.
Minimum - shows the minimum value.
Maximum - shows the maximum value.
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.

Percentiles - Select the percentiles (from 0 to 99) you would like to show on your table. Percentiles show the value where the selected percentage of the values fall below and the remainder fall above. For example, if you select the 10th Percentile, this row will display the values for each banner point where 10% of the values in the table fall below and 90% fall above.

Statistics row order

You can arrange statistics rows in the desired order by selecting a row, then using the up and down arrows to arrange the position for that row.