加权平均值与平均值_如何在Excel中计算加权平均值

加权平均值与平均值

A weighted average is one that takes into account the importance, or weight, of each value. This article will show you how to use Excel’s SUMPRODUCT and SUM functions individually and how to combine the two to calculate a weighted average.

加权平均值是考虑到每个值的重要性或权重的平均值。 本文将向您展示如何分别使用Excel的SUMPRODUCT和SUM函数，以及如何将两者结合起来以计算加权平均值。

什么是加权平均值？ (What is a Weighted Average?)

A weighted average is an average that takes into account the importance, or weight, of each value.  A good example would be calculating a student’s final grade based on their performance on a variety of different assignments and tests. Individual assignments usually don’t count as much towards a final grade as the final exam—things like quizzes, tests, and final exams will all have different weights. The weighted average is calculated as the sum of all of the values multiplied by their weights divided by the sum of all of the weights.

加权平均值是考虑每个值的重要性或权重的平均值。 一个很好的例子是根据学生在各种不同的作业和测验中的表现来计算他们的最终成绩。 通常，个人作业对期末成绩的重视程度不及期末考试的重要程度，例如测验，测试和期末考试的权重都不同。 加权平均值计算为所有值的总和乘以其权重再除以所有权重的总和。

The following example will demonstrate how to use Excel’s SUMPRODUCT and SUM functions to calculate a weighted average.

下面的示例将演示如何使用Excel的SUMPRODUCT和SUM函数来计算加权平均值。

让我们看一个例子 (Let’s Look