How to Calculate IC50 & IC90 Using Excel: Step-by-Step Tutorial

Welcome to our step-by-step tutorial on how to calculate IC50 and IC90 using Excel! In this video,

we’ll guide you through the entire process, from setting up your data to generating accurate dose-response curves.

What You’ll Learn:
What IC50 and IC90 mean in drug testing or biological assays
How to organize and input your data for analysis
How to create a dose-response curve in Excel
Using the logarithmic function and trendline to find IC50 and IC90
How to interpret the results for your experiments

Who is this tutorial for?
Researchers, students, and scientists working in pharmacology, toxicology, or cell biology
Anyone looking to calculate the inhibitory concentration of drugs or compounds
Those new to Excel and needing clear guidance on how to analyze dose-response data

Tools Needed:
Microsoft Excel (or similar spreadsheet software)
Sample data (we’ll provide an example in the video!)


Be sure to like, subscribe, and hit the bell icon to stay updated on our latest tutorials.
If you have any questions, feel free to drop them in the comments below!

📋Top Recommended Books for Study & Reference:
✅ Practical Microbiology by Dr. R.C. Dubey (Author), D K Maheshwari (Author) - https://amzn.to/3YRR6sK
✅ Experiments in Microbiology by K.R. Aneja (Author) - https://amzn.to/3EYz4yn
✅ A Textbook Of Microbiology by R C Dubey (Author), D K Maheshwari (Author) - https://amzn.to/3FdyzAt
✅ PRESCOTTS MICROBIOLOGY 12ED by Dorothy Wood (Author), Joanne Willey (Author), Kathleen Sandman (Author) - https://amzn.to/4mmUBS2
✅ Textbook Of Microbiology For Nursing - https://amzn.to/43AGhOk
✅ SET of Biochemistry, 6th Edition + Biochemistry Review & Assessment Includes MCQs by Satyanarayana (Author), U. Chakrapani (Author) - https://amzn.to/3YSGmKB



--------------------------------------------------


Chapters and Key moments:
00:00 | Intro
00:15 | How to Find IC50 & IC90 Using Excel
02:48 | Calculation Of Drag A IC50 Value
07:48 | Calculation Of Drag A IC90 Value
09:40 | Calculation Of Drag B IC50 Value
11:54 | Calculation Of Drag B IC90 Value


----------------------------------------------------


Recommended Videos For You:
Bacterial Morphology:    • Understanding Bacterial Morphology | Shape...  
Gram's Staining :    • Gram Staining Simplified: A Step-by-Step B...  
Acid Fast Staining :    • Mastering Acid Fast Staining: Ziehl-Neelse...  
Negative & Capsule Staining :    • Negative Staining & Capsule Staining: Step...  
Mpox :    • Monkeypox (Mpox) Outbreak: Understanding M...  
Hemocytometer :    • Perfect Guide to Cell Counting in a Hemocy...  
% Cell Inhabitation :    • How to Calculate and Graph % Cell Inhibiti...  
Staining Q & A :    • Ace Your Viva: Essential Q&A for Gram's St...  
Error Bars:    • Error Bars Explained: Visualizing Uncertai...  



------------------------------------------------



📌 For detailed notes and further insights, follow our LinkedIn page:   / tanomas-creation  



🌟 Thanks for Watching! 🌟

If you enjoyed this video and found it helpful, please give us a thumbs up 👍, share it with your friends, and leave a comment below with your thoughts or questions! We love hearing from you!

🔔 Don't forget to subscribe to our channel for more amazing content on Microbiology, Biotechnology, Application Biology, and, Life Science, etc. Hit the notification bell so you never miss an update!


Connect with us:

LinkedIn Page:   / tanomas-creation  
Facebook Page:   / 61563627400491  
Instagram:   / tanomas_creation  


Your support helps us create more valuable content, and we appreciate every like and subscription!


Thanks for being a part of our community!




---------------------------------------------



The selected predictions are:
#IC50
#IC90
#exceltutorial
#DoseResponseCurve
#pharmacology
#biostatistics
#NonlinearRegression
#DrugResearch
#CellAssays
#dataanalysis
#ScientificResearch