Using Excel for a Calibration Curve

Поделиться
HTML-код
  • Опубликовано: 8 ноя 2024

Комментарии • 118

  • @elishabosch3896
    @elishabosch3896 3 года назад +78

    In 3 and a half minutes you explained what 15 pages of instructions couldn't. Thank you!

  • @twodragonsmessingaround
    @twodragonsmessingaround 9 месяцев назад +3

    Taking intermediate environmental chem and still didn't know what I was doing with this one. Absolute chad, you're a hero Mike.

  • @joeweiss3659
    @joeweiss3659 7 лет назад +71

    You don’t even know how much of a saint you are to me right now!! Thankyou!!

    • @Toalettduck
      @Toalettduck 6 лет назад +2

      lol bro same here, fucking assignment

  • @gloriaodekunle
    @gloriaodekunle 11 месяцев назад +5

    7 years later this video is still highly appreciated.

  • @valentinadasilva102
    @valentinadasilva102 4 года назад +41

    What a life saviour, even four years later during a pandemic hahahaha TYSM!!!!

  • @hannahaataja5525
    @hannahaataja5525 8 месяцев назад +2

    THANK YOU!!!! You simplified this so much to understand!!! Life saver!!!!

  • @ohno6528
    @ohno6528 Год назад +2

    2 weeks before the big lab test and you saved me! Thank you man

  • @cesarcardenas2613
    @cesarcardenas2613 Год назад +2

    Thank you so much, explained in 3 minutes what I couldn't get in hours.

  • @thenixaless7493
    @thenixaless7493 8 месяцев назад +2

    Absolute life savior man! Thank you loads!!

  • @zeynepberreduysak8687
    @zeynepberreduysak8687 6 лет назад +1

    You are an angel for ones that cannot make an equation curve. Thank you

  • @KazmaHD
    @KazmaHD 2 года назад +2

    Heros get remembered; but, Legends never die. Fantastic content sir 👏👏👏

  • @Captain_Anil
    @Captain_Anil 5 лет назад +7

    Wow. Thats what i was looking for. So simply explained. Thank you.

  • @d9e240
    @d9e240 4 года назад +4

    Dude...you are my friggin' hero.

  • @elizabethmarvin8553
    @elizabethmarvin8553 5 лет назад +2

    This video helped so much with my lab. Thank you!!!

  • @arjunvegada8533
    @arjunvegada8533 3 года назад +3

    sir video helps a lot.
    our teacher explains it in a very bad manner.
    person like is boon to students all over the world.

  • @Adriana-fh6vz
    @Adriana-fh6vz 2 года назад

    Super frumos si practic ai explicat. Multumesc frumos!

  • @MonkeyDLuffy-xr4fl
    @MonkeyDLuffy-xr4fl 7 лет назад +1

    Straight to the point and well explained. Thanks!

  • @aseelshahin274
    @aseelshahin274 2 года назад +1

    SAVED MY LIFE

  • @timb7298
    @timb7298 Год назад +1

    This video rocks, thank you

  • @shanicedehaney1483
    @shanicedehaney1483 2 года назад +1

    Thank you! This helped a lot!

  • @FazeAlG
    @FazeAlG 5 лет назад +3

    Thank you for that very straight forward explanation. How do you plot that unknown concentration on the calibration graph?

    • @d9e240
      @d9e240 4 года назад +1

      After calculating the concentration in molarity (as he demonstrated in the video) I added the "unknown" (now known concentration and molarity) to the two columns on the left, I created a new chart. I had to rewrite the axes and title but no big deal. I'm sure there is an easier way, but it worked for me.

  • @jackmiller9829
    @jackmiller9829 2 года назад

    thanks so much! it helped me with my report essay

  • @lucasahnen8573
    @lucasahnen8573 2 года назад +1

    you are a king

  • @petron8092
    @petron8092 2 года назад +2

    Hey man, nice video! But I wonder how much important is the R-Squared value (Coefficient of Determination probably). Should I divide the final unkown concentration with the R-Squared or multiply? I cant find it anywhere on the internet and I have exam in few days. Thank you in advance!

  • @raivatsala
    @raivatsala 2 года назад +2

    Thank you so much

  • @Kekky101
    @Kekky101 3 года назад +1

    I appreciate this video thank you

  • @finnjones229
    @finnjones229 5 лет назад

    Absolute lifesaver mate!

  • @sukleijn.
    @sukleijn. 6 лет назад

    Simple explanation, so useful. Thanks so much!

  • @richamishra9421
    @richamishra9421 2 года назад +1

    In case of y=mx-c..we can use this type of standard curve for calculation or not? ...please reply me sir ..its urgent

    • @mikedavis6274
      @mikedavis6274  2 года назад

      You should be able to, yes. Ideally c would be zero or at least a very small number because the absorbance should be minimal when the concentration is zero.

  • @knomesarecooliguess5928
    @knomesarecooliguess5928 3 года назад

    thank you for your awesome tutorial

  • @Daniel-gk1dp
    @Daniel-gk1dp 7 дней назад +1

    THANK YOU SO MUCH

  • @pennypap5376
    @pennypap5376 4 года назад

    This is great! If my calibration curve is emission% (e.g. sodium) with concentration (ppm) and i want to find the sodium mg/mL, do i follow the same steps?

  • @Sara-tg7hm
    @Sara-tg7hm 4 месяца назад

    What if we measured absorbance for each concentration twice, how would we be able to plot that?

    • @mikedavis6274
      @mikedavis6274  4 месяца назад

      I have a couple thoughts, but first, I would recommend asking your teacher what they recommend. (1) You can take the average of the two absorbance readings. I assume it is the same solution, so you may have run it twice to get the average. (2) You can plot two lines. This could potentially give you another slope, and another answer in the end. (1) is my advice, but I would recommend asking your teacher.

  • @SY-ey5nr
    @SY-ey5nr 5 лет назад

    Thank you very much. Nice explanation

  • @Giblet12
    @Giblet12 3 года назад

    Really good video!

  • @yaminaderdah8555
    @yaminaderdah8555 5 лет назад

    Thank you ! It's very helpful.

  • @doxiciclinaclorhidratata617
    @doxiciclinaclorhidratata617 7 лет назад

    Thank you! Your video helped me, to do my job. :)

  • @sadaffatima4520
    @sadaffatima4520 3 года назад

    Can I use same method for GC-MS sample concentration calculation by placing area instead of absorbance i.e. by plotting concentration vs area graph. Then is it ok to calculate sample concentration using y value of trend line as discussed here.

  • @ofirshorshy8281
    @ofirshorshy8281 2 года назад

    Thank you! very helpful

  • @zhilingliu9126
    @zhilingliu9126 5 лет назад

    Thank you! This is very helpful

  • @chemef3266
    @chemef3266 4 года назад

    factor calibration .how many valor it can have ?

  • @MaryIbikunle-d3k
    @MaryIbikunle-d3k Год назад

    Please I'm unable to label my graph on my laptop. Please help me out

  • @ayshab2123
    @ayshab2123 5 лет назад +1

    How do you get the absorbance, I have the raw data from my concentrations from the UV/Vis spectrometer.

    • @mikedavis6274
      @mikedavis6274  5 лет назад

      Usually the numbers you get from the spectrometer are unitless absorbance or transmittance numbers

    • @ayshab2123
      @ayshab2123 5 лет назад

      @@mikedavis6274 I did the ratio of know concentration over zero to get absorbance to create my calibration curve but it's not linear at all. I don't know what exactly I did wrong😨

    • @mikedavis6274
      @mikedavis6274  5 лет назад

      So you had a known concentration, diluted it and ran it through the instrument? What numbers did the instrument give you?

    • @ayshab2123
      @ayshab2123 5 лет назад

      @@mikedavis6274 for each concentration it gave me a number for each wavelength, like at wavelength 380.5 it had absorbance of 1.206, this continues until wavelength 899

    • @ayshab2123
      @ayshab2123 5 лет назад

      I honestly think it's the machine I used. Mabey because it's cheaper.

  • @deepanshusindhwani8980
    @deepanshusindhwani8980 2 года назад

    nice explanation

  • @maromohammed5893
    @maromohammed5893 8 месяцев назад

    I don't understand why the absorbance 0.125?

    • @mikedavis6274
      @mikedavis6274  8 месяцев назад

      That was a number I made up for my unknown's absorbance. You should use whatever your unknown's absorbance was.

  • @1829Emily
    @1829Emily 5 лет назад

    Thank you this is so helpful

  • @aaniz8737
    @aaniz8737 2 года назад

    how did you get 0.125 as the absorbance?

    • @mikedavis6274
      @mikedavis6274  2 года назад +1

      That is a reading that came off the instrument.

  • @badboy-ko6he
    @badboy-ko6he 6 лет назад +1

    thank you man it was realy helpfull

  • @manojmaniyan9864
    @manojmaniyan9864 3 года назад

    Hi friends, I am using HG-C 1100 sensor and this sensor measures the range from -35mm to 35mm. I have doubt in using the formula float val = (float)(map(samplse,0,1023,-3500,3500)/100.0);. I have to take the readings from the sensor and should display it in the serial monitor. The values also should be accurate as in the sensor. Can anyone explain me how to take the formula and calibrate the same?
    Thanks in advance

  • @asedefp175
    @asedefp175 Год назад

    do not we need to measure blank sample?

    • @mikedavis6274
      @mikedavis6274  Год назад

      No. Your blank is essential zero. There is zero concentration so there is zero absorbance.

    • @asedefp175
      @asedefp175 Год назад

      @@mikedavis6274 thanks for the answer. If I measured the blank, it shows little absorbance. In that case, can we subtract the blank from the analyte absorbance? If blank has absorbance, then how to write 0 absorbance at 0 concentration?

  • @negarabahar
    @negarabahar 2 года назад

    Thank you so much.

  • @SaraShahossini
    @SaraShahossini 7 лет назад +2

    can you explain why you multiplied the unknown by 10 at the end? is it because it was originally in a 100ml flask and then you pipetted 10 ml from that into a new 100mL flask?

    • @mikedavis6274
      @mikedavis6274  7 лет назад +1

      That is right. In this lab, my students had to dilute something by a factor of 10, so we end up multiplying by 10 at the end.

  • @smilekhan1441
    @smilekhan1441 5 лет назад +1

    from where u get y value 0.125?

    • @mikedavis6274
      @mikedavis6274  5 лет назад +1

      That was my absorbance of my unknown solution. I got it in lab. It is a solution I could get the absorbance of, but didn't know the concentration of.

  • @annalerer5472
    @annalerer5472 6 лет назад

    Thank you for this!!

  • @lllyndon
    @lllyndon 23 дня назад +1

    THANK YOU OMG

  • @Cristelle731
    @Cristelle731 7 лет назад +1

    How did you get the 0.125?

    • @mikedavis6274
      @mikedavis6274  7 лет назад +2

      It was an absorbance for an unknown solution that was similar to what my students were using in lab.

    • @Cristelle731
      @Cristelle731 7 лет назад

      I got it! Thanks!

  • @kitziagonzalez237
    @kitziagonzalez237 6 лет назад

    If I diluted 10ml of my unknown to 100ml would I have to multiply it by 10?

  • @d.chappy3199
    @d.chappy3199 6 лет назад

    appreciate you, king

  • @maxa8459
    @maxa8459 4 года назад

    Thank you so much!!!

  • @sarmilakhanal4745
    @sarmilakhanal4745 7 лет назад

    Can u plz tell what should I do to find the concentration at the end if I have used 25 ml sample for the test? the last portion I felt confused?

    • @mikedavis6274
      @mikedavis6274  7 лет назад

      Do you mean you diluted a 25mL sample to 100mL? You would multiply the answer by 100 and divide by 25 or basically multiply by 4.

    • @sarmilakhanal4745
      @sarmilakhanal4745 7 лет назад

      No for ammonia test I applied phenol method for the test. No dilution is operated over here? how can I extract its concentration?

    • @mikedavis6274
      @mikedavis6274  7 лет назад

      Can you use the email address in the video to send me your procedure? Its hard to know without knowing a little more about what you did.

    • @sarmilakhanal4745
      @sarmilakhanal4745 7 лет назад

      its ok I got the soln thanx .. the video helped a lot

  • @xxanimefanxx11
    @xxanimefanxx11 5 лет назад +1

    I'm doing a homework assignment where we are given a graph and the concentrations. I plotted concentration vs absorbance and did all the calculations and got 1.4884E-05? Do you need to multiple it by 10 or was that just for your example?

    • @mikedavis6274
      @mikedavis6274  5 лет назад +1

      My students had to dilute their sample by a factor of ten, so in the end they had to multiply by ten. If you didn't dilute, you don't need to multiply.

    • @jackmiller7324
      @jackmiller7324 2 года назад

      I need to do this too lol

  • @yooniversally
    @yooniversally 3 года назад

    Thank you!!!

  • @cluelesstuber7352
    @cluelesstuber7352 6 лет назад

    Where did you get 140.33 ?

    • @mikedavis6274
      @mikedavis6274  6 лет назад

      That number (140.33) is the slope of the best fit curve through those points. Excel calculated it. You can also get it by picking an empty cell and typing in =slope(. It will prompt you to highlight your known y's, and then your known x's. So it would look like this for the example we just did. =slope(B2:B5,A2:A5). That will return the slope for you.

    • @cluelesstuber7352
      @cluelesstuber7352 6 лет назад

      Mike Davis 😊

  • @brandenwilliamson5183
    @brandenwilliamson5183 7 лет назад

    is this the same as a absorbance curve?

  • @mbm9041
    @mbm9041 3 года назад

    It is still giving me wierd graph even after following each step.

    • @mikedavis6274
      @mikedavis6274  3 года назад

      It could be the data. Send me your file or data.

  • @riviera443
    @riviera443 4 года назад

    Thanks a lot....

  • @valkaany
    @valkaany 4 года назад

    Thanks!

  • @Imisho
    @Imisho 3 года назад +1

    thank u ❤️❤️❤️

  • @oznurkosker1031
    @oznurkosker1031 4 года назад

    Thank you

  • @anythinggoes4588
    @anythinggoes4588 8 лет назад

    Appreciated!

  • @TFrankIV
    @TFrankIV 4 года назад +1

    Clutch bro

  • @georgeks688
    @georgeks688 2 года назад

    MIke you are a life saver I want to kiss you. Thank you for helping me solve my reports (University of Nicosia)

  • @laylaahmed1255
    @laylaahmed1255 8 месяцев назад +1

    I love you

  • @νικμαστεροφσιτυσιτυ

    when your prof on analytical chemistry teach also statistics....

  • @louisam1113
    @louisam1113 3 года назад

    My line goes the opposite way

  • @mars7031
    @mars7031 3 года назад +1

    u should pass by zero to do this !!!!!!!

  • @KCM1
    @KCM1 6 лет назад

    King

  • @SS-pn7ss
    @SS-pn7ss Год назад +1

    Thank you so much

  • @jessicaledesma5533
    @jessicaledesma5533 5 лет назад

    If I diluted 10ml of my unknown to 25ml would I have to multiply it by 10?

    • @mikedavis6274
      @mikedavis6274  5 лет назад

      No. If you diluted your sample 10:25, you would multiply it by 25/10 or 2.5. You diluted it because it was too concentrated.

    • @jessicaledesma5533
      @jessicaledesma5533 5 лет назад

      @@mikedavis6274 So, first when I prepared the unknown I diluted it by a 1:10 factor. Then, I diluted it again by a 10:25 factor. So, I have to multiply by 2.5?

  • @moroccan0714
    @moroccan0714 3 года назад

    Thanks a lot