https://bugs.documentfoundation.org/show_bug.cgi?id=94796
Bug ID: 94796
Summary: LINEST and INDEX problem
Product: LibreOffice
Version: 5.0.2.2 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: m...@mschaffer.net
There seems to be a problem using INDEX with LINEST.
For example, suppose we have the following array:
{7,100;9,105;11,104;12,108;15,111;17,120;19,133}
occupying A1:B7
Consider the two examples using linest using LINEST:
method 1: LINEST(B1:B7,A1:A7)
yields an array (1 by 2)=> {2.442, 80.177}
method 2: LINEST(B1:B7,A1:A7^{1,2})
yields an array (1 by 3) => {0.238, -3.768, 116.906}
These work as expected. However, if I try to do the following with the
aforementioned examples:
method 1a: =INDEX(LINEST(B1:B7,A1:A7),1,1)
yields the expected value of 2.442
method 1b: =INDEX(LINEST(B1:B7,A1:A7^{1,2}),1,1)
yields an error Err:502 (should be 0.238)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
