Results 1 to 10 of 10

Regress nonlinear equation

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2008
    Location
    Stoughton, MA
    Posts
    19

    Regress nonlinear equation

    Below is a nonlinear model, together with calibration data for which I would like to find the parameters Ro, Kc, a and b.

    R = Ro + Kc * (1/(1 + exp(-(a + b*lnC))

    Calibration Data

    C R
    0.0 0.3347
    4.8 0.4201
    7.7 0.5141
    11.2 0.6177
    14.4 0.6887

    Given the calibration data above, how can I calculate or at least estimate these parameters?
    I do not want to use an add-in program, like Solver, in Excel. I do, however, want to be able to use any existing functions, if necessary, in Excel. i'd appreciate it if someone can walk me through the steps.

    Thanks,

    Sheldon
    Last edited by VBA Noob; 11-20-2008 at 01:34 PM.

Thread Information

Users Browsing this Thread

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

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