Book 1

Télécharger au format xlsx, pdf ou txt
Télécharger au format xlsx, pdf ou txt
Vous êtes sur la page 1sur 6

FORECASTING MR

dt' = a + (b)t MAD


t dt t^2 t.dt
dt' = 164,095 + (0,19)t E = dt - dt'
1 160 1 160 164.29 -4.28
2 179 4 358 164.48 14.53
3 159 9 477 164.67 -5.66
4 177 16 708 164.86 12.15
5 154 25 770 165.05 -11.04
6 136 36 816 165.23 -29.23
7 180 49 1260 165.43 14.57
8 157 64 1256 165.62 -8.62
9 140 81 1260 165.81 -25.81
10 188 100 1880 166.00 22.00
11 173 121 1903 166.19 6.81
12 181 144 2172 166.38 14.63
SUM 1984 650 13020

MR
40
30
20
10
0
1 2 3 4 5 6 7 8 9 10 11
-10
-20
-30
-40
-50
dt' = a + (b)t MAD
t dt t^2 t.dt
dt' = 164,095 + (0,19)t E = dt - dt'
1 160 1 160 164.29 -4.28
2 179 4 358 164.48 14.53
3 159 9 477 164.67 -5.66
4 177 16 708 164.86 12.15
5 154 25 770 165.05 -11.04
6 136 36 816 165.23 -29.23
7 180 49 1260 165.43 14.57
8 157 64 1256 165.62 -8.62
9 140 81 1260 165.81 -25.81
10 188 100 1880 166.00 22.00
11 173 121 1903 166.19 6.81
12 181 144 2172 166.38 14.63
SUM 1984 650 13020
NG MR SINGLE MOVING AVERAGE MA(3) MA(4)
MA (3) MA (4) MA (3X5) MR t dt MA (3)
1 160
10.24 2 179
166 8.86 3 159 166
171.67 168.75 6.48 4 177 171.67
163.33 167.25 1.1 5 154 163.33
155.67 156.5 -40.28 6 136 155.67
156.67 161.75 162.67 -14.66 7 180 156.67
157.67 156.75 161 5.96 8 157 157.67
159 153.25 158.47 -34.42 9 140 159
161.67 166.25 158.13 -3.8 10 188 161.67
167 164.5 160.4 28.82 11 173 167
180.67 170.5 165.2 21.44 12 181 180.67
-10.26 SUM 1984

7 8 9 10 11 12
MA (3) MA (4) MA (3X5) MR

10.24
166 8.86
171.67 168.75 6.48
163.33 167.25 1.1
155.67 156.5 -40.28
156.67 161.75 162.67 -14.66
157.67 156.75 161 5.96
159 153.25 158.47 -34.42
161.67 166.25 158.13 -3.8
167 164.5 160.4 28.82
180.67 170.5 165.2 21.44
-10.26
VERAGE MA(3) MA(4) DOUBLE MOVING AVERAGE SIMPEL LINERAR REGRES
MA (4) t dt MA (5) MA (3X5) t dt
1 160 1 160
2 179 2 179
3 159 3 159
168.75 4 177 4 177
167.25 5 154 165.8 5 154
156.5 6 136 161 6 136
161.75 7 180 161.2 162.67 7 180
156.75 8 157 160.8 161.00 8 157
153.25 9 140 153.4 158.47 9 140
166.25 10 188 160.2 158.13 10 188
164.5 11 173 167.6 160.40 11 173
170.5 12 181 167.8 165.20 12 181
SUM 1984
L LINERAR REGRESION
t^2 t.dt
1 160
4 358
9 477
16 708
25 770
36 816
49 1260
64 1256
81 1260
100 1880
121 1903
144 2172
650 13020

Vous aimerez peut-être aussi