Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 29 Jun 2018 17:53:13 +0200Is it possible to change the letter in the equation of a trendline?https://ask.libreoffice.org/en/question/47322/is-it-possible-to-change-the-letter-in-the-equation-of-a-trendline/Hi,
I'm building graphics with trendlines. I've got multiple trendlines in one graphic and all the the equation start with f(x)... I'd like to change, in example, f(x) to g(t). Is it possible?
ThanksTheNiceGuySat, 07 Mar 2015 21:55:00 +0100https://ask.libreoffice.org/en/question/47322/r squared trendline - How does it actually function?https://ask.libreoffice.org/en/question/159324/r-squared-trendline-how-does-it-actually-function/Greetings all,
I would like to have a deeper understanding on how the r² is actually calculated.
On wikipedia, https://en.wikipedia.org/wiki/Coefficient_of_determination, it presents a calculation routine:
- r²=1-SSres/SStot, where SSres is the sum of (real y - adjusted y) and SStot is the sum of (real y - average real y).
By doing this, I have got a quite different different number from the one coming with the automatic trendline option. During my bachelor years I remember being there different ways to calculate the r². Is there a way for me to dig into the functions code that returns this r² value? I believe it might be possible to do, but I have never ventured myself into these dark waters.
Looking forward a concise answer.
Thanks in advance, Community.
Juliano FinckJulianofinckFri, 29 Jun 2018 17:53:13 +0200https://ask.libreoffice.org/en/question/159324/coefficient of determination R2 - value different to excelhttps://ask.libreoffice.org/en/question/102132/coefficient-of-determination-r2-value-different-to-excel/Hi there
Libreoffice Calc 5.3.02 -> R2= 0.886442
MS excel 2017 -> R2 = 0.5669
to calculate R2 in Libreoffice I follow this https://help.libreoffice.org/Chart/Trend_Lines
(select the chart and insert - trend lines - linear)
data used
<code><br>
1996 | 20.67<br>
1997 | 19.09<br>
1998 | 12.72<br>
1999 | 17.97<br>
2000 | 28.5<br>
2001 | 24.44<br>
2002 | 25.02<br>
2003 | 28.83<br>
2004 | 38.27<br>
2005 | 54.52<br>
2006 | 65.14<br>
2007 | 72.39<br>
2008 | 97.26<br>
2009 | 61.67<br>
2010 | 79.5<br>
2011 | 111.26<br>
2012 | 111.67<br>
2013 | 108.66<br>
2014 | 98.95<br>
2015 | 52.39<br>
2016 | 43.73<br>
beipinkSun, 25 Jun 2017 13:11:20 +0200https://ask.libreoffice.org/en/question/102132/logarithmic trendline not displaying on charthttps://ask.libreoffice.org/en/question/88339/logarithmic-trendline-not-displaying-on-chart/I have been trying to add a trendline to my chart, the equation and R-squared values display, but the line is nowhere to be seen. I have adjusted the line options to ensure that there is a thickness, transparency is set to 0%, and that the line option is a value other than "none". I want a logarithmic trendline, but tried a linear trendline as well and it also only displayed the equation and not the line itself. I had previously worked on the spreadsheet, created the chart, saved the file and closed the program. Upon reopening the file I'm having this issue.
Using version 5.0.5.2 on Windows 8.1mtndewjunkyWed, 22 Feb 2017 20:14:50 +0100https://ask.libreoffice.org/en/question/88339/How can I change the variable letters in a trendline equation?https://ask.libreoffice.org/en/question/40742/how-can-i-change-the-variable-letters-in-a-trendline-equation/Right now my equations reads: f(x) = 3.11x + 0.038, however I need to change f(x) and x to different variables. This is in the Calc Spreadsheet.ShdowMon, 06 Oct 2014 03:11:45 +0200https://ask.libreoffice.org/en/question/40742/Change name of trend line in legendhttps://ask.libreoffice.org/en/question/36966/change-name-of-trend-line-in-legend/Hi,
I have a problem with Libreoffice Calc 4.0. I have data series named "my_name". Then I inserted exponential trend line of this data series and in legend I have "Exponential (my_name)". I want to change this name with no affect to the name of the original data series. Is there any easy way?vaclav hummelMon, 14 Jul 2014 15:24:05 +0200https://ask.libreoffice.org/en/question/36966/Removing trend line text from the key/legend?https://ask.libreoffice.org/en/question/35474/removing-trend-line-text-from-the-keylegend/When plotting data onto a chart in LibreOffice Calc, are we able to remove the trendline 'key' from the legend while retaining the trendline on the graph? In some cases I feel the extra key for the trendline is just adding obvious clutter to the chart.WatercycleSat, 14 Jun 2014 18:17:48 +0200https://ask.libreoffice.org/en/question/35474/