Use Excel to remove the highest and lowest number. I think it is good to see it on the Internet.

At the end of each year, the school will select outstanding employees. It is inevitable to score all faculty members and use the scores as the basis for evaluation. Use Excel to enter scores one by one. In addition, you must remove the highest and lowest scores from the scores, and then obtain the average score of the remaining scores as the final result. The general practice is to sort the scores of each person separately, delete the highest and lowest scores in proportion, and then obtain the average score of the remaining scores. This method is too troublesome for schools with more than 300 faculty members. The trimmean function can be used in one step.

The following describes how to calculate the scores of the four faculty members (1). The serial number is the number of votes to be scored. If you want to calculate the scores of the faculty members Zhang, Wang, Li, and Liu, if you want to remove the 10% of the highest and lowest votes, you only need to enter "= trimmean (B2: b11, 0.2) ", indicating the final average score of Zhang xx. You can drag other filling handles. Among them, 0.2 indicates that each of the highest scores is removed by 10%, and a total of 20% (that is, 0.2) is removed ).