Competitive ELISA Tutorial 3: Analyzing Typical Competitive ELISA Data in Excel

In this video, we show how typical data from a Competitive ELISA (Enzyme-Linked Immunosorbent Assay) can be analyzed using common spreadsheet software, such as Microsoft Excel. There are several programs available for the analysis of ELISA data, but Excel is such a common program that it will be beneficial for many people to see how data analysis can be done using this program alone.
Here is the link to the Competitive ELISA tutorial mentioned in this video - • Competitive ELISA Tuto...
Our ELISA tutorials are kindly sponsored by Calbiotech. Click here to see Calbiotech's ELISA kits: protocol-place.com/Calbiotech
This video and other protocols can be found at our website, the "Protocol Place" - protocol-place.com/
A full ELISA protocol can be found at protocol-place.com/assays/sand...
This video is a part of our ELISA Tutorial Series. Here are all of the videos in this series:
ELISA Tutorial 1: Understand How an ELISA Works - • ELISA Tutorial 1: How ...
ELISA Tutorial 2: Coating and Blocking the ELISA Plate - • ELISA Tutorial 2: Coat...
ELISA Tutorial 3: Preparing and Adding Samples to the ELISA Plate - • ELISA Tutorial 3: Prep...
ELISA Tutorial 4: Finishing the Assay (Sandwich ELISA) - • ELISA Tutorial 4: Fini...
ELISA Tutorial 5: Preparing ELISA Data in Excel for Analysis with GraphPad Prism - • ELISA Tutorial 5: Prep...
ELISA Tutorial 6: How to Analyze ELISA Data with GraphPad Prism - • ELISA Tutorial 6: How ...
Competitive ELISA Tutorial 1: How a Competitive ELISA Works - • Competitive ELISA Tuto...
Competitive ELISA Tutorial 2: How to Use Calbiotech's Competitive ELISA Kits - • Competitive ELISA Tuto...
Competitive ELISA Tutorial 3: Analyzing Typical ELISA Data in Excel - • Competitive ELISA Tuto...
We hope you enjoy watching and benefit from our tutorials. If so, please take a minute to "like," or better yet, share them with others!
Thanks for watching!
Youssef Farhat
Protocol Place: protocol-place.com
**Check out some of our other tutorials via the links below**
Competitive ELISA Tutorials - - - • Competitive ELISA Tuto...
ELISA Tutorials - - - • ELISA Tutorial 1: How ...
Gelatin Zymography Tutorials - - - • Gelatin Zymography Tut...

[@ithirstyforknowledge]

Wonderful video. Extremely well explained. Special thanks for explaining the calcs. Great job!!! Thumbs up!

[@arvindchaurasiya3772]

Thank you sir. You explained it so nicely. I was struggling to solve second order polynomial equation, but I was not aware that it's so easy to solve it by excel.

[@user-pi7ps4op3o]

Thank you very much! You just can`t imagine how this video helped me!

[@abdul4boys]

Thanks a million! I found this video very helpful

[@agnesemans8654]

This video was very very helpful ! Thank you !!

[@ibrahimbayaso2084]

The video made my day. Thank you

[@yahiasaddek8236]

Million thanks! I found this video very helpful

[@yagmurturgut8]

Thank you very much. That saved my life.

[@mohmdali709]

Great Video, Thank you so much.

[@teodrop]

Very useful! many thanks!

[@geetarani2875]

very beautifully explain sir thanks

[@AbdallahHamayel]

Thanks, Really Great !

[@Ben__Hall]

😃😃Thank You Protocolplace.
This method really helped me alot, though i have a long way to go.
Wanted to ask, Why some of my unknown concentration calculated are Negative ?

[@futureddshanley]

Great Video!!!!

[@lokeshae1292]

very nice sir, thank you

[@zuha_tae_stan]

very well described 👍👍👍👍

[@olishasumer5377]

Thank you for this video. I wanted to know why some of my OD sample value bring cut off by a line?? I am still new in this 😅 I can't seem to find out why it's like this

[@greencard1245]

Thank you!

[@dzullevitt2966]

Very useful video thank you so much..

[@Myopinions24]

hi, sorry, but I don't understand how I should interpret the concentration after I calculated them? To what I should compare them? if I need to know the severity of the sample, what's the limit I should compare to? Is it positive control? and how I say this sample is negative? is it negative with its concentration equals/less the negative control? or should I compare them to the standards? please help me :(( I have an ELISA report to submit

[@xDomglmao]

wish you'd do some tutorials for excel tests (fisher test etc.), since your explanations are great

[@nizargravi1450]

Hi, how can I find the reference of that when data that are greater or smaller than standard ranges will be deleted?
Many thanks
Nizar Hussein

[@evgenia]

You need to do a serier on data-analysis basics. My university professor never explained this, just assuming we know it, failing 80% of class.

[@ujwal3488]

Hai thanks for the Video it helped me lot to understand , kindly let me now what if r2 value don't meet to .9 that is not closer to 1 in such result how to evaluate . And if the absorbance lower r greater to you std absorbance what to do ,how to dilute and measure the assay kindly help me in this to understand better .

[@sharpAXEE]

What to do if curve fit equation has E

[@robs9966]

Hi Youssef, thank you for the great videos. One thing that puzzles me is the plotting of the graph for extrapolating the unknown concentraions. Usually we plot Standard concentrations on X axis and variables like absorbance on the Y axis. In this tutorial, it is the other way around. Could you kindly provide an explanation for this.
Thank you

[@forbeslorman]

I believe it's so you can easily solve for Y (concentration) using the polynomial equation generated

[@miscelleneoustubes]

You could have also shown us how to calculate intra-assay and inter-assay coefficient of variations

[@solomonyilma9058]

Thank you Dear! Absorbance and concentration is directly proportional but here I have seen the revers. could you say something on the reason why this happen?

[@hossana842]

This is competitive ELISA so it is not directly proportional. Watch this ruclips.net/video/Kb26nQVMHds/видео.html.

[@Peace-vf1cn]

this is more suitable for measuring protein concentration. ELISA data with STD with known concentrations???

[@sanaamjad6629]

Hye! can i use this method for my sandwich ELISA data ?

[@atulpatel9343]

Can cElisa differentiate the vaccinated & Infected patients

[@stickom]

all fine until you plugged in 1/abs to x values.. can you explain that a little..

[@delladedel6197]

hi i found "E" on my equation. what does it mean?

[@tasleemarif1]

Della Dedel E means exponential,,ie. exp in Excel

[@ujwal3488]

Can I have your mail Id

[@Joseph-eq5od]

I hate elisa!!! #metabolism