Artificial Data
Random
This Chart demonstrates how statistical demand analysis and forecasting works
Level
Real=1
You can either
Trend
SF Ratio
1. Enter your own data in the column headed 'Real Deman' and set the value next to Real=1 to 1;
or
Seas
Normalised
Artifical
Real
If you enter less than 36 months of data, make sure that the blank periods are at the top.
Index
Indices
Demand
Demand
2 Use the artificial Data parameters (Level, Trend, Seasonal Indices and random element.
Totals
to generate artificial data which is then analysed and displayed on the graph
13141
The S.F. ratio determines how sensitive the analysis is to seasonality. Smaller numbers mean it is
18105
more likely to decide data is seasonal and therefore use a seasonal model
13728
16998
11669
16756
15089
18492
12765
13284
13501
15944
8413
16382
19153
23978
11861
15736
14414
32818
16426
16054
12584
23900
12160
16404
20525
13204
18928
14842
18728
16573
10354
14685
7910
15787
The browser does not support JavaScript. The calculations created using
ExcelEverywhere
will not work. Please access the web page using another browser.