Key Facts
- Category
- Math, Date & Finance
- Input Types
- textarea, number, checkbox
- Output Type
- json
- Sample Coverage
- 4
- API Ready
- Yes
Overview
The Trimmed Mean Calculator provides a robust way to find the average of a numeric dataset by excluding extreme outliers. By sorting your data and removing a specified percentage of the highest and lowest values, it calculates a more accurate central tendency that is not skewed by anomalies or measurement errors.
When to Use
- •When analyzing survey scores or judging panel results where extreme bias might exist.
- •When processing noisy sensor data or quality metrics that occasionally produce false spikes.
- •When you need a robust statistical average that completely excludes outliers rather than just capping them.
How It Works
- •Enter your numeric dataset as a comma-separated list in the input field.
- •Specify the percentage of values to trim from each tail (e.g., 10% from the top and 10% from the bottom).
- •The tool sorts the numbers, removes the specified outliers, and calculates the mean of the remaining values.
Use Cases
Examples
1. Calculating a fair competition score
Event Judge- Background
- A gymnastics competition uses 10 judges, but occasionally one judge gives an unusually harsh or generous score.
- Problem
- Calculate a fair average score by dropping the highest and lowest scores to prevent bias.
- How to Use
- Enter the 10 scores into the dataset field and set the trim percentage to 10%.
- Example Config
-
{"dataset": "8.5, 8.7, 8.8, 8.9, 9.0, 9.1, 9.1, 9.2, 9.3, 10.0", "trimPercent": 10, "decimalPlaces": 2} - Outcome
- The 8.5 (lowest) and 10.0 (highest) scores are removed, and the remaining 8 scores are averaged for a fair final result.
2. Analyzing average property prices
Real Estate Analyst- Background
- A neighborhood has mostly mid-range homes, but one massive mansion and one dilapidated property skew the standard average.
- Problem
- Find the typical home price without the extreme outliers distorting the data.
- How to Use
- Paste the list of recent sale prices and apply a 15% trim to both tails.
- Example Config
-
{"dataset": "50000, 310000, 315000, 320000, 325000, 330000, 340000, 2500000", "trimPercent": 15, "decimalPlaces": 0} - Outcome
- The tool drops the $50,000 and $2,500,000 properties, returning a trimmed mean that accurately reflects the standard market value.
Try with Samples
video, barcodeRelated Hubs
FAQ
What is a trimmed mean?
A trimmed mean is a method of averaging that removes a small, specified percentage of the largest and smallest values before calculating the mean, reducing the impact of outliers.
How is the trim percentage applied?
The percentage applies to each tail. For example, a 10% trim on a dataset of 100 items will remove the 10 lowest and 10 highest values.
What is the maximum trim percentage allowed?
You can trim up to 45% from each tail. Trimming 50% from both ends would leave no data to average.
Can I see which values were removed?
Yes, by enabling the 'Include Trimmed Values' option, the output will display the specific numbers that were excluded from the final calculation.
How does this differ from Winsorizing?
A trimmed mean completely removes the extreme values from the dataset, whereas Winsorizing replaces those extreme values with the nearest remaining values before averaging.