1 Find the density of water at your measured temperature in
Last updated: 6/19/2023
1 Find the density of water at your measured temperature in Table ME 5 in the lab manual and record 2 Start a new sheet in your spreadsheet Enter the values for the temperature and density of water along with the mass delivered in each trial as shown in Figure ME 11 in the lab manual 3 Enter the formula to calculate volume rearrange Equation ME 5 To lock the cell address of the density value in the spreadsheet formula add a dollar sign in front of the row number of the cell For example to lock the cell address of the density given in Figure ME 11 you would enter B 2 in the formula Adjust the calculated values to display the proper number of decimal places 4 Calculate the average standard deviation and coefficient of variation as described in Part I of the Data Analysis section 5 Enter the true value intended volume of 4 00 mL Calculate the absolute and errors as described in Part I of the Data Analysis section 6 Save a copy of your spreadsheet Print both sheets in normal value mode and then print both sheets in formula display mode by selecting the Show formulas option in the toolbar Water temperature 19 9 C 0 1pts Water density g mL Refer to this table of water density at different temperatures or Table ME 5 in the lab manual Include all seven decimal places provided in the table Complete the following table with your answers for volume mL and density g mL of water Report Table ME 5 Volume delivery analysis Calculations of volume delivered in each trial Trial 1 Trial 2 Trial 3 Mass delivered g 3 979 3 975 3 980 Table view List view Volume delivered mL 3 979 3 975 3 980