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? The trendline give you the trend of your data, but the numerical values of the equation must be linked to something. Did I mess something? And what about "forced intercept" (new option for 4.2), which sense can user give for categories value of zero? ----- LibreOffice 4.1.1.2 -- View this message in context: http://nabble.documentfoundation.org/Trendline-equation-tp4094690p4094863.html Sent from the QA mailing list archive at Nabble.com. _______________________________________________ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/