[Libreoffice-qa] Trendline equation

[Stefan Weigel]

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!