In this article:

How to Calculate the Mean, Median, and Mode in Google Sheets


You now have a dataset and need to calculate the so-called “measures of central tendency.” How would you do so? Fortunately, Google Sheets has its own functions to automatically calculate the mean, median, and mode of a dataset. They are defined as follows:

  • The mean, also known as the arithmetic mean or the average, is calculated by adding all the given values in the list divided by the number of such values.
  • The median is the value at the middle of the list after arranging them by increasing order.
  • The mode is the most frequent value in the list. 

For our example, we have a list of purchases of a single product. We wish to calculate the mean profit, the median of the amount of items ordered, and the mode of the amount of items ordered.

The source dataset
The source dataset


How to calculate the mean

To calculate the mean of a dataset, use the AVERAGE() function and set the input as the area of the array containing the data. For our example, the data for profit covers cells D2 to D56:

=AVERAGE(D2:D56)

The AVERAGE() function ignores text, and so if you accidentally included the header of the table it will not break the function nor change the result:

The source dataset, with the AVERAGE function highlighted.
The source dataset, with the AVERAGE function highlighted.


How to calculate the median

In a similar fashion, the MEDIAN() function calculates the median of the array. For our example, the data for the amount of items ordered covers cells B2 to B56:

=MEDIAN(B2:B56)

The MEDIAN() function ignores text, and so if you accidentally included the header of the table it will not break the function nor change the result:

The source dataset, with the MEDIAN function highlighted.
The source dataset, with the MEDIAN function highlighted.


How to calculate the mode

Finally, the MODE() function calculates the mode of the array. For our example, the data for the amount of items ordered covers cells B2 to B56:

=MODE(B2:B56)

The MODE() function ignores text, so if you accidentally included the header of the table, it won’t break the function nor change the result:

The source dataset, with the MODE function highlighted.
The source dataset, with the MODE function highlighted.


How to Find Mean in Google Sheets

The quickest and easiest way to calculate the mean of a dataset in Google Sheets is to use the AVERAGE function.

  1. Click on the cell you want to display the mean in
  2. Type =AVERAGE() in the cell
  3. Enter the numbers, cells or range you want to average in the parentheses.
  4. Press the ENTER key on your keyboard to return the result
The source dataset, with the AVERAGE function highlighted.

Use our bill due date tracker to easily track due dates from your spreadsheet in just a few clicks. 

If you enjoyed this article, you might also like our article on how to divide on Google Sheets or our article on how to make a random number generator in Google Sheets.

If you want to learn how to mail merge labels in Google Sheets, we also suggest checking out our detailed guide. 

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started