Perform the following steps for both kinds of sample: lead and copper or aluminum:

1.  For both runs, use the spreadsheet calculator to compute the temperature rise experienced by the cold water, cup and stirrer, (T_f - T_c), in cell E37:F37 on the Worksheet.

2.  Using the measured masses of water and the cup-stirrer, and the given specific heat of the material out of which the cup-stirrer is made, use the relation in equation (3) to compute the heat gained by the cold bodies during the experiment in cells E40:F40 on the Worksheet. The value for lead is automatically calculated by the spreadsheet. Reproduce the computation for the copper or aluminum data.

3.  The heat lost by the hot metal shot is equal to the heat gained by the cold bodies from equation (2). Divide the total heat lost by the mass and the temperature change of the hot metal shot as it appears in cells E38:F38, to obtain a value for the specific heat of the metal in each case. Enter the results in cells E43:F43 on the Worksheet. Again, the value for lead is automatically calculated by the spreadsheet. Reproduce the computation for the copper or aluminum data.

4.  Compare the measured specific heat of lead and copper or aluminum with the accepted values already entered in cells E44:F44 by calculating the percentage error and entering it in cells E45:F45 on the Worksheet.