PHPOffice /
PhpSpreadsheet
| @@ 1909-1919 (lines=11) @@ | ||
| 1906 | if ($stdDev > 0) { |
|
| 1907 | $count = $summer = 0; |
|
| 1908 | // Loop through arguments |
|
| 1909 | foreach ($aArgs as $k => $arg) { |
|
| 1910 | if ((is_bool($arg)) && |
|
| 1911 | (!Functions::isMatrixValue($k))) { |
|
| 1912 | } else { |
|
| 1913 | // Is it a numeric value? |
|
| 1914 | if ((is_numeric($arg)) && (!is_string($arg))) { |
|
| 1915 | $summer += pow((($arg - $mean) / $stdDev), 4); |
|
| 1916 | ++$count; |
|
| 1917 | } |
|
| 1918 | } |
|
| 1919 | } |
|
| 1920 | ||
| 1921 | // Return |
|
| 1922 | if ($count > 3) { |
|
| @@ 2903-2913 (lines=11) @@ | ||
| 2900 | ||
| 2901 | $count = $summer = 0; |
|
| 2902 | // Loop through arguments |
|
| 2903 | foreach ($aArgs as $k => $arg) { |
|
| 2904 | if ((is_bool($arg)) && |
|
| 2905 | (!Functions::isMatrixValue($k))) { |
|
| 2906 | } else { |
|
| 2907 | // Is it a numeric value? |
|
| 2908 | if ((is_numeric($arg)) && (!is_string($arg))) { |
|
| 2909 | $summer += pow((($arg - $mean) / $stdDev), 3); |
|
| 2910 | ++$count; |
|
| 2911 | } |
|
| 2912 | } |
|
| 2913 | } |
|
| 2914 | ||
| 2915 | if ($count > 2) { |
|
| 2916 | return $summer * ($count / (($count - 1) * ($count - 2))); |
|
