Suppose your teacher says The test counts twice as much as the quiz and the final exam counts three times as much as the quiz. How to calculate SQL moving average. Since the weight of all grades are equal we can calculate these grades with simple average or we can cound how many times each grade apear and use weighted average.
To calculate weighted average a predetermined weight is assigned to each number.
It has two parts. Since the weight of all grades are equal we can calculate these grades with simple average or we can cound how many times each grade apear and use weighted average. First the AVERAGE function below calculates the normal average of three scores. This means that for each midterm which is worth 15 percent the percentage is divided by 100 to yield 015.