In addition to Microsoft Excel , Google Sheet is an online tool for calculating, creating books, financial reports, etc. In particular, this tool will also provide us with calculation functions similar to Excel.
The MEDIAN function is a calculation function that helps us find the median in any sequence of a spreadsheet. Here we will introduce the article on how to use MEDIAN function on Google Sheets , please refer.
Access and Google Sheets Download Google Sheets on Android Download Google Sheets on iOS
How to use the MEDIAN function on Google Sheets
Syntax of the function: MEDIAN (number 1; number 2; number 3; ...) .
Inside:
- MEDIAN: is the name of the median finder.
- number 1; number 2; number 3; ...: The values in the sequence.
A few things to note when using the MEDIAN function:
- In the process of finding the median, all values are zeros, the logic and the text are automatically removed by the function and only the numerical values are calculated.
- If you enter an even number of sequences, this function will find the median by calculating the average of the two numbers in the sequence.
1. Find the median using MEDIAN in a sequence
Step 1: First go to Google Sheet and click on any cell.
Step 2: Enter the syntax of this function.
For example: = MEDIAN (1; 2; 9; 8; 5).
Step 3: Press the Enter button . The following will be the median value found for the sequence above.
2. Find the median within a range of value cells on Google Sheet
Step 1: In Google Sheets, open the worksheet in which you want to find the median.
Step 2: Click on any empty cell, then enter the following formula: = MEIDA (Range of cells) .
For example: = MEDIAN (D4: D9).
Step 3: Press the Enter button . Below is the median number found in the spreadsheet.
Above is a guide to using the MEDIAN function in Google Sheets, we hope that after following this article, you can easily get the median in an arbitrary series thanks to this function.
In addition, you can also refer to some other articles such as:
I wish you successful implementation!