How to Calculate the Brackett Series in Excel?

[ZedCar]

Homework Statement

I want to produce a simple Excel sheet to calculate the wavelengths of H atom transitions and calculate, in nm, the first 4 lines of the Brackett series.

Homework Equations

The Attempt at a Solution

Attempt at Excel sheet attached.

 

[DrClaude]

There is so much wrong here, I don't know where to start! You need to read up about using formulas in Excel.

For one thing, there are no "variables", but rather cell addresses. For example, to use the value of R, which you put in cell C2, you need to reference it with $C$2 (the dollar signs mean that neither C nor 2 will change when you copy the cell, it is an absolute address). Another example, in G4, to use the value of n, you reference $E4. There is no dollar sign in front of the 4 because you want the formula in G5 to read $E5 instead.

Also, why do you take n0 as 5? Why do you have a n-1 in the formula?

 

[ZedCar]

Also, why do you take n0 as 5? Why do you have a n-1 in the formula?

n0 should be 4.

I used n-1 in the formula to represent n' as in the Rydberg formula. n' being 1 less than n.

 

[asdf12312]

But isn't n' a fixed value? looking at the table in bottom right.. n' = 4 doesn't change does it.

 

[HalfLostAndSearching]

I appreciate your efforts in creating an Excel sheet to calculate the wavelengths of H atom transitions and specifically the first 4 lines of the Brackett series. The equations used in this calculation are based on the energy levels of the hydrogen atom and the Rydberg formula. Your attempt at the Excel sheet seems to be well-organized and easy to use. It would be helpful if you could provide a brief explanation of the equations and assumptions used in your calculation. Additionally, it would be beneficial to include references for the values used in the equations to ensure accuracy. Overall, your Excel sheet is a great tool for understanding the Brackett series and its transitions in the hydrogen atom. Keep up the good work!