You are here

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

private static function PHPExcel_Calculation_Statistical::_checkTrendArrays 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::_checkTrendArrays()
9 calls to PHPExcel_Calculation_Statistical::_checkTrendArrays()
PHPExcel_Calculation_Statistical::CORREL in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* CORREL * * Returns covariance, the average of the products of deviations for each data point pair. * *
PHPExcel_Calculation_Statistical::COVAR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* COVAR * * Returns covariance, the average of the products of deviations for each data point pair. * *
PHPExcel_Calculation_Statistical::FORECAST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* FORECAST * * Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. * *
PHPExcel_Calculation_Statistical::INTERCEPT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* INTERCEPT * * Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. * *
PHPExcel_Calculation_Statistical::LINEST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* LINEST * * Calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, * and then returns an array that describes the line. * *

... See full list

File

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

Class

PHPExcel_Calculation_Statistical
PHPExcel_Calculation_Statistical

Code

private static function _checkTrendArrays(&$array1, &$array2) {
  if (!is_array($array1)) {
    $array1 = array(
      $array1,
    );
  }
  if (!is_array($array2)) {
    $array2 = array(
      $array2,
    );
  }
  $array1 = PHPExcel_Calculation_Functions::flattenArray($array1);
  $array2 = PHPExcel_Calculation_Functions::flattenArray($array2);
  foreach ($array1 as $key => $value) {
    if (is_bool($value) || is_string($value) || is_null($value)) {
      unset($array1[$key]);
      unset($array2[$key]);
    }
  }
  foreach ($array2 as $key => $value) {
    if (is_bool($value) || is_string($value) || is_null($value)) {
      unset($array1[$key]);
      unset($array2[$key]);
    }
  }
  $array1 = array_merge($array1);
  $array2 = array_merge($array2);
  return True;
}