Formulas > =TRIMMEAN()
How to Use TRIMMEAN() in Google Sheets
Description
How To Actually Use TRIMMEAN() in Sheets
TRIMMEAN(data, exclude_proportion)
Try TRIMMEAN yourself
Use the TRIMMEAN function to calculate the mean of the data in the range A1:A10, excluding 20% of the highest and lowest values. Your formula should return the correct trimmed mean.
Hints (2)
-
Remember to specify the range and the proportion to exclude.
-
The exclude_proportion should be a decimal representing the percentage.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the TRIMMEAN() formula:
Generate a TRIMMEAN() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses TRIMMEAN(). 2 free AI generations, no signup. Members get unlimited use.
Generate a TRIMMEAN() formula