You are here

Home » API reference » Loft Data Grids 7.2 » Statistical.php » PHPExcel_Calculation_Statistical

public static function PHPExcel_Calculation_Statistical::AVERAGE in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php \PHPExcel_Calculation_Statistical::AVERAGE()

* AVERAGE * * Returns the average (arithmetic mean) of the arguments * * Excel Function: * AVERAGE(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *

Parameters

mixed $arg,... Data values: * @return float

10 calls to PHPExcel_Calculation_Statistical::AVERAGE()
PHPExcel_Calculation_Database::DAVERAGE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Database.php
* DAVERAGE * * Averages the values in a column of a list or database that match conditions you specify. * * Excel Function: * DAVERAGE(database,field,criteria) * * @access public * @category Database Functions *
PHPExcel_Calculation_MathTrig::SUBTOTAL in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* SUBTOTAL * * Returns a subtotal in a list or database. * *
PHPExcel_Calculation_Statistical::AVEDEV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* AVEDEV * * Returns the average of the absolute deviations of data points from their mean. * AVEDEV is a measure of the variability in a data set. * * Excel Function: * AVEDEV(value1[,value2[, ...]]) * * @access public * @category…
PHPExcel_Calculation_Statistical::DEVSQ in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* DEVSQ * * Returns the sum of squares of deviations of data points from their sample mean. * * Excel Function: * DEVSQ(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *
PHPExcel_Calculation_Statistical::KURT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* 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…

... See full list

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php, line 748

Class

PHPExcel_Calculation_Statistical
PHPExcel_Calculation_Statistical

Code

public static function AVERAGE() {
  $returnValue = $aCount = 0;

  // Loop through arguments
  foreach (PHPExcel_Calculation_Functions::flattenArrayIndexed(func_get_args()) as $k => $arg) {
    if (is_bool($arg) && (!PHPExcel_Calculation_Functions::isCellValue($k) || PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE)) {
      $arg = (int) $arg;
    }

    // Is it a numeric value?
    if (is_numeric($arg) && !is_string($arg)) {
      if (is_null($returnValue)) {
        $returnValue = $arg;
      }
      else {
        $returnValue += $arg;
      }
      ++$aCount;
    }
  }

  // Return
  if ($aCount > 0) {
    return $returnValue / $aCount;
  }
  else {
    return PHPExcel_Calculation_Functions::DIV0();
  }
}