PHPOffice /
PhpSpreadsheet
| @@ 1377-1392 (lines=16) @@ | ||
| 1374 | * |
|
| 1375 | * @return float |
|
| 1376 | */ |
|
| 1377 | public static function SUMX2MY2($matrixData1, $matrixData2) |
|
| 1378 | { |
|
| 1379 | $array1 = Functions::flattenArray($matrixData1); |
|
| 1380 | $array2 = Functions::flattenArray($matrixData2); |
|
| 1381 | $count = min(count($array1), count($array2)); |
|
| 1382 | ||
| 1383 | $result = 0; |
|
| 1384 | for ($i = 0; $i < $count; ++$i) { |
|
| 1385 | if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) && |
|
| 1386 | ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) { |
|
| 1387 | $result += ($array1[$i] * $array1[$i]) - ($array2[$i] * $array2[$i]); |
|
| 1388 | } |
|
| 1389 | } |
|
| 1390 | ||
| 1391 | return $result; |
|
| 1392 | } |
|
| 1393 | ||
| 1394 | /** |
|
| 1395 | * SUMX2PY2. |
|
| @@ 1402-1417 (lines=16) @@ | ||
| 1399 | * |
|
| 1400 | * @return float |
|
| 1401 | */ |
|
| 1402 | public static function SUMX2PY2($matrixData1, $matrixData2) |
|
| 1403 | { |
|
| 1404 | $array1 = Functions::flattenArray($matrixData1); |
|
| 1405 | $array2 = Functions::flattenArray($matrixData2); |
|
| 1406 | $count = min(count($array1), count($array2)); |
|
| 1407 | ||
| 1408 | $result = 0; |
|
| 1409 | for ($i = 0; $i < $count; ++$i) { |
|
| 1410 | if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) && |
|
| 1411 | ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) { |
|
| 1412 | $result += ($array1[$i] * $array1[$i]) + ($array2[$i] * $array2[$i]); |
|
| 1413 | } |
|
| 1414 | } |
|
| 1415 | ||
| 1416 | return $result; |
|
| 1417 | } |
|
| 1418 | ||
| 1419 | /** |
|
| 1420 | * SUMXMY2. |
|
| @@ 1427-1442 (lines=16) @@ | ||
| 1424 | * |
|
| 1425 | * @return float |
|
| 1426 | */ |
|
| 1427 | public static function SUMXMY2($matrixData1, $matrixData2) |
|
| 1428 | { |
|
| 1429 | $array1 = Functions::flattenArray($matrixData1); |
|
| 1430 | $array2 = Functions::flattenArray($matrixData2); |
|
| 1431 | $count = min(count($array1), count($array2)); |
|
| 1432 | ||
| 1433 | $result = 0; |
|
| 1434 | for ($i = 0; $i < $count; ++$i) { |
|
| 1435 | if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) && |
|
| 1436 | ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) { |
|
| 1437 | $result += ($array1[$i] - $array2[$i]) * ($array1[$i] - $array2[$i]); |
|
| 1438 | } |
|
| 1439 | } |
|
| 1440 | ||
| 1441 | return $result; |
|
| 1442 | } |
|
| 1443 | ||
| 1444 | /** |
|
| 1445 | * TRUNC. |
|
