Question 1: The definition and formula of geometric mean refer to the nth root of the product of n observations. According to the different data, the geometric mean can be weighted or unweighted. Let a set of data be X 1, X2, …, Xn, all greater than 0, then the geometric average Xg is: When calculating the average development speed, the most commonly used formula is:

Question 2: Is there a formula of geometric mean in Excel = geomean (b 12: B45), that is, find the geometric mean from b12 to b45 (positive number is required)?

Question 3: What are arithmetic mean, geometric mean and median? What is its scope of application? Geometric mean refers to the n-th square root of the product of n observations. According to the different data, the geometric mean can be weighted or unweighted.

Arithmetic average is the arithmetic average of all data, also known as average, and the symbol is m (average). Arithmetic average is the main measure of concentration trend, which plays an important role in statistics and is the basis of statistical analysis and inference. Mainly suitable for numerical data, not for quality data. According to different forms of expression, there are different calculation situations and formulas for arithmetic average.

Median (also called median, English: median), a proper term in statistics, represents a numerical value in a sample, population or probability distribution, and can divide the numerical value * * * into equal upper and lower parts. For a finite set of numbers, we can sort all the observed values and find the middle one as the median. If there are even numbers of observations, the average of the middle two values is usually taken as the median.