How To Create A Linear Standard Curve In Excel

In this video tutorial, I will show you how to create a linear standard curve using Microsoft Excel and how to use it to calculate unknown sample values. I will use the BCA total protein assay standards as an example.
THE ONLINE GUIDE
toptipbio.com/...
VIDEO BREAKDOWN
Step 1: The data (00:12)
Step 2: Creating the scatter plot (02:37)
Step 3: Inserting a line of best fit (03:22)
Step 4: Getting the equation of the line (04:28)
MORE HELPFUL HINTS & TIPS
toptipbio.com/
FOLLOW US
Facebook: / toptipbio
Twitter: / toptipbio
LinkedIn: / top-tip-bio

[@StevenBradburn]

THE ONLINE GUIDE
toptipbio.com/linear-standard-curve-excel/

[@blipblip4493]

can i use this same method for drawing std curve for Carbohydrate analysis?

[@stickom]

ok, I am excited...I learned this on BioTechnology classes at Miramar College San Diego and it was all unclear. Now after 13years applying again for a entry lab position again (the reason is obvious) I find the answer right on (i was skipping to get the answer) .... thank you, thank you, I will be your student for life!!!

[@jamaikadiekiwi]

You're a life saver for sure! Thank you so much for this tutorial!

[@xRaiderxDeath]

This video was EXACTLY what I needed! Was doing a lab report for the concentration of protein and its absorbance in a spectrophotometer and just searched "linear standard curve excel" and it gave me the perfect video. I cant thank you enough!

[@nancyngoasheng7806]

I'm busy with that report now🥲🥲

[@Mrs.411]

Me too

[@spilledcoffee383]

same

[@teademon1372]

same, we all got that excel struggle

[@alopiaspelagicus1628]

Great video! It was exactly what I had been looking for, and explained in great detail and with good visuals

[@endafarrell5968]

Excellent video, it explained what I needed to calculate precisely

[@jamesshin632]

This is a great video. Most videos go too fast and assume we know too much. thank you for helping the learning community!

[@StevenBradburn]

Thanks for the feedback James. You are very welcome

[@maggikento5187]

how to get the standard deviation/sem after we know the unknown sample's protein concentration against treatment concentration....?

[@빠다코코넛-o3f]

Thank you!!!!!!!!

[@muhammadfaizi2451]

Good day, need help.
I need to prepare glucose standanrd solution in the range of (1-13mg/ml)
How much distilled water need to be added if ; Example; 3mg glucose??

[@richamishra9421]

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

[@abidaferdous7913]

Hi, what my Y = 9.4274x - 0.0223? How shell I calculate

[@phani991]

Hey. Thanks a lot for the description. I am facing a problem ever since I switched my computer. The absorbance values for standards that start with Zero decimal for example, 0.67 is being considered Zero and this is only happening for 250, 125, and 25 ug while the 500ug standards value is getting rounded off to 1 no matter what the value is. And they all lie down on the x axis in a straight line. What could be the issue..?
I hope my doubt made some sense

[@StevenBradburn]

Hi Phani,
In Excel, if you highlight the cells with the absorbance values. Then right-click and select 'Format cells'. Then select 'Number' in the category and the decimal places to '2'. I think this should do the trick.
Let me know how it goes.
Best wishes,
Steven

[@bushystache]

The steps to display the equation of the line was not clear

[@bushystache]

The steps to display the equation of the line were not clear

[@hodaelsayed8837]

great video

[@marlenaguilar8386]

Thank you so much! Literally was able to understand so quickly with just one watch you’re the best

[@danielhermestapiamendoza579]

My standard curve dosen´t get straight, what could be the problem?

[@zinasantana]

perfect...saved me such a headache

[@juliavallusova6470]

Hello, may I ask. How would you predict the concentration of the unknown by creating a standard curve when having the response ratio(area of analyte peak/peak of internal standard)and concentration of few samples from GC-MS?

[@docshaheen6741]

A short valuable summary, thank you so much.

