Statistics
Find a geometric mean
=GEOMEAN(B2:B3)How it works in Excel
- B2:B3 is your data.
- It multiplies the numbers and takes the matching root.
- All values must be positive.
- For returns, use 1 plus each return, then subtract 1 from the answer.
The idea in general
It is the right average for things that compound, like growth rates.
What I assumed
- Your numbers are in B2:B3.
Check the result on your own data before relying on it.