Тёмный

Generating Standard Curve and Determining Concentration of Unknown Sample in Excel 

Teaching Junction
Подписаться 10 тыс.
Просмотров 60 тыс.
50% 1

In this video, you will learn how to Generate a Standard Curve and determine Unknown Concentrations in Excel by a Simple Method. A standard curve is used to accurately determine the concentration of your sample from the signal generated by an assay. I will show you how to create a standard linear curve using Microsoft Excel and how to use it to calculate unknown sample values. I will use imaginary data of concentration and absorbance as an example. I have used excel 2016 to generate a standard curve and determine an unknown concentration of compound. You can also use other versions of excel such as excel 2013, excel 2019 and excel 365.
#standardcurve #teachingjunction #excel #concentrationvsabsorbance
Other RU-vid queries:
Absorbance vs concentration,
How To Create A Linear Standard Curve In Excel,
Generating Standard Curve and Determining Concentration of Unknown Sample in Excel - Simple Method,
How to calculate Protein Concentration of Unknown Sample from standard curve in excel,
Generating Standard Curve and Determining Unknown Concentration in Excel,
Plot concentration vs absorbance scatter plot,
Calculate the concentration of the unknown sample from the absorbance measurement of an unknown sample,
Add Trendline,
Using Excel for a Calibration Curve,
How To Create A Linear Standard Curve In Excel,
how to create a linear standard curve in excel,
standard curve in excel,
how to make standard curve in excel,
how to create a standard curve in excel,
how to make a standard curve in excel,
standard curve excel,
standard curve absorbance vs concentration,
standard curve,
standard normal curve,
standard addition calibration curve,
how to plot standard curve,
unknown concentration from standard curve,
how to make standard curve in excel,
gallic acid standard curve preparation,
how to draw standard curve,

Опубликовано:

 

28 июн 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 30   
@TeachingJunction
@TeachingJunction Месяц назад
How to Add Error Bars of Standard Deviation in Excel Graphs: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_HzNHrcCmv4.html
@user-py3cr3lc4o
@user-py3cr3lc4o 8 месяцев назад
you saved my lifee, ThHANKYOUUUUU
@TeachingJunction
@TeachingJunction 8 месяцев назад
My pleasure
@kavyap4453
@kavyap4453 Год назад
Very useful.... thank you so much
@TeachingJunction
@TeachingJunction Год назад
Welcome 😊
@uzmahismat5829
@uzmahismat5829 Год назад
Thank u so much
@TeachingJunction
@TeachingJunction Год назад
You are welcome
@user-eq6sn3yb7f
@user-eq6sn3yb7f 10 месяцев назад
Can you make a video on how to compare our results with a standard?
@TeachingJunction
@TeachingJunction 10 месяцев назад
Thanks for your suggestion. I have note down your suggestion
@nausheenghaffar3941
@nausheenghaffar3941 8 месяцев назад
can we use this equation to calculate conc. if unknown sample absorbance value higher than ploted values?
@TeachingJunction
@TeachingJunction 8 месяцев назад
Yes
@asifmohammed5717
@asifmohammed5717 2 года назад
How did you find the value of concentration, as well as absorbance? please let me know Thank you
@TeachingJunction
@TeachingJunction 2 года назад
You can get these values from experiment. I have used imaginary values for demonstration purpose
@user-ze5ec2vj9o
@user-ze5ec2vj9o Год назад
Please how to found the number 0.0249
@thebluebeyond2329
@thebluebeyond2329 2 года назад
Please find the unknown concentration without the trend line equation. It's highly advicable not use the equation in most experimental reports
@rmrmsafarii9542
@rmrmsafarii9542 Год назад
Do you mind sharing how to go about doing that?
@akshaykirthan9281
@akshaykirthan9281 9 месяцев назад
TREND(select the concentration of std.,select the O.D of std.,select the O.D of unknown sample) Do this in excel
@nurainshamilabintikamalari7452
Why u use 0.0249x like where did u get the value?
@TeachingJunction
@TeachingJunction Год назад
That is the intercept value. you can get this value from regression equation generated by excel
@48_aufa41
@48_aufa41 8 месяцев назад
how do we know that the calibrated graphic that we made is correct sir?
@TeachingJunction
@TeachingJunction 8 месяцев назад
There are multiple factors. Firstly, make sure that your values falls into a linear range. Secondly, the value of correlation coefficient and coefficient of determination is also indicate the accuracy of calibration curve
@rubaikabhatti5772
@rubaikabhatti5772 Год назад
sir RSD ksy calculate kryn gy??
@TeachingJunction
@TeachingJunction Год назад
Firstly, calculate average and standard deviation. Put equal sign in excel cell, select standard deviation value and insert divide by sign before selecting average value. Put parenthesis around these values and multiply it with 100. Press enter, you will find the result i.e. =(SD/Average) * 100
@Happymoments-je2ss
@Happymoments-je2ss Год назад
sir how did you get the value 0 .0249
@user-ze5ec2vj9o
@user-ze5ec2vj9o Год назад
What is the answer please if you know now
@qussaialiraqi3661
@qussaialiraqi3661 2 месяца назад
why you chose value 0.484
@oursoils2405
@oursoils2405 Год назад
you thumbnails videos hidden the video at the end of the video please remove it
@TeachingJunction
@TeachingJunction Год назад
Thanks for your suggestion. I have modified the end screen
@Urarto
@Urarto Год назад
Don't use English title for your video if you are not making an english video. It is very cheep when you do a video in your own language and use a title from another languages.
@TeachingJunction
@TeachingJunction Год назад
Actually, you are a cheap person. Think before you speak. I am using English language as teaching medium. The people from more than 50 countries are taking advantage from these video. You have a sick mentality
Далее
МОЙ НОВЫЙ ДОМ
1:01:04
Просмотров 2,1 млн
Maybe a little TOO much gel 😂
00:12
Просмотров 11 млн
What is a Standard Curve?
6:52
Просмотров 257 тыс.
Creating a Line of Best Fit on Excel
6:52
Просмотров 336 тыс.
Lab Review - Standard Curve (Unit 2 Spectrophotometry)
12:30
How to Make a Calibration Curve in Excel
19:58
Просмотров 24 тыс.
Spectrophotometers, calibration curves and Beer's Law
11:58
МОЙ НОВЫЙ ДОМ
1:01:04
Просмотров 2,1 млн