SheetFX
≡
<< Go back to all functions

MODE

The MODE function in Google Sheets returns the most commonly occurring value in a dataset.

Function Syntax and Parameters

Syntax: MODE(value1, [value2, ...])

Parameters:

  • value1: The first value or range to consider.
  • value2, ...: [Optional] Additional values or ranges to consider.

Step-by-Step Tutorial

  1. Using MODE with individual values:

    • Example: =MODE(1, 2, 2, 3, 3, 3)
    • Result: 3

  2. Using MODE with a range of cells:

    • Example: If A1:A5 has the values 1, 2, 2, 3, 3, 3, then =MODE(A1:A5) will return 3.

Use Cases and Scenarios

  1. Survey Responses: Determine the most common response in a survey.
  2. Stock Analysis: Find the most frequently occurring stock price.
  3. Test Scores: Identify the most common test score in a class.

Related Functions

  • MEDIAN: Find the middle value in a set.
  • AVERAGE: Calculate the average of a range of values.

Related Articles