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.