The tutor shows how to get a graph and equation for data using LibreOffice Calc, in six easy steps.
- Let’s imagine your x-data is in a1:a5, your y-data, b1:b5.
- Select the range a1:b5.
- Click the Chart icon, which looks like a little pie graph. You’ll probably see your chart immediately, but it may not be a scatter plot.
- A chart wizard opens up, offering you choices. Pick XY(Scatter). You can also pick, on successive screens, other options as well, but for this purpose, you can next click Finish.
- Now, on the scatter plot that appears, you’ll see blue markers. Click on one of them; they’ll turn green. They need to be green.
- Go to the top and click Insert, then the Trend Lines… option. You’ll see different types of equations available. Select the one you desire, then, to see the equation, check the box Show Equation. Finally, click OK.
Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.