Hi guys,
I am not mathmatically minded, so please bear with me. I finished of an experiment a few weeks ago, now I am just trying to plot a few graphs and come to conclusions, the finish line is close, or so I thought.
So a quick recap on what I was actually doing.
This was an experiment measuring the rate of dissolution of a drug.
A standard solution was made up for the active compound in the drug andserial dilutions were then made from this. They were then placed into a UV vis spectrophotometer, absorbances were read and from this a calibration graph was made in excel, a line of best fit was made and from this I was able to plug in future absorbances from an experiment for it to automatically calculate the concentration for me. Hope this makes sense so far!!
For the experiment. the drug in question was then added to buffered solutions at ph2, ph8 and a control (water). At 30 min intervals, samples were taken and absorbances were read.
So I am getting some good absorbances, for the pH which was most suitable for the drug to dissolve, so I can use the calibration graph to calculate the concentration for these absorbances and then plot concentration against time. However for the pH's which were less suitable for the drug, the absorbances were of course low, I was hoping to be able to plot some sort of graph for each variable but I am not sure how I would go about it with negative values being produced. I am also getting these sort of values from excel, 2.1985E-05, which is confusing me.
I have never used excel for this sort of work before, so if someone could help me that would be great. I just want to get this finished and put to bed!
thanks