MODE
Formulas / MODECalculate the most frequently occurring number in a set of numbers.
=MODE(number1, [number2], …)
- number1 - required argument that is the number to calculate the mode of
- number2 - [OPTIONAL] additional argument that can be an array or reference
Examples
=MODE(1,2,4,4,5,5,5,6)The MODE function is a statistical function in Sourcetable used to find the most frequently occurring value in a set of data. For example, this will return 5 because 5 appears more frequently than any other value in the set.
=MODE(7,8,9,7,9)The MODE function can also be used to find the most frequently occurring value when there are two or more values that appear the same number of times. For example, this will return 7 because 7 and 9 both appear twice in the set, but 7 appears first in the list.
=MODE(7,9,6,5,3,1,0)If the set of numbers contains no values that appear more than once, the MODE function will return an error. For example, this will return an error (#N/A) because none of the values in the set appear more than once.
=MODE(B5:J5)The MODE function can also be used with a range of cells. For example, this will return the most frequently occurring value in the range B5:J5.
Summary
The MODE function is a useful tool for analyzing data sets. It calculates the most frequently occurring value in a list of numbers and returns the lowest of those values if multiple occur.
- The MODE function can accept up to 255 separate arguments of numbers, strings, arrays or references, and will ignore empty cells, text values, and logical values.
Need help with Formulas?
Frequently Asked Questions
What is the MODE Function?
Has the MODE function been replaced?
- MODE.MULT
- MODE.SNGL
What does the MODE function ignore?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.