Turn on thread page Beta
    • Thread Starter

    how to calculate ec50 on excel?

    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

    Name:  EC50 calc Excel.jpg
Views: 99
Size:  122.9 KB
The home of Results and Clearing


people online now


students helped last year

University open days

  1. Bournemouth University
    Clearing Open Day Undergraduate
    Wed, 22 Aug '18
  2. University of Buckingham
    Postgraduate Open Evening Postgraduate
    Thu, 23 Aug '18
  3. University of Glasgow
    All Subjects Undergraduate
    Tue, 28 Aug '18
How are you feeling about GCSE results day?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.