Chemical Forums
Chemistry Forums for Students => Undergraduate General Chemistry Forum => Topic started by: grs35 on March 24, 2012, 11:26:08 AM
-
i am using Excel to calculate standard curves from absorbance data. i have 4 concentrations matching with 4 different absorbance vaules. but i have to set the graph to zero first in order to write the equation.
because right now the line looks crooked. itis not linear. and therefore i have 3 different slopes. i have to have 1 single slope so that i can apply this equation to other calculations.
anyone knows how to set the graph to zero and write down this equation ?
here are the data :
x values
2.10^-6
4.10^-6
6.10^-6
1.10^-5
y values
0.169
0.342
0.489
0.795
-
Shouldn't you do a linear regression on your data?
-
Shouldn't you do a linear regression on your data?
honestly i am confused because of these results.
-
Looks quite linear to me. Have you done the blank test to see what is the absorbance for zero concentration? I would not force the curve to go through zero just for the sake of doing it.
-
Looks quite linear to me. Have you done the blank test to see what is the absorbance for zero concentration? I would not force the curve to go through zero just for the sake of doing it.
i put the values on the graph and its not linear. there are three slopes 86500, 73500, 76500
yes, i did it for zero concentration too. but they want us to perform linear regression and write down the equation. but it is impossible to do that with a nonlinear graph.
honestly i dont want to force it to go through zero too. but what should i do then ?
-
Maybe if you showed us your chart, we could see where you're having a problem. Yes, there are many possible slopes, but a linear regression will give you the best possible one to take in to account all that you know ... for most data sets likely found in an undergraduate laboratory.
-
Maybe if you showed us your chart, we could see where you're having a problem. Yes, there are many possible slopes, but a linear regression will give you the best possible one to take in to account all that you know ... for most data sets likely found in an undergraduate laboratory.
here is what i got.
bluedye1.numbers (http://www.4shared.com/file/o-iGEJtK/file.html?refurl=d1forum)
-
Please post it as an attached image.
-
(http://bluedye1)
-
i think this works.
-
Looks to me like you plotted absorbance against point number, not against concentration. Make a scatter plot.
-
Looks to me like you plotted absorbance against point number, not against concentration. Make a scatter plot.
how about now ?
-
Look at your y-axis. This is your absorbance. Do you see how each one of your data points matches an absorbance on your y-axis? Now look at your x-axis. This is your concentration. Does each data point match one of your concentrations? They don't. You'll notice the x-axis value for each of your data points is 1, 2, 3, 4. They should be 0.000002, 0.000004, 0.000006, 0.00001. If they don't have that on the x-axis, then you set your graph up wrong.
It looks like you didn't specify values for your x-axis, so Excel just filled in generic values 1, 2, 3, 4. You need to specify values for the x-axis. To do this, right click on one of your data points, then click "select data." There is an option there to edit a series, and you can then pick your x-axis and y-axis values as you please. Try that out.
It does look like you got your trendline down, right, though. So that's good. You just need to fix your x-axis.
-
Look at your y-axis. This is your absorbance. Do you see how each one of your data points matches an absorbance on your y-axis? Now look at your x-axis. This is your concentration. Does each data point match one of your concentrations? They don't. You'll notice the x-axis value for each of your data points is 1, 2, 3, 4. They should be 0.000002, 0.000004, 0.000006, 0.00001. If they don't have that on the x-axis, then you set your graph up wrong.
It looks like you didn't specify values for your x-axis, so Excel just filled in generic values 1, 2, 3, 4. You need to specify values for the x-axis. To do this, right click on one of your data points, then click "select data." There is an option there to edit a series, and you can then pick your x-axis and y-axis values as you please. Try that out.
It does look like you got your trendline down, right, though. So that's good. You just need to fix your x-axis.
thank you everyone. It was so simple but sometimes the mind just stops :) here is what i got at last. and its correct.