PhpSpreadsheet/tests/data/Calculation/Statistical/CORREL.php

30 lines
539 B
PHP
Raw Permalink Normal View History

<?php
return [
[
0.997054485502,
[3, 2, 4, 5, 6],
[9, 7, 12, 15, 17],
],
[
0.870035103816,
[2, 10, 7, 17, 14, 16, 8, 12, 11, 15, 18, 3, 4, 1, 6, 5, 13, 19, 20, 9],
[22.9, 45.78, 33.49, 49.77, 40.94, 36.18, 21.05, 50.57, 31.32, 53.76, 55.66, 27.61, 11.15, 10.11, 37.9, 31.08, 45.48, 63.83, 63.6, 27.01],
],
[
'#VALUE!',
3,
9,
],
[
'#N/A',
[],
[],
],
[
'#DIV/0!',
[3],
[9],
],
];