Experiment 14
ARCHIMEDES' PRINCIPLE

ANALYSIS


1.  Calculate the volume of each of the cylinders in m3, using the spreadsheet calculator. The volume for cylinder #1 is automatically calculated and appears in cell E10. View the formula in this cell to reproduce the calculation of the volume for the other cylinders in cells E11:E14 on the Worksheet.

2.  Use these volumes and the density of water to calculate the weight of an equal volume of water in each case, and enter the results in cells E23:E28 on the Worksheet. The spreadsheet calculation is already done for cylinder #1. Do the same for the other cylinders, and for the rock.

3.  Compare the results of step 2 above with the buoyant force determined from the observed loss in weight of the cylinders while suspended in water by subtracting this value from the actual weight in air in each case. Enter the results of the buoyant force calculations in cells F23:F28 on the Worksheet. The result for cylinder #1 is already calculated. Do the same for the other cylinders, and for the rock.

4.  Using equation (1), determine the specific gravity of each of the cylinders and the rock, and enter in cells G23:G28 on the Worksheet. Determine the density of the cylinders from the specific gravity by multiplying the SG by the density of water in cells D33:D38 on the Worksheet. A sample calculation is again provided for cylinder #1. Do the same for the other cylinders, and for the rock.

5.  Determine the density of each cylinder by using the basic definition of density and the mass-volume data in each case. Enter the results in cells C33:C38 on the Worksheet, and compare with the values obtained in step 4 above by finding the percentage difference and entering it in cells E33:E38. A sample calculation is again provided for cylinder #1. Do the same for the other cylinders, and for the rock.

6.  Using equation (2), determine the specific gravity and density of the mystery solution provided, and enter the results in cells F42:G46 on the Worksheet. Only the cylinder data need be used here.

7.  Find the average values of the mystery fluid specific gravity and density and enter in cells F47:G47.

8.  Answer Questions 1 through 4 on the Worksheet.

9.  Print out the Worksheet and submit it to your instructor.