Summary: | LibreOffice Calc does not have a nice Linear Regression tool | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | dajoker |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | enhancement | ||
Priority: | medium | CC: | rb.henschel, reisi007 |
Version: | 3.3.1 release | ||
Hardware: | Other | ||
OS: | All | ||
Whiteboard: | |||
i915 platform: | i915 features: |
Description
dajoker
2011-03-22 14:14:29 UTC
Please be more specific about what you are missing and what you get in Gnumeric and not in Calc. 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 You can get all the needed values using LINEST. I do not think, that LO should integrate such a wizard. Such wizard can be provided by an extension. Please have a look at http://openoffice.org/projects/sc/downloads/download/Data%20Analysis/Statistical%20data%20analysis%20tool.zip [I don't know whether it is on the extensions-website, because it is down currently.] [This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian To resolve the NEEDINFO state, there is still no advanced/nice linear regression tool in LO as far as i can tell. |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.