Excel FunctionsLesson 98Free preview
MODE
This lesson is part of Excel · All levels
Summary
MODE is an Excel statistical function that returns the most frequently occurring value (mode) in a range. The modern version is MODE.SNGL for one mode and MODE.NG for several modes. This function is useful for analyzing data frequencies.
Key points
- The MOSES return the value with the highest frequency of occurrence
- MODE.SNGL yields one mode value, MODE.NG can be several
- If there is no recurring value, the result is error #N/A
- The mode can be either numbers or text depending on the data.
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.