[Libreoffice-bugs] [Bug 35567] LibreOffice Calc does not have a nice Linear Regression tool

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=35567

--- Comment #2 from dajoker at gmail.com 2011-03-24 20:06:50 PDT ---
Output like the following by running a quick tool that just selects the
independent and dependent variables' data, plus provides other options.  This
is similar to what is provided with other proprietary packages and, as far as I
know, is not part of OO.o or LO.  Sorry about the spacing:

SUMMARY OUTPUT        Response Variable:    GE            

Regression Statistics                        
Multiple R    0.8117049                    
R^2    0.658865                    
Standard Error    0.061578                    
Adjusted R^2    0.652983                    
Observations    60                    

ANOVA                        
    df    SS    MS    F    Significance of F    
Regression    1    0.424772    0.424772    112.0206    3.63E−15    
Residual    58    0.219931    0.003792            
Total    59    0.644702                

    Coefficients    Standard Error    t-Statistics    p-Value    Lower 95%   
Upper 95%
Intercept    −0.00201    0.007955    −0.25203    0.801906    −0.01793   
0.01392
S&P    1.642878    0.155223    10.58398    3.63E−15    1.332165    1.95359

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.