Weighted Mean ni1 xiwini1wi This implies that Weighted Mean w1x1w2x2wnxnw1w2wn. For example if you need to find the harmonic mean of 10 12 16 and 8 you might type each of these values into a separate cell in the spreadsheet cells A1-A4. For example to calculate the geometric mean of the values 12 -8 and 2 instead calculate the geometric mean of their decimal multiplier equivalents of 112 092 and 102 to compute a geometric mean of 10167.
Select the cell where the weighted average should go for us thats cell D15 and then type the following formula into the function bar.
STDEVP range of values AVERAGE range of values. Number1 is required subsequent numbers are optional. Explanation GEOMEAN3000033000 returns 314643. Therefore set the.