Difference between revisions of "Documentation/FAQ/Calc/Charts/How do I compute or plot trend lines?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Charts
(New page: {{DISPLAYTITLE: How do I compute or plot trend lines?}} <section begin=question/> '''How do I compute or plot trend lines?''' <section end=question/> <section begin=answer/> First, You n...) |
m |
||
| Line 16: | Line 16: | ||
Trendline: You have to have an xy chart to make a trendline (change the chart type). When you have a chart, select the data points, and then right click and select 'Object properties'. In the statistics tab, select the regression picture (none, linear, etc.) that you want. | Trendline: You have to have an xy chart to make a trendline (change the chart type). When you have a chart, select the data points, and then right click and select 'Object properties'. In the statistics tab, select the regression picture (none, linear, etc.) that you want. | ||
| − | + | OpenOffice.org Version 1, Calc only really does linear. | |
<section end=answer/> | <section end=answer/> | ||
[[Category:Documentation/FAQ/Calc/Charts]] | [[Category:Documentation/FAQ/Calc/Charts]] | ||
Latest revision as of 12:38, 6 October 2021
How do I compute or plot trend lines?
First, You need a column on your spreadsheet to hold average values. Averages can be made by using one of these formulas:
=SUM(<cell range>/<number of cells>)
=AVERAGE(<cell range>)
Now, on to graphing:
You can do trendlines in Calc, but you can't show the equation of the line. To do that you need to do a linear array function.
Trendline: You have to have an xy chart to make a trendline (change the chart type). When you have a chart, select the data points, and then right click and select 'Object properties'. In the statistics tab, select the regression picture (none, linear, etc.) that you want.
OpenOffice.org Version 1, Calc only really does linear.
