In your spreadsheet program, create a new spreadsheet. give it a unique name so you can return to it later if necessary. in column a, which could be given the title "cylinder mass," enter the true mass of the cylinder used, from 0 (no cylinder) to 6.000 g. in column b, which could be given the title "balance 1 reading," enter the balance readings you recorded for balance 1. in column c, titled "balance 2 reading," enter the balance readings you recorded for balance you can open the data sheet (above) to find these values. create two charts, with lines and points: one for balance 1 readings (y-axis) vs the cylinder mass (x-axis), and another for balance 2 readings vs mass of the cylinder. while they should both show an obvious linear relationship, the points will not fall exactly on a single line with a slope of 1.000 and an intercept of 0.000.
using the method illustrated in the introduction section, plot a linear trendline and display the linear equation and the r-squared value for the trendline. enter the calculated values below with three significant figures. in order to force the r-squared value to display more significant figures, you might have to hover the cursor over the trendline legend, right-click to expose properties, select "format trendline ", select the category and switch it to number from general, and set the decimal places to 5.