xny/vendor/phpoffice/phpspreadsheet/tests/data/Calculation/Statistical/LINEST.php

<?php

use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;

return [
    [
        [1.0, 0.0],
        [1, 2, 3, 4, 5],
        [1, 2, 3, 4, 5],
        false,
        false,
    ],
    [
        [2.310344827586207, 0.0],
        [1, 9, 5, 7],
        [0, 4, 2, 3],
        false,
        false,
    ],
    [
        [2.0, 1.0],
        [1, 9, 5, 7],
        [0, 4, 2, 3],
        true,
        false,
    ],
    [
        [0.600378787879, 0.0],
        [3, 10, 3, 6, 8, 12, 1, 4, 9, 14],
        [8, 2, 11, 6, 5, 4, 12, 9, 6, 1],
        false,
        false,
    ],
    [
        [-1.1064189189190, 14.081081081081],
        [3, 10, 3, 6, 8, 12, 1, 4, 9, 14],
        [8, 2, 11, 6, 5, 4, 12, 9, 6, 1],
        true,
        false,
    ],
    [
        [
            [0.600378787879, 0.0],
            [0.3130441135917, ExcelError::NA()],
            [0.2901220667036, 7.193206086629],
            [3.6782360429317, 9],
            [190.3200757575760, 465.679924242424],
        ],
        [3, 10, 3, 6, 8, 12, 1, 4, 9, 14],
        [8, 2, 11, 6, 5, 4, 12, 9, 6, 1],
        false,
        true,
    ],
    [
        [
            [-1.1064189189190, 14.081081081081],
            [0.1491074289251, 1.083468383961],
            [0.8731378215565, 1.622464237727],
            [55.0605598780781, 8],
            [144.9408783783780, 21.059121621622],
        ],
        [3, 10, 3, 6, 8, 12, 1, 4, 9, 14],
        [8, 2, 11, 6, 5, 4, 12, 9, 6, 1],
        true,
        true,
    ],
    [
        [
            [56.837944664032, 11704.347826086974],
            [54.403741747077, 131988.39973671117],
            [0.108159322123, 13123.598915116556],
            [1.091488562082, 9],
            [187985818.1818185, 1550059636.363636],
        ],
        [142000, 144000, 151000, 150000, 139000, 169000, 126000, 142900, 163000, 169000, 149000],
        [2310, 2333, 2356, 2379, 2402, 2425, 2448, 2471, 2494, 2517, 2540],
        true,
        true,
    ],
    //        'multi-series' => [
    //            [
    //                [-234.2371645, 2553.21066, 12529.76817, 27.64138737, 52317.83051],
    //                [13.26801148, 530.6691519, 400.0668382, 5.429374042, 12237.3616],
    //                [0.996747993, 970.5784629, '#N/A', '#N/A', '#N/A'],
    //                [459.7536742, 6, '#N/A', '#N/A', '#N/A'],
    //                [1732393319, 5652135.316, '#N/A', '#N/A', '#N/A'],
    //            ],
    //            [142000, 144000, 151000, 150000, 139000, 169000, 126000, 142900, 163000, 169000, 149000],
    //            [
    //                [2310, 2, 2, 20],
    //                [2333, 2, 2, 12],
    //                [2356, 3, 1.5, 33],
    //                [2379, 3, 2, 43],
    //                [2402, 2, 3, 53],
    //                [2425, 4, 2, 23],
    //                [2448, 2, 1.5, 99],
    //                [2471, 2, 2, 34],
    //                [2494, 3, 3, 23],
    //                [2517, 4, 4, 55],
    //                [2540, 2, 3, 22],
    //            ],
    //            true,
    //            true,
    //        ],
];