[@StevenBradburn]

Very welcome

[@raniaa.m.35]

Great video and valuable information

[@nafeesajilani4106]

Hi, can i ask, is it possible for the absorbance value to be more than 1?

[@StevenBradburn]

Hi,
Yes this is possible. It all depends on your experiment. But, absorbance values can be greater than 1.
Thanks

[@ChayadaSongsakul]

How did you get the numbers .346 and .759

[@AfterSchoolReviews]

My screen doesn’t have a design tab 😞

[@kyledebruyn703]

Straight to the point and well explained!

[@ayaay8091]

does 277 and 736 ug/ml work with western blot?? please any help, i have 400 ug/ml total protein using BCA assy!!

[@ahmedadilee3315]

My lord and savior

[@LeopoldoPalma]

Perfect tutorial, thaks a lot.

[@joand2217]

Followed but background corrected came negative values..now some results are negative values

[@crostadiformaggio1]

Thanks, this was so useful!!

[@weiminwang2603]

If we plot Standard concentrations on Y axis and variables like absorbance on the X axis.How do you think plan?

[@muhammadim1575]

Thank you so much...very nice effort

[@ChayadaSongsakul]

Where did you get the two avg absorbance values from?

[@inshawaheed6936]

Thank you so much this was very helpful for my assignment!

[@el_debola]

You have just saved my life thank you 😭😭😭❤️

[@nikkieasley6204]

This was SO helpful, thank you!!

[@StevenBradburn]

Glad it was helpful!

[@nikitathorat6763]

This was really useful for me.. Thanks

[@StevenBradburn]

Very welcome

[@tshegofatso811]

This helped me with my big research, thank you

[@abdulkaderkajol6263]

Excellent!!❤

[@aishaliane]

This was in-depth and helped me so much. Thanks!

[@StevenBradburn]

You are very welcome. I am glad it helped you

[@empace5344]

oh my god. Thank you so much. I just started my first method development project ever at a startup and am SO glad to have found your helpful video. Much appreciated.

[@Olubussie9894]

Thank you so much, I have been on this since morning.

[@emilfunkvang]

Shouldn't you divide both y and 0.0017? y/0.009 - 0.0017/0.009 = x?

[@grgandhi]

how to use that r2 value in finding unkwown conc.

[@shraddjais]

thanks

[@rae_9648]

whats the control key you mention?

[@boutglo6853]

Exactly what I needed, thank you!

[@elameno5240]

Ayy Vu

[@tkdwls1998]

thx! u saved my life

[@ChristinaTsakalidou]

You are a life saviour

[@teifionjones5810]

Great simple video and very informative, thanks man!

[@StevenBradburn]

Very welcome

[@unclekenzo3247]

You are a great man sir, a very great man. See you in heaven.

[@obby3010]

You're THE MAN. You've just got yourelf a new subscriber.

[@putradaninla-aesong7758]

thx so much

[@aminlone6330]

thankyou

[@lemonhasan2480]

Thank you for such a clear lesson....

[@dxnnxm]

im writng my ELISA report right now, this is a godsend thank you so much!

[@StevenBradburn]

Very welcome Denny. Good luck!

[@CheefEeth]

Just found your channel and shocked you don't have more subscribers. Just got a job that requires a lot of Graphpad Prism work and your videos are so helpful. Thank you!

[@StevenBradburn]

Many thanks for your kind words Ethan. More content to come :)

[@wayne02058]

You are awesome

[@ayezaz936]

Thank you! Really helpful :)

[@amnaj5943]

so helpful thank you!

[@iman2584]

Really thanks.. this helped me alot :)

[@starsinthenightsky449]

3:54

[@anzah7617]

Thank you so much, this is so useful!

[@sobrietyliiving]

Thank you! This was a huge help!

[@StevenBradburn]

Glad it helped!

[@bal0423]

THANKS!

[@julial3758]

LOL, omg wth I don't get it.. what's with the calculations .. what's that for