PHPOffice /
PhpSpreadsheet
| @@ 2088-2105 (lines=18) @@ | ||
| 2085 | } |
|
| 2086 | ||
| 2087 | $bestFitLinear = \PhpOffice\PhpSpreadsheet\Shared\trend\trend::calculate(\PhpOffice\PhpSpreadsheet\Shared\trend\trend::TREND_LINEAR, $yValues, $xValues, $const); |
|
| 2088 | if ($stats) { |
|
| 2089 | return [ |
|
| 2090 | [ |
|
| 2091 | $bestFitLinear->getSlope(), |
|
| 2092 | $bestFitLinear->getSlopeSE(), |
|
| 2093 | $bestFitLinear->getGoodnessOfFit(), |
|
| 2094 | $bestFitLinear->getF(), |
|
| 2095 | $bestFitLinear->getSSRegression(), |
|
| 2096 | ], |
|
| 2097 | [ |
|
| 2098 | $bestFitLinear->getIntersect(), |
|
| 2099 | $bestFitLinear->getIntersectSE(), |
|
| 2100 | $bestFitLinear->getStdevOfResiduals(), |
|
| 2101 | $bestFitLinear->getDFResiduals(), |
|
| 2102 | $bestFitLinear->getSSResiduals(), |
|
| 2103 | ], |
|
| 2104 | ]; |
|
| 2105 | } |
|
| 2106 | ||
| 2107 | return [ |
|
| 2108 | $bestFitLinear->getSlope(), |
|
| @@ 2157-2174 (lines=18) @@ | ||
| 2154 | } |
|
| 2155 | ||
| 2156 | $bestFitExponential = \PhpOffice\PhpSpreadsheet\Shared\trend\trend::calculate(\PhpOffice\PhpSpreadsheet\Shared\trend\trend::TREND_EXPONENTIAL, $yValues, $xValues, $const); |
|
| 2157 | if ($stats) { |
|
| 2158 | return [ |
|
| 2159 | [ |
|
| 2160 | $bestFitExponential->getSlope(), |
|
| 2161 | $bestFitExponential->getSlopeSE(), |
|
| 2162 | $bestFitExponential->getGoodnessOfFit(), |
|
| 2163 | $bestFitExponential->getF(), |
|
| 2164 | $bestFitExponential->getSSRegression(), |
|
| 2165 | ], |
|
| 2166 | [ |
|
| 2167 | $bestFitExponential->getIntersect(), |
|
| 2168 | $bestFitExponential->getIntersectSE(), |
|
| 2169 | $bestFitExponential->getStdevOfResiduals(), |
|
| 2170 | $bestFitExponential->getDFResiduals(), |
|
| 2171 | $bestFitExponential->getSSResiduals(), |
|
| 2172 | ], |
|
| 2173 | ]; |
|
| 2174 | } |
|
| 2175 | ||
| 2176 | return [ |
|
| 2177 | $bestFitExponential->getSlope(), |
|
