[Libreoffice-bugs] [Bug 142643] New: LibreOffice Calc power regression coefficients error

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142643

            Bug ID: 142643
           Summary: LibreOffice Calc power regression coefficients error
           Product: LibreOffice
           Version: 7.0.6.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: edwardsontan at protonmail.ch

Description:
After selecting x and y data for power regression (y = ax^b) the results for a
and b are incorrect. Cells for "Intercept" and "LN(X1)" are erroneous. 

Steps to Reproduce:
X        Y
------------
1       2.7
2       4
3       4.4
4       7.1
5       4.9
6       3.6
7       4
8       0.6
9       1
10      4.3


Actual Results:
Confidence level        0.99

        Coefficients
Intercept       1.57125263268399
LN(X1)  -0.310308529671727


Expected Results:
a = 4.812672931
b = -0.3103085297


Reproducible: Always


User Profile Reset: No



Additional Info:
a = 4.812672931
b = -0.3103085297

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210604/10e2ea16/attachment.htm>