Using each features relative importance as the weight value lets now calculate each phone models weighted average score. Step 4 As the formula for calculating the weighted average suggests now Divide the sum-product with the sum of weights. Step 2 Calculate the SUMPRODUCT ie multiply each value by its weight and then calculate their sum in order to get the sum-product.
Step 4 As the formula for calculating the weighted average suggests now Divide the sum-product with the sum of weights.
Start by selecting the cell where you want the result to. How to calculate weighted average when the weights dont add up to one 1. Therefore all weights should be equal to 100 or 1. Searching for a typical formula for a weighted average yields something like this you multiply each average by a weighting factor that is calculated from the proportion of the impressions they represent then add them together.