posted by natash on .
ok I'm having trouble with graphing this chemistry lab. It's on atomic emission spectra. In this experiment we observed the line spectrum of first helium, and here is the data:
color: distance: wavelenght:
light blue 21.70cm
light green 22.75cm
faint red 33.95cm
and then for hydrogen:
Its given the visible helium emission lines:
wavelenght(nm) relative intensity
and so on...
Also there is a table of colors of visible light:
wavelenght range (nm)
and so on...
Now I'm asked to make a calibration curve for helium. distance along meter stick A vs. waelength
I know Y is the distance (cm)which we found out in the lab and wavelenght (nm) is the X.
I don't understand how I would set up the excel.
Personally, I wouldn't waste my time on setting up a program on Excel. If you were to do this every day for a year it would make sense but to do it once it is easier to calculate each line and graph it manually. You can be through with it by the time you set up the program. Of course, you may have been asked to graph it ON THE COMPUTER with Excel in which case just ignore this response. I don't know how to use Excel to graph. However, if you will go to the Excel help button and type in graph, the instructions will come up. I have found the Help section very useful.