Weighted average of assessment results
This example shows how to calculate a weighted average of multiple test results, using the Excel SUMPRODUCT and SUM functions
Example: Weighted average of assessment results
|
=SUMPRODUCT(C5:C9,D5:D9)/SUM(D5:D9)
|
This formula uses a combination of Excel SUMPRODUCT and SUM functions to calculate the weighted average of the five test results, in rage (C5:C9), weighted against their individual weights, in range (D5:D9). Using this formula we don't need to individually calculate the weighted amounts of each test and then sum them, it calculates all of this.
|
EXPLANATION
This example shows how to calculate a weighted average of multiple test results. The formula use a combination of the Excel SUMPRODUCT and SUM functions.
This example shows how to calculate a weighted average of multiple test results. The formula use a combination of the Excel SUMPRODUCT and SUM functions.
FORMULA
=SUMPRODUCT(assessment_results,weights)/SUM(weights)
=SUMPRODUCT(assessment_results,weights)/SUM(weights)
ARGUMENTS
assessment_results: The assessment results that you want to assign a specific weight to.
weights: The weights that are assigned to each assessment.
assessment_results: The assessment results that you want to assign a specific weight to.
weights: The weights that are assigned to each assessment.
APPLICATION
The calculation of a weighted average against multiple assessments results that is shown in this example can be applied to an educational environment. Educational institutions such as Universities, Colleges, High Schools and others can apply this example if they want to calculate a weighted average of assessment results.
The calculation of a weighted average against multiple assessments results that is shown in this example can be applied to an educational environment. Educational institutions such as Universities, Colleges, High Schools and others can apply this example if they want to calculate a weighted average of assessment results.