TRIMMEAN

The TRIMMEAN function in Google Sheets calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset. This function is commonly used to reduce the impact of outliers on the average.

Function Syntax and Parameters

Syntax: TRIMMEAN(data, exclude_proportion)

Parameters:

• data: The dataset or range of cells containing the data.
• exclude_proportion: The proportion of data to exclude from both ends of the dataset. This value must be between 0 and 1.

Step-by-Step Tutorial

1. Using TRIMMEAN to calculate the mean excluding extreme values:
   • Example: =TRIMMEAN(A1:A10, 0.1)
   • Result: This formula will calculate the mean of the dataset in cells A1 to A10, excluding the highest and lowest 10% of values.

Use Cases and Scenarios

1. Financial Analysis: Calculate the trimmed mean of stock prices to eliminate extreme values.
2. Quality Control: Determine the average value of production measurements after excluding outliers.
3. Survey Analysis: Calculate the mean score of a survey question excluding the highest and lowest responses.

Related Functions

• AVERAGE: Calculate the arithmetic mean of a dataset.
• MEDIAN: Find the middle value in a dataset.

Related Articles

• Top 5 Statistical Functions Every Google Sheets User Should Know
• Using Statistical Functions to Analyze Data in Google Sheets