Excel加权平均计算函数的创建及使用

Creation and Use of Excel weighted Average Calculation Function

摘要:

利用Excel宏创建加权平均计算函数WeightedAverage()，说明了创建方法，给出了函数代码，通过品位加权平均计算说明了WeightedAverage()函数的使用。同时，对于分散分布的数据，介绍了使用Excel “自动筛选”功能进行计算的方法。

Abstract:

By using excel macro, a weighted average calculated function, that is weightedAverage () has been created, creation method has been introduced, and function code has been given. Through grade weighted average calculation, the use of weighted average () has been introduced. At the same time, the calculated method for scatterring data by using excel "AutoFilter function" has been introduced as well.