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  
 

Powered By ExcelEverywhere