I have made a calibration curve on excel, then used the function "=TREND(B2:B6,A2:A6,B8)" to automatically calculate the concentrations for me from previously determined absorbances.
However just to test them out, I added in the absorbances from the first 3 in my calibration curve, expecting to get the exact same concentrations, but they are slightly out, anyone know why this is?
I hope this makes sense, all help is very much appreciated.
Anyone here good at using Excel? Check out my calibration curve on excel! watch
- Thread Starter
- 11-05-2015 23:54
- 12-05-2015 00:01
If you were to plot your data on a chart, then add a line-of-best-fit, then the points do not fall exactly on the line (R2 = 0.9995, which is pretty good).
Using the TREND command is essentially doing the same thing.
- 12-05-2015 18:41
Ok thanks, first time I've ever done one on excel, so wanted to make sure it was right before I started plugging in new absorbances.Last edited by S.Duncan; 12-05-2015 at 18:44.