AVERAGE Top 3 Scores in Microsoft Excel
The main purpose of this formula is to average the top 3 scores in a data set. Here we will learn how to get the average of the top three scores in the data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the AVERAGE and LARGE function, you can able to average the top 3 scores in a data set.
So, with the help of this formula, you can able to get the average of the top three scores in the data range in the workbook in Microsoft Excel.
General Formula to AVERAGE Top 3 Scores
=AVERAGE(LARGE(range,{1,2,3}))
The Explanation for the AVERAGE Top 3 Scores
So we know that with the help of the given formula above, you can able to average the top 3 scores in a data set. Here we will learn how to get the average of the top three scores in the data range in the workbook in Microsoft Excel.
As we know that the LARGE function is designed to retrieve the top nth value from a set of numbers. That implies in the following data set, LARGE(A1:A10,1) will return the highest value, and in this data, LARGE(A1:A10,2) will return the 2nd highest value, and so on.
So, with the help of this formula, you can able to get the average of the top three scores in the data range in the workbook in Microsoft Excel.