View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cham Cham is offline
external usenet poster
 
Posts: 10
Default S Curve ...can I create it in Excel?

Thank you Herbert.

I have the curved graph started, and plan on altering values and creating
the best graph possible.

I hope to pay your kindness forward.

Scott

"Herbert Seidenberg" wrote:

I translated the equation shown at
http://en.wikipedia.org/wiki/Generalised_logistic_curve
into Excel.
Y=KA+KC/((1+KT*EXP(-KB*(T-2*KM)))^(1/KT))
where Y=Weight, height, size, etc
KA 0 lower asymptote
KC 1 upper asymptote minus KA
KM 2.5 time of maximum growth
KB 1 growth rate
KT 1 assymetry of max growth time
Plot Y vs T from 0 to 10 with the given parameters,
then play with K?