Google Spreadsheets MEDIAN Function GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office

Use the Google Sheets MEDIAN Function

Find the midmost value in a set of numbers

By Ted French Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. lifewire's editorial guidelines Updated on May 15, 2020 Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook Along with helping you track your data, Google Sheets also lets you analyze and modify it using functions. If you have a large set of numbers and want to find the middle value, you'll want to use the MEDIAN function. Here's how to use it.

Finding the Middle Value With the MEDIAN Function

To make it easier to measure central tendency, Google Spreadsheets has a number of functions that will calculate the more commonly used average values. These include: The MEDIAN function finds the median or middle value in a list of numbers. The AVERAGE function finds the arithmetic mean for a list of numbers. The MODE function finds the most commonly occurring value in a list of numbers.

The MEDIAN Function' s Syntax and Arguments

A function's syntax refers to the layout of the function and includes the function's name, brackets, comma separators, and arguments. The syntax for the MEDIAN function is: =MEDIAN (number_1, number_2, ...number_30) number_1 - (required) the data to be included in calculating the median number_2:number_30 - (optional) additional data values to be included in the median calculations. The maximum number of entries you can include is 30. This rule doesn't apply if your function uses a range of cells. The arguments can contain: a list of numbers; cell references to the location of the data in the worksheet; a range of cell references; or a named range.

Finding the Median Mathematically

It's easiest to find a median for an odd number of values. For example, the median of a set containing the numbers 2,3, and 4 is 3. With an even number of values, you calculate the median by finding the average for the two middle values. For example, you'd calculate the median for the numbers 2,3,4,5, by averaging the middle two numbers, 3 and 4: (3 + 4) / 2
that results in a median of 3.5.

How to Enter the MEDIAN Function

Once you've entered your data set into a spreadsheet, here's how to enter the function to calculate the median: Click the cell you want to enter the function into. Type = and then MEDIAN to begin the function. Open a set of parentheses by typing (. Highlight the cells you want to use to calculate the median. In the example above, you would drag from Cell A2 to Cell C2. Press the Enter key to add the closing parenthesis and to complete the function. The median will replace what you typed in the cell, but the function will still appear in the formula bar above the worksheet.

Blank Cells vs Zero

The MEDIAN function ignores empty cells but not ones containing the numeral 0. So for the set (4, 6, [empty cell], 8), the median would be 6 because the function reads that set as (4, 6, 8). The set (4, 6, 0, 8), however, would have a median of 5, because the function places all of the values it's analyzing into ascending order. So it would find the average of the middle two values in the adjusted set (0, 4, 6, 8). Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Use the Google Spreadsheets AVERAGE Function Use the Excel RIGHT Function to Extract Characters Use Excel's EOMONTH Function to Add or Subtract Months How to Use Excel's MROUND Function How to Round Numbers Down in Excel With the ROUNDDOWN Function Excel SUMIFS: Sum Only Values Meeting Multiple Criteria How to Count Data in Selected Cells With Excel's COUNTIF Function How to Combine the ROUND and SUM Functions in Excel How to Sum Columns or Rows in Google Sheets How to Use the Excel DATE Function How to Use the Round Function in Excel Find The MEDIAN IF Your Formula Meets Criteria in Excel Ignore Error Values When Finding the Average in Excel Round up Numbers in Excel With the ROUNDUP Function How to Use the Excel TRUNC Function How to Calculate Weighted Averages in Excel With SUMPRODUCT Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies