Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_arimaforecasting.wasp
Title produced by softwareARIMA Forecasting
Date of computationWed, 17 Dec 2014 18:55:33 +0000
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2014/Dec/17/t1418842592r3o7ueh8yxpktk3.htm/, Retrieved Mon, 13 May 2024 07:38:05 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=270578, Retrieved Mon, 13 May 2024 07:38:05 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact95
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Univariate Data Series] [] [2008-12-14 11:54:22] [d2d412c7f4d35ffbf5ee5ee89db327d4]
- RMP   [ARIMA Backward Selection] [] [2011-12-06 20:20:50] [b98453cac15ba1066b407e146608df68]
- RMP     [ARIMA Forecasting] [] [2013-11-22 17:46:21] [0307e7a6407eb638caabc417e3a6b260]
- RMPD      [ARIMA Forecasting] [] [2014-12-17 16:00:58] [1651e47f7f65f3a10bbbb444d4b26be7]
- R P           [ARIMA Forecasting] [] [2014-12-17 18:55:33] [023a69c6c348bca0f1811b046758af62] [Current]
Feedback Forum

Post a new message
Dataseries X:
12.90
7.40
12.20
12.80
7.40
6.70
12.60
14.80
13.30
11.10
8.20
11.40
6.40
10.60
12.00
6.30
11.30
11.90
9.30
9.60
10.00
6.40
13.80
10.80
13.80
11.70
10.90
16.10
13.40
9.90
11.50
8.30
11.70
6.10
9.00
9.70
10.80
10.30
10.40
12.70
9.30
11.80
5.90
11.40
13.00
10.80
12.30
11.30
11.80
7.90
12.70
12.30
11.60
6.70
10.90
12.10
13.30
10.10
5.70
14.30
8.00
13.30
9.30
12.50
7.60
15.90
9.20
9.10
11.10
13.00
14.50
12.20
12.30
11.40
8.80
14.60
7.30
12.60
13.00
12.60
13.20
9.90
7.70
10.50
13.40
10.90
4.30
10.30
11.80
11.20
11.40
8.60
13.20
12.60
5.60
9.90
8.80
7.70
9.00
7.30
11.40
13.60
7.90
10.70
10.30
8.30
9.60
14.20
8.50
13.50
4.90
6.40
9.60
11.60
11.10
4.35
12.70
18.10
17.85
16.60
12.60
17.10
19.10
16.10
13.35
18.40
14.70
10.60
12.60
16.20
13.60
18.90
14.10
14.50
16.15
14.75
14.80
12.45
12.65
17.35
8.60
18.40
16.10
11.60
17.75
15.25
17.65
15.60
16.35
17.65
13.60
11.70
14.35
14.75
18.25
9.90
16.00
18.25
16.85
14.60
13.85
18.95
15.60
14.85
11.75
18.45
15.90
17.10
16.10
19.90
10.95
18.45
15.10
15.00
11.35
15.95
18.10
14.60
15.40
15.40
17.60
13.35
19.10
15.35
7.60
13.40
13.90
19.10
15.25
12.90
16.10
17.35
13.15
12.15
12.60
10.35
15.40
9.60
18.20
13.60
14.85
14.75
14.10
14.90
16.25
19.25
13.60
13.60
15.65
12.75
14.60
9.85
12.65
11.90
19.20
16.60
11.20
15.25
11.90
13.20
16.35
12.40
15.85
14.35
18.15
11.15
15.65
17.75
7.65
12.35
15.60
19.30
15.20
17.10
15.60
18.40
19.05
18.55
19.10
13.10
12.85
9.50
4.50
11.85
13.60
11.70
12.40
13.35
11.40
14.90
19.90
17.75
11.20
14.60
17.60
14.05
16.10
13.35
11.85
11.95
14.75
15.15
13.20
16.85
7.85
7.70
12.60
7.85
10.95
12.35
9.95
14.90
16.65
13.40
13.95
15.70
16.85
10.95
15.35
12.20
15.10
17.75
15.20
14.60
16.65
8.10




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time2 seconds
R Server'George Udny Yule' @ yule.wessa.net

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 2 seconds \tabularnewline
R Server & 'George Udny Yule' @ yule.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=270578&T=0

