Hi Everyone,
I am currently trying to create a formula which calculates the Weighted Variance % between two data sets in excel. Thus far, I have the total units and the the weighted percentages of the respective numbers. With these inputs, I have been able to calculate the weighted mean for each of the datasets by using the formula: Sumproduct (A3:A9,B3:B9)/Sum(B3:B9), with the same formula being used for the data set below. However, I am having a difficulty creating a formula which calculates the % Weighted Variance between these two figures. Any help would be greatly appreciated. Thank You!
I am currently trying to create a formula which calculates the Weighted Variance % between two data sets in excel. Thus far, I have the total units and the the weighted percentages of the respective numbers. With these inputs, I have been able to calculate the weighted mean for each of the datasets by using the formula: Sumproduct (A3:A9,B3:B9)/Sum(B3:B9), with the same formula being used for the data set below. However, I am having a difficulty creating a formula which calculates the % Weighted Variance between these two figures. Any help would be greatly appreciated. Thank You!