Calculating Three Largest and Three Smallest Average

Excel file teaching how to perform Calculating Three Largest and Three Smallest Average operation.

Excel Source: Calculating Three Largest and Three Smallest Average

Data distribution is analyzed using Excel's MAX and MIN functions. This study demonstrates the effect of extreme outliers on the mean. Users can automate this calculation using dynamic ranges. Particularly useful results are obtained in performance or sales analyses.

Hope it is useful.