PHPOffice /
PhpSpreadsheet
| @@ 2008-2030 (lines=23) @@ | ||
| 2005 | } |
|
| 2006 | ||
| 2007 | $bestFitLinear = \PhpSpreadsheet\Shared\trend\trend::calculate(\PhpSpreadsheet\Shared\trend\trend::TREND_LINEAR, $yValues, $xValues, $const); |
|
| 2008 | if ($stats) { |
|
| 2009 | return [ |
|
| 2010 | [ |
|
| 2011 | $bestFitLinear->getSlope(), |
|
| 2012 | $bestFitLinear->getSlopeSE(), |
|
| 2013 | $bestFitLinear->getGoodnessOfFit(), |
|
| 2014 | $bestFitLinear->getF(), |
|
| 2015 | $bestFitLinear->getSSRegression(), |
|
| 2016 | ], |
|
| 2017 | [ |
|
| 2018 | $bestFitLinear->getIntersect(), |
|
| 2019 | $bestFitLinear->getIntersectSE(), |
|
| 2020 | $bestFitLinear->getStdevOfResiduals(), |
|
| 2021 | $bestFitLinear->getDFResiduals(), |
|
| 2022 | $bestFitLinear->getSSResiduals(), |
|
| 2023 | ], |
|
| 2024 | ]; |
|
| 2025 | } else { |
|
| 2026 | return [ |
|
| 2027 | $bestFitLinear->getSlope(), |
|
| 2028 | $bestFitLinear->getIntersect(), |
|
| 2029 | ]; |
|
| 2030 | } |
|
| 2031 | } |
|
| 2032 | ||
| 2033 | /** |
|
| @@ 2072-2094 (lines=23) @@ | ||
| 2069 | } |
|
| 2070 | ||
| 2071 | $bestFitExponential = \PhpSpreadsheet\Shared\trend\trend::calculate(\PhpSpreadsheet\Shared\trend\trend::TREND_EXPONENTIAL, $yValues, $xValues, $const); |
|
| 2072 | if ($stats) { |
|
| 2073 | return [ |
|
| 2074 | [ |
|
| 2075 | $bestFitExponential->getSlope(), |
|
| 2076 | $bestFitExponential->getSlopeSE(), |
|
| 2077 | $bestFitExponential->getGoodnessOfFit(), |
|
| 2078 | $bestFitExponential->getF(), |
|
| 2079 | $bestFitExponential->getSSRegression(), |
|
| 2080 | ], |
|
| 2081 | [ |
|
| 2082 | $bestFitExponential->getIntersect(), |
|
| 2083 | $bestFitExponential->getIntersectSE(), |
|
| 2084 | $bestFitExponential->getStdevOfResiduals(), |
|
| 2085 | $bestFitExponential->getDFResiduals(), |
|
| 2086 | $bestFitExponential->getSSResiduals(), |
|
| 2087 | ], |
|
| 2088 | ]; |
|
| 2089 | } else { |
|
| 2090 | return [ |
|
| 2091 | $bestFitExponential->getSlope(), |
|
| 2092 | $bestFitExponential->getIntersect(), |
|
| 2093 | ]; |
|
| 2094 | } |
|
| 2095 | } |
|
| 2096 | ||
| 2097 | /** |
|
