After all of the data has been collected, and your preliminary calculations have been signed off by Mrs. Colwell, use the spreadsheet 1-spectrum.xls (in your period folder) to determine your experimental wavelengths and percent errors of the red, cyan, and violet lines in the Balmer's series of the hydrogen spectrum.

Immediately after opening the EXCEL file, resave it as LastnameLastnameLastnameSpectrum.xls. You are to only input values into the yellow cells - the blue cells have already been programmed for you. If your errors are large, see Mrs. Colwell about recollecting your data. Once you are satisfied with your results, type in the names of your group members and save your spreadsheet a final time. A printout of your file is required as part of your lab report.

What is the filename of your spreadsheet?

What was the average experimental value of your group's red wavelength (in nm)?

What was the average experimental value of your group's cyan wavelength (in nm)?

What was the average experimental value of your group's violet wavelength (in nm)?

Which wavelength had the greatest percent error?

State and explain a source of error that could account for your error.