Median: Excellent Function and 10 Examples of Usage

The Median is a function that would return with a median of the numbers given to it. Median is a numeric value that is in the middle of different numbers.

The syntax is very simple, which makes it look like this: MEDIAN(number1; number2, and so on until 255).

The median has these following arguments:

Number 1: This is required.

Number 2 – 255: This is optional, going all the way to 255, for which the user wants medina of.

Example 1: Simple Median Formula

We are have different data of our sales management, and we would like to know the median of the sales department. This help in acknowledging how we are averagely performing. It help in reaching our next goal.

Simple Median Formula

Example 2: Median and 25%

The goal has been set, and we would like to know how we would be able to do in our next goal. Annually, we look at various aspects in our business, and determine if we have reached our goal for that year. We have determine that every year, we would like our median to increase by 25%, and we want to know this median, for that reason, we are going to use the previous data to acknowledge if the 25% has increased or not.

Median and 25.png

Example 3: Median and Sum

The business needs to pay its debt on an average level, and we need to make sure that the business works excellently in form of finances. It is why we have been looking at the business, but the tax office is much more interested in the average performance this time. This is why we have decided to check if the median could cover the expenses.

Median and Sum

Example 4: Median with Text

The whole data has been inputted in text, and it is crucial that we’d decide what would work best for the circumstances. Our data is layout, and now we would like to determine the median, using the label we have given to our data.

Median with Text

Example 5: Medium Capacity: Phase 1

Generally, we believe that the medium should have the ability to pay at least the maximum expenses in the range of our total expenses. However, we do not know how the medium would perform under the circumstances, which is why we are using the medium and max to find out.

Medium Capacity Phase 1

Example 6: Medium Capacity: Phase 2

As it was shown in the previous example, the median is not doing well with the evaluation, which is why we believe that the evaluation should continue, because we cannot tolerate such high expenses. This is why we want to see how the median would perform in a different evaluation: median and min.

Medium Capacity Phase 2

Example 7: Medium Capacity: Phase 3

The phase three is now about being fair, using previous data, and use it to find the appropriate answer to how the medium is performing. This is why we are now going with a medium minus medium in the data.

Medium Capacity Phase 3

Example 8: IF and Median

We have a specific goal for the business, and throughout the months in the year, we have followed the business’ process. Every month we have made specific amount, which is why we’d determine that if we make a specific money the last month of the year, then we need to know the median, so we can see if the median we have determined has been reached.

IF and Median

Example 9: Median and Average

The data has been layout, and we are trying to see the median and average of both expenses and revenues, which is why we are using both formulas to find out how it would work out.

Median and Average

Example 10: Double Median and Percentage

The business needs answers of how it would perform, and because we would like to know what would happen if we add 35 percent that an investor was going to pay us, and then remove the median again, the business might be able to do the median for finding the answers we want.

Double Median and Percentage