Hey there! Sign in to join this conversationNew here? Join for free

Anyone here good at using Excel? Check out my calibration curve on excel! watch

    • Thread Starter
    Offline

    2
    ReputationRep:
    Hi guys,

    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.

    Attached Images
     
    Offline

    17
    ReputationRep:
    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.
    Offline

    0
    ReputationRep:
    Hi,
    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.
 
 
 
Poll
Do you agree with the PM's proposal to cut tuition fees for some courses?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.