Skip to main content

GEOMEAN

Returns the geometric mean of positive numeric data.

Syntax

expression.GEOMEAN(args);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

NameRequired/OptionalData typeDefaultDescription
argsRequiredApiRange | number[] | ApiNameUp to 255 numeric values for which the geometric mean will be calculated. Arguments can be numbers, names, ranges, or arrays of numbers.

Returns

number

Example

This example shows how to calculate the geometric mean of positive numeric data.

// How to find the geometric mean.

// Use a function to calculate the geometric mean of positive numeric data.

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
let ans = func.GEOMEAN(28, 16, 878, 800, 1650, 2000);
worksheet.GetRange("B2").SetValue(ans);