The mode is the value that appears most often in a data set. To find it, count how many times each value occurs and pick the one with the highest frequency. Unlike the mean or median, the mode works with both numbers and non-numerical categories, making it uniquely versatile.
Finding the Mode Step by Step
Start by organizing your data. If you have the set 3, 7, 3, 9, 5, 3, 7, list each unique value and tally how often it appears: 3 shows up three times, 7 shows up twice, and 5 and 9 each appear once. The value 3 has the highest frequency, so 3 is the mode.
For larger data sets, sorting the values from smallest to largest makes counting easier. Once sorted, identical values sit next to each other and you can quickly spot which cluster is the longest. You don’t need any formula for a simple list of values. Just count and compare.
When There Is More Than One Mode
A data set can have multiple modes. If two values tie for the highest frequency, the set is called bimodal. For example, in the set 2, 4, 4, 6, 6, 8, both 4 and 6 appear twice, so both are modes. If three values tie, the set is trimodal. Any data set with more than one mode can be described broadly as multimodal.
A data set can also have no mode at all. If every value appears exactly once (like 1, 3, 5, 7), no single value occurs more frequently than the others, so there is no mode to report. Similarly, if every value appears the same number of times (like 2, 2, 4, 4, 6, 6), listing all of them as modes would just restate the entire data set, which defeats the purpose. In that case, it’s standard to say the data has no mode.
Using the Mode for Non-Numerical Data
The mode is the only measure of central tendency that works with categorical data. The mean and median require numbers, but the mode simply asks “which category appears most often?” If you survey 20 people about their favorite color and get 7 responses for blue, 6 for red, 4 for green, and 3 for yellow, the mode is blue. This makes the mode especially useful for survey responses, product preferences, or any situation where your data consists of names or labels rather than quantities.
Finding the Mode in Grouped Data
When data is organized into ranges (like 0–9, 10–19, 20–29), you can’t simply pick the most frequent individual value because the raw values are hidden inside intervals. Instead, you identify the modal class, which is the interval with the highest frequency, and then estimate the mode’s position within that interval using a formula.
The formula is:
Mode = L + [Δ1 / (Δ1 + Δ2)] × i
- L is the lower boundary of the modal class
- Δ1 is the difference between the modal class frequency and the frequency of the class just before it
- Δ2 is the difference between the modal class frequency and the frequency of the class just after it
- i is the class width (the size of each interval)
For example, suppose the interval 20–29 has the highest frequency at 15, the interval before it (10–19) has a frequency of 10, and the interval after it (30–39) has a frequency of 12. The class width is 10. Plugging in: L = 20, Δ1 = 15 − 10 = 5, Δ2 = 15 − 12 = 3. The estimated mode is 20 + [5 / (5 + 3)] × 10 = 20 + 6.25 = 26.25. This gives you an approximation of where the most common value likely falls within that interval.
Finding the Mode in Excel or Google Sheets
Spreadsheets can find the mode instantly. In Excel, two functions handle different situations:
- MODE.SNGL returns a single mode. Type =MODE.SNGL(A1:A50) to get the most frequent value in that range. If multiple modes exist, it returns only the first one it encounters.
- MODE.MULT returns all modes when a data set is multimodal. Because it can return more than one result, you need to enter it as an array formula. Select a vertical range of cells, type =MODE.MULT(A1:A50), and press Ctrl+Shift+Enter (or just Enter in newer versions of Excel with dynamic arrays). For a horizontal layout, wrap it in TRANSPOSE: =TRANSPOSE(MODE.MULT(A1:A50)).
Both functions ignore text, logical values, and empty cells, but they do count cells containing zero. If no value in your range appears more than once, both functions return a #N/A error, which is the spreadsheet’s way of telling you there is no mode.
Google Sheets uses the same =MODE function, which behaves like MODE.SNGL. For multiple modes, you can sort your data and use COUNTIF to tally frequencies manually, or use a combination of UNIQUE and COUNTIF to build a frequency table.
When the Mode Is Most Useful
The mode tells you what’s typical in a popularity sense rather than a mathematical average sense. A shoe store wants to know which size sells most often, not the average shoe size. A restaurant wants to know which dish gets ordered the most. In these cases, the mode gives you a directly actionable answer.
For numerical data, the mode is particularly helpful when the distribution is skewed or contains outliers. The mean can be pulled far from the center by a few extreme values, but the mode stays anchored to whatever value actually occurs most frequently. It pairs well with the mean and median to give a fuller picture of your data. If all three are close together, the data is fairly symmetric. If the mode sits far from the mean, the distribution is likely skewed.