Should you need to find the middle value in a set of data in your spreadsheet without having to do it manually, Google Sheets has a function that does it instantly for you. Here’s how to use the MEDIAN function.
Fire up Google Sheets and open a spreadsheet with datasets for which you want to find the median.
Click on an empty cell and type =MEDIAN(<value1>, [<value2>, ...]) into the cell or the formula entry field, replacing <value1> and <value2> with the values or ranges to consider for calculating.
The MEDIAN function in Google Sheets supports any number of arguments, and anything other than the first value is optional. It will look something like this:
=MEDIAN(1,2,5,7,7)
After you press the “Enter” key, the cell will now contain the median of the numbers you put in the function.
If you want to use a range of cells as values, it will look like this:
=MEDIAN(F3:F11)
Read the remaining 9 paragraphs
from How-To Geek https://ift.tt/32WJdlS
No comments:
Post a Comment