Brackett Series - Excel sheet

  • Thread starter ZedCar
  • Start date
  • #1
354
1

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.
 

Attachments

  • Brackett.xlsx
    28.6 KB · Views: 456

Answers and Replies

  • #2
DrClaude
Mentor
7,603
3,999
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?
 
  • #3
354
1
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.
 
  • #4
199
1
But isn't n' a fixed value? looking at the table in bottom right.. n' = 4 doesn't change does it.
 

Related Threads on Brackett Series - Excel sheet

Replies
1
Views
3K
Replies
4
Views
2K
Replies
4
Views
2K
  • Last Post
Replies
2
Views
1K
Replies
9
Views
190
  • Last Post
Replies
2
Views
2K
  • Last Post
Replies
7
Views
2K
  • Last Post
Replies
3
Views
5K
  • Last Post
Replies
5
Views
4K
  • Last Post
Replies
4
Views
2K
Top