hi!
does anyone know how to calculate the line of best fit? I really need help with this.
thanks!
Line of best fit
Line of best fit
OpenOffice 3.0.1 on Ubuntu 9.04
Re: line of best fit
There are three ways, at least, to get the best linear fit to data. You can use the functions SLOPE and INTERCEPT in separate cells. These functions have the form
You can also use the RSQ() function to get the R^2 of the fit.
You can use the array function LINEST() to get the linear fit. It returns various statistics in addition to the slope and intercept. I suggest you check out the Help section, as that function is more complicated.
Finally, if the data are used in a scatter chart, you can double click on the chart to put it in edit mode and then go to Insert -> Trend Lines to add the line, equation and R Squared to the chart.
Code: Select all
=SLOPE(YRange;XRange)
=INTERCEPT(YRange;XRange)
You can use the array function LINEST() to get the linear fit. It returns various statistics in addition to the slope and intercept. I suggest you check out the Help section, as that function is more complicated.
Finally, if the data are used in a scatter chart, you can double click on the chart to put it in edit mode and then go to Insert -> Trend Lines to add the line, equation and R Squared to the chart.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: line of best fit
Alternatively you can plot the data as an X Y scatter chart, and add a a trend line.
In edit mode right click on any of the plot points select add trend line, and from the pop-up window chose Linear regression and tick the show equation box.
In edit mode right click on any of the plot points select add trend line, and from the pop-up window chose Linear regression and tick the show equation box.
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
- merikilpikonna
- Posts: 3
- Joined: Sun Dec 13, 2009 12:37 am
Re: Line of best fit
is it also possible for non linear curves?
old posts suggest that there has been a statistics tab in earlier oo versions, but i can not find an equivalent.
old posts suggest that there has been a statistics tab in earlier oo versions, but i can not find an equivalent.
OpenOffice 3.1 on Ubuntu 9.10
Re: Line of best fit
If you search the Help Index of OpenOffice Charts for Trend Lines in Charts, you will find formulas for finding the parameters of various kinds of non-linear fits.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.