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

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 ก.ค. 2024
  • 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

ความคิดเห็น • 59

  • @virgirma1328_PhD_scholar
    @virgirma1328_PhD_scholar ปีที่แล้ว +6

    Thank you so much for this presentation !

  • @easybiologynotes
    @easybiologynotes ปีที่แล้ว +6

    Excellent this is what I was looking for.

  • @dikshyapanthi7681
    @dikshyapanthi7681 ปีที่แล้ว +3

    Best lecture on TH-cam ❤

  • @dr.ahmedmajeed6336
    @dr.ahmedmajeed6336 ปีที่แล้ว +2

    That was very helpful, thanks a bunch

  • @saroshsohail8050
    @saroshsohail8050 8 หลายเดือนก่อน +2

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

    • @BiologyLectures
      @BiologyLectures  8 หลายเดือนก่อน

      Thank you very much for the kind words

    • @BiologyLectures
      @BiologyLectures  8 หลายเดือนก่อน

      Thank you very much for the kind words ❤️

  • @kittyttoki
    @kittyttoki ปีที่แล้ว +2

    Super amazing, you made it so easy

  • @NAA077
    @NAA077 ปีที่แล้ว +1

    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
      @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. th-cam.com/video/U66FloGr-s0/w-d-xo.html

  • @aishanivadi9741
    @aishanivadi9741 3 หลายเดือนก่อน +1

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

  • @ruth-annfrimpong1723
    @ruth-annfrimpong1723 10 หลายเดือนก่อน +1

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

  • @Esteppang
    @Esteppang 8 หลายเดือนก่อน +1

    Thank you very much!

    • @BiologyLectures
      @BiologyLectures  8 หลายเดือนก่อน

      You are most welcome 🤗

  • @markrobinson9676
    @markrobinson9676 ปีที่แล้ว +1

    Excellent tutorial

  • @olaadel60
    @olaadel60 7 หลายเดือนก่อน

    This equation is used for testosterone analysis ?

  • @Mauryaarjun
    @Mauryaarjun ปีที่แล้ว +1

    Thank you🙏🌹❤

  • @user-li6us3lv8o
    @user-li6us3lv8o 2 หลายเดือนก่อน +1

    you saved me. thank you so much

  • @faithobi9774
    @faithobi9774 6 หลายเดือนก่อน

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

  • @shirushana
    @shirushana ปีที่แล้ว

    thank you so much :)

  • @maanotshimange4129
    @maanotshimange4129 ปีที่แล้ว +1

    Did you measure two times on the same same samples ?

    • @BiologyLectures
      @BiologyLectures  ปีที่แล้ว

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

  • @TU-qc5xr
    @TU-qc5xr 3 หลายเดือนก่อน

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

  • @shreyasverma5157
    @shreyasverma5157 2 หลายเดือนก่อน +1

    Great!!!

  • @mirzaaishah4966
    @mirzaaishah4966 2 หลายเดือนก่อน +1

    Easy to understand

  • @hadassahsunday6851
    @hadassahsunday6851 ปีที่แล้ว +1

    How did you get the equation

    • @BiologyLectures
      @BiologyLectures  ปีที่แล้ว

      As shown in the video, click on show equation icon

  • @BeHappy-tr9wh
    @BeHappy-tr9wh 2 หลายเดือนก่อน

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

  • @JHKanus
    @JHKanus 3 หลายเดือนก่อน +1

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

    • @lifeiseco7688
      @lifeiseco7688 หลายเดือนก่อน

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

  • @biyamushtaq9616
    @biyamushtaq9616 10 หลายเดือนก่อน +1

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

    • @BiologyLectures
      @BiologyLectures  10 หลายเดือนก่อน

      You can measure the absorbance at 562 nm.

    • @biyamushtaq9616
      @biyamushtaq9616 10 หลายเดือนก่อน +1

      @@BiologyLectures thank you

    • @BiologyLectures
      @BiologyLectures  10 หลายเดือนก่อน

      @@biyamushtaq9616 You are most welcome.

  • @khanshab5173
    @khanshab5173 5 หลายเดือนก่อน

    Concentration sy phly wali absorbance kha sy i

  • @redcolour1197
    @redcolour1197 ปีที่แล้ว +1

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

    • @BiologyLectures
      @BiologyLectures  ปีที่แล้ว

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

  • @NehaKumari-lt8xw
    @NehaKumari-lt8xw 12 วันที่ผ่านมา

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

  • @neha7neha
    @neha7neha 9 หลายเดือนก่อน +2

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

  • @shrikrishan7105
    @shrikrishan7105 ปีที่แล้ว +1

    How i come Germany ❤😊

    • @BiologyLectures
      @BiologyLectures  ปีที่แล้ว

      You can come to study or work in Germany.

    • @shrikrishan7105
      @shrikrishan7105 ปีที่แล้ว

      @@BiologyLectures Tell me the process please

    • @shrikrishan7105
      @shrikrishan7105 ปีที่แล้ว

      @@BiologyLectures can you call me..?

    • @manidipasarkar1060
      @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
      @manidipasarkar1060 ปีที่แล้ว

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