https://bugs.freedesktop.org/show_bug.cgi?id=75655
Priority: medium
Bug ID: 75655
Assignee: [email protected]
Summary: EDITING: Exponential smoothing uses incorrect formula
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.1.1 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 94945
--> https://bugs.freedesktop.org/attachment.cgi?id=94945&action=edit
Sample showing Excel vs LO results
When using the exponential smoothing option under the new statistics menu it
exhibits the following problems;
1. The first result in the series should be #N/A as it has no previous data.
2. The cell references are incorrect on several counts
3. The results are the same as the input
Also, would it be possible to supress the column headers with a option in the
dialog box?
When compared to Excel, putting the alpha value into a separate cell is a good
idea.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
