| category | 
PHPExcel | 
| package | 
PHPExcel_Shared_Trend | 
| copyright | 
Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel) | 
 Methods
Define the regression and calculate the goodness of fit for a set of X and Y data values
__construct(float[] $yValues, float[] $xValues, boolean $const) 
Parameters
$yValues
float[]The set of Y-values for this regression
 
$xValues
float[]The set of X-values for this regression
 
$const
boolean
  
 
getBestFitType()
        
getBestFitType() 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getBestFitType() | 
  
 
getCorrelation()
        
getCorrelation($dp) 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getCorrelation() | 
Parameters
$dp
  
 
getCovariance()
        
getCovariance($dp) 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getCovariance() | 
Parameters
$dp
  
 
getDFResiduals()
        
getDFResiduals($dp) 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getDFResiduals() | 
Parameters
$dp
  
 
Return the Equation of the best-fit line
getEquation(int $dp) : string
Parameters
$dp
intNumber of places of decimal precision to display
 
Returns
string
  
 
getError()
        
getError() 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getError() | 
  
 
getF()
        
getF($dp) 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getF() | 
Parameters
$dp
  
 
Return the goodness of fit for this regression
getGoodnessOfFit(int $dp) : float
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getGoodnessOfFit() | 
Parameters
$dp
intNumber of places of decimal precision to return
 
Returns
float
  
 
getGoodnessOfFitPercent()
        
getGoodnessOfFitPercent($dp) 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getGoodnessOfFitPercent() | 
Parameters
$dp
  
 
Return the Value of X where it intersects Y = 0
getIntersect(int $dp) : string
Parameters
$dp
intNumber of places of decimal precision to display
 
Returns
string
  
 
Return the standard error of the Intersect
getIntersectSE(int $dp) : string
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getIntersectSE() | 
Parameters
$dp
intNumber of places of decimal precision to display
 
Returns
string
  
 
getSSRegression()
        
getSSRegression($dp) 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getSSRegression() | 
Parameters
$dp
  
 
getSSResiduals()
        
getSSResiduals($dp) 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getSSResiduals() | 
Parameters
$dp
  
 
Return the Slope of the line
getSlope(int $dp) : string
Parameters
$dp
intNumber of places of decimal precision to display
 
Returns
string
  
 
Return the standard error of the Slope
getSlopeSE(int $dp) : string
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getSlopeSE() | 
Parameters
$dp
intNumber of places of decimal precision to display
 
Returns
string
  
 
Return the standard deviation of the residuals for this regression
getStdevOfResiduals(int $dp) : float
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getStdevOfResiduals() | 
Parameters
$dp
intNumber of places of decimal precision to return
 
Returns
float
  
 
Return the X-Value for a specified value of Y
getValueOfXForY(float $yValue) : float
Parameters
Returns
floatX-Value
  
 
Return the Y-Value for a specified value of X
getValueOfYForX(float $xValue) : float
Parameters
Returns
floatY-Value
  
 
Return the original set of X-Values
getXValues() : float[]
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getXValues() | 
Returns
float[]X-Values
  
 
getYBestFitValues()
        
getYBestFitValues() 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::getYBestFitValues() | 
  
 
_calculateGoodnessOfFit()
        
_calculateGoodnessOfFit($sumX, $sumY, $sumX2, $sumY2, $sumXY, $meanX, $meanY, $const) 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::_calculateGoodnessOfFit() | 
Parameters
$sumX
$sumY
$sumX2
$sumY2
$sumXY
$meanX
$meanY
$const
  
 
_leastSquareFit()
        
_leastSquareFit($yValues, $xValues, $const) 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::_leastSquareFit() | 
Parameters
$yValues
$xValues
$const
  
 
Execute the regression and calculate the goodness of fit for a set of X and Y data values
_exponential_regression(float[] $yValues, float[] $xValues, boolean $const) 
Parameters
$yValues
float[]The set of Y-values for this regression
 
$xValues
float[]The set of X-values for this regression
 
$const
boolean
  
 
 Properties
 
$_DFResiduals 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_DFResiduals | 
  
 
 
$_F 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_F | 
  
 
 
$_SSRegression 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_SSRegression | 
  
 
 
$_SSResiduals 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_SSResiduals | 
  
 
 
$_Xoffset 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_Xoffset | 
  
 
 
$_Yoffset 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_Yoffset | 
  
 
 
$_adjustToZero : boolean
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_adjustToZero | 
  
 
 
 
$_correlation 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_correlation | 
  
 
 
$_covariance 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_covariance | 
  
 
 
$_error : boolean
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_error | 
  
 
 
$_goodnessOfFit 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_goodnessOfFit | 
  
 
 
$_intersect 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_intersect | 
  
 
 
$_intersectSE 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_intersectSE | 
  
 
 
$_slope 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_slope | 
  
 
 
$_slopeSE 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_slopeSE | 
  
 
 
$_stdevOfResiduals 
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_stdevOfResiduals | 
  
 
 
$_valueCount : int
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_valueCount | 
  
 
 
$_xValues : float[]
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_xValues | 
  
 
 
$_yBestFitValues : float[]
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_yBestFitValues | 
  
 
 
$_yValues : float[]
Inherited
| inherited_from | 
\PHPExcel_Best_Fit::$$_yValues |