Suppose I have a (xy scatter) diagram in localc and insert a trend line, for example a linear one of the type f(x) = ax + b
. I know hot to display the equation in the diagram, but how can I reference to the parameters a
and b
in a cell to make further calculations with it?
Oh, in ubuntu libreoffice calc can be started using the command localc
@student - As you know how to display the trend line equation just look at the equation and take the parameters you need. The parameters have a high number of digits thus the result should be sufficiently precise.
Due to complexity reasons I feel the the equations @karolus indicates are only available for linear trend lines.
An enhancement request to copy the parameters from trend line equations appears to me as a very interesting one.
Please feel free to post such an enhancement request at: https://www.libreoffice.org/get-help/bug/?enhancement=yes and publish the bug number here to allow other to add comments.
A less-than-convenient workaround:
Copy the equation in the chart to clipboard.
Start a new OO Draw window: File > New > Drawing
Paste the equation
Select the equation and right-click > Break
Now you can click into the text and copy/paste it as plain text anywhere you like.
It really work, thank you!
This is great. Only one detail: when copying the equation after braking it, note that any minus sign in the equation is taken as hifen.
Jorge
To extract the trend line data from a series of x
an y
values, you can use the LINEST function. This function returns the values for s and b from your equation above. It can also return other tests such as the r squared value.
Because LINEST returns multiple results, it must be entered as an array formula. You do this by pressing Ctrl+Shift+Enter when you finish entering the formula. The results are returned to multiple cells. Approximately 2 columns wide by 5 rows high.
LINEST takes 4 arguments. 1 a list of Y-Values, 2 a list of x-values, 3 enter TRUE to force the vertical axis intercept to 0 or false for it to be calculated. 4. Enter TRUE to return regression statistics and FALSE to only return the values for a
and b
.
let us know if you have any questions.
Cheers,
John