mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-23 19:43:37 +00:00
Mark Baker
2d8c8c8ecf
- Move TREND() functions into the Statistical Trends class - Unit tests for TREND() - Create Confidence class for Statistical Confidence functions
21 lines
526 B
PHP
21 lines
526 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
'slope' => [-1.1, -1.1064189189190],
|
|
'intersect' => [14.1, 14.081081081081],
|
|
'goodnessOfFit' => [0.873138, 0.8731378215564962],
|
|
'equation' => 'Y = 14.08 + -1.11 * X',
|
|
[3, 10, 3, 6, 8, 12, 1, 4, 9, 14],
|
|
[8, 2, 11, 6, 5, 4, 12, 9, 6, 1],
|
|
],
|
|
[
|
|
'slope' => [1.0, 1.0],
|
|
'intersect' => [-2.0, -2.0],
|
|
'goodnessOfFit' => [1.0, 1.0],
|
|
'equation' => 'Y = -2 + 1 * X',
|
|
[1, 2, 3, 4, 5],
|
|
[3, 4, 5, 6, 7],
|
|
],
|
|
];
|