https://bugs.documentfoundation.org/show_bug.cgi?id=105427
--- Comment #5 from andi <[email protected]> ---
sorry sirs, the question is not "more suitable"
- no matter if chosen "curve" or "line" chart the resulting formula is wrong!
- mathematical background: to approximate 3 given x/y points the resulting
formula with second square polynom finds all these given points exactly!!!
- the correct resulting formula for the 3 points (-2/4) (0/0) (2/4) would be
y(x)=x²
- the wrong trendline formula found by calc is: y(x) = 4x²-16x+16
- try with (0/0); does y(x)=4x²-16x+16 hit (0/0)? No!
- does y(x)=x² hit (0/0) Yes!
This bug is serious and I would appreciate if you try see the math behind it
and check then what you get from cal
Thanks lot!
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
