[Bug 62836] [PATCH] Implementation of Excel TREND function

2018-11-02 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62836 --- Comment #9 from Matthias Becht --- (In reply to Yegor Kozlov from comment #8) > Patched applied in r1845586. The fix will be included in upcoming 4.0.1 > release Sorry that it took me so long to reply, I was fairly busy this week. That se

[Bug 62836] [PATCH] Implementation of Excel TREND function

2018-11-02 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62836 Yegor Kozlov changed: What|Removed |Added Resolution|--- |FIXED Status|NEW

[Bug 62836] [PATCH] Implementation of Excel TREND function

2018-10-27 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62836 --- Comment #7 from Yegor Kozlov --- Created attachment 36218 --> https://bz.apache.org/bugzilla/attachment.cgi?id=36218&action=edit Trend handling all X's being the same Remove the directive in cells A65 and A66. These tests pass with this

[Bug 62836] [PATCH] Implementation of Excel TREND function

2018-10-27 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62836 --- Comment #6 from Yegor Kozlov --- I'm inclined to commit the patch as it is. The code is great and perfectly covers the basic functionality. The edge cases is a subtle area . Excel handles them differently from OpenOffice and Google Spreads

[Bug 62836] [PATCH] Implementation of Excel TREND function

2018-10-24 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62836 --- Comment #5 from Matthias Becht --- Hmm, I just remembered what the biggest problem was, which I forgot to mention before. There needs to be at least one more sample than there are x variables in order for the multiple linear regression to w

[Bug 62836] [PATCH] Implementation of Excel TREND function

2018-10-22 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62836 --- Comment #4 from Yegor Kozlov --- >> - So if all x and y values are the same, Excel just returns that value, no >> matter what? I concluded it empirically and it seems to be true. The only exception are cass when Excel returns !REF#, but t

[Bug 62836] [PATCH] Implementation of Excel TREND function

2018-10-22 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62836 --- Comment #3 from Matthias Becht --- I'm still not entirely sure about all of Excel's behavior: - So if all x and y values are the same, Excel just returns that value, no matter what? - If the y's are different but all x's are the same, Com

[Bug 62836] [PATCH] Implementation of Excel TREND function

2018-10-21 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62836 --- Comment #2 from Yegor Kozlov --- Pretty impressive. This definitely should go in trunk. The not implemented cases aren't a problem of Commons Math. >From a mathematical standpoint one needs minimum two data points to perform linear regre

[Bug 62836] [PATCH] Implementation of Excel TREND function

2018-10-18 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62836 --- Comment #1 from Matthias Becht --- Created attachment 36201 --> https://bz.apache.org/bugzilla/attachment.cgi?id=36201&action=edit Test cases for TREND -- You are receiving this mail because: You are the assignee for the bug. --