Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

The normal GEOMEAN function is assuming that all the various numbers are equally weighted, but in this case it's not, so how can I calculate a weighted geometric mean?

share|improve this question

2 Answers 2

I think you can use SUMPRODUCT to calculate a weighted average but I'm not sure how you can do that with a weighted geometric mean.

Assuming values in A1:D1 and weights in A2:D2 try this "array formula"

=PRODUCT(A1:D1^(A2:D2/SUM(A2:D2)))

confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula

if all the values in A2:D2 (the weights) are the same then that formula will give you the same result as

=GEOMEAN(A1:D1)

That formula should give you the same results as the calculator here

Note: you can remove the SUM function if weights sum to 1

share|improve this answer

There's no built-in formula for this, but you can use SUMPRODUCT to assist. See: http://support.microsoft.com/kb/214049

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.