Server User Guides > Survey Tabulation > Table specification syntax > Special elements > Displaying median and percentile values
 
Displaying median and percentile values
This example is based on the Museum sample data set.
You can add a median as a row or column on a numeric variable. This shows the value above and below which 50% of cases fall.
visits{base(), median(visits)}
You can also add one or more percentiles. This is the value below which a certain percentage of the cases fall. To add a percentile you need to include a cut-off value to specify the percentage:
visits{base(), percentile(visits, 25)}
Note that the median is identical to a percentile with a cut-off value of 50.
Example
This example displays the base, lower quartile (cases that fall below the 25th percentile), median (cases that fall below the 50th percentile) and upper quartile (cases that fall below the 75th percentile) for the visits variable. As it uses two percentile elements, each has a unique name, percentile25 and percentile75:
visits{base(), percentile25 'Lower quartile' percentile(visits,25), median 'Median' median(visits), percentile75 'Upper quartile'
percentile(visits,75)}
Table showing median and percentiles
Here is a table that has this axis on the side:
This graphic is described in the surrounding text.
For information on how to display medians and percentiles as cell items rather than as rows or columns of a table, see Summary statistics of numeric variables.
See also
Special elements