Job Settings|Statistics Rows

In Setup|Job Settings, you can specify percentiles and the order of statistics rows using the Statistics Rows tab.

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

Changing values for statistics

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

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

Related topics:

Job Settings

Profile Settings