Results of the analysis:Įxcel uses next formula to calculate the standard errors: = SQRT(SUMXMY2('Actual value range' 'range of forecast values') / 'size of the smoothing window'). We tick the «Chart Output», «Standard Errors».Ĭlose the dialog box by clicking OK. The program will place the smoothed levels here and the will define size independently. Output interval –is a reference to the upper left cell of the output range. The damping factor is the coefficient of exponential smoothing (default is 0.3). The input interval is the range of sales values. This alignment method is suitable for our dynamic series, the values of which fluctuate strongly. Select «Exponential Smoothing» from the proposed list of tools for statistical analysis. The connection of the « Data Analysis » add-in is described here in detail.
Click at the bottom «Go» to «Add-Ins Excel» and select « Data Analysis ». On the «DATA» tab click the «Data Analysis» button. The task is to identify the main development trend.Įnter the sales data in the Excel spreadsheet: Example: a sales network analyzes data on sales of goods by stores located in cities with a population of fewer than 50,000 people. As a rule, regular changes in the members of the series are predictable. Their variability is divided into regular and random components. If you capture the values of some process at certain intervals, you get the elements of the time series.
0 kommentar(er)
