Trimmed Mean spreadsheet functions on variables

VTrimMean
VTrimMeanSEM

Description

VTrimMean and VTrimMeanSEM calculate a trimmed mean and the standard error of a trimmed mean.

VTrimMean(k,variable[,filter]) computes the trimmed mean of a variable.

VTrimMeanSEM(k,variable[,filter]) computes the standard error of the trimmed mean of a variable.

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).

Examples

VTrimMean(0.1,Systolic) calculates the trimmed mean of the data for variable Systolic with 10% of cases dropped: 5% at the lower side and 5% at the hiher side.

VTrimMean(3,Systolic) calculates the trimmed mean of the data for variable Systolic with 3 cases dropped at the lower side and 3 cases at the higher side, so a total of 6 cases are dropped.

VTrimMeanLow
VTrimMeanHigh

VTrimMeanLow and VTrimMeanHigh calculate the confidence interval of a trimmed mean of a variable.

VTrimMeanLow(k,ci,variable[,filter]) and VTrimMeanHigh(k,ci,variable[,filter]) compute the lower and higher value of the ci% confidence interval of the trimmed mean of a variable.

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.

Note

This function calculates a statistic on a variable. Be careful when you use this function in cells of the columns that correspond to the variable, because this actually adds a value to the variable which can lead to unexpected and faulty results. You can exclude the cell to avoid this.

Related functions