https://bugs.documentfoundation.org/show_bug.cgi?id=165355
Bug ID: 165355
Summary: Errors in Linear fit to data with TREND function
Product: LibreOffice
Version: 24.8.4.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Constant and linear terms calculated with TREND function are not exact
Steps to Reproduce:
1. linear fit to data in column (B vs A in this case) -> col E
2. calc residuals (y-data in B minus fit in E) -> col F
Actual Results:
3. residuals show remaining constant & linear components -> lower plot
Expected Results:
4. NO constant & linear components as in -> col G
where remaining components are further removed -> upper plot
Reproducible: Always
User Profile Reset: No
Additional Info:
n/a
--
You are receiving this mail because:
You are the assignee for the bug.
