[Libreoffice-qa] Trendline equation
stefan.weigel at bildungskreis.org
Sat Feb 1 22:02:04 CET 2014
Am 31.01.2014 12:35, schrieb Laurent BP:
> Stefan Weigel wrote
>> > 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.
> If you do not specify X-values/categories, what sense can you give in the
> equation for 'x'?
> From my point of view, equation is useful if you need to extrapolate or
> interpolate values. What else?
A1= Oct | B1= 1100 US$
A2= Nov | B2= 1300 US$
A3= Dec | B3= 1200 US$
A4= Jan | B4= 1400 US$
A5= Feb | B5= 1600 US$
A6= Mar | B6= 1500 US$
Create a Column chart. Insert formula.
Formula reads: f(x) = 88,57x + 1040
You can use the formula displayed in a Line chart or Column chart in
order to extrapolate the row to the following months. X would be the
number of the month, counting from October = 1.
Extrapolate July: f(x=10) = 1926
No matter if you do specify X-values or categories or not. Anyway,
there are lots of cases, where the formula is usefull in a regular
chart that does not need to be a XY chart.
LibreOffice - Die Freiheit nehm' ich mir!
More information about the Libreoffice-qa