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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from edwardsontan at protonmail.ch ---
The following is the dataset that I was working on and which first alerted me
to the problem. 

X       Y
----------
240     57
280     48
320     40
360     35
400     30
500     25
600     20
700     17
800     14
1000    11.5
1200    9.5
1500    8
2000    6.7
2500    5.5
3000    4
4000    3
6000    2
8000    1.2

I used an online power regression calculator
(https://keisan.casio.com/exec/system/14059931777261) to get the correct
answers. 

Libre Calc results:
a = -1.03774556216783
b = 9.66940331258679

Online calculator results:
a = 15825.903
b = -1.03774556

-- 
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/8533a698/attachment.htm>