/** * GEOMEAN * * Returns the geometric mean of an array or range of positive data. For example, you * can use GEOMEAN to calculate average growth rate given compound interest with * variable rates. * * @param array of mixed Data Series * @return float */ public static function GEOMEAN() { $aMean = PHPExcel_Calculation_Functions::PRODUCT(func_get_args()); if (is_numeric($aMean) && $aMean > 0) { $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args()); $aCount = PHPExcel_Calculation_Functions::COUNT($aArgs); if (PHPExcel_Calculation_Functions::MIN($aArgs) > 0) { return pow($aMean, 1 / $aCount); } } return self::$_errorCodes['num']; }