Reference no: EM132441505
Imagine you are given a metal cylinder and asked to determine whether it is made of gold, lead, copper, or iron. The densities of these materials are as follows.
Material Density (g/cm3)
Gold 19.3
Lead 11.3
Copper 8.93
Iron 7.86
You measure the mass of the cylinder to be m = 4339.9 0.5 grams, and you measure the length of the cylinder to be L = 18.220 0.003 cm. Just like in the lab you performed, you now measure the diameter in eight different places and obtain the following results.
Diameter (cm)
3.970
4.065
4.040
4.000
3.970
3.945
4.000
4.035
(a) Create an Excel spreadsheet that contains the above diameter measurements as well as all calculations necessary to obtain the average diameter of the cylinder and the standard deviation of the average diameter. Record these values below.
Davg =
Units are required for this answer.
Label all quantities in your spreadsheet and include units as appropriate, then submit your Excel file for grading. Give it the name density_yourusername.xls. The file size is limited to 100 KB.
This answer has not been graded yet.
(b) Determine the density of the cylinder.
avg =
(c) Which material is your cylinder most likely made from: gold, lead, copper, or iron?