Use the AVERAGE function to calculate the average output - Basic Statistical Functions - Microsoft Excel Tutorials

Use the AVERAGE function to calculate the average output using Microsoft Excel

In this example, the output of three production lines has been recorded for several days. Now the average of the three highest outputs of each line has to be calculated. For this task, Excel provides the AVERAGE function, which returns the average, or arithmetic mean, of the arguments.

AVERAGE(number1, number2, ...)

number1, number2, ...: From 1 to 30 numeric arguments for which you want to determine the average. It is also possible to use a cell reference, as shown in this example.

To calculate the average of the three highest capacities of each production line:

1. In cells B2:D10 type the output of each machine.
2. Select cells B13:D13 and type the following formula: =AVERAGE(LARGE(B$2:B$10,1),LARGE(B$2:B$10,2),LARGE(B$2:B$10,3)).
3. Press <-Ctrl+Enter->.

Use the AVERAGE function to calculate the average output

Use the INDEX, MATCH, and LARGE functions to determine and locate the best salesperson - Basic Statistical Function - Microsoft Excel Tutorials

Use the INDEX, MATCH, and LARGE functions to determine and locate the best salesperson using Microsoft Excel

As seen in the previous tips, it is easy to find out the highest value in a list. But how do you find the one person on a sales team who sold the most? And how do you find out how much ahead of the others he or she is?  Start with the LARGE function to determine the highest sale. Then use the INDEX and MATCH functions to retrieve the name of the employee.

To determine and locate the best employee:

1. In cells B2:B10 type the daily sales of the employees.
2. Select cell D3 and type the following formula: =INDEX($A$2:$A$10,MATCH(LARGE($B$2:$B$10,1),$B$2:$B$10,0)).
3. Press <-Enter->.
4. Select cell D6 and type the following formula: =LARGE($B$2:$B$10,1)-LARGE($B$2:$B$10,2).
5. Press <-Enter->.

Use the INDEX MATCH and LARGE functions to determine and locate the best salesperson

Use the LARGE function to find the highest values - Basic Statistical Functions - Microsoft Excel Tutorials

Use the LARGE function to find the highest values using Microsoft Excel

To determine the highest value in a list, we used the MAX function. To find out multiple high values of a range, the LARGE function can be used. This function returns the nth highest value in a set of data.

LARGE(array, n)

array: Array or range of numerical data in which we want to find the nth highest value.
n: The position from the highest in the array or range of data to return.

To determine the three highest values of a range:

1. In cells A2:C10 type any values from 0 to 99.
2. Number cells A12, A13, and A14 with 1, 2, and 3.
3. Select cells B12:D14 and type the following formula:=LARGE(B$2:B$10,$A12).
4. Press <-Ctrl+Enter->.

Use the LARGE function to find the highest values