Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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.




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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.




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default 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.








  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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.






  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default 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
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,180
Default 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?

  #9   Report Post  
Posted to microsoft.public.excel.misc
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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create excel based standalone application Pete_R Excel Discussion (Misc queries) 0 December 4th 05 11:59 PM
how to create the formula "cumsum" in excel paulc59 Excel Worksheet Functions 5 November 26th 05 02:58 AM
Create database in excel? wirthless New Users to Excel 7 October 30th 05 02:57 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
create price list from excel sheet -keevill- Excel Discussion (Misc queries) 1 February 8th 05 12:02 AM


All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"