How to Calculate the Brackett Series in Excel?

  • Thread starter Thread starter ZedCar
  • Start date Start date
  • Tags Tags
    Excel Series
AI Thread Summary
To calculate the wavelengths of hydrogen atom transitions in the Brackett series using Excel, it's essential to correctly reference cell addresses, using absolute references for constants like R. The user attempted to use variable references incorrectly, which led to confusion in the formulas. The correct value for n0 should be 4, not 5, and the use of n-1 in the formula represents n' as per the Rydberg formula. Clarification is needed on whether n' is a fixed value, as it appears to remain constant in the context provided. Proper formula setup and understanding of the variables are crucial for accurate calculations.
ZedCar
Messages
353
Reaction score
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

Physics news on Phys.org
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?
 
  • Like
Likes 1 person
DrClaude said:
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.
 
But isn't n' a fixed value? looking at the table in bottom right.. n' = 4 doesn't change does it.
 
Thread 'Variable mass system : water sprayed into a moving container'

Thread 'Variable mass system : water sprayed into a moving container'

Starting with the mass considerations #m(t)# is mass of water #M_{c}# mass of container and #M(t)# mass of total system $$M(t) = M_{C} + m(t)$$ $$\Rightarrow \frac{dM(t)}{dt} = \frac{dm(t)}{dt}$$ $$P_i = Mv + u \, dm$$ $$P_f = (M + dm)(v + dv)$$ $$\Delta P = M \, dv + (v - u) \, dm$$ $$F = \frac{dP}{dt} = M \frac{dv}{dt} + (v - u) \frac{dm}{dt}$$ $$F = u \frac{dm}{dt} = \rho A u^2$$ from conservation of momentum , the cannon recoils with the same force which it applies. $$\quad \frac{dm}{dt}...
View full post »

Thread 'Egg Drop Challenge! Need ideas for winning designs'

I was thinking using 2 purple mattress samples, and taping them together, I do want other ideas though, the main guidelines are; Must have a volume LESS than 1600 cubic centimeters, and CAN'T exceed 25 cm in ANY direction. Must be LESS than 1 kg. NO parachutes. NO glue or Tape can touch the egg. MUST be able to take egg out in less than 1 minute. Grade A large eggs will be used.
View full post »

Similar threads

Brackett series nearest to Paschen series
Replies
1
Views
4K
Kinetic Energy Equations in MS Excel
Replies
3
Views
5K
How do I calculate the normal force for equilibrium lab?
Replies
20
Views
6K
Coulomb's Law and Conditional Convergent Alternating Harmonic Series
Replies
11
Views
2K
Electric field between conducting and non-conducting sheets
Replies
9
Views
4K
Calculation of no. of spectral lines for group of similar atoms
Replies
16
Views
3K
Question about finding electric field using slope on excel
Replies
1
Views
2K
Centripetal Lab- finding the mass from the slope
Replies
1
Views
3K
Solved: Value of Infinity for Hydrogen Atom Wavelength
Replies
4
Views
2K
Young's double slit experiment: Determine thickness of mica
Replies
2
Views
2K

Hot Threads

Recent Insights

Back
Top