Excel removes the highest score and the lowest score and calculates the average

Computers have become a standard configuration for modern work, so office software is also a basic operation that needs to be mastered at work. With the development of technology, the functions of office software are becoming increasingly powerful. Excel is often used in practical work due to its powerful functions. As a data display, Excel is clear and intuitive. As a calculation software, Excel is convenient and accurate. Excel can perform sums, summarization, and average calculations. Today we will teach you how to remove the highest score and the lowest score in Excel and calculate the average.

After opening the form, I found that the highest score in the table was 100 points and the lowest score was 66 points. Therefore, we need to calculate the average of the other scores except these two scores.

#2. Click the function icon (as shown below).

3. Use the TRIMMEAN function.

#4. This function is to find the average value after removing the highest value. Here, select all the scores in the value area and enter 2/6 for the percentage. There are a total of 6 people's scores, and there are 2 people with the highest score and the lowest score.

5. Enter the formula =TRIMMEAN(B2:B7,2/6), press the Enter key, and the calculation result will appear.

The editor taught you how to remove the highest score and the lowest score in Excel and find the average. This is an upgrade operation for finding the average. We are doing this operation. It is often used when scoring in competitions. The average score calculated by this method is more fair. There are more operations in excel that require us to dig and learn carefully in actual work. Computer novices should study each item carefully. Calculate energy.

The above is the detailed content of Excel removes the highest score and the lowest score and calculates the average. For more information, please follow other related articles on the PHP Chinese website!