Home >
Community >
Can IC50 be calculated using MS-Excel?
Upvote
24
Downvote
+ Scattering
+ Microsoft office excel
+ Ic50
Posted by
Nick Kapatais
Can IC50 be calculated using MS-Excel?
Hi,I wish to calculate IC50 from dose dependent response data. I am planning to use 'Scatter Plot' option in MS-Excel. then generate the equation for curve in 'y=mx+c' option. Using this equation i will put value of y=50 and calculate the value of x, and treat it as IC50.However, I have some doubts.i) My concentration range is linear (e.g. - 0.3, 0.6, 0.9, 1.2.....). Does it need to be logarithmic? Is it necessary?ii) Is the formula i am using right?Kindly provide references so i could validate my method.
