I. Intro
The MODE function returns the mode, the most frequently occurring value, of a data set.
II. About the function
- 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 that repeat at the same frequency, the smallest among these values is returned. For example, if both the numbers 2 and 5 are repeated three times, then 2 is returned.
- If the data set doesn't contain any repeating values, then the #N/A error value is returned.
- The parameters can be numbers, 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
- Select a cell and click Formulas on the toolbar, then select Statistical > MODE. You can also directly enter =MODE in a cell.
- Enter the parameters in the cell. For example: =MODE(A1:A10).
- Press Enter to display the result, which is 2 in this example.
250px|700px|reset
Delete the MODE function
Select the cell with the MODE function and press Delete.
IV. Use case
Product managers: Find the most common value
User feedback helps product managers identify where potential problems lie and address them accordingly. The MODE function is useful in this case by identifying which product has the most complaints.
- Formula used below: =MODE(B2:B10)
- About the parameters: Based on the selected timeframe, product no. 2 has the most user complaints and needs to be optimized.
250px|700px|reset