PHPOffice /
PhpSpreadsheet
| @@ 1324-1339 (lines=16) @@ | ||
| 1321 | * @param mixed[] $matrixData2 Matrix #2 |
|
| 1322 | * @return float |
|
| 1323 | */ |
|
| 1324 | public static function SUMX2MY2($matrixData1, $matrixData2) |
|
| 1325 | { |
|
| 1326 | $array1 = Functions::flattenArray($matrixData1); |
|
| 1327 | $array2 = Functions::flattenArray($matrixData2); |
|
| 1328 | $count = min(count($array1), count($array2)); |
|
| 1329 | ||
| 1330 | $result = 0; |
|
| 1331 | for ($i = 0; $i < $count; ++$i) { |
|
| 1332 | if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) && |
|
| 1333 | ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) { |
|
| 1334 | $result += ($array1[$i] * $array1[$i]) - ($array2[$i] * $array2[$i]); |
|
| 1335 | } |
|
| 1336 | } |
|
| 1337 | ||
| 1338 | return $result; |
|
| 1339 | } |
|
| 1340 | ||
| 1341 | /** |
|
| 1342 | * SUMX2PY2 |
|
| @@ 1348-1363 (lines=16) @@ | ||
| 1345 | * @param mixed[] $matrixData2 Matrix #2 |
|
| 1346 | * @return float |
|
| 1347 | */ |
|
| 1348 | public static function SUMX2PY2($matrixData1, $matrixData2) |
|
| 1349 | { |
|
| 1350 | $array1 = Functions::flattenArray($matrixData1); |
|
| 1351 | $array2 = Functions::flattenArray($matrixData2); |
|
| 1352 | $count = min(count($array1), count($array2)); |
|
| 1353 | ||
| 1354 | $result = 0; |
|
| 1355 | for ($i = 0; $i < $count; ++$i) { |
|
| 1356 | if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) && |
|
| 1357 | ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) { |
|
| 1358 | $result += ($array1[$i] * $array1[$i]) + ($array2[$i] * $array2[$i]); |
|
| 1359 | } |
|
| 1360 | } |
|
| 1361 | ||
| 1362 | return $result; |
|
| 1363 | } |
|
| 1364 | ||
| 1365 | /** |
|
| 1366 | * SUMXMY2 |
|
| @@ 1372-1387 (lines=16) @@ | ||
| 1369 | * @param mixed[] $matrixData2 Matrix #2 |
|
| 1370 | * @return float |
|
| 1371 | */ |
|
| 1372 | public static function SUMXMY2($matrixData1, $matrixData2) |
|
| 1373 | { |
|
| 1374 | $array1 = Functions::flattenArray($matrixData1); |
|
| 1375 | $array2 = Functions::flattenArray($matrixData2); |
|
| 1376 | $count = min(count($array1), count($array2)); |
|
| 1377 | ||
| 1378 | $result = 0; |
|
| 1379 | for ($i = 0; $i < $count; ++$i) { |
|
| 1380 | if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) && |
|
| 1381 | ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) { |
|
| 1382 | $result += ($array1[$i] - $array2[$i]) * ($array1[$i] - $array2[$i]); |
|
| 1383 | } |
|
| 1384 | } |
|
| 1385 | ||
| 1386 | return $result; |
|
| 1387 | } |
|
| 1388 | ||
| 1389 | /** |
|
| 1390 | * TRUNC |
|
