tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{(._);g?]F)*LsX1,~84ǺAaPi˄(;wѻ]cºP"cJDz^?zo~_UY̳-=~J*U \ֵ/5}z}Z''b]MSzљsEvtTg1 Ϲ }=7pOSYa5& mN2:v3c c2&Ɖ|t o.Щ3cdRExbPpd}ib|J/n\j&rJ%+j[,xl2O& w4}Q8vO惤VJ4]i W߱n6ŇXɸAQN$sGzƨNƨFC+q-%BgMdSYa5& mN2:v3c c2&Ɖ|t IɆ< SYa5& mN2:v3c c2&Ɖ|t fm$|c:=? dbUEa^=T"XUe!h rCR<…lS# bT%N؄c<4I\}?ay#8tȺvw_1>4Jh n;'; qkEGYq)]Y(V2!WjɳPٽ=E hΗk&=Ƃ $8"ut=m,u;{gu˜i*@ͥ>Sgc?yx?h1랰pE;b"`e؝m)`Q.Z]b"{aPd MV́q MQ3.3mT,*Raiz#m,f[qܩ֨*TVMׂgxZB4J8V;Qˋю [0dMTRb,gmG!!ET\`&hq(Q i6ކ3OP%!2uJ3/!i x0Uwv4\ܲZ,uu:*́ o:*'d}׳ ֗ӣ/WbnTpp?Qsaܙ~.> &3Q{ $eUS^[\{"QJFWM+}xüQ(VCUgRIn.H| Ҕ.${X[ >@e=ng Q4>2 7W}TH'kE}I؆u,YY"-cFCĶ8nn&,`\ft! jRr!E#*`-f<|ı5fEZ^ BJq\B2ӭȽsu$sv#0)NiHG}/xQ瑄v'?FITp͑K*ClWJt7$qiY4:o飙4I ,i$݈ n.OR4k쵼W QJ >w's-{KM謶 [ NRF.e ]pSXzA@$ke·_~F? C[􋍡MQJm V,iAu  vK,:_(5Kӱښ@:U$r3 TyaJe3J1 di20Kr-\Ōo@jtxAkB7薩xRܖ"NQ(8Cj|zK\Gv0>vMG$YytNYp N[\%1vԛ'_2GMyIXWcN jv UV*⨀i<%`ԓtv4t 8N_QFͦIm-$T>'a۸Y_Z=2 sR]~yYTe /cnoˆv>eE>AUbt9FX2\Zis#&䢻EHn1P! vp#ZP왲;X7W៼[x?J_?rͷLX 'uUavyճ- yT2(GNRopTH\VQHG QɐXL4,w,М#fnn74^"U& C,hk #0*"?,r2fIsJj6G&azr~slԯ+ߕ( tQÒu"dOB Cۉ) wK \jG5vln.ӘW= ŭ VvL,DǛ-$D.=+.-ↀq su7klD]%3ZCy@g $"0ȵ[T{on qdwْDv+;Q-i=mo<4AO=5uBp/_}Y @oJZk^pMj%cB(XՖw.8F`6pq6$3$VyQzgX<?$U?4;%) &$$ꇇ|q{:>SIC"Mx|Zш缿Xjvüevr7ҲvS183ZPԽ HϴoH|> Gb}HQ@ӖOVY_Y1 тiܱ]U`Ok=>tXz_An &fIsJj6G&azr$Bz`^\"-iIy})e)!T8@1?"3Mj< 団=kvKˬx+ےoO@rhILe?c4;BU,7@cEbDq؉[Ǧm 6|y[OE(}XPR# LYE"DM > vVcil!ԻRH^{j8=W) ~+N'1P! vp#ZP왲;X7W៼[x?J_?rͷLX 'uUavyճ- yT2(~/MiŦ_Qx'#IxRچ(*#c.ܸ&l1OtצYQxokv qaI~je/7w  <+̉H3Zq"?mLz@rb fF]VK޺)q55*=C<]i4ԡh;NH6L|"Oڴje@e8o9#lder-open"> JAMA For an m-by-n matrix A with m >= n, the singular value decomposition is an m-by-n orthogonal matrix U, an n-by-n diagonal matrix S, and an n-by-n orthogonal matrix V so that A = U*S*V'
  •  JAMA Pythagorean Theorem: a = 3 b = 4 r = sqrt(square(a) + square(b)) r = 5 r = sqrt(a^2 + b^2) without under/overflow
  •  PHPExcel
  • Back to top  

    PHPExcel_Linear_Best_Fit

    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

    int

    Number 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

    int

    Number 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
    Inherited
    inherited_from \PHPExcel_Best_Fit::getIntersect()

    Parameters

    $dp

    int

    Number 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

    int

    Number 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
    Inherited
    inherited_from \PHPExcel_Best_Fit::getSlope()

    Parameters

    $dp

    int

    Number 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

    int

    Number 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

    int

    Number of places of decimal precision to return

    Returns

    float

    Return the X-Value for a specified value of Y

    getValueOfXForY(float $yValue) : float

    Parameters

    $yValue

    float

    Y-Value

    Returns

    floatX-Value

    Return the Y-Value for a specified value of X

    getValueOfYForX(float $xValue) : float

    Parameters

    $xValue

    float

    X-Value

    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

    _linear_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
     

    $_bestFitType : string
     

    $_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