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->.
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 |
No comments:
Post a Comment