LogisticForecast

Syntax

LogisticForecast(Year1, Value1, Year2, Value2,... YearN, ValueN) or
LogisticForecast(ExcelFile, ExcelRange)
LogisticForecast(Branch:Variable)

See also: Using Time-Series Functions and Specifying Excel File and Range Parameters.

Summary

Logistic forecasting is used to estimate future values based on a time series of historical data. The new values are predicted using an approximate fit of a logistic function by linear regression.

A logistic function takes the general form:

where the Y terms corresponds to the variableData that can change over time. to be forecast and the X term is years. A, B, a, b are constants and e is the base of the natural logarithm (2.718). A logistic forecast is most appropriate when a variable is expected to show an "S "shaped curve over time. This makes it useful for forecasting shares, populations and other variables that are expected to grow slowly at first, then rapidly and finally more slowly, approaching some final value (the "B" term in the above equation).

Use this function with caution. You may need to first use some other package to test the statistical validity of the forecast (i.e. test how well the regression "fits" the historical data).

NB: The result of this function will be overridden by any value calculated for the base yearThe first historical year of a LEAP analysis. of your analysis. In some cases this may lead to a marked "jump" from the base year value to the succeeding year's value. This may reflect the fact that the base year you have chosen is not a good match of the long-term trends in your scenarioA self-consistent story line of how a future energy system might evolve over time in a particular socio-economic setting and under a particular set of policy conditions. , or it may reflect a poor fit between the regression and the historical data.