powerBestFitClass.php 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138
  1. <?php
  2. require_once PHPEXCEL_ROOT . 'PHPExcel/Shared/trend/bestFitClass.php';
  3. /**
  4. * PHPExcel_Power_Best_Fit
  5. *
  6. * Copyright (c) 2006 - 2015 PHPExcel
  7. *
  8. * This library is free software; you can redistribute it and/or
  9. * modify it under the terms of the GNU Lesser General Public
  10. * License as published by the Free Software Foundation; either
  11. * version 2.1 of the License, or (at your option) any later version.
  12. *
  13. * This library is distributed in the hope that it will be useful,
  14. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  15. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
  16. * Lesser General Public License for more details.
  17. *
  18. * You should have received a copy of the GNU Lesser General Public
  19. * License along with this library; if not, write to the Free Software
  20. * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
  21. *
  22. * @category PHPExcel
  23. * @package PHPExcel_Shared_Trend
  24. * @copyright Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel)
  25. * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
  26. * @version ##VERSION##, ##DATE##
  27. */
  28. class PHPExcel_Power_Best_Fit extends PHPExcel_Best_Fit
  29. {
  30. /**
  31. * Algorithm type to use for best-fit
  32. * (Name of this trend class)
  33. *
  34. * @var string
  35. **/
  36. protected $bestFitType = 'power';
  37. /**
  38. * Return the Y-Value for a specified value of X
  39. *
  40. * @param float $xValue X-Value
  41. * @return float Y-Value
  42. **/
  43. public function getValueOfYForX($xValue)
  44. {
  45. return $this->getIntersect() * pow(($xValue - $this->xOffset), $this->getSlope());
  46. }
  47. /**
  48. * Return the X-Value for a specified value of Y
  49. *
  50. * @param float $yValue Y-Value
  51. * @return float X-Value
  52. **/
  53. public function getValueOfXForY($yValue)
  54. {
  55. return pow((($yValue + $this->yOffset) / $this->getIntersect()), (1 / $this->getSlope()));
  56. }
  57. /**
  58. * Return the Equation of the best-fit line
  59. *
  60. * @param int $dp Number of places of decimal precision to display
  61. * @return string
  62. **/
  63. public function getEquation($dp = 0)
  64. {
  65. $slope = $this->getSlope($dp);
  66. $intersect = $this->getIntersect($dp);
  67. return 'Y = ' . $intersect . ' * X^' . $slope;
  68. }
  69. /**
  70. * Return the Value of X where it intersects Y = 0
  71. *
  72. * @param int $dp Number of places of decimal precision to display
  73. * @return string
  74. **/
  75. public function getIntersect($dp = 0)
  76. {
  77. if ($dp != 0) {
  78. return round(exp($this->intersect), $dp);
  79. }
  80. return exp($this->intersect);
  81. }
  82. /**
  83. * Execute the regression and calculate the goodness of fit for a set of X and Y data values
  84. *
  85. * @param float[] $yValues The set of Y-values for this regression
  86. * @param float[] $xValues The set of X-values for this regression
  87. * @param boolean $const
  88. */
  89. private function powerRegression($yValues, $xValues, $const)
  90. {
  91. foreach ($xValues as &$value) {
  92. if ($value < 0.0) {
  93. $value = 0 - log(abs($value));
  94. } elseif ($value > 0.0) {
  95. $value = log($value);
  96. }
  97. }
  98. unset($value);
  99. foreach ($yValues as &$value) {
  100. if ($value < 0.0) {
  101. $value = 0 - log(abs($value));
  102. } elseif ($value > 0.0) {
  103. $value = log($value);
  104. }
  105. }
  106. unset($value);
  107. $this->leastSquareFit($yValues, $xValues, $const);
  108. }
  109. /**
  110. * Define the regression and calculate the goodness of fit for a set of X and Y data values
  111. *
  112. * @param float[] $yValues The set of Y-values for this regression
  113. * @param float[] $xValues The set of X-values for this regression
  114. * @param boolean $const
  115. */
  116. public function __construct($yValues, $xValues = array(), $const = true)
  117. {
  118. if (parent::__construct($yValues, $xValues) !== false) {
  119. $this->powerRegression($yValues, $xValues, $const);
  120. }
  121. }
  122. }