Please use the spreadsheets to answer the questions from 9-12

Chem 1A Scientific Graphing Lab Part 2: Spreadsheet And Formula Entry 1. Enter the following headers into top cells of 8 columns of the spreadsheet: Mass (g), Volume (mL), Density (g/mL), Ave Mass (g), % Dev Mass, Ave Density (g/mL), True Density (g/mL), % Error 2. Enter the following data into the first 2 columns, under the Mass and Volume headers: Mass (g) Volume (mL) 9.2785 13.87 9.8725 14.10 9.4721 13.92 9.5742 13.99 9.7427 14.02 3 Use the entered data to perform calculations for density. Remember that: density = mass/volume Using the appropriate syntax for a spreadsheet formula (start the formula with "=") that will use the data in the first 2 columns for this calculation, enter a formula in the first cell under the Density header. If the values for the first row of data, 9.2785 and 13.87 are in cells A2 and B2 respectively, the formula in cell C2 should be the expression "=A2/B2", and the value displayed should be the results of the calculation. 4 Copy the density formula in cell C2 into the cells below it. This can be accomplished by copying the density formula in the first cell and pasting it into the remaining cells below. Alternatively, select the first cell (C2), then drag the lower right-hand "+" sign in the cell down the column. This will apply the formula to the other relative mass and volume data there. Density values should now appear in all cells under the Density (g/mL) header. 5 Adjust the display format of the calculated cells to the correct number of significant figures. (Increase/Decrease Decimal buttons) 6 In the first cell under the Ave Mass (g) header, enter a formula for determining the average of the mass values. Alternatively, Excel contains the special function "Average" for this formula. An average value should now appear in the cell. 7 Perform a percent deviation analysis on the mass measurement data. Remember the equation for percent deviation, (experimental value - average value) x 100% = % deviation (+ or -) average value In the first cell directly under the % Dev Mass header, enter a spreadsheet formula for determining the percent deviation of the mass value on the same row, using the newly calculated average mass value in its permanent cell position. When using a permanent cell location in a formula (like the average value in this calculation), a "$" sign must be placed in front of the cell letter and cell number (e.g. $C$9 instead of C9). A percent10 11 12 deviation value should now appear in the cell. Check the spreadsheet's value by performing the same calculation on your scientic calculator. When the spreadsheet formula for the percent deviation calculation is correct in the rst cell, then select that cell and drag the lower right-hand \"+\" sign down the column to apply the formula to the other relative mass data in each row. Percent deviation values should appear in all cells under the % Dev Mass header now. If necessary, format the new values to the appropriate amount of sig gs. To calculate an average density value in the cell under Ave Density (glmL) header, enter a spreadsheet formula that is similar to the formula that was entered for the average mass in step 6. Check the spreadsheet calculation by performing the same calculation on your scientic calculator. If necessary, format the new value to the appropriate amount of sig gs. Enter the following true density value in the cell under True Density (gme): 0.6824 Perform a percent error analysis on the average density value. Remember the equation for percent error: {experimental value true value} x 100 % = % error (+ or -) true value In the rst cell directly under the % Error header, enter a spreadsheet formula for determining the percent error of the average density value as compared to the above true density value. A percent error value should now appear in the cell. Check the spreadsheet's value by performing the same calculation on your scientic calculator. Format the new value to the appropriate amount of sig gs. The display should be similar to this, with appropriately rounded and formatted values for all X's: Mass (g) Volume Density Ave %Dev Ave Density True Density %Error (mL) (gme) Mass (a) Mass (g/mL) (g/mL) 9.2785 13.87 X X X X 0.6824 X 9.8725 14.10 X X 9.4721 13.92 X X 9.5742 13.99 X X 9.7427 14.02 X X A B C D E F G H Mass (9) Volume (ml) Density (g/ml) Ave Mass (g) % Dev Mass Ave Density (g/ml) True Density (g/ml) % Error 9.2785 13.87 0.6690 9.588 -3.228 0.6858 0.682 0.4947 9.8725 14.10 0.7002 2.967 9.4721 13.92 0.6805 -1.209 9.5742 13.99 0.6844 -0.144 9.7427 14.02 0.6949 1.613 10Step by step solution below 6) A B C D G H 1) 1 Mass(g) Volume(ml) Density(g/ml) Ave Mass(g) %Dev Mass Ave Density(g/ml) True Density(g/ml) %Error A B D E F G H 9.2785 13.87 0.6690 9.588 -3.2279933 1 Mass(g) Volume(ml) Density(g/ml) Ave Mass(g) %Dev Mass Ave Density(g/ml) True Density(g/ml) %Error 9.8725 14.1 0.7002 2.96725073 9.4721 13.92 0.6805 1.2088027 VOUAWN 2) 9.5742 13.99 0.6844 0.1439299 9.7427 14.02 0.6949 1.61347518 B C D E F G H 1 Mass(g) Volume(ml) Density(g/ml) Ave Mass(g) %Dev Mass Ave Density(g/ml) True Density(g/ml) %Error 9.2785 13.87 7) W N 9.8725 14.1 9.4721 13.92 A H U AL 9.5742 13.9 Mass(g) Volume(ml) Density(g/ml) Ave Mass(g) %Dev Mass Ave Density(g/ml) True Density(g/ml) %Error 6 9.7427 14.02 9.2785 13.87 0.6690 9.588 -3.228 9.8725 14.1 0.700 2.96 0.6805 -1.209 3) HOWAWN 9.4721 13.92 9.5742 13.99 0.6844 -0.144 9.7427 14.02 0.6949 1.61 A B C D E F G H 1 Mass(g) Volume(ml) Density(g/ml) Ave Mass(g) %Dev Mass Ave Density(g/ml) True Density(g/ml) %Error 9.2785 13.87 0.668961788 8) 9.8725 14.1 0.700177305 QUIAWN 9.4721 13.92 0.680466954 A B D E F G H 9.5742 13.99 0.684360257 1 Mass(g) Volume(ml) Density(g/ml) Ave Mass(g) %Dev Mass Ave Density(g/ml) True Density(g/ml) %Error 9.7427 14.02 0.694914408 9.2785 13.87 0.6690 9.588 -3.22 0.6858 0.6824 9.872 14.1 .7002 2.967 n AWN 0.6805 -1.209 4) 9.4721 13.92 9.5742 13.99 0.6844 -0.144 E F G H 9.7427 14.02 0.6949 1.613 A B C D 1 Mass(g) Volume(ml) Density(g/ml) Ave Mass(g) %Dev Mass Ave Density(g/ml) True Density(g/ml) %Error N 9.2785 13.87 0.6690 9)required solution 9.8725 14.1 0.7002 9.4721 13.92 0.6805 G H 9.5742 13.99 0.6844 C 9.7427 14.02 0.6949 Mass(g) Volume(ml) Density(g/ml) Ave Mass(g) %Dev Mass Ave Density(g/ml) True Density(g/ml) %Error 9.2785 13.87 0.6690 9.588 -3.228 0.6858 0.6824 0.4947 WN 9.8725 14.1 0.7002 2.967 9.4721 13.92 0.6805 -1.209 5 ) UT 9.5742 13.99 0.6844 -0.144 9.7427 14.02 0.6949 1.613 A B C D E G H 1 Mass(g) Volume(ml) Density(g/ml) Ave Mass(g) %Dev Mass Ave Density(g/ml) True Density(g/ml) %Error 9.2785 13.87 0.6690 9.588 9.8725 14.1 0.7002 UIAWN 9.4721 13.92 0.680 9.5742 13.99 0.6844 9.7427 14.02 0.6949 7