public static function PHPExcel_Calculation_Statistical::FISHERINV 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::FISHERINV()

* FISHERINV * * Returns the inverse of the Fisher transformation. Use this transformation when * analyzing correlations between ranges or arrays of data. If y = FISHER(x), then * FISHERINV(y) = x. * *

Parameters

float $value: * @return float

File

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

Class

PHPExcel_Calculation_Statistical

PHPExcel_Calculation_Statistical

Code

public static function FISHERINV($value) {
  $value = PHPExcel_Calculation_Functions::flattenSingleValue($value);
  if (is_numeric($value)) {
    return (exp(2 * $value) - 1) / (exp(2 * $value) + 1);
  }
  return PHPExcel_Calculation_Functions::VALUE();
}