The basic formula for a weighted average where the weights add up to 1 is x1 w1 x2 w2 x3 w3 and so on where x is each number in your set and w is the corresponding weighting factor. In our school days we used to calculate the average of any range by summing the values first then dividing the same with the total number of values used in sum. Also called the mean average.
So we got the top 3 values as we used the array constant 123 into LARGE for the second argument.
We always divided the numerator by the denominator and multiplied the result by 100 to get the. Later the AVERAGE function returned the average of the values. How do you calculate the annual growth rate in Excel. How to Calculate Averages in Excel.