You can use the following formulas to find the mean, median, and mode of a dataset in Excel:

=AVERAGE(A1:A10) =MEDIAN(A1:A10) =MODE.MULT(A1:A10)

It’s worth noting that each of these formulas will simply ignore non-numeric or blank values when calculating these metrics for a range of cells in Excel.

The following examples shows how to use these formulas in practice with the following dataset:

**Example: Finding the Mean in Excel**

The **mean** represents the average value in a dataset.

The following screenshot shows how to calculate the mean of a dataset in Excel:

The mean turns out to be **19.11**.

**Example: Finding the Median in Excel**

The **median** represents the middle value in a dataset, when all of the values are arranged from smallest to largest.

The following screenshot shows how to calculate the median of a dataset in Excel:

The median turns out to be **20**.

**Example: Finding the Mode in Excel**

The **mode** represents the value that occurs most often in a dataset. Note that a dataset can have no mode, one mode, or multiple modes.

The following screenshot shows how to calculate the mode(s) of a dataset in Excel:

The modes turn out to be **7** and **25**. Each of these values appears twice in the dataset, which is more often than any other value occurs.

**Note:** If you use the **=MODE()** function instead, it will only return the first mode. For this dataset, only the value 7 would be returned. For this reason, it’s always a good idea to use the **=MODE.MULT()** function in case there happens to be more than one mode in the dataset.

**Additional Resources**

How to Calculate the Interquartile Range (IQR) in Excel

How to Calculate the Midrange in Excel

How to Calculate Standard Deviation in Excel

This is not working for me. When I put =mode.mult() the output is only one of the modes. It doesn’t show the other modes. I can see them in the formula box if I use that. But in the cell it only gives one of the modes. How can I get it to display all the modes?

very cool