The Student Room Group
Competition - post a photo you've taken of nature >>
Competition - post a photo you've taken of nature >>
Competition - post a photo you've taken of nature >>

Calibration curve on EXCEL can anyone help me? I'm doing it for 2 data sets

So I have two series of data (duplicates) of absorbance for standarised glucose solutions and I'm trying to use excel to make a calibration curve to find the concentration of the unknown but my big issue is that I can't do a line of best fit between the two sets so please help.
bump
Could you show the steps of what you've tried doing already? I don't think many people can help since you could have done multiple things incorrectly. :smile:
Original post by Harantony
Could you show the steps of what you've tried doing already? I don't think many people can help since you could have done multiple things incorrectly. :smile:



How have I done things incorrectly? Lmao The smiley face doesn't help m8

I've ended up averaging the series and I plotted a line of best fit using the averages of the two data series. And then I hid the average points that excel plotted to make the line of best fit with white paint so that I only have two data series instead of two data series and the average


A little deception on my part but worked like a charm.

Quick Reply

Related discussions

Latest

Trending

Trending

Articles for you