Forecasting a time series
APRE algorithm
To illustrate the approach, a simple Excel programme, containing macros, was created. At present the first 40 observations of the famous Lorenz attractor are entered in the cells B5:B44. To predict the future values, just click on the button with the time series picture on it, respond to the two dialogue boxes which will emerge and see what happens next. If you want to try your own data, copy your own data into column B over the existing data set. If your data set is longer, there is no problem. If it is shorter, then delete the old values from this column. Click on the button to produce forecasts. To start the spreadsheet, click here. Don't forget, you must enable macros in your Excel.