本文整理汇总了PHP中PHPExcel_Calculation_Functions::AVERAGE方法的典型用法代码示例。如果您正苦于以下问题:PHP PHPExcel_Calculation_Functions::AVERAGE方法的具体用法?PHP PHPExcel_Calculation_Functions::AVERAGE怎么用?PHP PHPExcel_Calculation_Functions::AVERAGE使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类PHPExcel_Calculation_Functions
的用法示例。
在下文中一共展示了PHPExcel_Calculation_Functions::AVERAGE方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: KURT
/**
* KURT
*
* Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness
* or flatness of a distribution compared with the normal distribution. Positive
* kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a
* relatively flat distribution.
*
* @param array Data Series
* @return float
*/
public static function KURT()
{
$aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args());
$mean = PHPExcel_Calculation_Functions::AVERAGE($aArgs);
$stdDev = PHPExcel_Calculation_Functions::STDEV($aArgs);
if ($stdDev > 0) {
$count = $summer = 0;
// Loop through arguments
foreach ($aArgs as $arg) {
// Is it a numeric value?
if (is_numeric($arg) && !is_string($arg)) {
$summer += pow(($arg - $mean) / $stdDev, 4);
++$count;
}
}
// Return
if ($count > 3) {
return $summer * ($count * ($count + 1) / (($count - 1) * ($count - 2) * ($count - 3))) - 3 * pow($count - 1, 2) / (($count - 2) * ($count - 3));
}
}
return self::$_errorCodes['divisionbyzero'];
}