How to Use the MEDIAN Function in Google Sheets

How to Use the MEDIAN Function in Google Sheets


Linux Articles / All 40 Views comments

Sheets Header

Ought to it's essential to discover the center worth in a set of knowledge in your spreadsheet with out having to do it manually, Google Sheets has a perform that does it immediately for you. Right here’s learn how to use the MEDIAN perform.

Hearth up Google Sheets and open a spreadsheet with datasets for which you need to discover the median.

Click on on an empty cell and sort =MEDIAN(<value1>, [<value2>, ...]) into the cell or the components entry area, changing <value1> and <value2> with the values or ranges to think about for calculating.

The MEDIAN perform in Google Sheets helps any variety of arguments, and something aside from the primary worth is non-compulsory. It can look one thing like this:


Enter the function into an empty cell with the numbers from which want to find the median value.

After you press the “Enter” key, the cell will now include the median of the numbers you set within the perform.

Press the "Enter" key and the median will appear in the cell.

If you wish to use a variety of cells as values, it is going to appear to be this:


You can use ranges from your spreadsheet as well, just reference them in the function.

After you press the “Enter” key, the cell will include the median worth of the vary you offered to the perform.

Press "Enter" and the media value will replace the function.

Some issues to notice concerning the MEDIAN perform: Something entered is sorted numerically, from the bottom to highest worth, and cells which might be empty—excluding “zero”—and that include textual content might be ignored by the perform.

The MEDIAN perform returns the midmost worth in a numerical dataset if the set incorporates an odd variety of values. In the event you enter a good variety of values, the MEDIAN perform will estimate a response between the 2 middle values.

For instance, discover how we enter 36 values, none of that are “$31,” but the perform returns a median worth of “$31.” It's because to seek out the median, the perform provides the center two numbers collectively after which divides by 2 to estimate the median. So, behind the scenes, it calculates (30 + 32) / 2 = 31 to supply the end result.

The function will estimate a median if there is an even number of values entered. The estimated value is between the middle two values.