The LOG function takes a value out of base-10 and determines how many times you need to multiply 10 together to equal that value. In Microsoft Excel the mean can be calculated by using one of the following functions. AVERAGEIF - finds an average of numbers based on a single criterion.
To get the Geometric Mean it is not so straight forward.
We will calculate the geometric mean for the sales of year the 2018 and 2019 in figure 2. However the actual formula and definition of the geometric mean is that it is the n-th root of the product of n numbers or. Geometric Mean Return Formula. How you calculate the geometric mean is rather easy-you use the GEOMEAN function built into Excel.