2
First, Arrange the data in ascending order
a) for an odd number of observations, the median is the middle value
b) for an even number of observations, the median is the average of the two middle values
Example a): Use the example of 5 executives: 46, 54, 42, 46, and 32.
Arrange in ascending order: 32, 42, 46, 46, 54
n = 5 (odd), then:
Median = 46
Example b): Assume a new executive is added to the sample. 46, 54, 42, 46, 32, and 16.
Arrange in ascending order: 16, 32, 42, 46, 46, 54
n = 6 (even), then:
Median = (42+46)/2 = 44.
In Excel: Median =MEDIAN(RANGE)=44
Percentiles
The median is the 50th percentile, the value that falls in the middle when we sort the observations of a
numerical variable.