In this article:

May 8, 2024

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.

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:

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:

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 quickest and easiest way to calculate the mean of a dataset in Google Sheets is to use the **AVERAGE function**.

- Click on the cell you want to display the mean in
- Type
**=AVERAGE()**in the cell - Enter the numbers, cells or range you want to average in the parentheses.
- Press the ENTER key on your keyboard to return the result

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.

Get Google Sheets productivity and automation tips delivered straight to your inbox

We'll email you 1-3 times a week — and never share your information.

Get your copy of our free Google Sheets automation guide!

- 27 pages of Google Sheets tips and tricks to save time
- Covers pivot tables and other advanced topics
- 100% free

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->