How to calculate median in excel

The median (Medians) refers to the value in the middle after the data is arranged in order of size, represented by Me. Quickly calculate the median with Excel!

How to calculate the median in excel:

1. Median

When the number of data N is an odd number, the value in the middle is the median;

When N is an even number, the median is the average of the two values ​​in the middle.

The advantage of the median is that it is not affected by large or small data. In many cases, it is more appropriate to use it to represent the general level of the entire data. If there are extreme variable values ​​in the sequence, the median is a better representative value than the mean.

2. Example application

As shown below, if you require the median of the test score, enter the formula =MEDIAN(B3:B11) to quickly find the median of the score The number is 75. The method is simple, accurate and effective!

For more EXCEL related tutorials, please visit the excel basic tutorial column!

The above is the detailed content of How to calculate median in excel. For more information, please follow other related articles on the PHP Chinese website!