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 Subscribe to our channel: / biologylectures
Please follow us on
Facebook: / biologylectures
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

[@virgirma1328_PhD_scholar]

Thank you so much for this presentation !

[@BiologyLectures]

You are most welcome 🤗

[@easybiologynotes]

Excellent this is what I was looking for.

[@BiologyLectures]

Glad it was helpful!

[@dr.ahmedmajeed6336]

That was very helpful, thanks a bunch

[@BiologyLectures]

You are most welcome 🤗

[@mahagullzafar9708]

Very well explained

[@dikshyapanthi7681]

Best lecture on CZcams ❤

[@BiologyLectures]

thanks

[@olaadel60]

This equation is used for testosterone analysis ?

[@kittyttoki]

Super amazing, you made it so easy

[@BiologyLectures]

Thank you very much 😊

[@saroshsohail8050]

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

[@BiologyLectures]

Thank you very much for the kind words

[@BiologyLectures]

Thank you very much for the kind words ❤️

[@Esteppang]

Thank you very much!

[@BiologyLectures]

You are most welcome 🤗

[@ruth-annfrimpong1723]

thank you sooooo much for this..... very simple....

[@BiologyLectures]

You are most welcome.

[@NAA077]

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

[@BiologyLectures]

You are most welcome. Please find the link below for the bacterial growth curve. We will upload another video about how to measure the bacterial growth curve over time as soon as possible. czcams.com/video/U66FloGr-s0/video.html

[@markrobinson9676]

Excellent tutorial

[@BiologyLectures]

Thank you! Cheers!

[@aishanivadi9741]

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

[@BiologyLectures]

You are most welcome.

[@faithobi9774]

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

[@shirushana]

thank you so much :)

[@BiologyLectures]

You are most welcome

[@Mauryaarjun]

Thank you🙏🌹❤

[@BiologyLectures]

You are most welcome.

[@user-li6us3lv8o]

you saved me. thank you so much

[@BiologyLectures]

You're welcome!

[@TU-qc5xr]

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

[@maanotshimange4129]

Did you measure two times on the same same samples ?

[@BiologyLectures]

Yes, that is correct. That's why we have technical duplicates.

[@BeHappy-tr9wh]

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

[@shreyasverma5157]

Great!!!

[@BiologyLectures]

You are welcome.

[@hadassahsunday6851]

How did you get the equation

[@BiologyLectures]

As shown in the video, click on show equation icon

[@mirzaaishah4966]

Easy to understand

[@BiologyLectures]

Thank you

[@khanshab5173]

Concentration sy phly wali absorbance kha sy i

[@JHKanus]

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

[@lifeiseco7688]

Not necessary..... points may be above or below or on line....r value vary accordingly

[@biyamushtaq9616]

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

[@BiologyLectures]

You can measure the absorbance at 562 nm.

[@biyamushtaq9616]

@@BiologyLectures thank you

[@BiologyLectures]

@@biyamushtaq9616 You are most welcome.

[@redcolour1197]

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

[@BiologyLectures]

Then please follow the instructions shown in the video to calculate the concentration

[@NehaKumari-lt8xw]

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

[@neha7neha]

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

[@BiologyLectures]

It will be in mg/ml.

[@shrikrishan7105]

How i come Germany ❤😊

[@BiologyLectures]

You can come to study or work in Germany.

[@shrikrishan7105]

@@BiologyLectures Tell me the process please

[@shrikrishan7105]

@@BiologyLectures can you call me..?

[@manidipasarkar1060]

@@BiologyLectures Respected Sir..Can you please help me out to find the other value? I have absorbance value of unknown sample for different time like 20 min.,30 min. and for 60 min. I have standard curve also for the same drug. I have used D-glucose and the process is In Vitro Reverse Iontophoresis Process. Now I'm struggling to find the other value. What I want to calculate: Extracted glucose Concentration (µM), Concentration for receptor chamber (µgm), Cumulative amount(µg), Glucose flux extracted(nmole cm−2 h−1), steady state flux, cumulative penetration for each sampling time.

[@manidipasarkar1060]

Can you please share your mail i'd here..??