The geometric mean is not usually defined with negative numers because the nth root of a negative number product including an odd number of negatives is a complex number involving the imaginary number iSQRT -1. For example population growth for first year is 30 for second year is 25 and for third year it is 15. The numbers either all positive or all negative must be separated by commas or spaces or they may be entered on separate linesThe population or sample option selector is only used for calculating the variance or standard.
Geometric Mean X 1 X 2 X 3.
The general formula for the geometric mean of n numbers is the nth root of their product. Geometric mean work-around 10000 x 1 10000 x 2 10000 x n n 10000 This moves all data values out off the negative zone performs the operation and then moves the result back down again. 1 to 255 arguments for which you want to calculate the mean. Another way to calculate the geometric mean is with logarithms as it is also the average of logarithmic values converted back to base 10.