Excel Functions Tutorials
- Statistical Function in Excel
- AVERAGE Excel Function
- Average Formula in Excel
- AverageIF in Excel
- AVERAGEIFS Function in Excel
- CORREL Excel Function
- Correlation Matrix in Excel
- Correlation vs Covariance
- COUNT Excel Function
- Count Formula in Excel
- COUNTA Excel Function
- COUNTIF Excel Function
- COUNTIF Formula in Excel
- COUNTIFS Function in Excel
- COUNTIF with Multiple Criteria
- COUNTIF Examples
- FORECAST Excel Function
- Forecast Formula in Excel
- FREQUENCY Excel Function
- Frequency Formula in Excel
- GROWTH Excel Function
- Growth Formula in Excel
- LARGE Excel Function
- LINEST Excel Function
- Linear Regression in Excel
- Lognormal Distribution in Excel
- MAX Excel Function
- Max Excel Formula
- Mean vs Median
- MEDIAN Excel Function
- MEDIAN Formula in Excel
- MIN in Excel
- MODE Excel Function
- NORM.S.INV Function in Excel
- NORMDIST in Excel
- PERCENTILE Excel Function
- Percentile Formula in Excel
- Percentile Rank Formula
- Poisson Distribution in Excel
- P-Value in Excel
- QUARTILE Excel Function
- RANK Function in Excel
- SLOPE Function in Excel
- SMALL Function in Excel
- Standard Deviation in Excel
- Standard Deviation Formula in Excel
- TREND Function in Excel
- T-TEST in Excel
- Chi Square Test in Excel
- Variance vs Standard Deviation
- Weibull Distribution in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
Related Courses
Difference Between Mean vs Median
Mean and Median is a measure of central tendency and are often used in the measurement of large data sets where analysis needs to be drawn and results are interpreted. Mean, median and mode are three measures of averages which show the disperse the data is from the mean or the average. Mean vs Median methods are used in statistics widely, whereas the mean value of the data is the most widely used method among the three.
What is Mean?
Mean is a simple sum of the numbers of observations in an array which is divided by the numbers of observations. For example, if we talk about the average height or the mean height of a group consisting of 5 people. The mean height would be calculated by summing the height of 5 people divided by the number of people i.e. 5.
Mean Formula
Mean Formula = (Sum of all the observations/number of observations)
What is the Median?
Median on the other hand is the middle number in the set of data array which separates the higher set of the data from the lower. The data needs to be arranged in ascending order first to calculate the median of the data. When the data set have cardinality the mean of the middle two numbers in the data set needs to be taken. However, Mean vs Median methods is often used interchangeably.
4.9 (1,353 ratings)
Median Formula
Median Formula = (n+1)/2 when n is an odd number
Median: [(n/2) + {(n/2)+1}] / 2 when n is an even number
Mean vs Median Infographics
Here we provide you with the top 7 difference between Mean vs Median
Mean vs Median – Key Differences
The key differences between Mean vs Median are as follows –
- Mean is the simple to use and apply and can be applied to any data array set whether even or odd. Median on the other hand is a bit slightly complex to use and the data set needs to be arranged in the ascending or the descending order first before calculation
- The mean is normally used for normal distributions whereas the median is used for skewed distributions data set
- The mean is simple but it is not robust become it can contain outliers in the distributions and can sometimes not give the user the correct results for interpretation. On the other hand, the median method is robust and is better suited to use for as it used for skewed distributions to derive the central tendency of the date set and will give the user many accurate results when compared to mean
- There is only one formula of mean that is the sum of all the observations divided by the numbers of observations. Whereas, the median has two formula one of the odd where just the middle numbers from the dataset become the median. But when we have even data set the middle of the two values are picked and are divided by 2 which then gives us the median of the even data set
Head to Head Difference Between Mean vs Median
Let’s now look at the head to head difference between Mean vs Median
Mean | Median | |
The mean is computed by adding up all the values in the data array which is then divided by the numbers of observations | Median is the exact middle value of the data set. It can be computed by arranging the data set in the ascending order and then finding or picking out the middle value from the data set | |
It is more widely used in the industry due to an easy computation of the average and it gives us a quick number | It is not used often in the industry but it is more complete and accurate than mean which just a simple sum of numbers | |
It is used generally for normally skewed data set i.e. normal distribution | It is particularly handy to describe dataset with a significant skewness in the data or when the data has a long tail. It is used widely where the outliners carry significant weight in the data there mean is not a good method of calculation | |
It is not a robust tool for a calculation to derive the central tendency | It is a much robust tool as it determines the weight in the data which is generally high weight at the longer tails | |
It is very sensitive to outliers | It is much less affected by the outliers | |
It is simple to use | It is complex in nature | |
It cannot be calculated for categorical data, as the values cannot be summed | It cannot be identified for categorised nominal data as it cannot be logically ordered |
Mean vs Median Conclusion
Apart from mean vs median, there is one more method which is often used for measuring central tendency that is the mode. A mode is a value which is most frequently occurred in the data set, the mode has an advantage over the mean vs median that it can be found for both numerical and categorized data set.
Despite the existence of mode and median the superiority of better results and analysis over the mean, the mean is still the most appropriate measure of central tendency, especially if the data set is a normal distribution and the data is normally skewed.
As a good analyst, the central tendency should be measured with all the three data methods and the variance in the analysis should be pondered and carefully analyzed to produce better and more accurate results in the data set.
Recommended Articles
This has a been a guide to Mean vs Median. Here we also discuss the top difference between Mean vs Median along with infographics and comparison table. You may also have a look at the following articles –
- How to Use MEDIAN Formula in Excel?
- Examples of Weighted Mean Formula (with Excel Template)
- What is the Harmonic Mean Formula?
- Mean Formula
- Median Formula in Statistics
- Normal Distribution Graph Excel
- Variance and Standard Deviation
- QUARTILE Function in Excel
- Calculate Standard Deviation in Excel
- Calculate Minimum in Excel
- LINEST Function
- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion