[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-07-03 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 oooforum (fr) changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail bec

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-07-03 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 oooforum (fr) changed: What|Removed |Added Resolution|FIXED |NOT_AN_ISSUE -- You are receiving this ma

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-07-03 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 Peter changed: What|Removed |Added CC||legi...@gmail.com --- Comment #13 from Peter ---

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-07-02 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 jari.koso...@rayence.com changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|---

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-06-30 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 --- Comment #11 from oooforum (fr) --- I don't understand what you mean. As said before, Excel and Calc are treated CORREL function identically. -- You are receiving this mail because: You are the assignee for the issue.

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-06-30 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 --- Comment #9 from jari.koso...@rayence.com --- Created attachment 86161 --> https://bz.apache.org/ooo/attachment.cgi?id=86161&action=edit test with same y-scale and same y-direction noise -- You are receiving this mail because: You are the as

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-06-30 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 --- Comment #8 from jari.koso...@rayence.com --- Created attachment 86160 --> https://bz.apache.org/ooo/attachment.cgi?id=86160&action=edit test case with different y-scale, but noise only on y-axis direction -- You are receiving this mail bec

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-06-30 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 --- Comment #10 from jari.koso...@rayence.com --- I guess it works only, if both y-scale and y-direction noise is same (only X-axis data can be scaled) The noise and scaling can not be on both axis, with the equation used. This might be quite good

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-06-30 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 --- Comment #7 from jari.koso...@rayence.com --- Created attachment 86159 --> https://bz.apache.org/ooo/attachment.cgi?id=86159&action=edit test case 2 with selectable origin This shows that CORREL -results do not depend on the data position, on

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-06-30 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 --- Comment #6 from jari.koso...@rayence.com --- The correlation does not depend on the position of the data and thus is not sensitive to the translation of the data. However rotation of the data changes the CORREL-function results. This can be rig

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-06-30 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 --- Comment #5 from jari.koso...@rayence.com --- Created attachment 86158 --> https://bz.apache.org/ooo/attachment.cgi?id=86158&action=edit test case 2 with origin selectable -- You are receiving this mail because: You are the assignee for the

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-06-30 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 oooforum (fr) changed: What|Removed |Added CC||ooofo...@free.fr --- Comment #4 from ooofo

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-06-29 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 --- Comment #3 from mroe --- I don't know what the values should be … but maybe the numerator 1 in the formulae for y' should be the slope like for x'? Simply insert a X-Y chart for x'/y' and look if you get expected results. Otherwise make your o

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-06-29 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 --- Comment #2 from jari.koso...@rayence.com --- In the test case "CORREL_FUNC_TEST_CASE.ods", the target would be to get the cell C27 value to be the same as the cell K27 value, even the slope of the fitted data is different for the left table dat

[Issue 127459] CORREL function results seem to depend on the slope of the data

2017-06-28 Thread bugzilla
https://bz.apache.org/ooo/show_bug.cgi?id=127459 jari.koso...@rayence.com changed: What|Removed |Added Issue Type|DEFECT |ENHANCEMENT --- Comment #1 from