Code Duplication    Length = 16-16 lines in 3 locations

src/PhpSpreadsheet/Calculation/MathTrig.php 3 locations

@@ 1340-1355 (lines=16) @@
1337
     *
1338
     * @return float
1339
     */
1340
    public static function SUMX2MY2($matrixData1, $matrixData2)
1341
    {
1342
        $array1 = Functions::flattenArray($matrixData1);
1343
        $array2 = Functions::flattenArray($matrixData2);
1344
        $count = min(count($array1), count($array2));
1345
1346
        $result = 0;
1347
        for ($i = 0; $i < $count; ++$i) {
1348
            if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) &&
1349
                ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) {
1350
                $result += ($array1[$i] * $array1[$i]) - ($array2[$i] * $array2[$i]);
1351
            }
1352
        }
1353
1354
        return $result;
1355
    }
1356
1357
    /**
1358
     * SUMX2PY2.
@@ 1365-1380 (lines=16) @@
1362
     *
1363
     * @return float
1364
     */
1365
    public static function SUMX2PY2($matrixData1, $matrixData2)
1366
    {
1367
        $array1 = Functions::flattenArray($matrixData1);
1368
        $array2 = Functions::flattenArray($matrixData2);
1369
        $count = min(count($array1), count($array2));
1370
1371
        $result = 0;
1372
        for ($i = 0; $i < $count; ++$i) {
1373
            if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) &&
1374
                ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) {
1375
                $result += ($array1[$i] * $array1[$i]) + ($array2[$i] * $array2[$i]);
1376
            }
1377
        }
1378
1379
        return $result;
1380
    }
1381
1382
    /**
1383
     * SUMXMY2.
@@ 1390-1405 (lines=16) @@
1387
     *
1388
     * @return float
1389
     */
1390
    public static function SUMXMY2($matrixData1, $matrixData2)
1391
    {
1392
        $array1 = Functions::flattenArray($matrixData1);
1393
        $array2 = Functions::flattenArray($matrixData2);
1394
        $count = min(count($array1), count($array2));
1395
1396
        $result = 0;
1397
        for ($i = 0; $i < $count; ++$i) {
1398
            if (((is_numeric($array1[$i])) && (!is_string($array1[$i]))) &&
1399
                ((is_numeric($array2[$i])) && (!is_string($array2[$i])))) {
1400
                $result += ($array1[$i] - $array2[$i]) * ($array1[$i] - $array2[$i]);
1401
            }
1402
        }
1403
1404
        return $result;
1405
    }
1406
1407
    /**
1408
     * TRUNC.