1. Use
the data you have collected in procedure 4 to calculate 
,
and thus determine the focal length f, for each value of do.
Record the results in cells G39:G47. Find the average focal
length from the data in cells G39:G47, and enter the result in cell
G48.
Answer Questions 6 and
7 on the Worksheet.
,
and thus determine the focal length f, for each value of do.
Record the results in cells G39:G47. Find the average focal
length from the data in cells G39:G47, and enter the result in cell
G48.
Answer Questions 6 and
7 on the Worksheet.2. Copy and Paste the data in Table C39:F47 (not the entire table)
into the Table in cells A81:D89. For each do
value, compute the ratios
to be entered in cells E81:E89
and the ratios
to be entered in cells F81:F89.
3. Compute the percentage error between the height ratio and the distance ratio in each case, and enter the results in cells G81:G89. Find the average of all these errors and enter the result in cell F92.
4. Obtain
a printout of your Worksheet and use it to develop your lab report.