| Chem 182 - Winter 2021 (Visible Spectroscopy Expt.) |
| Table 1: Rydberg Constant Determination |
| Color | nf | ni | λ (nm) | λ (m) | "Transition" | 1/λ (m-1) |
| Red | 2 | 3 |
| Aqua | 2 | 4 |
| Blue/Purple | 2 | 5 |
| Violet | 2 | 6 |
| Slope from Rydberg Graph (m-1) | (use the =SLOPE() function) |
| * Accepted Rydb. Constant (m-1) | 1.097373E+07 |
| Percent Error (%) | % Low |
| * Reference for Ryd. Constant: Handbook of Chemistry and Physics, 81st Ed., 2019-2020, p.1-3 |
| Work to be done: |
| 1. Measure the wavelength (3 SFs) for the 4 emission lines from the spectrum image provided on Canvas |
| 2. Calculate the wavelength for each transition in meters |
| 3. Calculate the "Transition" value for each transition to 4 SFs (1/n2 - 1/n2) |
| 4. Calculate 1/λ in m-1 for each Wavelength |
| 5. Make a graph of transition (x-axis) and 1/λ (y-axis) |
| 6. Insert a linear regression trendline and the R2 value |
| 7. Deteremine the value of the Rydberg constant (the slope) |
| 8. Determine the % error (use given accepted value) |
| 9. Print a copy of the spreadsheets and graphs for your notebook |
| 10. Make sure you show one sample calculation, including the |
| Excel formula for each type of calculation you do |
| 11. Upload a copy of this Excel file after completing both parts |
Layan
ExcelDataforVisibleSpectW21.xlsx
