No video
Generating Standard Curve and Determining Concentration of Unknown Sample in Excel
Рет қаралды 60,223
2 жыл бұрын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 KZfaq 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,
@TeachingJunction 2 ай бұрын
How to Add Error Bars of Standard Deviation in Excel Graphs: kzfaq.info/get/bejne/la6qgaujyKnRpmg.html
@user-py3cr3lc4o 8 ай бұрын
you saved my lifee, ThHANKYOUUUUU
@TeachingJunction 8 ай бұрын
My pleasure
@kavyap4453 Жыл бұрын
Very useful.... thank you so much
@TeachingJunction Жыл бұрын
Welcome 😊
@uzmahismat5829 Жыл бұрын
Thank u so much
@TeachingJunction Жыл бұрын
You are welcome
@user-eq6sn3yb7f 10 ай бұрын
Can you make a video on how to compare our results with a standard?
@TeachingJunction 10 ай бұрын
Thanks for your suggestion. I have note down your suggestion
@asifmohammed5717 2 жыл бұрын
How did you find the value of concentration, as well as absorbance? please let me know Thank you
@TeachingJunction 2 жыл бұрын
You can get these values from experiment. I have used imaginary values for demonstration purpose
@nausheenghaffar3941 8 ай бұрын
can we use this equation to calculate conc. if unknown sample absorbance value higher than ploted values?
@TeachingJunction 8 ай бұрын
Yes
@user-ze5ec2vj9o Жыл бұрын
Please how to found the number 0.0249
@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 Жыл бұрын
Do you mind sharing how to go about doing that?
@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
@qussaialiraqi3661 2 ай бұрын
why you chose value 0.484
@48_aufa41 8 ай бұрын
how do we know that the calibrated graphic that we made is correct sir?
@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
@nurainshamilabintikamalari7452 Жыл бұрын
Why u use 0.0249x like where did u get the value?
@TeachingJunction Жыл бұрын
That is the intercept value. you can get this value from regression equation generated by excel
@rubaikabhatti5772 Жыл бұрын
sir RSD ksy calculate kryn gy??
@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 Жыл бұрын
sir how did you get the value 0 .0249
@user-ze5ec2vj9o Жыл бұрын
What is the answer please if you know now
@oursoils2405 Жыл бұрын
you thumbnails videos hidden the video at the end of the video please remove it
@TeachingJunction Жыл бұрын
Thanks for your suggestion. I have modified the end screen
@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 Жыл бұрын
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
Teaching Junction
Рет қаралды 3,5 М.
ОВР Шоу
Рет қаралды 9 МЛН
Khabar SPORT
Рет қаралды 368 М.
Bio-Resource
Рет қаралды 401 М.
Teaching Junction
Рет қаралды 4,1 М.