ANALYSIS
1. Use the data you have collected in
Procedure step 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.
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.