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.

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