MEDIAN Function
It gives us the middle-value number from your data set.
Before getting started on how to use and when to use the median function in Excel, it should be known how to find the median in math without Excel. The median is typically the middle number that you have in a sequence of numbers or data sets.
In math, the usual way to do it is first to put all your numbers in order. After putting them in order from least to greatest, you pick the one in the middle after crossing each number out on each side evenly.
Typically, you would have to have an odd set of numbers to get the middle number. This is because our goal is to get the last standing number from the data.
If we have an even set of even numbers, we will end up with two middle numbers. Although having two middle numbers does not mean we won’t be able to find the median. We would just have to take extra steps to find it.
For example, if you have five numbers: 4,6,2,8,9, we would put them in order.
After arranging the numbers in order, your first step is complete. The next step that should be taken would be crossing the numbers out until you reach your middle number.
The middle value is six, which is your median. The median separates the higher half value from the lower half value.
If there is an instance where you have two numbers that are in the middle, then you would proceed to find the mean of the two numbers. You would add the two middle-value numbers and divide the sum by two.
The numbers you pick also do not have to be single-digit numbers; they can work with any range of numbers.
Often in school, we would learn about the median. When we learned about the median, we were also taught about the MEAN and MODE. These are also functions in Excel.
It is always good to remember what these are used for because you might use them. For example, in the median, you must use the mean to find the median when there is a set of even numbers.
NOTE
The mean helps you find the average of a set of numbers. You add all the values together and divide them by the number of values you added together. The mode you use is the repetitive number. It is the number you continue to see the most.
What to know about the MEDIAN function
When working on excel, most of the time, you are using large sets of data. To be able to find the median how we did above on a large set of data would take a very long time. Therefore, Excel provides a median function to make it easier for us.
Using the median function in Excel will still give us the middle-value number from your data set. Typically when you work in finance or other jobs, such as actuaries that use large sets of data, you would use Excel to help. The function can give you the point at which your data is centered.
Excel is not only for people with jobs; it can also be used by students who just need a system to help them. The function would help identify their middle number from a large data set much easier than if they were to do it by hand.
Formula
The first thing one should know is the formula for it in Excel.
=MEDIAN(number 1, [number2],…)
This is an example of how it looks when entering the formula. The function on Microsoft Excel has the following arguments:
- Number 1 input is required. The following numbers are optional.
- Number 2 and any other number following are optional.
Take note on
- You can find the median on either one number or up to two-hundred and fifty-five numbers.
- Any argument can range from numbers, arrays, references, or names that have to contain numbers.
- Any rational value or a word representation of a number typed into the formula will be counted.
- Any argument that is an error value or if there is text that the system can not translate into a number will cause errors.
- If there are empty cells, those values are ignored. Although if there is a cell with the number zero, then the system will include it.
- If you contain Excel 2007 and up, the function will accept up to two hundred fifty-five arguments. Although if you have older versions, such as Excel 2003 and under, you may only be able to enter about 30 arguments.
Examples
Let’s proceed with finding a few examples of median to help learn how to use the function.
In the following example, we will start by just trying to find the middle value using an odd set of values.
1. Example #1
Notice that you can click on the cells you want to be added to your formula, and the formula will adjust itself with the cells’ names.
After the formula is completed or when you press the enter key on your keyboard, the system will solve it for you. In this case, our median was three. The system took into consideration our repetitive numbers and the zero.
2. Example #2
Now, let's follow with an even set of numbers.
The result was 2.5 because since the set of numbers is even, the system knows that it needs to take extra steps to find the middle set value.
NOTE
If the data set is a total of even numbers, then the MEDIAN will follow to calculate the average of the two-middle value numbers.
3. Example #3
For this example, we will enter the logical values such as TRUE and FALSE. Even though we have the logical value in the cells, we will still get the middle number.
Logical values like true and false are ignored, but you will still get the middle value.
Key Takeaways
- Median Function can identify the middle set number from the data provided.
- In the data, if there's a range of middle numbers, you will have to proceed to solve the median of the two middle-value numbers.
- The median function on Excel can be entered by typing it out in the cell or entered from the financial section.
- The function benefits easier and faster results for large data sets.
- Input 1 on the formula is not optional.
- Start by entering an equal sign and typing the median to enter the formula.
- If you have an even set of numbers, the median will be calculated by solving for the mean of the middle set values.
or Want to Sign up with your social account?