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:
violet 20.35cm
light blue 21.70cm
green 23.08cm
light green 22.75cm
yellow 27.70cm
red 31.70cm
faint red 33.95cm
and then for hydrogen:
purple 19.57cm
green 22.47cm
yellow 26.95cm
red 31.00cm
Its given the visible helium emission lines:
wavelenght(nm) relative intensity
447.1 200
468.6 30
471.3 30
and so on...
Also there is a table of colors of visible light:
wavelenght range (nm)
380-420 violet
420-440 violet-blue
440-470 blue
470-500 blue-green
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.
plzzzzzzzzzzzzzzz help
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.
To set up the Excel spreadsheet for creating a calibration curve for helium, you will follow these steps:
Step 1: Create two columns in your Excel spreadsheet. Name the first column "Distance (cm)" and the second column "Wavelength (nm)".
Step 2: Enter the data for helium into the respective columns. In the "Distance (cm)" column, enter the values you obtained in the lab for helium. In the "Wavelength (nm)" column, enter the corresponding wavelength values from the given visible helium emission lines table.
Step 3: Now, you need to convert the distance from centimeters to meters, as specified in the question. To do this, divide the values in the "Distance (cm)" column by 100 and replace the existing values with the converted values.
Step 4: Plot the data points on a scatter plot in Excel. Highlight both columns by clicking and dragging on the column headers. Then, go to the "Insert" tab in the Excel ribbon and select the "Scatter" chart type. Choose the scatter plot with markers only, without any connecting lines.
Step 5: Adding a trendline. Right-click on any data point, and then select "Add Trendline" from the context menu. In the "Format Trendline" pane, choose the "Linear" option for simplicity. This will add a best-fit straight line to your data points.
Step 6: Formatting the chart. Customize your chart by adding chart axis labels, titles, adjusting font sizes, and changing colors as needed. This will make your chart more professional and visually appealing.
By following these steps, you should be able to create a calibration curve for helium in Excel using the given data.