Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc User Guide
Previous Page Home Next Page

Fitting a regression line to the data

So far we have been working with a simple scatter plot, but if we look at the data points on the graph, it looks like there is a fairly strong relationship between wind speed and the amount of cloud cover. Let’s add a regression line to this graph and see what we get.

  1. Right-click in the graph and select Edit.


    From now on, we will omit ‘right click in the chart’ in our instructions. Unless otherwise specified, the command Edit assumes that this has been done and that we are selecting Edit from the pop-up menu that we first saw in Figure 59.

  2. Select Insert > Statistics and then Linear Regression.

The linear regression line is now on the graph. This freshly invented data does show that cloud cover increases as the wind speed picks up. However, to make the graph look a little better, we should have increased the y-axis from a maximum of 50 to 55 or even 60.



Calc will graph four different kinds of regression line: Linear, logarithmic, exponential and power. If you need the coefficients for these lines, you must use the statistical functions to calculate the regressions.

OpenOffice Calc User Guide
Previous Page Home Next Page

  Published under the terms of the Open Publication License Design by Interspire