Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 20 Apr 2014 03:58:40 +0200Is there a polynomial curve fit function(s) in Calc ?https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/Is there a polynomial curve fit function(s) in Calc ? Mon, 20 Feb 2012 23:18:15 +0100https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/Answer by oweng for <p>Is there a polynomial curve fit function(s) in Calc ? </p>
https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?answer=32941#post-id-32941As per the comments by @Pedro it is time to provide an updated answer to this question. The [v4.2 release notes](https://wiki.documentfoundation.org/ReleaseNotes/4.2#Chart) under *Chart* indicate these trend line enhancements:
- Support more than one trend line per series (Tomaž Vajngerl)
- Force intercept for trend lines fdo#40314 (Tomaž Vajngerl)
- Extrapolation of trend lines fdo#40316 (Tomaž Vajngerl)
- Polynomial trend lines fdo#35712 (Tomaž Vajngerl)
- Moving average trend lines fdo#40315 (Tomaž Vajngerl)
Thus, with respect to this question, there *is* now a polynomial curve fit function. These enhancements cover all the issues (shortcomings) listed by the [CorePolyGUI extension](http://extensions.libreoffice.org/extension-center/improved-trend-lines), and a few others as well. The CorePolyGUI extension may now therefore be redundant.Sun, 20 Apr 2014 03:58:40 +0200https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?answer=32941#post-id-32941Answer by ByteMe for <p>Is there a polynomial curve fit function(s) in Calc ? </p>
https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?answer=30308#post-id-30308There is no polynomial trend line yet. Polycorel is ok, but not quite as elegant as the integrated features of MS Office. There is however FOSS alternative: gnumeric. It's got more capabilities when it comes to regressions, but lacks a bit in compatibility with LibreOffice. I tend to use them side by side and I export finished graphs to png's for \LaTeX\ documents. I sincerely hope LibreOffice will take the opportunity to implement the extra features of the gnumeric fork(at least I think it's a fork, don't quote me on it and don't shoot me if I'm wrong) into the more standard LibreOffice.Mon, 24 Feb 2014 14:53:36 +0100https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?answer=30308#post-id-30308Comment by Pedro for <p>There is no polynomial trend line yet. Polycorel is ok, but not quite as elegant as the integrated features of MS Office. There is however FOSS alternative: gnumeric. It's got more capabilities when it comes to regressions, but lacks a bit in compatibility with LibreOffice. I tend to use them side by side and I export finished graphs to png's for \LaTeX\ documents. I sincerely hope LibreOffice will take the opportunity to implement the extra features of the gnumeric fork(at least I think it's a fork, don't quote me on it and don't shoot me if I'm wrong) into the more standard LibreOffice.</p>
https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?comment=30311#post-id-30311@ByteMe, actually you are wrong :) Polynomial curves have been added in the 4.2 branch (see following link, under Chart)
http://www.libreoffice.org/download/4-2-new-features-and-fixes/Mon, 24 Feb 2014 15:39:05 +0100https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?comment=30311#post-id-30311Answer by Lee L for <p>Is there a polynomial curve fit function(s) in Calc ? </p>
https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?answer=316#post-id-316**As noted by others, this answer is now outdated. There is now a polynomial curve fitting function built into the LibreOffice chart/graphing facility.**
-------------------------------------------------------------------------
CorelPolyGUI is an extension for LibreOffice that implements polynomial curve fits.
You can find it here: http://extensions.libreoffice.org/extension-center/improved-trend-lines
You can also use the linest function. LibreOffice doesn't automatically generate the values for x^2, x^3, etc when you use the linest function for polynomial regressions. You have to generate those values yourself in columns adjacent to the values for x, then run the regression across the set of cells that includes those values for different orders of x and the values for y.
******
The instructions from http://help.libreoffice.org/Chart/Trend_Lines
A polynomial regression curve cannot be added [to a chart] automatically. You must calculate this curve manually.
Create a table with the columns x, x², x³, … , xⁿ, y up to the desired degree n.
Use the formula =LINEST(Data_Y,Data_X) with the complete range x to xⁿ (without headings) as Data_X.
The first row of the LINEST output contains the coefficients of the regression polynomial, with the coefficient of xⁿ at the leftmost position.
The first element of the third row of the LINEST output is the value of r². See the LINEST function for details on proper use and an explanation of the other output parameters.
****************************************************
Also, see the manual for linest at http://help.libreoffice.org/3.4/Calc/Array_Functions#LINEST
Note that using linest with an array requires that the user exit the cell containing the linest function with Ctrl+Shift+Enter, not just pressing Enter.Tue, 21 Feb 2012 16:30:07 +0100https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?answer=316#post-id-316Answer by unquimico for <p>Is there a polynomial curve fit function(s) in Calc ? </p>
https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?answer=285#post-id-285The answer is quite easy: NO. And there has never been one. I'm a physics and chemistry teacher, and I like to use Libreoffice at school, but when it comes to explain an oblique shot I can't show off this software. Of course, I can build the graphic position-time, but I can't get the right equation.
I hate to say this, but in my opinion, this is the only question where Excel is better than Calc.
P.D: excuse me if I have made some mistakes, I'm still learning EnglishTue, 21 Feb 2012 09:52:15 +0100https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?answer=285#post-id-285Comment by Pedro for <p>The answer is quite easy: NO. And there has never been one. I'm a physics and chemistry teacher, and I like to use Libreoffice at school, but when it comes to explain an oblique shot I can't show off this software. Of course, I can build the graphic position-time, but I can't get the right equation.</p>
<p>I hate to say this, but in my opinion, this is the only question where Excel is better than Calc.</p>
<p>P.D: excuse me if I have made some mistakes, I'm still learning English</p>
https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?comment=30312#post-id-30312@unquimico, maybe it's time to update to 4.2.1 and test the new polynomial regressions ;)Mon, 24 Feb 2014 15:44:57 +0100https://ask.libreoffice.org/en/question/260/is-there-a-polynomial-curve-fit-functions-in-calc/?comment=30312#post-id-30312