[TABLE]
[ROW][C]Summary of computational transaction[/C][/ROW]
[ROW][C]Raw Input[/C][C]view raw input (R code) [/C][/ROW]
[ROW][C]Raw Output[/C][C]view raw output of R engine [/C][/ROW]
[ROW][C]Computing time[/C][C]2 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'George Udny Yule' @ yule.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=270578&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=270578&T=0

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time2 seconds
R Server'George Udny Yule' @ yule.wessa.net







Univariate ARIMA Extrapolation Forecast
timeY[t]F[t]95% LB95% UBp-value(H0: Y[t] = F[t])P(F[t]>Y[t-1])P(F[t]>Y[t-s])P(F[t]>Y[274])
26215.15-------
26313.2-------
26416.85-------
2657.85-------
2667.7-------
26712.6-------
2687.85-------
26910.95-------
27012.35-------
2719.95-------
27214.9-------
27316.65-------
27413.4-------
27513.9516.13299.733222.53270.25190.79870.81550.7987
27615.716.10299.551222.65460.4520.74020.41160.7906
27716.8511.03944.480517.59830.04120.08180.82970.2403
27810.9512.14065.581318.69980.3610.07970.90770.3533
27915.3513.01546.456219.57470.24270.73140.54940.4543
28012.212.52735.96819.08650.4610.19950.91890.3971
28115.113.79377.234420.3530.34810.6830.80230.5468
28217.7513.16866.609319.72790.08550.28190.59660.4724
28315.212.70126.141919.26040.22760.06570.79450.4173
28414.614.08177.522420.64090.43850.36910.40340.5807
28516.6515.28488.725521.8440.34170.58110.34170.7133
2868.114.44887.889621.00810.02890.25540.6230.623

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast \tabularnewline
time & Y[t] & F[t] & 95% LB & 95% UB & p-value(H0: Y[t] = F[t]) & P(F[t]>Y[t-1]) & P(F[t]>Y[t-s]) & P(F[t]>Y[274]) \tabularnewline
262 & 15.15 & - & - & - & - & - & - & - \tabularnewline
263 & 13.2 & - & - & - & - & - & - & - \tabularnewline
264 & 16.85 & - & - & - & - & - & - & - \tabularnewline
265 & 7.85 & - & - & - & - & - & - & - \tabularnewline
266 & 7.7 & - & - & - & - & - & - & - \tabularnewline
267 & 12.6 & - & - & - & - & - & - & - \tabularnewline
268 & 7.85 & - & - & - & - & - & - & - \tabularnewline
269 & 10.95 & - & - & - & - & - & - & - \tabularnewline
270 & 12.35 & - & - & - & - & - & - & - \tabularnewline
271 & 9.95 & - & - & - & - & - & - & - \tabularnewline
272 & 14.9 & - & - & - & - & - & - & - \tabularnewline
273 & 16.65 & - & - & - & - & - & - & - \tabularnewline
274 & 13.4 & - & - & - & - & - & - & - \tabularnewline
275 & 13.95 & 16.1329 & 9.7332 & 22.5327 & 0.2519 & 0.7987 & 0.8155 & 0.7987 \tabularnewline
276 & 15.7 & 16.1029 & 9.5512 & 22.6546 & 0.452 & 0.7402 & 0.4116 & 0.7906 \tabularnewline
277 & 16.85 & 11.0394 & 4.4805 & 17.5983 & 0.0412 & 0.0818 & 0.8297 & 0.2403 \tabularnewline
278 & 10.95 & 12.1406 & 5.5813 & 18.6998 & 0.361 & 0.0797 & 0.9077 & 0.3533 \tabularnewline
279 & 15.35 & 13.0154 & 6.4562 & 19.5747 & 0.2427 & 0.7314 & 0.5494 & 0.4543 \tabularnewline
280 & 12.2 & 12.5273 & 5.968 & 19.0865 & 0.461 & 0.1995 & 0.9189 & 0.3971 \tabularnewline
281 & 15.1 & 13.7937 & 7.2344 & 20.353 & 0.3481 & 0.683 & 0.8023 & 0.5468 \tabularnewline
282 & 17.75 & 13.1686 & 6.6093 & 19.7279 & 0.0855 & 0.2819 & 0.5966 & 0.4724 \tabularnewline
283 & 15.2 & 12.7012 & 6.1419 & 19.2604 & 0.2276 & 0.0657 & 0.7945 & 0.4173 \tabularnewline
284 & 14.6 & 14.0817 & 7.5224 & 20.6409 & 0.4385 & 0.3691 & 0.4034 & 0.5807 \tabularnewline
285 & 16.65 & 15.2848 & 8.7255 & 21.844 & 0.3417 & 0.5811 & 0.3417 & 0.7133 \tabularnewline
286 & 8.1 & 14.4488 & 7.8896 & 21.0081 & 0.0289 & 0.2554 & 0.623 & 0.623 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=270578&T=1

