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