Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




how do I plot a logistic curve
I need to fit a logistic curve to data points on a scatter plot to determine
if regression (r^2) values are closer to 1, then linear or exponential regression lines. The formula is Y = N/1+Ab^t where N = 281422, A = 281421, b = %increase/time (slope), and t = time (x axis) my data points are as follows: (0,38558),(10,49371),(20,62980),(30,76212),(40,922 28),(50,106022),(60,123203),(70,132165),(80,151326 ),(90,179323),(100,203212),(110,226546),(120,24871 0),(130,281422) examples are greatly appreciated. 
#2




Answer: how do I plot a logistic curve
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.misc




how do I plot a logistic curve
I'm a little bit confused. What is the value of b? Are the pairs (t,Y)? Is
t in seconds or minutes? "TRUSSMAN" wrote: I need to fit a logistic curve to data points on a scatter plot to determine if regression (r^2) values are closer to 1, then linear or exponential regression lines. The formula is Y = N/1+Ab^t where N = 281422, A = 281421, b = %increase/time (slope), and t = time (x axis) my data points are as follows: (0,38558),(10,49371),(20,62980),(30,76212),(40,922 28),(50,106022),(60,123203),(70,132165),(80,151326 ),(90,179323),(100,203212),(110,226546),(120,24871 0),(130,281422) examples are greatly appreciated. 
#4
Posted to microsoft.public.excel.misc




how do I plot a logistic curve
t is in years, the value of b (slope) differs depending on the value of t,
and yes the pairs are (t,Y) "Joel" wrote: I'm a little bit confused. What is the value of b? Are the pairs (t,Y)? Is t in seconds or minutes? "TRUSSMAN" wrote: I need to fit a logistic curve to data points on a scatter plot to determine if regression (r^2) values are closer to 1, then linear or exponential regression lines. The formula is Y = N/1+Ab^t where N = 281422, A = 281421, b = %increase/time (slope), and t = time (x axis) my data points are as follows: (0,38558),(10,49371),(20,62980),(30,76212),(40,922 28),(50,106022),(60,123203),(70,132165),(80,151326 ),(90,179323),(100,203212),(110,226546),(120,24871 0),(130,281422) examples are greatly appreciated. 
#5
Posted to microsoft.public.excel.misc




how do I plot a logistic curve
Use Linest, Logest, or Trend. These are worksheet function that you can put
on you worksheet or call the from VBA worksheetfunctions.Linest(Parm1, Parm2, Parm3) worksheetfunctions.Logest(Parm1, Parm2, Parm3) worksheetfunctions.Trend(Parm1, Parm2, Parm3) =Linest(Parm1, Parm2, Parm3) =Logest(Parm1, Parm2, Parm3) =Trend(Parm1, Parm2, Parm3) See worksheet help for more details. In VBA use Range("A1:D4") for Params "TRUSSMAN" wrote: t is in years, the value of b (slope) differs depending on the value of t, and yes the pairs are (t,Y) "Joel" wrote: I'm a little bit confused. What is the value of b? Are the pairs (t,Y)? Is t in seconds or minutes? "TRUSSMAN" wrote: I need to fit a logistic curve to data points on a scatter plot to determine if regression (r^2) values are closer to 1, then linear or exponential regression lines. The formula is Y = N/1+Ab^t where N = 281422, A = 281421, b = %increase/time (slope), and t = time (x axis) my data points are as follows: (0,38558),(10,49371),(20,62980),(30,76212),(40,922 28),(50,106022),(60,123203),(70,132165),(80,151326 ),(90,179323),(100,203212),(110,226546),(120,24871 0),(130,281422) examples are greatly appreciated. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
how do i plot a logistic curve?  Excel Discussion (Misc queries)  
How do you graph a logistic growth curve?  Excel Discussion (Misc queries)  
How can I plot data in different columns to same curve?  Charts and Charting in Excel  
How do I plot the derivative of a curve in Excel?  Excel Worksheet Functions  
Plot the sin curve along the line y=x  Charts and Charting in Excel 