Trimmed Mean functions

TrimMean
TrimMeanSEM

Description

TrimMean and TrimMeanSEM calculate a trimmed mean and the standard error of a trimmed mean.

TrimMean(k,range) computes the trimmed mean of the contents of the cells in the specified range.

TrimMeanSEM(k,range) computes the standard error of the trimmed mean of the contents of the cells in the specified range.

If k is equal to or larger than 1 then k will be taken as the number of cases to drop at both sides (if k=1 then 2 cases will be dropped in total).

If k is smaller than 1 then k will be taken as a proportion and (n*k/2) cases will be dropped at both sides, so a total of (n*k) cases will be dropped (if k=0.1 then 10% of cases will be dropped).

See Calculation of Trimmed Mean, SE and confidence interval for computational details.

Examples

TrimMean(0.1,A1:A100) calculates the trimmed mean of the data in range A1:A100 with 10% of cases dropped: 5% at the lower side and 5% at the hiher side.

TrimMean(3,A1:A100) calculates the trimmed mean of the data in range A1:A100 with 3 cases dropped at the lower side and 3 cases at the higher side, so a total of 6 cases are dropped.

TrimMeanLow
TrimMeanHigh

TrimMeanLow and TrimMeanHigh calculate the confidence interval of a trimmed mean.

TrimMeanLow(k,ci,range) and TrimMeanHigh(k,ci,range) compute the lower and higher value of the ci% confidence interval of the trimmed mean of the contents of the cells in the specified range.

The confidence interval ci must be given in the range 0..100. A value of 95 will give the values of a 95% confidence interval.

Related functions

This site uses cookies to store information on your computer. More info...