Avatar of DColin
DColinFlag for Thailand

asked on 

Fitting a curve to data

Hi Experts,

Please look at the attached logistic data plots. I have used excel's polynomial trend line feature to fit a curve to the logistic sigmoid curves. Is there a better way or formula to fit curves to these type of plots? eng-0.xlsx
Math / Science

Avatar of undefined
Last Comment
Avatar of Member_2_4694817

I shall consider "column B" only.
There are of course many sigmoidal curves, the most prominent being 1/(1+e^(-t)).
Probably you want to test your data against transformations of this.
Since the values "apparently" tend to 0 for t -> -oo and to 1 for t -> +oo, we may restict our search to determine parameters a and b such that 1/(1 + e^(-a*t + b) ) is a good fit.
Note that the outer data points hardly contribute anythin to our knwledge of the curve (they've already fulfilled theiry duty by telling us about the limits as t -> +- oo). The most distinctive part of the curve is near y = 1/2.
The expression  1/(1 + e^(-a*t + b) ) becomes 1/2 exactly when  t = b/a.
The derivative of 1/(1 + e^(-a*t + b) ) at the same point is  a/4.
Hence I suggest you take only thos data point with value between 0.3 and 0.7, say, make a linear degression, i.e. find a best fit line  y = A*t + B.
This line passes through y=1/2 at  t = (1/2 - B)/A with slope A.
Thus a = 4*A and b = 2 - 4*B should give a good fit.

Avatar of DColin
Flag of Thailand image


Hi thehagman:

Thank you for your reply. I do not have enough math knowledge to understand your answer fully. Could you please use some examples to illustrate your answer. So for column B if I was supplied the X values of -4 and 8 what would I need to do to predict the Y values (somewhere between 0 and 1) ? thanks.
Avatar of Member_2_4694817

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Math / Science
Math / Science

The Math / Science topic primarily includes discussions of mathematics, physics, statistics and economic analysis, but also biology, chemistry and other sciences.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo