MEDIAN function - The function returns the median of the given numbers in Excel

The following article introduces you to the MEDIAN function - one of the functions in the statistical function group is very popular in Excel.

MEDIAN function - The function returns the median of the given numbers in Excel Picture 1

Description: The function returns the median of the given numbers. Median number is the number in the middle of a set of numbers.

Syntax: MEDIAN (number1, [number2], .)

Inside:

- number1, [number2], .) Are the values ​​you want to find the median, where number1 is the required parameter, other values ​​are optional and contain up to 255 number parameters .

Attention:

- The value of the argument must be a number, name, array or reference containing numbers.

- If the number of sets of numbers you want to calculate the median is even -> the function performs the average calculation of the two middle numbers.

- Logical or text values ​​when typing directly into the argument list -> these values ​​are still counted.

- If the argument is a reference array containing text values ​​or logic -> these values ​​are ignored, but the value 0 is still counted.

- Arguments that are text or error values ​​cannot be converted -> cause errors in the function.

For example:

Calculate the median of number values ​​as described in the following data table:

MEDIAN function - The function returns the median of the given numbers in Excel Picture 2

- In the cell to calculate enter the formula : = MEDIAN (D6: D11)

MEDIAN function - The function returns the median of the given numbers in Excel Picture 3

- Press Enter -> median of values ​​is:

MEDIAN function - The function returns the median of the given numbers in Excel Picture 4

- Where the number of values ​​in the set of values ​​you want to calculate the median is even, but the values ​​are not evenly spaced -> the function still calculates the normal way.

MEDIAN function - The function returns the median of the given numbers in Excel Picture 5

- Where the number of values ​​in the set of values ​​you want to calculate the median is even, but the values ​​are evenly spaced -> the function performs the average value of the two numbers in the middle, here (12 + 15) ) / 2 = 13.5

MEDIAN function - The function returns the median of the given numbers in Excel Picture 6

Above are instructions and some specific examples when using MEDIAN function in Excel.

Good luck!