The median represents a value that separates the upper half of the bottom half of a sample data. Microsoft Excel has a function that allows you to easily calculate the median. Let's see how median calculation in Excel.
Median calculation in Excel
The middle function in Excel can be classified as a statistical function. It can be entered as part of a formula in a cell of a spreadsheet. The syntax of the MEDIANE function is as follows:
MEDIAN (number1, (number2), …)
Where number1, number2, … are numerical values for which you want to calculate the median. It can be numbers, named ranges or references to cells containing numbers. Number 1 is mandatory, the following numbers are optional.
To use the MEDIANE function as a worksheet function in Microsoft Excel:
- Enter the values in the cells
- Use the formula to calculate the value.
1) Enter the values in the cells
Suppose you want to find the median of the numbers in the cells D2: D8. Simply enter the value of the data by opening a blank Excel sheet and proceeding as follows,
Make a column of average monthly expenses and another column, adjacent to that of the amount.
Enter the description in column 1 and the corresponding value or amount in column 2
2) Use the formula to calculate the value
Now, to calculate the median click inside any cell and use the formula as simple as this one:
Instantly, the median value corresponding to the data will be visible in the cell. Here, it is important to note that when the total number of values is odd, the MEDIAN Excel function returns the middle number in the data set, that is, when it is there are numbers from 1 to 7, the median value will be 4 (1,2, 3,45,6,7)
Alternatively, when the total number of values is even, Excel will return as the average of the two intermediate numbers, that is, if there are numbers from 1 to 8, the median value will be ( 1,2,3,4,5,6,8,8) 4 + 5/2 = 4.5
You do not have to worry about cells with texts because empty cells, as well as cells containing text and logical values, are ignored.
Note: Cells with null values (0) are included in the calculations.
In the most recent versions of Microsoft Excel, the MEDIAN function accepts up to 255 arguments.