Weighted Average in excel is calculated when we assign each data set with some kind of weights like weightage in statistics or portfolios we use weighted average to calculate more robust and impact observations and calculations the formula for weighted average is very simple which is w1x1w2x2wnxn w1w2wn where w is the weight assigned to the x value and we use sumproduct function to calculate the weighted average. 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. You only calculate the average when the values in the data set count equally.
Whenever there is a sale of goods by two persons to each other on different dates the formula for calculating average due date is text Average due date text Base date pm frac text Total of the products text Total of the amounts Average due date Base date Total of the amountsTotal of the products.
SUMPRODUCTC3C11D3D11SUMD3D11 Press Enter after typing the formula to view the weighted average. In the example shown the formula in G5 copied down is. I need to get the weighted average price by date monthly. On the other hand if year two and year five payments were switched the weighted average life would be much lower.