The first step in calculating the Geometric Mean using this method is to determine the logarithm of each data point using your calculator. How you calculate the geometric mean is rather easyyou use the GEOMEAN function built into Excel. The place that a geometric mean is most often used and therefore a geometric standard deviation is when calculating investment returns over time especially when the returns involve compound interest.
Hey guys welcome to learning attitude in this video i am going to share the simple method that you can used for calculating geometric mean in this you dont.
The place that a geometric mean is most often used and therefore a geometric standard deviation is when calculating investment returns over time especially when the returns involve compound interest. To compute the geometric mean and geometric CV you can use the DISTLOGNORMAL option on the PROC TTEST statement as follows. If the logarithms in step 1 are common base 10 logs then the geometric mean in step 3 is computed by taking 10. 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.