PHPOffice /
PhpSpreadsheet
| @@ 1400-1415 (lines=16) @@ | ||
| 1397 | * |
|
| 1398 | * @return float |
|
| 1399 | */ |
|
| 1400 | public static function SUMX2MY2($matrixData1, $matrixData2) |
|
| 1401 | { |
|
| 1402 | $array1 = Functions::flattenArray($matrixData1); |
|
| 1403 | $array2 = Functions::flattenArray($matrixData2); |
|
| 1404 | $count = min(count($array1), count($array2)); |
|
| 1405 | ||
| 1406 | $result = 0; |
|
| 1407 | for ($i = 0; $i < $count; ++$i) { |
|
| 1408 | if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) && |
|
| 1409 | ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) { |
|
| 1410 | $result += ($array1[$i] * $array1[$i]) - ($array2[$i] * $array2[$i]); |
|
| 1411 | } |
|
| 1412 | } |
|
| 1413 | ||
| 1414 | return $result; |
|
| 1415 | } |
|
| 1416 | ||
| 1417 | /** |
|
| 1418 | * SUMX2PY2. |
|
| @@ 1425-1440 (lines=16) @@ | ||
| 1422 | * |
|
| 1423 | * @return float |
|
| 1424 | */ |
|
| 1425 | public static function SUMX2PY2($matrixData1, $matrixData2) |
|
| 1426 | { |
|
| 1427 | $array1 = Functions::flattenArray($matrixData1); |
|
| 1428 | $array2 = Functions::flattenArray($matrixData2); |
|
| 1429 | $count = min(count($array1), count($array2)); |
|
| 1430 | ||
| 1431 | $result = 0; |
|
| 1432 | for ($i = 0; $i < $count; ++$i) { |
|
| 1433 | if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) && |
|
| 1434 | ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) { |
|
| 1435 | $result += ($array1[$i] * $array1[$i]) + ($array2[$i] * $array2[$i]); |
|
| 1436 | } |
|
| 1437 | } |
|
| 1438 | ||
| 1439 | return $result; |
|
| 1440 | } |
|
| 1441 | ||
| 1442 | /** |
|
| 1443 | * SUMXMY2. |
|
| @@ 1450-1465 (lines=16) @@ | ||
| 1447 | * |
|
| 1448 | * @return float |
|
| 1449 | */ |
|
| 1450 | public static function SUMXMY2($matrixData1, $matrixData2) |
|
| 1451 | { |
|
| 1452 | $array1 = Functions::flattenArray($matrixData1); |
|
| 1453 | $array2 = Functions::flattenArray($matrixData2); |
|
| 1454 | $count = min(count($array1), count($array2)); |
|
| 1455 | ||
| 1456 | $result = 0; |
|
| 1457 | for ($i = 0; $i < $count; ++$i) { |
|
| 1458 | if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) && |
|
| 1459 | ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) { |
|
| 1460 | $result += ($array1[$i] - $array2[$i]) * ($array1[$i] - $array2[$i]); |
|
| 1461 | } |
|
| 1462 | } |
|
| 1463 | ||
| 1464 | return $result; |
|
| 1465 | } |
|
| 1466 | ||
| 1467 | /** |
|
| 1468 | * TRUNC. |
|
