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

Creation and Use of Excel weighted Average Calculation Function

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

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.