Post Reply 
(12C) Geometric Mean with Percentage
07-13-2024, 07:08 PM
Post: #2
RE: (12C) Geometric Mean with Percentage
You could just add 100 to the percentages, calculate the geometric mean and subtract 100 from the result.

Also the logarithm could be used to translate the geometric to the arithmetic mean:

\(
\log(\sqrt{x \cdot y}) = \frac{\log{x} + \log{y}}{2}
\)

This program enters the data:
Code:
01-       26 : EEX
02-        2 : 2
03-       40 : +
04-    43 23 : g LN
05-       49 : Σ+

To calculate the geometric mean use:
Code:
01-    43  0 : g x̄
02-    43 22 : g eˣ
03-       26 : EEX
04-        2 : 2
05-       30 : -
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: (12C) Geometric Mean with Percentage - Thomas Klemm - 07-13-2024 07:08 PM



User(s) browsing this thread: 2 Guest(s)