https://bugs.documentfoundation.org/show_bug.cgi?id=172858
Bug ID: 172858
Summary: inconsistent results for linear regression factors,
i.e. m, b in f(x)=y=m*x+b between calculation and
graphic
Product: LibreOffice
Version: 26.2.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In an XY diagram, the formula of the linear regression ( f(x)=m*x + b ) can be
displayed.
However, using the functions STEIGUNG and ACHSENABSCHNITT result in different
values! See the spreadsheet sample attached.
Steps to Reproduce:
1.Make an XY diagram out of a 2-diminensional array.
2.Select a data point and unsing the right mouse key, have the regression line
together with its formula displayed
3.Calculate STEIGUNG and ACHSENABSCHNITT and compare the results.
Actual Results:
The results for m and b are different.
Expected Results:
equal results, of course.
Reproducible: Always
User Profile Reset: No
Additional Info:
Die lineare Regressionsgleichung
Die lineare Regression folgt der Gleichung y=m*x+b.
m = STEIGUNG(Daten_Y;Daten_X)
b = ACHSENABSCHNITT(Daten_Y ;Daten_X)
Berechnen Sie das Bestimmtheitsmaß durch
R2 = BESTIMMHEITSMASS(Daten_X;Daten_Y)
Darüber hinaus liefert für m, b und R2 die Matrixfunktion RGP zusätzliche
Statistiken für eine Regressionsanalyse.
--
You are receiving this mail because:
You are the assignee for the bug.
