Three Major and Three Minor Averages Calculation
Excel file teaching how to perform Calculating Three Largest and Three Smallest Average operation.
Excel Source: Three Major and Three Minor Averages Calculation
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.