[Libreoffice-qa] Trendline equation
Stefan Weigel
stefan.weigel at bildungskreis.org
Fri Jan 31 00:25:22 PST 2014
Hi,
Am 30.01.2014 22:12, schrieb Laurent BP:
> https://bugs.freedesktop.org/show_bug.cgi?id=74163
> Lets take an example which corresponds to a common error of beginner:
> 1. Enter Data such as X=1, 10, 100 and Y=11, 12, 13
> 2. Create a *XY* (scatter) chart
> 3. Insert trendline and show equation
> => f(x) = 0.0165165165x + 11.3888888889
> With same data:
> 4. Create a *Line* chart with "First column as label" selected on 2nd step
> 5. Insert linear trendline and show equation
> => f(x) = 1x + 10
> Do you know some case, where the user would require the equation of the
> trendline for other type of diagram different from XY scatter chart?
Yes, I do.
Example:
1. Enter Data A1=11, A2=13, A3=12, A4=14, A5=16, A6=15
2. Select A1:A6
3. 4. Create a Line chart
4. Insert linear trendline and show equation
--> Equation does make sense.
;-)
As long as you do *not* specify X-values or categories, the equation
is usefull even for "Column", "Bar", "Area", "Line" and "Column and
Line" charts.
Cheers,
Stefan
--
LibreOffice - Die Freiheit nehm' ich mir!
More information about the Libreoffice-qa
mailing list