Generating Standard Curve and Determining Concentration of Unknown Sample in Excel - Easy Method

In this video lecture, we explain about
Generating Standard Curve and Determining the concentration of Unknown Samples in Excel.
-Processing absorbance data
-Plotting concentration vs absorbance scatter plot
-Adding Trendline
-Displaying R2 value and equation on chart
-Calculating the concentration of the unknown sample such as protein concentration from the absorbance

Biology Lectures is a research organization with the mission of providing free, world-class education for anyone, anywhere. We offer quizzes, questions, instructional videos, and articles on a range of academic subjects, including biology, microbiology, pharmacology, bioinformatics, immunology, biochemistry, anatomy and physiology, and many more.

Please follow us on

Disclaimer

This video is for educational purposes only. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational, or personal use tips the balance in favor of fair use.
#Biologylectures #biochemistry #protein

[easybiologynotes]

Excellent this is what I was looking for.

[virgirma_PhD_scholar]

Thank you so much for this presentation !

[saroshsohail]

Thank you so much, sir. It was well presented with a moderate pace and exceptional explanation.

[Sid-roye]

Great video, well explained!
However, I was wondering: what is the range to be considered a good R square value? (so that you know that your standard curve is good enough to use it to calculate unknown protein concentrations?)
Also, regarding the displayed equation y=mx+b, does b (or m) have to have a specific value too to consider it to be a good standard curve?


Thank you very much!

[dr.ahmedmajeed]

That was very helpful, thanks a bunch

[aishanivadi]

Dude you saved me!! Thankyou so much this was so helpful

[NAA]

Thanks for all of your wonderful videos, I'm just wondering if you have any video here to measure growth curve and how to do that experiment under inducer effect if you have it already please paste the link here I could not find it myself.. best

[TU-qcxr]

how can you find an unknown dosage using the final concentration and the absorbance?

[maanotshimange]

Did you measure two times on the same same samples ?

[JHKanus]

Is it must for my plot points to be on the line?

[biyamushtaq]

aoa
reading of absorbance was measured on nm ??
you did not mention it
kindly explain it
thank you

[faithobi]

How do I convert the concentration gotten from the graph to percentage

[olaadel]

This equation is used for testosterone analysis ?

[NehaKumari-ltxw]

The equation will be x = (y- intercept)/ slope.
U are doing x = ( y+intercept)/slope
Please explain if i am doing wrong

[BeHappy-trwh]

How to convert mg/ml to mg/100gram... Please reply

[ShubhamMathur-gl]

Why the y intercept comming negative??

[khanshab]

Concentration sy phly wali absorbance kha sy i

[nehaneha]

I have one doubt that the concentration of unknown will be in mg/ml or mg/100 gram?

[redcolour]

The Concentration I got from the Spectrophotometer and from this equation are totally different.