public static function PHPExcel_Calculation_Statistical::STDEV in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php \PHPExcel_Calculation_Statistical::STDEV()

* STDEV * * Estimates standard deviation based on a sample. The standard deviation is a measure of how * widely values are dispersed from the average value (the mean). * * Excel Function: * STDEV(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *

Parameters

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

5 calls to PHPExcel_Calculation_Statistical::STDEV()

PHPExcel_Calculation_Database::DSTDEV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Database.php

* DSTDEV * * Estimates the standard deviation of a population based on a sample by using the numbers in a * column of a list or database that match conditions that you specify. * * Excel Function: * DSTDEV(database,field,criteria) * *…

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::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…

PHPExcel_Calculation_Statistical::SKEW in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php

* SKEW * * Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry * of a distribution around its mean. Positive skewness indicates a distribution with an * asymmetric tail extending toward more positive values.…

PHPExcel_Calculation_Statistical::ZTEST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php

* ZTEST * * Returns the Weibull distribution. Use this distribution in reliability * analysis, such as calculating a device's mean time to failure. * *

File

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

Class

PHPExcel_Calculation_Statistical

PHPExcel_Calculation_Statistical

Code

public static function STDEV() {
  $aArgs = PHPExcel_Calculation_Functions::flattenArrayIndexed(func_get_args());

  // Return value
  $returnValue = null;
  $aMean = self::AVERAGE($aArgs);
  if (!is_null($aMean)) {
    $aCount = -1;
    foreach ($aArgs 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 = pow($arg - $aMean, 2);
        }
        else {
          $returnValue += pow($arg - $aMean, 2);
        }
        ++$aCount;
      }
    }

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