GEOMEAN function - The function returns the average of a positive array or range of data in Excel

The following article introduces you to GEOMEAN functions - one of the functions in the statistical function group is very popular in Excel.

GEOMEAN function - The function returns the average of a positive array or range of data in Excel Picture 1

Description: The function returns the kernel average of a positive data range or range. Use the function to calculate the average growth when knowing the gross profit with variable interest rates.

 Syntax: GEOMEAN (number1, [number2], .)

Inside:

- number1, number2, .: The value you want to calculate the standardized overall probability, where number1 is the required parameter, other parameters are optional and contain up to 255 number parameters .

Attention:

- Parameter values ​​can be numbers, names or arrays of references.

- If the logical values, the text is entered directly into the function -> these values ​​are still counted

- If the argument is a reference or an array containing logical values, text or blank cells -> the function ignores these values.

- If any value of number ≤ 0 -> the function returns the #NUM! Error value

- Arguments that are text or error values ​​cannot be converted into numbers -> error function

- GEOMEAN function calculated based on the equation:

[G {M_ {bar y}} = sqrt [n] {{{y_1} {y_2} {y_3} . {y_n}}}]

For example:

Calculate the average of the values ​​in the data table below:

GEOMEAN function - The function returns the average of a positive array or range of data in Excel Picture 2

- In the cell to calculate enter the formula : = GEOMEAN (D6: D10)

GEOMEAN function - The function returns the average of a positive array or range of data in Excel Picture 3

- Press Enter -> The average of the values ​​is:

GEOMEAN function - The function returns the average of a positive array or range of data in Excel Picture 4

- Where the value of number ≤ 0 -> the function returns the #NUM! Error value

GEOMEAN function - The function returns the average of a positive array or range of data in Excel Picture 5

- Where number is a logical value or text -> the function ignores those values.

GEOMEAN function - The function returns the average of a positive array or range of data in Excel Picture 6

Above are instructions and some specific examples when using GEOMEAN function in Excel.

Good luck!