+ Reply to Thread
Results 1 to 9 of 9

Dose response curve linear equation

  1. #1
    Registered User
    Join Date
    01-22-2021
    Location
    london, england
    MS-Off Ver
    version 16.45
    Posts
    5

    Dose response curve linear equation

    I have done a dose response curve and I have done a linear line to get the equation which I need to work out the value of something else. However, my equation follows the format of y =mx - c but i am confused as i thought it is meant to be y = mx + c? Could someone help with what the issue is here?

  2. #2
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: Dose response curve linear equation

    First, it would help if you were more specific. At the very least, provide the specific Excel formulas, not math abstractions. Even better, attach an Excel file that demonstrates the issues raised in your question. See the bright yellow banner at the top of this webpage for attachment instructions.

    Note that y = mx - c can be written y = mx + (-c). In other words, "c" is simply a negative intercept in your form y = mx + c.

    Aside.... I would be interested in seeing your dose-response curve, and the formula that generates it, if any. I just participated in a discussion where that came up. I might learn from your example.

    -----

    PS.... AFAIK, a dose-response curve is s-shaped. So why are you fitting a linear equation to it? Would you prefer to fit an s-shaped (sigmoid) function to the dose-reponse data?

    If so, I will definitely need that Excel file attachment with the data.
    Last edited by joeu2004; 01-22-2021 at 08:28 PM.

  3. #3
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Dose response curve linear equation

    Mathematically there's NO DIFFERENCE between y = m x - c and y = m x + c. The only difference would be the sign of the fitted value of c. Since subtracting -3.5 is identical to adding +3.5, this is po-TAY-toes, po-TAH-toes, different way of expressing the same thing.

    ADDED: I don't work in biostats/pharmaceuticals, but I expect there may be underlying interpretative meaning between positive and negative constant intercepts, and such interpretations would involve psychological bias and maybe whether test subjects would have preconceptions whether they were given placebos.
    Last edited by hrlngrv; 01-22-2021 at 09:02 PM. Reason: addendum

  4. #4
    Registered User
    Join Date
    01-22-2021
    Location
    london, england
    MS-Off Ver
    version 16.45
    Posts
    5

    Re: Dose response curve linear equation

    Thanks for your reply, I have attached an image of the curves and equations. Attachment 714782

    I am trying to fit a linear equation in order to work out the IC50 value.

  5. #5
    Registered User
    Join Date
    01-22-2021
    Location
    london, england
    MS-Off Ver
    version 16.45
    Posts
    5

    Re: Dose response curve linear equation

    Sorry just realised I didn't tag you, not sure how this works

  6. #6
    Registered User
    Join Date
    01-22-2021
    Location
    london, england
    MS-Off Ver
    version 16.45
    Posts
    5

    Re: Dose response curve linear equation

    Quote Originally Posted by hrlngrv View Post
    Mathematically there's NO DIFFERENCE between y = m x - c and y = m x + c. The only difference would be the sign of the fitted value of c. Since subtracting -3.5 is identical to adding +3.5, this is po-TAY-toes, po-TAH-toes, different way of expressing the same thing.

    ADDED: I don't work in biostats/pharmaceuticals, but I expect there may be underlying interpretative meaning between positive and negative constant intercepts, and such interpretations would involve psychological bias and maybe whether test subjects would have preconceptions whether they were given placebos.
    Thanks for your reply!

  7. #7
    Registered User
    Join Date
    01-22-2021
    Location
    london, england
    MS-Off Ver
    version 16.45
    Posts
    5

    Re: Dose response curve linear equation

    Quote Originally Posted by joeu2004 View Post
    First, it would help if you were more specific. At the very least, provide the specific Excel formulas, not math abstractions. Even better, attach an Excel file that demonstrates the issues raised in your question. See the bright yellow banner at the top of this webpage for attachment instructions.

    Note that y = mx - c can be written y = mx + (-c). In other words, "c" is simply a negative intercept in your form y = mx + c.

    Aside.... I would be interested in seeing your dose-response curve, and the formula that generates it, if any. I just participated in a discussion where that came up. I might learn from your example.

    -----

    PS.... AFAIK, a dose-response curve is s-shaped. So why are you fitting a linear equation to it? Would you prefer to fit an s-shaped (sigmoid) function to the dose-reponse data?

    If so, I will definitely need that Excel file attachment with the data.
    Thanks for your reply, I have attached an image of the curves and equations. Attachment 714782

    I am trying to fit a linear equation in order to work out the IC50 value.

  8. #8
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: Dose response curve linear equation

    Cannot access Attachment 714782. Be sure that it is an Excel file, not an image file. When I say "Excel file", I mean: saved as xlsx, xlsm or xls.

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Dose response curve linear equation

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

    Please re-read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Possibly linear of Non-linear equation solution?
    By SamJay in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-03-2021, 03:27 PM
  2. Slopes/rates on a non-linear curve
    By stefanbg in forum Excel General
    Replies: 8
    Last Post: 10-28-2020, 01:22 PM
  3. Tiered or Progressive non-linear price curve formula
    By kflorian in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2013, 04:30 PM
  4. Replies: 3
    Last Post: 03-06-2011, 01:38 PM
  5. How to deal with a non-linear calibration curve
    By NegativeGLover in forum Excel General
    Replies: 9
    Last Post: 07-21-2010, 08:58 AM
  6. How to forecast value for a non-linear curve
    By anmck in forum Excel General
    Replies: 1
    Last Post: 10-30-2009, 04:15 PM
  7. [SOLVED] How can I estimate EC50 in a dose-response graph?
    By Charis in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-23-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1