Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() "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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
create excel based standalone application | Excel Discussion (Misc queries) | |||
how to create the formula "cumsum" in excel | Excel Worksheet Functions | |||
Create database in excel? | New Users to Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
create price list from excel sheet | Excel Discussion (Misc queries) |