Browse » Home
Thursday, April 18, 2013
How to Find the Weighted Mean in Excel 2007
1. Input your data points into column A in your Excel 2007 worksheet, one number per cell. For example, you might input the numbers 90, 86, 45, 67, 78, 76, 79, 82.
2. Input the weight of each of the numbers in column B. The weight of each number should sit directly to the right of the number. The weights you choose do not matter, they are only meaningful relative to each other. For example, if a data point has a weight of 1 and another point has a weight of 2, the second point will be twice as important to the mean, but if both data points have a weight of 2, they will be identically important. The weights might be 1, 1.5, 2, 1.25, 3.6, 4, 2, 1.
3. Write '=A1*B1' (without quotes) in cell C1.
4. Left-click cell C1 to highlight it, then press 'Ctrl C' to copy it.
5. Highlight column C by clicking the letter 'C' above the column, then paste the formula by pressing 'Ctrl V.'
6. Type '=SUM(C:C:) / SUM(B:B)' (without quotes) in cell D1 to find the weighted average. In the example, the weighted average is 74.47 (rounded).