Bug 117208 - Wrong equation evaluation of the Trend Line
Summary: Wrong equation evaluation of the Trend Line
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-04-24 12:38 UTC by Hildo
Modified: 2018-04-24 23:23 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Data and chart with the line trend (36.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-04-24 12:38 UTC, Hildo 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Hildo 2018-04-24 12:38:46 UTC 
Created attachment 141590 [details]
Data and chart with the line trend

I am send a attachment with data and charts. In the charts I plot the point and after the linear trend line of this data.
The strange is that the trend line equation doesn't match with the data.
For example, using other software I came up with
Ch0(x) = (74,7809 - 0,0054723) * x
Ch3(x) = (74, 95901 - 0,0025367) *x
that is different from the Calc give equation. The strange is data the line plot (visualization) is fine.
Comment 1 Jean-Baptiste Faure 2018-04-24 21:01:31 UTC 
What about using XY chart instead of line chart ? In line chart the abscissa is the column number (constant step equal to 1).

Status set to NEEDINFO, please set it back to UNCONFIRMED once requested
informations are provided.

Best regards. JBF
Comment 2 Hildo 2018-04-24 23:23:57 UTC 
Yes, it is works.
Thanks be the tip.