✨Creating an account only takes 20 seconds, and doesn’t require any personal info.
If you’ve got one already, please log in.🤝
Interquartile mean
The interquartile mean is a type of average (central tendency statistic).
It’s calculated by first discarding data values in the upper and lower quartiles, and then taking the arithmetic mean of the remaining values within the middle quartiles.
For example, a class of English language learners obtain scores of 42, 54, 60, 66, 67, 73, 75, 76, 92, and 95. The interquartile mean of these data is 69.5.
Discarding data from the upper and lower quartiles removes any outliers and includes only inliers. Thus, unlike the arithmetic mean, it is not affected by outliers.
The TRIMMEAN() spreadsheet function can be used to obtain this. It takes two arguments; the array of data and the fraction to be trimmed from the distribution. For an interquartile mean, the fraction to be trimmed is 0.5, because the top 0.25 and bottom 0.25 of values are discarded. So the code will be TRIMMEAN(array, 0.5)
