To calculate a weighted average in Excel, simply use SUMPRODUCT and SUM.1. First, the AVERAGE function below calculates the normal average of three scores....

## how to calculate weighted average

To calculate a weighted average in Excel, simply use SUMPRODUCT and SUM.1. First, the AVERAGE function below calculates the normal average of three scores....