I. Intro

The MODE function is commonly used to return the most frequently occurring value in a dataset. The mode is the value with the highest repetition frequency in a set of values.

II. Explanation

•Formula: =MODE(value1,[value2],...)

•Parameters:

◦value1 (required): The first value or range to be calculated.

◦value2 (optional): Additional values or ranges to be calculated.

•Example: =MODE(A2:A100,5)

•Note:

◦If there are values repeated at the same frequency, the smallest value amongst the repeated values is returned. For example, if both the numbers 2 and 5 are repeated three times, then 2 is returned.

◦If the dataset doesn't contain repeated data, then =MODE returns the error value N/A.

◦The parameters can be numbers, or names, arrays, or references that contain numbers.

◦If the array or reference parameter contains text, logical values, or blank cells, these values will be ignored. However, cells containing the value zero will be included in the calculation.

III. Steps

Use the MODE function

1.Select a cell and enter =MODE, or click Formulas on the toolbar. Select Statistics, then select the MODE function.

2.Enter formula parameters =MODE(A1:A10) into the cell.

3.Press Enter to display the result in the cell, which is 2.

Delete the MODE function

Select the cell with the MODE function applied, and press Delete to clear the formula from the selected cell.

IV. Scenarios

•Product manager essentials: Use the MODE function to quickly find the mode

We need user feedback to ensure products are constantly improving, and counting which products have been receiving user complaints can help us find out if there's a specific product problem. In this case, we can use the MODE function to find out which product has been complained about the most when faced with a large amount of feedback.

•Formula used in the figure below: =MODE(B2:B10)

•Formula parameter explanation: As shown in the figure below, we found out that within the selected range, product no. 2 has the most user complaints and needs to be adjusted.