[TABLE]
[ROW][C]Univariate ARIMA Extrapolation Forecast[/C][/ROW]
[ROW][C]time[/C][C]Y[t][/C][C]F[t][/C][C]95% LB[/C][C]95% UB[/C][C]p-value(H0: Y[t] = F[t])[/C][C]P(F[t]>Y[t-1])[/C][C]P(F[t]>Y[t-s])[/C][C]P(F[t]>Y[274])[/C][/ROW]
[ROW][C]262[/C][C]15.15[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]263[/C][C]13.2[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]264[/C][C]16.85[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]265[/C][C]7.85[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]266[/C][C]7.7[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]267[/C][C]12.6[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]268[/C][C]7.85[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]269[/C][C]10.95[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]270[/C][C]12.35[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]271[/C][C]9.95[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]272[/C][C]14.9[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]273[/C][C]16.65[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]274[/C][C]13.4[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]275[/C][C]13.95[/C][C]16.1329[/C][C]9.7332[/C][C]22.5327[/C][C]0.2519[/C][C]0.7987[/C][C]0.8155[/C][C]0.7987[/C][/ROW]
[ROW][C]276[/C][C]15.7[/C][C]16.1029[/C][C]9.5512[/C][C]22.6546[/C][C]0.452[/C][C]0.7402[/C][C]0.4116[/C][C]0.7906[/C][/ROW]
[ROW][C]277[/C][C]16.85[/C][C]11.0394[/C][C]4.4805[/C][C]17.5983[/C][C]0.0412[/C][C]0.0818[/C][C]0.8297[/C][C]0.2403[/C][/ROW]
[ROW][C]278[/C][C]10.95[/C][C]12.1406[/C][C]5.5813[/C][C]18.6998[/C][C]0.361[/C][C]0.0797[/C][C]0.9077[/C][C]0.3533[/C][/ROW]
[ROW][C]279[/C][C]15.35[/C][C]13.0154[/C][C]6.4562[/C][C]19.5747[/C][C]0.2427[/C][C]0.7314[/C][C]0.5494[/C][C]0.4543[/C][/ROW]
[ROW][C]280[/C][C]12.2[/C][C]12.5273[/C][C]5.968[/C][C]19.0865[/C][C]0.461[/C][C]0.1995[/C][C]0.9189[/C][C]0.3971[/C][/ROW]
[ROW][C]281[/C][C]15.1[/C][C]13.7937[/C][C]7.2344[/C][C]20.353[/C][C]0.3481[/C][C]0.683[/C][C]0.8023[/C][C]0.5468[/C][/ROW]
[ROW][C]282[/C][C]17.75[/C][C]13.1686[/C][C]6.6093[/C][C]19.7279[/C][C]0.0855[/C][C]0.2819[/C][C]0.5966[/C][C]0.4724[/C][/ROW]
[ROW][C]283[/C][C]15.2[/C][C]12.7012[/C][C]6.1419[/C][C]19.2604[/C][C]0.2276[/C][C]0.0657[/C][C]0.7945[/C][C]0.4173[/C][/ROW]
[ROW][C]284[/C][C]14.6[/C][C]14.0817[/C][C]7.5224[/C][C]20.6409[/C][C]0.4385[/C][C]0.3691[/C][C]0.4034[/C][C]0.5807[/C][/ROW]
[ROW][C]285[/C][C]16.65[/C][C]15.2848[/C][C]8.7255[/C][C]21.844[/C][C]0.3417[/C][C]0.5811[/C][C]0.3417[/C][C]0.7133[/C][/ROW]
[ROW][C]286[/C][C]8.1[/C][C]14.4488[/C][C]7.8896[/C][C]21.0081[/C][C]0.0289[/C][C]0.2554[/C][C]0.623[/C][C]0.623[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=270578&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=270578&T=1

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Univariate ARIMA Extrapolation Forecast
timeY[t]F[t]95% LB95% UBp-value(H0: Y[t] = F[t])P(F[t]>Y[t-1])P(F[t]>Y[t-s])P(F[t]>Y[274])
26215.15-------
26313.2-------
26416.85-------
2657.85-------
2667.7-------
26712.6-------
2687.85-------
26910.95-------
27012.35-------
2719.95-------
27214.9-------
27316.65-------
27413.4-------
27513.9516.13299.733222.53270.25190.79870.81550.7987
27615.716.10299.551222.65460.4520.74020.41160.7906
27716.8511.03944.480517.59830.04120.08180.82970.2403
27810.9512.14065.581318.69980.3610.07970.90770.3533
27915.3513.01546.456219.57470.24270.73140.54940.4543
28012.212.52735.96819.08650.4610.19950.91890.3971
28115.113.79377.234420.3530.34810.6830.80230.5468
28217.7513.16866.609319.72790.08550.28190.59660.4724
28315.212.70126.141919.26040.22760.06570.79450.4173
28414.614.08177.522420.64090.43850.36910.40340.5807
28516.6515.28488.725521.8440.34170.58110.34170.7133
2868.114.44887.889621.00810.02890.25540.6230.623







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPEsMAPESq.EMSERMSEScaledEMASE
2750.2024-0.15650.15650.14514.765200-0.67360.6736
2760.2076-0.02570.09110.08520.16232.46381.5696-0.12430.3989
2770.30310.34480.17570.195733.763412.8973.59121.79290.8636
2780.2757-0.10870.15890.17261.417510.02713.1666-0.36740.7395
2790.25710.15210.15760.1715.45029.11173.01860.72030.7357
2800.2671-0.02680.13580.14690.10717.6112.7588-0.1010.6299
2810.24260.08650.12870.13881.70646.76752.60140.40310.5975
2820.25410.25810.14490.158520.98918.54522.92321.41360.6995
2830.26350.16440.14710.16086.24428.28952.87910.7710.7075
2840.23770.03550.13590.14830.26877.48742.73630.15990.6527
2850.21890.0820.1310.14261.86396.97622.64120.42130.6317
2860.2316-0.78380.18540.177740.30789.75383.1231-1.9590.7423

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & sMAPE & Sq.E & MSE & RMSE & ScaledE & MASE \tabularnewline
275 & 0.2024 & -0.1565 & 0.1565 & 0.1451 & 4.7652 & 0 & 0 & -0.6736 & 0.6736 \tabularnewline
276 & 0.2076 & -0.0257 & 0.0911 & 0.0852 & 0.1623 & 2.4638 & 1.5696 & -0.1243 & 0.3989 \tabularnewline
277 & 0.3031 & 0.3448 & 0.1757 & 0.1957 & 33.7634 & 12.897 & 3.5912 & 1.7929 & 0.8636 \tabularnewline
278 & 0.2757 & -0.1087 & 0.1589 & 0.1726 & 1.4175 & 10.0271 & 3.1666 & -0.3674 & 0.7395 \tabularnewline
279 & 0.2571 & 0.1521 & 0.1576 & 0.171 & 5.4502 & 9.1117 & 3.0186 & 0.7203 & 0.7357 \tabularnewline
280 & 0.2671 & -0.0268 & 0.1358 & 0.1469 & 0.1071 & 7.611 & 2.7588 & -0.101 & 0.6299 \tabularnewline
281 & 0.2426 & 0.0865 & 0.1287 & 0.1388 & 1.7064 & 6.7675 & 2.6014 & 0.4031 & 0.5975 \tabularnewline
282 & 0.2541 & 0.2581 & 0.1449 & 0.1585 & 20.9891 & 8.5452 & 2.9232 & 1.4136 & 0.6995 \tabularnewline
283 & 0.2635 & 0.1644 & 0.1471 & 0.1608 & 6.2442 & 8.2895 & 2.8791 & 0.771 & 0.7075 \tabularnewline
284 & 0.2377 & 0.0355 & 0.1359 & 0.1483 & 0.2687 & 7.4874 & 2.7363 & 0.1599 & 0.6527 \tabularnewline
285 & 0.2189 & 0.082 & 0.131 & 0.1426 & 1.8639 & 6.9762 & 2.6412 & 0.4213 & 0.6317 \tabularnewline
286 & 0.2316 & -0.7838 & 0.1854 & 0.1777 & 40.3078 & 9.7538 & 3.1231 & -1.959 & 0.7423 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=270578&T=2

[TABLE]
[ROW][C]Univariate ARIMA Extrapolation Forecast Performance[/C][/ROW]
[ROW][C]time[/C][C]% S.E.[/C][C]PE[/C][C]MAPE[/C][C]sMAPE[/C][C]Sq.E[/C][C]MSE[/C][C]RMSE[/C][C]ScaledE[/C][C]MASE[/C][/ROW]
[ROW][C]275[/C][C]0.2024[/C][C]-0.1565[/C][C]0.1565[/C][C]0.1451[/C][C]4.7652[/C][C]0[/C][C]0[/C][C]-0.6736[/C][C]0.6736[/C][/ROW]
[ROW][C]276[/C][C]0.2076[/C][C]-0.0257[/C][C]0.0911[/C][C]0.0852[/C][C]0.1623[/C][C]2.4638[/C][C]1.5696[/C][C]-0.1243[/C][C]0.3989[/C][/ROW]
[ROW][C]277[/C][C]0.3031[/C][C]0.3448[/C][C]0.1757[/C][C]0.1957[/C][C]33.7634[/C][C]12.897[/C][C]3.5912[/C][C]1.7929[/C][C]0.8636[/C][/ROW]
[ROW][C]278[/C][C]0.2757[/C][C]-0.1087[/C][C]0.1589[/C][C]0.1726[/C][C]1.4175[/C][C]10.0271[/C][C]3.1666[/C][C]-0.3674[/C][C]0.7395[/C][/ROW]
[ROW][C]279[/C][C]0.2571[/C][C]0.1521[/C][C]0.1576[/C][C]0.171[/C][C]5.4502[/C][C]9.1117[/C][C]3.0186[/C][C]0.7203[/C][C]0.7357[/C][/ROW]
[ROW][C]280[/C][C]0.2671[/C][C]-0.0268[/C][C]0.1358[/C][C]0.1469[/C][C]0.1071[/C][C]7.611[/C][C]2.7588[/C][C]-0.101[/C][C]0.6299[/C][/ROW]
[ROW][C]281[/C][C]0.2426[/C][C]0.0865[/C][C]0.1287[/C][C]0.1388[/C][C]1.7064[/C][C]6.7675[/C][C]2.6014[/C][C]0.4031[/C][C]0.5975[/C][/ROW]
[ROW][C]282[/C][C]0.2541[/C][C]0.2581[/C][C]0.1449[/C][C]0.1585[/C][C]20.9891[/C][C]8.5452[/C][C]2.9232[/C][C]1.4136[/C][C]0.6995[/C][/ROW]
[ROW][C]283[/C][C]0.2635[/C][C]0.1644[/C][C]0.1471[/C][C]0.1608[/C][C]6.2442[/C][C]8.2895[/C][C]2.8791[/C][C]0.771[/C][C]0.7075[/C][/ROW]
[ROW][C]284[/C][C]0.2377[/C][C]0.0355[/C][C]0.1359[/C][C]0.1483[/C][C]0.2687[/C][C]7.4874[/C][C]2.7363[/C][C]0.1599[/C][C]0.6527[/C][/ROW]
[ROW][C]285[/C][C]0.2189[/C][C]0.082[/C][C]0.131[/C][C]0.1426[/C][C]1.8639[/C][C]6.9762[/C][C]2.6412[/C][C]0.4213[/C][C]0.6317[/C][/ROW]
[ROW][C]286[/C][C]0.2316[/C][C]-0.7838[/C][C]0.1854[/C][C]0.1777[/C][C]40.3078[/C][C]9.7538[/C][C]3.1231[/C][C]-1.959[/C][C]0.7423[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=270578&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=270578&T=2

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPEsMAPESq.EMSERMSEScaledEMASE
2750.2024-0.15650.15650.14514.765200-0.67360.6736
2760.2076-0.02570.09110.08520.16232.46381.5696-0.12430.3989
2770.30310.34480.17570.195733.763412.8973.59121.79290.8636
2780.2757-0.10870.15890.17261.417510.02713.1666-0.36740.7395
2790.25710.15210.15760.1715.45029.11173.01860.72030.7357
2800.2671-0.02680.13580.14690.10717.6112.7588-0.1010.6299
2810.24260.08650.12870.13881.70646.76752.60140.40310.5975
2820.25410.25810.14490.158520.98918.54522.92321.41360.6995
2830.26350.16440.14710.16086.24428.28952.87910.7710.7075
2840.23770.03550.13590.14830.26877.48742.73630.15990.6527
2850.21890.0820.1310.14261.86396.97622.64120.42130.6317
2860.2316-0.78380.18540.177740.30789.75383.1231-1.9590.7423



Parameters (Session):
par1 = 12 ; par2 = 1 ; par3 = 0 ; par4 = 1 ; par5 = 12 ; par6 = 1 ; par7 = 0 ; par8 = 0 ; par9 = 1 ; par10 = FALSE ;
Parameters (R input):
par1 = 12 ; par2 = 1 ; par3 = 0 ; par4 = 1 ; par5 = 12 ; par6 = 1 ; par7 = 0 ; par8 = 0 ; par9 = 1 ; par10 = FALSE ;
R code (references can be found in the software module):
par10 <- 'FALSE'
par9 <- '1'
par8 <- '0'
par7 <- '0'
par6 <- '1'
par5 <- '12'
par4 <- '0'
par3 <- '0'
par2 <- '1'
par1 <- '12'
par1 <- as.numeric(par1) #cut off periods
par2 <- as.numeric(par2) #lambda
par3 <- as.numeric(par3) #degree of non-seasonal differencing
par4 <- as.numeric(par4) #degree of seasonal differencing
par5 <- as.numeric(par5) #seasonal period
par6 <- as.numeric(par6) #p
par7 <- as.numeric(par7) #q
par8 <- as.numeric(par8) #P
par9 <- as.numeric(par9) #Q
if (par10 == 'TRUE') par10 <- TRUE
if (par10 == 'FALSE') par10 <- FALSE
if (par2 == 0) x <- log(x)
if (par2 != 0) x <- x^par2
lx <- length(x)
first <- lx - 2*par1
nx <- lx - par1
nx1 <- nx + 1
fx <- lx - nx
if (fx < 1) {
fx <- par5
nx1 <- lx + fx - 1
first <- lx - 2*fx
}
first <- 1
if (fx < 3) fx <- round(lx/10,0)
(arima.out <- arima(x[1:nx], order=c(par6,par3,par7), seasonal=list(order=c(par8,par4,par9), period=par5), include.mean=par10, method='ML'))
(forecast <- predict(arima.out,par1))
(lb <- forecast$pred - 1.96 * forecast$se)
(ub <- forecast$pred + 1.96 * forecast$se)
if (par2 == 0) {
x <- exp(x)
forecast$pred <- exp(forecast$pred)
lb <- exp(lb)
ub <- exp(ub)
}
if (par2 != 0) {
x <- x^(1/par2)
forecast$pred <- forecast$pred^(1/par2)
lb <- lb^(1/par2)
ub <- ub^(1/par2)
}
if (par2 < 0) {
olb <- lb
lb <- ub
ub <- olb
}
(actandfor <- c(x[1:nx], forecast$pred))
(perc.se <- (ub-forecast$pred)/1.96/forecast$pred)
bitmap(file='test1.png')
opar <- par(mar=c(4,4,2,2),las=1)
ylim <- c( min(x[first:nx],lb), max(x[first:nx],ub))
plot(x,ylim=ylim,type='n',xlim=c(first,lx))
usr <- par('usr')
rect(usr[1],usr[3],nx+1,usr[4],border=NA,col='lemonchiffon')
rect(nx1,usr[3],usr[2],usr[4],border=NA,col='lavender')
abline(h= (-3:3)*2 , col ='gray', lty =3)
polygon( c(nx1:lx,lx:nx1), c(lb,rev(ub)), col = 'orange', lty=2,border=NA)
lines(nx1:lx, lb , lty=2)
lines(nx1:lx, ub , lty=2)
lines(x, lwd=2)
lines(nx1:lx, forecast$pred , lwd=2 , col ='white')
box()
par(opar)
dev.off()
prob.dec <- array(NA, dim=fx)
prob.sdec <- array(NA, dim=fx)
prob.ldec <- array(NA, dim=fx)
prob.pval <- array(NA, dim=fx)
perf.pe <- array(0, dim=fx)
perf.spe <- array(0, dim=fx)
perf.scalederr <- array(0, dim=fx)
perf.mase <- array(0, dim=fx)
perf.mase1 <- array(0, dim=fx)
perf.mape <- array(0, dim=fx)
perf.smape <- array(0, dim=fx)
perf.mape1 <- array(0, dim=fx)
perf.smape1 <- array(0,dim=fx)
perf.se <- array(0, dim=fx)
perf.mse <- array(0, dim=fx)
perf.mse1 <- array(0, dim=fx)
perf.rmse <- array(0, dim=fx)
perf.scaleddenom <- 0
for (i in 2:fx) {
perf.scaleddenom = perf.scaleddenom + abs(x[nx+i] - x[nx+i-1])
}
perf.scaleddenom = perf.scaleddenom / (fx-1)
for (i in 1:fx) {
locSD <- (ub[i] - forecast$pred[i]) / 1.96
perf.scalederr[i] = (x[nx+i] - forecast$pred[i]) / perf.scaleddenom
perf.pe[i] = (x[nx+i] - forecast$pred[i]) / x[nx+i]
perf.spe[i] = 2*(x[nx+i] - forecast$pred[i]) / (x[nx+i] + forecast$pred[i])
perf.se[i] = (x[nx+i] - forecast$pred[i])^2
prob.dec[i] = pnorm((x[nx+i-1] - forecast$pred[i]) / locSD)
prob.sdec[i] = pnorm((x[nx+i-par5] - forecast$pred[i]) / locSD)
prob.ldec[i] = pnorm((x[nx] - forecast$pred[i]) / locSD)
prob.pval[i] = pnorm(abs(x[nx+i] - forecast$pred[i]) / locSD)
}
perf.mape[1] = abs(perf.pe[1])
perf.smape[1] = abs(perf.spe[1])
perf.mape1[1] = perf.mape[1]
perf.smape1[1] = perf.smape[1]
perf.mse[1] = perf.se[1]
perf.mase[1] = abs(perf.scalederr[1])
perf.mase1[1] = perf.mase[1]
for (i in 2:fx) {
perf.mape[i] = perf.mape[i-1] + abs(perf.pe[i])
perf.mape1[i] = perf.mape[i] / i
perf.smape[i] = perf.smape[i-1] + abs(perf.spe[i])
perf.smape1[i] = perf.smape[i] / i
perf.mse[i] = perf.mse[i-1] + perf.se[i]
perf.mse1[i] = perf.mse[i] / i
perf.mase[i] = perf.mase[i-1] + abs(perf.scalederr[i])
perf.mase1[i] = perf.mase[i] / i
}
perf.rmse = sqrt(perf.mse1)
bitmap(file='test2.png')
plot(forecast$pred, pch=19, type='b',main='ARIMA Extrapolation Forecast', ylab='Forecast and 95% CI', xlab='time',ylim=c(min(lb),max(ub)))
dum <- forecast$pred
dum[1:par1] <- x[(nx+1):lx]
lines(dum, lty=1)
lines(ub,lty=3)
lines(lb,lty=3)
dev.off()
load(file='createtable')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Univariate ARIMA Extrapolation Forecast',9,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'time',1,header=TRUE)
a<-table.element(a,'Y[t]',1,header=TRUE)
a<-table.element(a,'F[t]',1,header=TRUE)
a<-table.element(a,'95% LB',1,header=TRUE)
a<-table.element(a,'95% UB',1,header=TRUE)
a<-table.element(a,'p-value
(H0: Y[t] = F[t])',1,header=TRUE)
a<-table.element(a,'P(F[t]>Y[t-1])',1,header=TRUE)
a<-table.element(a,'P(F[t]>Y[t-s])',1,header=TRUE)
mylab <- paste('P(F[t]>Y[',nx,sep='')
mylab <- paste(mylab,'])',sep='')
a<-table.element(a,mylab,1,header=TRUE)
a<-table.row.end(a)
for (i in (nx-par5):nx) {
a<-table.row.start(a)
a<-table.element(a,i,header=TRUE)
a<-table.element(a,x[i])
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.row.end(a)
}
for (i in 1:fx) {
a<-table.row.start(a)
a<-table.element(a,nx+i,header=TRUE)
a<-table.element(a,round(x[nx+i],4))
a<-table.element(a,round(forecast$pred[i],4))
a<-table.element(a,round(lb[i],4))
a<-table.element(a,round(ub[i],4))
a<-table.element(a,round((1-prob.pval[i]),4))
a<-table.element(a,round((1-prob.dec[i]),4))
a<-table.element(a,round((1-prob.sdec[i]),4))
a<-table.element(a,round((1-prob.ldec[i]),4))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Univariate ARIMA Extrapolation Forecast Performance',10,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'time',1,header=TRUE)
a<-table.element(a,'% S.E.',1,header=TRUE)
a<-table.element(a,'PE',1,header=TRUE)
a<-table.element(a,'MAPE',1,header=TRUE)
a<-table.element(a,'sMAPE',1,header=TRUE)
a<-table.element(a,'Sq.E',1,header=TRUE)
a<-table.element(a,'MSE',1,header=TRUE)
a<-table.element(a,'RMSE',1,header=TRUE)
a<-table.element(a,'ScaledE',1,header=TRUE)
a<-table.element(a,'MASE',1,header=TRUE)
a<-table.row.end(a)
for (i in 1:fx) {
a<-table.row.start(a)
a<-table.element(a,nx+i,header=TRUE)
a<-table.element(a,round(perc.se[i],4))
a<-table.element(a,round(perf.pe[i],4))
a<-table.element(a,round(perf.mape1[i],4))
a<-table.element(a,round(perf.smape1[i],4))
a<-table.element(a,round(perf.se[i],4))
a<-table.element(a,round(perf.mse1[i],4))
a<-table.element(a,round(perf.rmse[i],4))
a<-table.element(a,round(perf.scalederr[i],4))
a<-table.element(a,round(perf.mase1[i],4))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable1.tab')