[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127517 --- Comment #8 from mohr.christ...@gmail.com --- Thank you for taking a look and linking to the paper. Turns out my excel using colleague have wrong numbers. This is still unexpected behavior but als libreoffice is mathematically correct there is nothing that can be done. Thanks again, I will read up on the mathematics and correct my calculations. :) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127517 Laurent BP changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |NOTABUG --- Comment #7 from Laurent BP --- (In reply to Buovjaga from comment #6) > Laurent: can you comment on this? Excel chart is wrong ;-) Scientific article Attachment 91622 of bug 73374 explain why Excel calculation is wrong: it can give negative R² In case of forced intercept, a different calculation must be used, as LINEST function does (in LibO and Excel). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127517 Buovjaga changed: What|Removed |Added CC||jumbo4...@yahoo.fr --- Comment #6 from Buovjaga --- (In reply to Leyan from comment #5) > I had a look in the code, this is deliberate. A specific computation was > introduced to reproduce the behavior of the LINEST function, by replacing > the difference to the average by the difference to the constant to intercept: > > * The original bug is here: > https://bugs.documentfoundation.org/show_bug.cgi?id=73374 > * The commit made to solve it is here: > https://github.com/LibreOffice/core/commit/ > 9e67015be6e9e53e19466117d692de17c18463da > > The LINEST function also gives R2=0.985148. > > In Excel (Office365), the LINEST function answers 0.985148 and the chart R2 > is 0.9373. Laurent: can you comment on this? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127517 --- Comment #5 from Leyan --- I had a look in the code, this is deliberate. A specific computation was introduced to reproduce the behavior of the LINEST function, by replacing the difference to the average by the difference to the constant to intercept: * The original bug is here: https://bugs.documentfoundation.org/show_bug.cgi?id=73374 * The commit made to solve it is here: https://github.com/LibreOffice/core/commit/9e67015be6e9e53e19466117d692de17c18463da The LINEST function also gives R2=0.985148. In Excel (Office365), the LINEST function answers 0.985148 and the chart R2 is 0.9373. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127517 Buovjaga changed: What|Removed |Added Blocks||116700 Component|Calc|Chart OS|Linux (All) |All Status|UNCONFIRMED |NEW CC||ilmari.lauhakangas@libreoff ||ice.org Version|6.3.1.2 release |4.4.7.2 release Ever confirmed|0 |1 --- Comment #4 from Buovjaga --- I confirm R^2 value is not 0,9373 in the lower graph Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=116700 [Bug 116700] [META] Chart trend line bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127517 --- Comment #3 from mohr.christ...@gmail.com --- Created attachment 157556 --> https://bugs.documentfoundation.org/attachment.cgi?id=157556&action=edit Screenshot of error in 6.4 Bug is still present. It really is a big problem as trend lines and R^2 values are widely used! -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127517 --- Comment #2 from mohr.christ...@gmail.com --- Created attachment 154749 --> https://bugs.documentfoundation.org/attachment.cgi?id=154749&action=edit Example of wrongl R^2 calculation Sample file as requested. The correct R^2 value is also included in the file. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127517 mohr.christ...@gmail.com changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127517 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127517 Xisco Faulí changed: What|Removed |Added Ever confirmed|0 |1 CC||xiscofa...@libreoffice.org Status|UNCONFIRMED |NEEDINFO --- Comment #1 from Xisco Faulí --- Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 127517] Libreoffice Calc Trendline R^2 value calculation goes wrong when trendline is forced through 0
https://bugs.documentfoundation.org/show_bug.cgi?id=127517 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs