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