Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Since you say that the curve initially accelerates,
I visualize the curve as an "S" curve. Maybe like this: http://en.wikipedia.org/wiki/Generalised_logistic_curve Here is the formula in Excel: y=k_a+k_c/((1+k_t*EXP(-k_b*(x-2*k_m)))^(1/k_t)) where y= population x= time k_a lower asymptote k_c upper asymptote minus k_a k_m time of maximum growth k_b growth rate k_t asymmetry of max growth time A simplified formula might look like this: y=a/(b+EXP(-c*x)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forecast and Trends | Excel Worksheet Functions | |||
Charts - Trends - Excel Formula | Charts and Charting in Excel | |||
Need help building chart to track trends between two different sets of data | Charts and Charting in Excel | |||
fill rate trends | Excel Worksheet Functions | |||
TRENDS | Excel Discussion (Misc queries) |