+ Reply to Thread
Results 1 to 2 of 2

Sigmoid curve fitting dataset.

  1. #1
    Registered User
    Join Date
    02-18-2021
    Location
    netherlands
    MS-Off Ver
    mac
    Posts
    1

    Question Sigmoid curve fitting dataset.

    I have received an assignment for which I need to choose 3 technologies from this dataset and to fit them to a generic sigmoid curve (e.g. logistics function). However, I don't seem to be able to figure out how this is done. Can someone help?

    In this file, I've made a start with my own input, but it doesn't seem to fit under the max. of 100 (since we're talking about percentages), does anyone know what I am missing here?
    Attached Files Attached Files
    Last edited by mirjama; 02-18-2021 at 09:38 AM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,363

    Re: Sigmoid curve fitting dataset.

    I think you are missing part of step 6 -- add any necessary constraints to the solver model. If you intend for the upper maximum of the logistics model (determined by B3 in each sheet) to be no larger than 100, then you need to add a constraint to your solver model(s) that B3 can be no larger than 100.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. 3D Curve Fitting
    By EssoExplJoe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2017, 04:56 PM
  2. fitting curve equation 4PL and 5PL
    By mazan2010 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-13-2016, 01:18 PM
  3. Curve Fitting and interpolation
    By salmanisn in forum Excel General
    Replies: 3
    Last Post: 01-24-2011, 04:18 AM
  4. [SOLVED] curve fitting
    By somsankarsen@gmail.com in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-03-2006, 02:10 PM
  5. curve fitting a charging capacitor type curve
    By mcgradys in forum Excel General
    Replies: 4
    Last Post: 11-15-2005, 08:50 AM
  6. Best fitting curve
    By ladee_bird in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2005, 09:05 AM
  7. best curve fitting
    By ladee_bird in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-20-2005, 03:05 AM

Tags for this Thread

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