Results 1 to 2 of 2

Thread: Fitting curve Excel (XLfit)

  1. #1
    Oct 2009

    Fitting curve Excel (XLfit)

    I have to make a 5-PL fitting curve.
    I'm using an add-on for Excel (XLfit), does someone know how to use it ?!! because when I want to apply the 5PL model it doesn't work !
    I tested it with values obtained directly from their model equation so it should fit completely perfectly and it doesn't work !!!
    Any ideas ?

    Follow Math Help Forum on Facebook and Google+

  2. #2
    fcs is offline
    Jan 2011

    5-PL Curve Fitting with MasterPlex ReaderFit

    I know this thread is old but I hope to provide an answer that may assist future visitors

    Before I begin answering though, I need to make a disclaimer that I am representing Hitachi Solutions which is the company behind MasterPlex ReaderFit.

    Ok, now down to business. If you are not getting a good curve fit with the 5-PL model equation, there may be reasons other than the software (in this case XLfit).

    First, the curve fit will only be as good as the data that you feed the software. If you do not have a nice set of points that can help the algorithm decide the best curve fit parameters, you will end up with a pretty bad curve fit.

    Second, if you are using 0 standards, it will cause an error in the model equation because of mathematical limits (i.e. division by zero). In this case, I would recommend either placing in an extremely small positive value such as 0.000000001 or exclude the point all together.

    Third, there could be user error in using XLfit. Unfortunately, I cannot help here but I can recommend MasterPlex ReaderFit which is designed around our core competency: Our 4PL and the 5PL curve fitting algorithms. It also includes weighting algorithms to offset one of the assumptions of the 4PL/5PL model equations which is that all standard groups have the same scatter (or variance). If one is doing an immunoassay or bioassay, we know that this is not true. In fact, we see the exact opposite and this phenomenon is know as heteroscedasticity. Try saying that 3 times fast

    Please refer to my blog post for more details on the 5PL model equation or the importance of weighting with the 4PL and 5PL.

    I'd also be more than happy to answer any questions you may have at aliu at miraibio dot com.

    I hope this helps!

    Allen Liu
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Curve Fitting
    Posted in the Advanced Algebra Forum
    Replies: 11
    Last Post: Nov 23rd 2010, 03:55 PM
  2. Curve Fitting 2
    Posted in the Calculus Forum
    Replies: 8
    Last Post: Sep 15th 2010, 06:38 AM
  3. Curve fitting
    Posted in the Math Software Forum
    Replies: 7
    Last Post: Nov 27th 2008, 04:21 AM
  4. Replies: 2
    Last Post: Dec 28th 2007, 02:48 PM
  5. [Req] Curve Fitting using Excel
    Posted in the Business Math Forum
    Replies: 4
    Last Post: Dec 26th 2007, 12:44 PM

Search Tags

/mathhelpforum @mathhelpforum