https://bugs.documentfoundation.org/show_bug.cgi?id=105427
Bug ID: 105427
Summary: : trendline formula wrong for second degree polynomial
approximation
Product: LibreOffice
Version: 5.0.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: prel...@web.de
Created attachment 130537
--> https://bugs.documentfoundation.org/attachment.cgi?id=130537&action=edit
graphics of the description above
given: 3 points x1/y1; x2/y2; x3/y3
generate: a graph through theses 3 points
apply: trendline to approximate this graph; for approximation
use second degree polynom for approximation
show: formula of the trendline
formula is wrong for approximation trendline with second degree polynom
approximation (hint: e.g. third degree does not show the mistake)
example:
(A1/B1) = (-2/4)
(A2/B2) = (0/0)
(A3/B3) = (2/4)
graph through these three points is a normal parabola y(x)=x²
trendline looks o.k. but it shows the formula y(x)=4*x²-16*x+16 (wrong!)
y(0)=4*0²-16*0+16 (wrong)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
