PHPOffice /
PhpSpreadsheet
| @@ 2027-2049 (lines=23) @@ | ||
| 2024 | } |
|
| 2025 | ||
| 2026 | $bestFitLinear = \PhpSpreadsheet\Shared\trend\trend::calculate(\PhpSpreadsheet\Shared\trend\trend::TREND_LINEAR, $yValues, $xValues, $const); |
|
| 2027 | if ($stats) { |
|
| 2028 | return array( |
|
| 2029 | array( |
|
| 2030 | $bestFitLinear->getSlope(), |
|
| 2031 | $bestFitLinear->getSlopeSE(), |
|
| 2032 | $bestFitLinear->getGoodnessOfFit(), |
|
| 2033 | $bestFitLinear->getF(), |
|
| 2034 | $bestFitLinear->getSSRegression(), |
|
| 2035 | ), |
|
| 2036 | array( |
|
| 2037 | $bestFitLinear->getIntersect(), |
|
| 2038 | $bestFitLinear->getIntersectSE(), |
|
| 2039 | $bestFitLinear->getStdevOfResiduals(), |
|
| 2040 | $bestFitLinear->getDFResiduals(), |
|
| 2041 | $bestFitLinear->getSSResiduals() |
|
| 2042 | ) |
|
| 2043 | ); |
|
| 2044 | } else { |
|
| 2045 | return array( |
|
| 2046 | $bestFitLinear->getSlope(), |
|
| 2047 | $bestFitLinear->getIntersect() |
|
| 2048 | ); |
|
| 2049 | } |
|
| 2050 | } |
|
| 2051 | ||
| 2052 | ||
| @@ 2093-2115 (lines=23) @@ | ||
| 2090 | } |
|
| 2091 | ||
| 2092 | $bestFitExponential = \PhpSpreadsheet\Shared\trend\trend::calculate(\PhpSpreadsheet\Shared\trend\trend::TREND_EXPONENTIAL, $yValues, $xValues, $const); |
|
| 2093 | if ($stats) { |
|
| 2094 | return array( |
|
| 2095 | array( |
|
| 2096 | $bestFitExponential->getSlope(), |
|
| 2097 | $bestFitExponential->getSlopeSE(), |
|
| 2098 | $bestFitExponential->getGoodnessOfFit(), |
|
| 2099 | $bestFitExponential->getF(), |
|
| 2100 | $bestFitExponential->getSSRegression(), |
|
| 2101 | ), |
|
| 2102 | array( |
|
| 2103 | $bestFitExponential->getIntersect(), |
|
| 2104 | $bestFitExponential->getIntersectSE(), |
|
| 2105 | $bestFitExponential->getStdevOfResiduals(), |
|
| 2106 | $bestFitExponential->getDFResiduals(), |
|
| 2107 | $bestFitExponential->getSSResiduals() |
|
| 2108 | ) |
|
| 2109 | ); |
|
| 2110 | } else { |
|
| 2111 | return array( |
|
| 2112 | $bestFitExponential->getSlope(), |
|
| 2113 | $bestFitExponential->getIntersect() |
|
| 2114 | ); |
|
| 2115 | } |
|
| 2116 | } |
|
| 2117 | ||
| 2118 | ||
