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