devtodev - Project Seasonality.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
datemetric
corrected metric
additional calculations
day #
linear trend
day in cycle
deviation
trend * seasonality
2
01/03/1623,29523,295140,50410.5833,044
3
02/03/1635,46035,460Autocorrelation lag (days)240,11020.8835,198
4
03/03/1635,16135,16110.70037339,71730.8936,456
5
04/03/1645,81345,81320.34832439,32441.1745,213
6
05/03/1644,68444,6843-0.06789538,93051.1544,991
7
06/03/1644,94744,9474-0.10756638,53761.1744,001
8
07/03/1641,55641,55650.11463738,14371.0939,438
9
08/03/1634,10934,10960.43153837,75010.9030,798
10
09/03/1634,09434,09470.72566937,35720.9132,782
11
10/03/1628,77035,9031036,96330.9733,928
12
11/03/1637,71137,711Max autocorrelation1136,57041.0342,047
13
12/03/1642,21642,21670.725661236,17651.1741,808
14
13/03/1643,28243,2821335,78361.2140,856
15
14/03/1641,03841,0381435,39071.1636,590
16
15/03/1632,29832,298Trend coefficients1534,99610.9228,551
17
16/03/1631,67731,677-393.4040897.161634,60320.9230,365
18
17/03/1635,85135,8511734,20931.0531,400
19
18/03/1642,09142,0911833,81641.2438,880
20
19/03/1637,50137,501Seasonality coefficients1933,42351.1238,626
21
20/03/1635,73135,731day #coefficients2033,02961.0837,712
22
21/03/1631,09231,09210.8158312132,63670.9533,743
23
22/03/1625,71128,07820.8775342232,24210.8726,304
24
23/03/1625,06325,06330.9178832331,84920.7927,949
25
24/03/1625,07025,07041.1497622431,45630.8028,873
26
25/03/1635,97435,97451.1556782531,06241.1635,714
27
26/03/1636,37136,37161.1417832630,66951.1935,443
28
27/03/1633,58933,58971.0339282730,27561.1134,568
29
28/03/1627,90827,9082829,88270.9330,896
30
29/03/1623,79023,7902929,48910.8124,058
31
30/03/1625,85325,8533029,09520.8925,532
32
31/03/1625,48325,4833128,70230.8926,345
33
01/04/163228,308432,548
34
02/04/163327,915532,261
35
03/04/163427,522631,424
36
04/04/163527,128728,049
37
05/04/163626,735121,811
38
06/04/163726,341223,116
39
07/04/163825,948323,817
40
41
Do you have any other questions? Drop us a line at info@devtodev.com
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Лист7
__OpenSolverCache__
__OpenSolver__
__Solver__
расчет сезонности
очистка от выбросов