The median function calculates the middle value of the data. Half the observations are less than or equal to the median. Half the observations are greater than or equal to the median.
If the data set contains an odd number of values, then the median is the middle value in the ordered data set. If the data set contains an even number of values, the median is the average of the two middle values. For example, for the set of numbers 1, 2, 3, 21, 35, 42, the median is the average of the two middle values (3 and 21), which is 12.
For number, specify a column of numbers.
|C1 contains 6, 3, 15
Use the median function to describe an entire set of observations with a single value that represents the center of the data.
Compared to the mean, the median is less sensitive to extreme data values. Thus, the median is often a more informative measure of the center of skewed data. For example, the mean may not be a good statistic for describing salaries within a company. The relatively high salaries of a few top earners inflate the overall average, giving a false idea of salaries at the company. In this case, the median is more informative. The median is equivalent to the 2nd quartile or the 50th percentile.