What is a Trimmed Mean Calculator?
A trimmed mean is the average of a dataset after a fixed percentage of the smallest and largest values has been removed from each end. This trimmed mean calculator sorts your data, cuts g = ⌊n × p⌋ values from each tail and averages the rest, with every step shown. A 10% trimmed mean of 20 values drops the 2 smallest and 2 largest and averages the middle 16. It resists outliers better than the mean and uses more of the data than the median. The tool also returns the winsorized mean and the interquartile mean.
What the Trimmed Mean Calculator does
Enter your data and a Trim percentage (each tail). The calculator removes g = ⌊n × p⌋ values from each end of the sorted list, averages the rest, and marks every trimmed value in a table so you can see exactly what was left out. Beside the trimmed (truncated) mean it reports the winsorized mean, which replaces the extreme values with the nearest kept value instead of deleting them, and the interquartile mean, the 25% trimmed mean.
A trimmed mean is a compromise between the mean, which uses every value and is dragged by outliers, and the median, which ignores everything except the middle. Use it when the data are mostly well behaved but a few values are suspect: reaction times with lapses, judges’ scores, prices with data-entry errors, or any heavy-tailed measurement. The comparison table lines the five measures up so you can see how much the tails matter.
How to use the Trimmed Mean Calculator
- Type or paste your numbers into Data values, in any order.
- Enter the Trim percentage (each tail): 10 for a 10% trimmed mean, 25 for the interquartile mean, or 0 for the ordinary mean. The value must be below 50.
- Read the trimmed mean, how many values were removed from each end and how many were kept.
- Compare it with the ordinary mean, winsorized mean, interquartile mean and median in the table, and check the sorted-data table to see which values were trimmed.
Trimmed Mean formula
Sort the data so that x₁ ≤ x₂ ≤ … ≤ xₙ. With trim proportion p per tail, g values are cut from each end.
| Symbol | Meaning |
|---|---|
| x₍ₖ₎ | k-th smallest value |
| n | number of values |
| p | proportion trimmed from each tail (0.10 for 10%) |
| g | whole number of values removed from each end |
| ⌊ ⌋ | round down to a whole number |
Rounding convention. When n × p is not a whole number this calculator rounds down, which matches scipy.stats.trim_mean, R’s mean(x, trim = p) and Excel’s TRIMMEAN. Some textbooks round to the nearest whole number, and some packages give the boundary values a fractional weight so that exactly n × p values are removed. For small n these choices can change the answer; the note under the results tells you when that applies.
Because of the rounding, the interquartile mean shown here is the exact textbook interquartile mean only when n is divisible by 4.
p = 0 gives the ordinary mean. As p approaches 0.5 the trimmed mean becomes the median.
Worked example
Worked example: reaction times with two bad trials
Problem. A participant’s 20 reaction times (ms) are 312, 298, 345, 287, 301, 330, 295, 1250, 318, 305, 290, 322, 340, 299, 310, 308, 120, 327, 315, 303. One trial was an anticipation (120 ms) and one a lapse (1250 ms). Find the 10% trimmed mean.
- 01Sort: 120, 287, 290, 295, 298, 299, 301, 303, 305, 308, 310, 312, 315, 318, 322, 327, 330, 340, 345, 1250.
- 02Number to trim: g = ⌊20 × 0.10⌋ = 2 from each end.
- 03Remove 120 and 287 from the low end and 345 and 1250 from the high end, leaving 16 values from 290 to 340.
- 04Sum of the 16 kept values = 4,973, so the trimmed mean is 4,973 / 16 = 310.8125 ms.
- 05Winsorized mean: replace 120 and 287 with 290, and 345 and 1250 with 340: (2 × 290 + 4,973 + 2 × 340) / 20 = 6,233 / 20 = 311.65 ms.
- 06For comparison, the ordinary mean is 6,975 / 20 = 348.75 ms and the median is (308 + 310) / 2 = 309 ms.
Answer. The 10% trimmed mean is 310.81 ms. The ordinary mean, 348.75 ms, is higher than 19 of the 20 trials because of the single 1250 ms lapse; the trimmed mean sits with the bulk of the data, close to the median of 309 ms.
Trimmed mean versus winsorized mean
Both methods limit the influence of the g most extreme values at each end. Trimming deletes them, so the average is taken over n − 2g values. Winsorizing keeps the sample size at n but pulls each extreme value in to the nearest value that was kept, on the view that an extreme observation is still evidence of a high or low result even if its exact size is not trusted.
The winsorized mean therefore leans slightly further towards the tails than the trimmed mean. In the reaction-time example the two are 311.65 and 310.81 ms. Winsorized values are also what you need for the standard error of a trimmed mean, which is why the two are usually reported together.
| Method | What happens to the extremes | Values averaged | Typical use |
|---|---|---|---|
| Ordinary mean | Nothing | n | Clean, roughly symmetric data |
| Trimmed mean | Removed | n − 2g | Robust estimate of the centre; judging panels |
| Winsorized mean | Replaced by the nearest kept value | n | Robust variance estimates; finance and survey data |
| Median | All but the middle one or two removed | 1 or 2 | Strongly skewed data |
Trimmed mean in Excel, R and Python
The main trap is that Excel’s TRIMMEAN takes the total fraction removed from both ends together, while R, SciPy and this calculator take the fraction removed from each end. A 10% trimmed mean here is TRIMMEAN(range, 0.2) in Excel.
With the 20 reaction times from the worked example in cells A1:A20, =TRIMMEAN(A1:A20, 0.2) returns 310.8125, the same as a 10% trim per tail in this calculator. Excel works out 20 × 0.2 = 4 values to exclude and splits them 2 and 2. If n × percent is odd or not a whole number, Excel rounds down to the nearest even number, so it always removes the same count from each end. Google Sheets’ TRIMMEAN behaves the same way.
| Tool | 10% trimmed mean (10% from each end) | Rounding of n × p |
|---|---|---|
| This calculator | Trim percentage = 10 | Down |
| Excel / Google Sheets | TRIMMEAN(range, 0.2) | Down (to an even total) |
| R | mean(x, trim = 0.1) | Down |
| Python (SciPy) | scipy.stats.trim_mean(x, 0.1) | Down |
Common use cases
- Judging and scoring panels: drop the highest and lowest scores before averaging so one judge cannot swing the result.
- Reaction-time and timing data: damp the effect of anticipations and lapses without discarding trials by hand.
- Economic indicators: trimmed-mean inflation measures remove the most extreme price changes each month to show the underlying trend.
- Data with occasional recording errors: get a sensible average before you have had time to investigate each suspicious value.
- Robust reporting: show the trimmed mean beside the mean; a large gap is itself a finding about the tails.
Assumptions and limitations
- Trimming removes the same number of values from each end whether or not they are outliers. With skewed data that shifts the estimate towards the median and it no longer estimates the population mean.
- The trim percentage should be chosen before looking at the results. Picking the percentage that gives the answer you prefer is a form of data dredging.
- A trimmed mean protects against at most g wild values per end. If more than that share of the data is contaminated, use the median and the median absolute deviation.
- It does not tell you which values are outliers. To flag them explicitly, use the 1.5 × IQR fences.
- Totals cannot be recovered from a trimmed mean: multiplying it by n does not give the sum of the data. For budgets and totals, use the ordinary mean.
Frequently asked questions
What is meant by trimmed mean?
How do you calculate a trimmed mean?
Does a 10 percent trimmed mean remove 10% in total or 10% from each end?
What does a 20% trimmed mean mean?
How do you calculate a trimmed mean in Excel?
What is the difference between a trimmed mean and a winsorized mean?
What trim percentage should I use?
What is the interquartile mean?
Why does my textbook get a different trimmed mean?
Is the trimmed mean the same as the truncated mean?
Cite this page
Statculator. (2026, November 14). Trimmed Mean Calculator. Retrieved November 14, 2026, from https://statculator.com/descriptive-statistics/trimmed-mean-calculator/