where L is the length and d is the diameter.

2.    Use these volumes and the density of water given in your text to calculate the weight of an equal volume of water (the displaced weight) for each object (cylinders and rock), and enter the results in cells E22:E27 on the Worksheet. Use the relation:

Displaced Weight = ρwater g V

where g is the acceleration of gravity and V is the volume of the cylinder calculated above.

3.    Compare the results of step 2 above with the buoyant force as determined from the observed loss in weight of the objects (cylinders and rock) while suspended in water by subtracting this value from the actual weight in air in each case. Use the relation:

B = W_o− W₁

Enter the results of the buoyant force calculations in cells F22:F27 on the Worksheet.

4.    Using equation (1), determine the specific gravity of each of the cylinders and the rock, and enter in cells G22:G27 on the Worksheet.

5.    Determine the density of the objects from the specific gravity by multiplying the SG times the density of water and enter the results in cells D32:D37 on the Worksheet.

6.    Determine the density of each object by using the basic definition of density and the mass-volume data in each case. Use the relation:

 
Recall that the mass and the weight (in air) are related by: .

Enter the results in cells C32:C37 on the Worksheet, and compare with the values obtained in step 5 above by finding the percentage difference and entering it in cells E32:E37.

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

8.    Determine the density of the mystery fluid by multiplying the Specific Gravity by the density of water, and enter the results in cells G41:G45.

9.    From the above results, find the average specific gravity and density of this fluid, and enter in cells F46:G46.

10.    Answer Questions 1 through 4 on the Worksheet.