how to calculate ec50 on excel?
Turn on thread page Beta
how can i calculate ec50? watch
- Thread Starter
- 24-10-2016 18:07
- 24-10-2016 23:43
Place your values of response magnitude (or degree of effect of drug e.g. change in heart rate) (which you should standardize so that the maximum effect is 100 %) in one column and the dose of drug in the previous column.
Then select all the cells in those two columns and do Insert > Chart > Line Chart > Scatter Chart (drug dose on x axis; effect y axis)
Then draw a horizontal line rightwards from the 50% mark on the y axis and read off the EC50 on the x axis