S Curve ...can I create it in Excel?
 

Putting together a presentation where I want to regularly refer to a graph
depicting the S curve. I would love to create this curve somehow in excel.
I have tried unsucessfully. Your thoughts and suggestions are greatly
appreciated.

S Curve ...can I create it in Excel?
 

See http://en.wikipedia.org/wiki/Logistic_function
If you need help implementing this in Excel, please come back.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cham" wrote in message
...
Putting together a presentation where I want to regularly refer to a graph
depicting the S curve. I would love to create this curve somehow in
excel.
I have tried unsucessfully. Your thoughts and suggestions are greatly
appreciated.

S Curve ...can I create it in Excel?
 

On Mon, 15 Jan 2007 07:08:01 -0800, Cham
wrote:

Putting together a presentation where I want to regularly refer to a graph
depicting the S curve. I would love to create this curve somehow in excel.
I have tried unsucessfully. Your thoughts and suggestions are greatly
appreciated.

Are you, perhaps, thinking of graphing the SINE function?

Set up two columns

Degrees Sine

In the degrees column, put a series of values from 0 to 360, perhaps with an
increment of 15.

In the Sine column, use a formula of the type:

=SIN(RADIANS(degrees)

Then graph using a line and the X-Y type of graph.


--ron

S Curve ...can I create it in Excel?
 

"Bernard Liengme" wrote:

See http://en.wikipedia.org/wiki/Logistic_function
If you need help implementing this in Excel, please come back.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cham" wrote in message
...
Putting together a presentation where I want to regularly refer to a graph
depicting the S curve. I would love to create this curve somehow in
excel.
I have tried unsucessfully. Your thoughts and suggestions are greatly
appreciated.

S Curve ...can I create it in Excel?
 

"Bernard Liengme" wrote:

See http://en.wikipedia.org/wiki/Logistic_function
If you need help implementing this in Excel, please come back.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

Hi Bernard,

I am excited to see the curve I hope to create.

If your help with implementing this program in excel is still on the
table...I would with great appreciation take your offer.

Thank you for your time.

Scott





"Cham" wrote in message
...
Putting together a presentation where I want to regularly refer to a graph
depicting the S curve. I would love to create this curve somehow in
excel.
I have tried unsucessfully. Your thoughts and suggestions are greatly
appreciated.

S Curve ...can I create it in Excel?
 

I will have time later tonight
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cham" wrote in message
...


"Bernard Liengme" wrote:

See http://en.wikipedia.org/wiki/Logistic_function
If you need help implementing this in Excel, please come back.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

Hi Bernard,

I am excited to see the curve I hope to create.

If your help with implementing this program in excel is still on the
table...I would with great appreciation take your offer.

Thank you for your time.

Scott





"Cham" wrote in message
...
Putting together a presentation where I want to regularly refer to a
graph
depicting the S curve. I would love to create this curve somehow in
excel.
I have tried unsucessfully. Your thoughts and suggestions are greatly
appreciated.

S Curve ...can I create it in Excel?
 

Thank you Bernard.

Your efforts are greatly appreciated.

Scott

"Bernard Liengme" wrote:

I will have time later tonight
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cham" wrote in message
...


"Bernard Liengme" wrote:

See http://en.wikipedia.org/wiki/Logistic_function
If you need help implementing this in Excel, please come back.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

Hi Bernard,

I am excited to see the curve I hope to create.

If your help with implementing this program in excel is still on the
table...I would with great appreciation take your offer.

Thank you for your time.

Scott





"Cham" wrote in message
...
Putting together a presentation where I want to regularly refer to a
graph
depicting the S curve. I would love to create this curve somehow in
excel.
I have tried unsucessfully. Your thoughts and suggestions are greatly
appreciated.

S Curve ...can I create it in Excel?
 

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?

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?