April 20, 2019, 02:41:06 PM
Forum Rules: Read This Before Posting


Topic: Making an energy level diagram with excel?  (Read 3774 times)

0 Members and 1 Guest are viewing this topic.

Offline WK95

  • Regular Member
  • ***
  • Posts: 13
  • Mole Snacks: +0/-0
Making an energy level diagram with excel?
« on: November 02, 2013, 11:18:02 AM »
For a lab, we are to make an energy level diagram for the hydrogen atom based on our observations and measured wavelengths. Just how can I make such a graph with Excel?

Offline curiouscat

  • Chemist
  • Sr. Member
  • *
  • Posts: 3005
  • Mole Snacks: +121/-35
Re: Making an energy level diagram with excel?
« Reply #1 on: November 02, 2013, 11:34:07 AM »
Show us your numbers.

Offline WK95

  • Regular Member
  • ***
  • Posts: 13
  • Mole Snacks: +0/-0
Re: Making an energy level diagram with excel?
« Reply #2 on: November 02, 2013, 05:03:21 PM »
I was only able to see 3 Emission lines for Hydrogen. Their wavelengths as I've measured are 435nm which reflects a drop from n=5 to 2, 485nm which reflects a drop from 4 to 2, and 650nm which reflects a drop from 3 to 2.

Offline WK95

  • Regular Member
  • ***
  • Posts: 13
  • Mole Snacks: +0/-0
Re: Making an energy level diagram with excel?
« Reply #3 on: November 05, 2013, 10:52:40 PM »
I need to make this sort of graph with Excel only.

http://utopia.cord.org/step_online/st1-1/Fig1-13.gif

Sponsored Links