Free Statistics

of Irreproducible Research!

Author's title

Author*Unverified author*
R Software Modulerwasp_arimaforecasting.wasp
Title produced by softwareARIMA Forecasting
Date of computationWed, 25 Apr 2018 21:04:08 +0200
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2018/Apr/25/t1524683248s9j7trc9h0o3mt3.htm/, Retrieved Sat, 04 May 2024 02:45:01 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=315055, Retrieved Sat, 04 May 2024 02:45:01 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact143
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [ARIMA Forecasting] [] [2018-04-25 19:04:08] [d41d8cd98f00b204e9800998ecf8427e] [Current]
Feedback Forum

Post a new message
Dataseries X:
14 383,10
13 630,90
13 384,30
12 417,10
12 100,50
11 691,50
12 011,00
12 000,90
11 671,10
11 482,50
10 986,20
12 131,50
12 141,60
11 576,20
11 840,70
10 385,80
9 915,70
9 999,20
10 667,40
10 650,20
10 456,70
11 392,60
12 229,70
13 249,80
13 572,90
12 759,10
13 091,40
11 840,40
11 216,50
11 035,70
11 390,20
11 770,10
11 278,00
12 693,10
12 725,10
14 111,00
14 298,50
13 440,30
13 816,30
12 202,20
11 343,90
11 247,20
11 658,80
11 819,20
11 396,60
12 441,10
13 398,20
13 706,10
13 772,40
14 478,40
13 694,10
12 165,10
11 543,90
11 425,80
11 948,30
11 967,00
11 224,10
11 911,30
12 810,80
13 778,90
13 246,67
12 205,54
12 837,87
11 698,80
10 725,48
10 649,56
11 020,91
11 059,02
10 830,69
11 935,15
12 030,17
13 092,69
13 066,31
12 519,09
12 145,35
11 296,54
10 733,00
10 307,85
10 437,27
9 967,83
9 497,42
10 804,31
11 641,19
12 157,71
11 831,90
10 991,17
11 091,70
10 164,63
9 055,35
8 648,46
8 863,47
9 103,50
8 691,99
9 587,15
10 091,62
10 605,96
11 055,12
10 406,87
10 257,89
9 281,56
8 842,30
8 720,15
9 195,92
9 271,34
8 950,93
10 139,95
10 682,15
11 453,83
11 439,97
10 779,43
10 179,98
9 317,86
9 011,00
8 840,39
9 084,81
9 532,60
9 001,07
9 946,53
10 660,34
11 133,07
11 358,38




Summary of computational transaction
Raw Input view raw input (R code)
Raw Outputview raw output of R engine
Computing time91 seconds
R ServerBig Analytics Cloud Computing Center

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input view raw input (R code)  \tabularnewline
Raw Outputview raw output of R engine  \tabularnewline
Computing time91 seconds \tabularnewline
R ServerBig Analytics Cloud Computing Center \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=315055&T=0

[TABLE]
[ROW]
Summary of computational transaction[/C][/ROW] [ROW]Raw Input[/C] view raw input (R code) [/C][/ROW] [ROW]Raw Output[/C]view raw output of R engine [/C][/ROW] [ROW]Computing time[/C]91 seconds[/C][/ROW] [ROW]R Server[/C]Big Analytics Cloud Computing Center[/C][/ROW] [/TABLE] Source: https://freestatistics.org/blog/index.php?pk=315055&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=315055&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 Input view raw input (R code)
Raw Outputview raw output of R engine
Computing time91 seconds
R ServerBig Analytics Cloud Computing Center







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[97])
9610605.96-------
9711055.12-------
9810406.8711124.16429791.576712456.75180.14570.54040.54040.5404
9910257.8911123.9799051.758413196.19960.20630.75120.75120.526
1009281.5611123.79388513.75113733.83650.08330.74220.74220.5206
1018842.311123.60868069.027714178.18940.07160.88140.88140.5175
1028720.1511123.42337681.255214565.59150.08560.9030.9030.5155
1039195.9211123.23817332.922214913.5540.15950.8930.8930.514
1049271.3411123.05297013.991715232.11410.18850.8210.8210.5129
1058950.9311122.86776718.07615527.65940.16690.7950.7950.512
10610139.9511122.68256440.81215804.5530.34040.81840.81840.5113
10710682.1511122.49736179.062316065.93230.43070.65160.65160.5107
10811453.8311122.31215930.481716314.14260.45020.5660.5660.5101
10911439.9711122.12695693.262116550.99180.45430.45230.45230.5097
11010779.4311121.94175465.97516777.90850.45280.45610.45610.5092
11110179.9811121.75655247.468316996.04480.37670.54550.54550.5089
1129317.8611121.57145036.796817206.34590.28060.61920.61920.5085
113901111121.38624833.173717409.59870.25530.7130.7130.5082
1148840.3911121.2014635.935617606.46640.24530.73820.73820.508
1159084.8111121.01584444.517117797.51450.2750.74840.74840.5077
1169532.611120.83064258.431817983.22950.32510.71960.71960.5075
1179001.0711120.64554077.257218164.03370.27770.67070.67070.5073
1189946.5311120.46033900.624218340.29640.3750.71750.71750.5071
11910660.3411120.27513728.207418512.34290.45150.62220.62220.5069
12011133.0711120.093559.718718680.46130.49870.54740.54740.5067
12111358.3811119.90483394.901418844.90830.47590.49870.49870.5066

\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[97]) \tabularnewline
96 & 10605.96 & - & - & - & - & - & - & - \tabularnewline
97 & 11055.12 & - & - & - & - & - & - & - \tabularnewline
98 & 10406.87 & 11124.1642 & 9791.5767 & 12456.7518 & 0.1457 & 0.5404 & 0.5404 & 0.5404 \tabularnewline
99 & 10257.89 & 11123.979 & 9051.7584 & 13196.1996 & 0.2063 & 0.7512 & 0.7512 & 0.526 \tabularnewline
100 & 9281.56 & 11123.7938 & 8513.751 & 13733.8365 & 0.0833 & 0.7422 & 0.7422 & 0.5206 \tabularnewline
101 & 8842.3 & 11123.6086 & 8069.0277 & 14178.1894 & 0.0716 & 0.8814 & 0.8814 & 0.5175 \tabularnewline
102 & 8720.15 & 11123.4233 & 7681.2552 & 14565.5915 & 0.0856 & 0.903 & 0.903 & 0.5155 \tabularnewline
103 & 9195.92 & 11123.2381 & 7332.9222 & 14913.554 & 0.1595 & 0.893 & 0.893 & 0.514 \tabularnewline
104 & 9271.34 & 11123.0529 & 7013.9917 & 15232.1141 & 0.1885 & 0.821 & 0.821 & 0.5129 \tabularnewline
105 & 8950.93 & 11122.8677 & 6718.076 & 15527.6594 & 0.1669 & 0.795 & 0.795 & 0.512 \tabularnewline
106 & 10139.95 & 11122.6825 & 6440.812 & 15804.553 & 0.3404 & 0.8184 & 0.8184 & 0.5113 \tabularnewline
107 & 10682.15 & 11122.4973 & 6179.0623 & 16065.9323 & 0.4307 & 0.6516 & 0.6516 & 0.5107 \tabularnewline
108 & 11453.83 & 11122.3121 & 5930.4817 & 16314.1426 & 0.4502 & 0.566 & 0.566 & 0.5101 \tabularnewline
109 & 11439.97 & 11122.1269 & 5693.2621 & 16550.9918 & 0.4543 & 0.4523 & 0.4523 & 0.5097 \tabularnewline
110 & 10779.43 & 11121.9417 & 5465.975 & 16777.9085 & 0.4528 & 0.4561 & 0.4561 & 0.5092 \tabularnewline
111 & 10179.98 & 11121.7565 & 5247.4683 & 16996.0448 & 0.3767 & 0.5455 & 0.5455 & 0.5089 \tabularnewline
112 & 9317.86 & 11121.5714 & 5036.7968 & 17206.3459 & 0.2806 & 0.6192 & 0.6192 & 0.5085 \tabularnewline
113 & 9011 & 11121.3862 & 4833.1737 & 17409.5987 & 0.2553 & 0.713 & 0.713 & 0.5082 \tabularnewline
114 & 8840.39 & 11121.201 & 4635.9356 & 17606.4664 & 0.2453 & 0.7382 & 0.7382 & 0.508 \tabularnewline
115 & 9084.81 & 11121.0158 & 4444.5171 & 17797.5145 & 0.275 & 0.7484 & 0.7484 & 0.5077 \tabularnewline
116 & 9532.6 & 11120.8306 & 4258.4318 & 17983.2295 & 0.3251 & 0.7196 & 0.7196 & 0.5075 \tabularnewline
117 & 9001.07 & 11120.6455 & 4077.2572 & 18164.0337 & 0.2777 & 0.6707 & 0.6707 & 0.5073 \tabularnewline
118 & 9946.53 & 11120.4603 & 3900.6242 & 18340.2964 & 0.375 & 0.7175 & 0.7175 & 0.5071 \tabularnewline
119 & 10660.34 & 11120.2751 & 3728.2074 & 18512.3429 & 0.4515 & 0.6222 & 0.6222 & 0.5069 \tabularnewline
120 & 11133.07 & 11120.09 & 3559.7187 & 18680.4613 & 0.4987 & 0.5474 & 0.5474 & 0.5067 \tabularnewline
121 & 11358.38 & 11119.9048 & 3394.9014 & 18844.9083 & 0.4759 & 0.4987 & 0.4987 & 0.5066 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=315055&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[97])[/C][/ROW]
[ROW][C]96[/C][C]10605.96[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]97[/C][C]11055.12[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]98[/C][C]10406.87[/C][C]11124.1642[/C][C]9791.5767[/C][C]12456.7518[/C][C]0.1457[/C][C]0.5404[/C][C]0.5404[/C][C]0.5404[/C][/ROW]
[ROW][C]99[/C][C]10257.89[/C][C]11123.979[/C][C]9051.7584[/C][C]13196.1996[/C][C]0.2063[/C][C]0.7512[/C][C]0.7512[/C][C]0.526[/C][/ROW]
[ROW][C]100[/C][C]9281.56[/C][C]11123.7938[/C][C]8513.751[/C][C]13733.8365[/C][C]0.0833[/C][C]0.7422[/C][C]0.7422[/C][C]0.5206[/C][/ROW]
[ROW][C]101[/C][C]8842.3[/C][C]11123.6086[/C][C]8069.0277[/C][C]14178.1894[/C][C]0.0716[/C][C]0.8814[/C][C]0.8814[/C][C]0.5175[/C][/ROW]
[ROW][C]102[/C][C]8720.15[/C][C]11123.4233[/C][C]7681.2552[/C][C]14565.5915[/C][C]0.0856[/C][C]0.903[/C][C]0.903[/C][C]0.5155[/C][/ROW]
[ROW][C]103[/C][C]9195.92[/C][C]11123.2381[/C][C]7332.9222[/C][C]14913.554[/C][C]0.1595[/C][C]0.893[/C][C]0.893[/C][C]0.514[/C][/ROW]
[ROW][C]104[/C][C]9271.34[/C][C]11123.0529[/C][C]7013.9917[/C][C]15232.1141[/C][C]0.1885[/C][C]0.821[/C][C]0.821[/C][C]0.5129[/C][/ROW]
[ROW][C]105[/C][C]8950.93[/C][C]11122.8677[/C][C]6718.076[/C][C]15527.6594[/C][C]0.1669[/C][C]0.795[/C][C]0.795[/C][C]0.512[/C][/ROW]
[ROW][C]106[/C][C]10139.95[/C][C]11122.6825[/C][C]6440.812[/C][C]15804.553[/C][C]0.3404[/C][C]0.8184[/C][C]0.8184[/C][C]0.5113[/C][/ROW]
[ROW][C]107[/C][C]10682.15[/C][C]11122.4973[/C][C]6179.0623[/C][C]16065.9323[/C][C]0.4307[/C][C]0.6516[/C][C]0.6516[/C][C]0.5107[/C][/ROW]
[ROW][C]108[/C][C]11453.83[/C][C]11122.3121[/C][C]5930.4817[/C][C]16314.1426[/C][C]0.4502[/C][C]0.566[/C][C]0.566[/C][C]0.5101[/C][/ROW]
[ROW][C]109[/C][C]11439.97[/C][C]11122.1269[/C][C]5693.2621[/C][C]16550.9918[/C][C]0.4543[/C][C]0.4523[/C][C]0.4523[/C][C]0.5097[/C][/ROW]
[ROW][C]110[/C][C]10779.43[/C][C]11121.9417[/C][C]5465.975[/C][C]16777.9085[/C][C]0.4528[/C][C]0.4561[/C][C]0.4561[/C][C]0.5092[/C][/ROW]
[ROW][C]111[/C][C]10179.98[/C][C]11121.7565[/C][C]5247.4683[/C][C]16996.0448[/C][C]0.3767[/C][C]0.5455[/C][C]0.5455[/C][C]0.5089[/C][/ROW]
[ROW][C]112[/C][C]9317.86[/C][C]11121.5714[/C][C]5036.7968[/C][C]17206.3459[/C][C]0.2806[/C][C]0.6192[/C][C]0.6192[/C][C]0.5085[/C][/ROW]
[ROW][C]113[/C][C]9011[/C][C]11121.3862[/C][C]4833.1737[/C][C]17409.5987[/C][C]0.2553[/C][C]0.713[/C][C]0.713[/C][C]0.5082[/C][/ROW]
[ROW][C]114[/C][C]8840.39[/C][C]11121.201[/C][C]4635.9356[/C][C]17606.4664[/C][C]0.2453[/C][C]0.7382[/C][C]0.7382[/C][C]0.508[/C][/ROW]
[ROW][C]115[/C][C]9084.81[/C][C]11121.0158[/C][C]4444.5171[/C][C]17797.5145[/C][C]0.275[/C][C]0.7484[/C][C]0.7484[/C][C]0.5077[/C][/ROW]
[ROW][C]116[/C][C]9532.6[/C][C]11120.8306[/C][C]4258.4318[/C][C]17983.2295[/C][C]0.3251[/C][C]0.7196[/C][C]0.7196[/C][C]0.5075[/C][/ROW]
[ROW][C]117[/C][C]9001.07[/C][C]11120.6455[/C][C]4077.2572[/C][C]18164.0337[/C][C]0.2777[/C][C]0.6707[/C][C]0.6707[/C][C]0.5073[/C][/ROW]
[ROW][C]118[/C][C]9946.53[/C][C]11120.4603[/C][C]3900.6242[/C][C]18340.2964[/C][C]0.375[/C][C]0.7175[/C][C]0.7175[/C][C]0.5071[/C][/ROW]
[ROW][C]119[/C][C]10660.34[/C][C]11120.2751[/C][C]3728.2074[/C][C]18512.3429[/C][C]0.4515[/C][C]0.6222[/C][C]0.6222[/C][C]0.5069[/C][/ROW]
[ROW][C]120[/C][C]11133.07[/C][C]11120.09[/C][C]3559.7187[/C][C]18680.4613[/C][C]0.4987[/C][C]0.5474[/C][C]0.5474[/C][C]0.5067[/C][/ROW]
[ROW][C]121[/C][C]11358.38[/C][C]11119.9048[/C][C]3394.9014[/C][C]18844.9083[/C][C]0.4759[/C][C]0.4987[/C][C]0.4987[/C][C]0.5066[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=315055&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=315055&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[97])
9610605.96-------
9711055.12-------
9810406.8711124.16429791.576712456.75180.14570.54040.54040.5404
9910257.8911123.9799051.758413196.19960.20630.75120.75120.526
1009281.5611123.79388513.75113733.83650.08330.74220.74220.5206
1018842.311123.60868069.027714178.18940.07160.88140.88140.5175
1028720.1511123.42337681.255214565.59150.08560.9030.9030.5155
1039195.9211123.23817332.922214913.5540.15950.8930.8930.514
1049271.3411123.05297013.991715232.11410.18850.8210.8210.5129
1058950.9311122.86776718.07615527.65940.16690.7950.7950.512
10610139.9511122.68256440.81215804.5530.34040.81840.81840.5113
10710682.1511122.49736179.062316065.93230.43070.65160.65160.5107
10811453.8311122.31215930.481716314.14260.45020.5660.5660.5101
10911439.9711122.12695693.262116550.99180.45430.45230.45230.5097
11010779.4311121.94175465.97516777.90850.45280.45610.45610.5092
11110179.9811121.75655247.468316996.04480.37670.54550.54550.5089
1129317.8611121.57145036.796817206.34590.28060.61920.61920.5085
113901111121.38624833.173717409.59870.25530.7130.7130.5082
1148840.3911121.2014635.935617606.46640.24530.73820.73820.508
1159084.8111121.01584444.517117797.51450.2750.74840.74840.5077
1169532.611120.83064258.431817983.22950.32510.71960.71960.5075
1179001.0711120.64554077.257218164.03370.27770.67070.67070.5073
1189946.5311120.46033900.624218340.29640.3750.71750.71750.5071
11910660.3411120.27513728.207418512.34290.45150.62220.62220.5069
12011133.0711120.093559.718718680.46130.49870.54740.54740.5067
12111358.3811119.90483394.901418844.90830.47590.49870.49870.5066







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPEsMAPESq.EMSERMSEScaledEMASE
980.0611-0.06890.06890.0666514511.004600-1.46571.4657
990.095-0.08440.07670.0738750110.1547632310.5797795.1796-1.76981.6177
1000.1197-0.19850.11730.10943393825.28961552815.4831246.1202-3.76442.3333
1010.1401-0.2580.15250.13925204368.73712465703.79651570.256-4.66162.9154
1020.1579-0.27560.17710.15985775722.75673127707.58851768.5326-4.91093.3145
1030.1739-0.20960.18250.16483714555.17093225515.51891795.972-3.93833.4185
1040.1885-0.19970.1850.16723428840.73563254561.97841804.0405-3.78383.4706
1050.202-0.24260.19220.17334717313.42733437405.90961854.0242-4.43823.5916
1060.2148-0.09690.18160.1643965763.18413162778.94011778.4203-2.00813.4156
1070.2268-0.04120.16760.1519193905.75192865891.62121692.8945-0.89983.1641
1080.23820.02890.1550.1408109904.11082615347.30211617.20350.67742.938
1090.2490.02780.14440.1314101024.22582405820.37911551.07070.64952.7473
1100.2595-0.03180.13570.1237117314.28182229781.44851493.2453-0.69992.5898
1110.2695-0.09250.13260.1212886943.04532133864.41971460.7753-1.92442.5423
1120.2791-0.19360.13670.12493253374.64022208498.43441486.1018-3.68572.6185
1130.2885-0.23420.14280.13024453729.78482348825.39381532.5878-4.31242.7244
1140.2975-0.2580.14950.1365202098.77492516665.00451586.4-4.66062.8383
1150.3063-0.22410.15370.13964146134.11982607191.06641614.6799-4.16082.9117
1160.3148-0.16660.15440.14042522476.57182602732.40881613.2986-3.24542.9293
1170.3231-0.23550.15840.14394492600.1822697225.79751642.3233-4.33122.9994
1180.3312-0.1180.15650.14231378112.36212634410.8721623.0868-2.39882.9708
1190.3392-0.04310.15140.1378211540.33472524280.3931588.7984-0.93982.8785
1200.34690.00120.14480.1318168.48092414536.39681553.87790.02652.7545
1210.35440.0210.13970.127256870.40962316300.3141521.93970.48732.66

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & sMAPE & Sq.E & MSE & RMSE & ScaledE & MASE \tabularnewline
98 & 0.0611 & -0.0689 & 0.0689 & 0.0666 & 514511.0046 & 0 & 0 & -1.4657 & 1.4657 \tabularnewline
99 & 0.095 & -0.0844 & 0.0767 & 0.0738 & 750110.1547 & 632310.5797 & 795.1796 & -1.7698 & 1.6177 \tabularnewline
100 & 0.1197 & -0.1985 & 0.1173 & 0.1094 & 3393825.2896 & 1552815.483 & 1246.1202 & -3.7644 & 2.3333 \tabularnewline
101 & 0.1401 & -0.258 & 0.1525 & 0.1392 & 5204368.7371 & 2465703.7965 & 1570.256 & -4.6616 & 2.9154 \tabularnewline
102 & 0.1579 & -0.2756 & 0.1771 & 0.1598 & 5775722.7567 & 3127707.5885 & 1768.5326 & -4.9109 & 3.3145 \tabularnewline
103 & 0.1739 & -0.2096 & 0.1825 & 0.1648 & 3714555.1709 & 3225515.5189 & 1795.972 & -3.9383 & 3.4185 \tabularnewline
104 & 0.1885 & -0.1997 & 0.185 & 0.1672 & 3428840.7356 & 3254561.9784 & 1804.0405 & -3.7838 & 3.4706 \tabularnewline
105 & 0.202 & -0.2426 & 0.1922 & 0.1733 & 4717313.4273 & 3437405.9096 & 1854.0242 & -4.4382 & 3.5916 \tabularnewline
106 & 0.2148 & -0.0969 & 0.1816 & 0.1643 & 965763.1841 & 3162778.9401 & 1778.4203 & -2.0081 & 3.4156 \tabularnewline
107 & 0.2268 & -0.0412 & 0.1676 & 0.1519 & 193905.7519 & 2865891.6212 & 1692.8945 & -0.8998 & 3.1641 \tabularnewline
108 & 0.2382 & 0.0289 & 0.155 & 0.1408 & 109904.1108 & 2615347.3021 & 1617.2035 & 0.6774 & 2.938 \tabularnewline
109 & 0.249 & 0.0278 & 0.1444 & 0.1314 & 101024.2258 & 2405820.3791 & 1551.0707 & 0.6495 & 2.7473 \tabularnewline
110 & 0.2595 & -0.0318 & 0.1357 & 0.1237 & 117314.2818 & 2229781.4485 & 1493.2453 & -0.6999 & 2.5898 \tabularnewline
111 & 0.2695 & -0.0925 & 0.1326 & 0.1212 & 886943.0453 & 2133864.4197 & 1460.7753 & -1.9244 & 2.5423 \tabularnewline
112 & 0.2791 & -0.1936 & 0.1367 & 0.1249 & 3253374.6402 & 2208498.4344 & 1486.1018 & -3.6857 & 2.6185 \tabularnewline
113 & 0.2885 & -0.2342 & 0.1428 & 0.1302 & 4453729.7848 & 2348825.3938 & 1532.5878 & -4.3124 & 2.7244 \tabularnewline
114 & 0.2975 & -0.258 & 0.1495 & 0.136 & 5202098.7749 & 2516665.0045 & 1586.4 & -4.6606 & 2.8383 \tabularnewline
115 & 0.3063 & -0.2241 & 0.1537 & 0.1396 & 4146134.1198 & 2607191.0664 & 1614.6799 & -4.1608 & 2.9117 \tabularnewline
116 & 0.3148 & -0.1666 & 0.1544 & 0.1404 & 2522476.5718 & 2602732.4088 & 1613.2986 & -3.2454 & 2.9293 \tabularnewline
117 & 0.3231 & -0.2355 & 0.1584 & 0.1439 & 4492600.182 & 2697225.7975 & 1642.3233 & -4.3312 & 2.9994 \tabularnewline
118 & 0.3312 & -0.118 & 0.1565 & 0.1423 & 1378112.3621 & 2634410.872 & 1623.0868 & -2.3988 & 2.9708 \tabularnewline
119 & 0.3392 & -0.0431 & 0.1514 & 0.1378 & 211540.3347 & 2524280.393 & 1588.7984 & -0.9398 & 2.8785 \tabularnewline
120 & 0.3469 & 0.0012 & 0.1448 & 0.1318 & 168.4809 & 2414536.3968 & 1553.8779 & 0.0265 & 2.7545 \tabularnewline
121 & 0.3544 & 0.021 & 0.1397 & 0.1272 & 56870.4096 & 2316300.314 & 1521.9397 & 0.4873 & 2.66 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=315055&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]98[/C][C]0.0611[/C][C]-0.0689[/C][C]0.0689[/C][C]0.0666[/C][C]514511.0046[/C][C]0[/C][C]0[/C][C]-1.4657[/C][C]1.4657[/C][/ROW]
[ROW][C]99[/C][C]0.095[/C][C]-0.0844[/C][C]0.0767[/C][C]0.0738[/C][C]750110.1547[/C][C]632310.5797[/C][C]795.1796[/C][C]-1.7698[/C][C]1.6177[/C][/ROW]
[ROW][C]100[/C][C]0.1197[/C][C]-0.1985[/C][C]0.1173[/C][C]0.1094[/C][C]3393825.2896[/C][C]1552815.483[/C][C]1246.1202[/C][C]-3.7644[/C][C]2.3333[/C][/ROW]
[ROW][C]101[/C][C]0.1401[/C][C]-0.258[/C][C]0.1525[/C][C]0.1392[/C][C]5204368.7371[/C][C]2465703.7965[/C][C]1570.256[/C][C]-4.6616[/C][C]2.9154[/C][/ROW]
[ROW][C]102[/C][C]0.1579[/C][C]-0.2756[/C][C]0.1771[/C][C]0.1598[/C][C]5775722.7567[/C][C]3127707.5885[/C][C]1768.5326[/C][C]-4.9109[/C][C]3.3145[/C][/ROW]
[ROW][C]103[/C][C]0.1739[/C][C]-0.2096[/C][C]0.1825[/C][C]0.1648[/C][C]3714555.1709[/C][C]3225515.5189[/C][C]1795.972[/C][C]-3.9383[/C][C]3.4185[/C][/ROW]
[ROW][C]104[/C][C]0.1885[/C][C]-0.1997[/C][C]0.185[/C][C]0.1672[/C][C]3428840.7356[/C][C]3254561.9784[/C][C]1804.0405[/C][C]-3.7838[/C][C]3.4706[/C][/ROW]
[ROW][C]105[/C][C]0.202[/C][C]-0.2426[/C][C]0.1922[/C][C]0.1733[/C][C]4717313.4273[/C][C]3437405.9096[/C][C]1854.0242[/C][C]-4.4382[/C][C]3.5916[/C][/ROW]
[ROW][C]106[/C][C]0.2148[/C][C]-0.0969[/C][C]0.1816[/C][C]0.1643[/C][C]965763.1841[/C][C]3162778.9401[/C][C]1778.4203[/C][C]-2.0081[/C][C]3.4156[/C][/ROW]
[ROW][C]107[/C][C]0.2268[/C][C]-0.0412[/C][C]0.1676[/C][C]0.1519[/C][C]193905.7519[/C][C]2865891.6212[/C][C]1692.8945[/C][C]-0.8998[/C][C]3.1641[/C][/ROW]
[ROW][C]108[/C][C]0.2382[/C][C]0.0289[/C][C]0.155[/C][C]0.1408[/C][C]109904.1108[/C][C]2615347.3021[/C][C]1617.2035[/C][C]0.6774[/C][C]2.938[/C][/ROW]
[ROW][C]109[/C][C]0.249[/C][C]0.0278[/C][C]0.1444[/C][C]0.1314[/C][C]101024.2258[/C][C]2405820.3791[/C][C]1551.0707[/C][C]0.6495[/C][C]2.7473[/C][/ROW]
[ROW][C]110[/C][C]0.2595[/C][C]-0.0318[/C][C]0.1357[/C][C]0.1237[/C][C]117314.2818[/C][C]2229781.4485[/C][C]1493.2453[/C][C]-0.6999[/C][C]2.5898[/C][/ROW]
[ROW][C]111[/C][C]0.2695[/C][C]-0.0925[/C][C]0.1326[/C][C]0.1212[/C][C]886943.0453[/C][C]2133864.4197[/C][C]1460.7753[/C][C]-1.9244[/C][C]2.5423[/C][/ROW]
[ROW][C]112[/C][C]0.2791[/C][C]-0.1936[/C][C]0.1367[/C][C]0.1249[/C][C]3253374.6402[/C][C]2208498.4344[/C][C]1486.1018[/C][C]-3.6857[/C][C]2.6185[/C][/ROW]
[ROW][C]113[/C][C]0.2885[/C][C]-0.2342[/C][C]0.1428[/C][C]0.1302[/C][C]4453729.7848[/C][C]2348825.3938[/C][C]1532.5878[/C][C]-4.3124[/C][C]2.7244[/C][/ROW]
[ROW][C]114[/C][C]0.2975[/C][C]-0.258[/C][C]0.1495[/C][C]0.136[/C][C]5202098.7749[/C][C]2516665.0045[/C][C]1586.4[/C][C]-4.6606[/C][C]2.8383[/C][/ROW]
[ROW][C]115[/C][C]0.3063[/C][C]-0.2241[/C][C]0.1537[/C][C]0.1396[/C][C]4146134.1198[/C][C]2607191.0664[/C][C]1614.6799[/C][C]-4.1608[/C][C]2.9117[/C][/ROW]
[ROW][C]116[/C][C]0.3148[/C][C]-0.1666[/C][C]0.1544[/C][C]0.1404[/C][C]2522476.5718[/C][C]2602732.4088[/C][C]1613.2986[/C][C]-3.2454[/C][C]2.9293[/C][/ROW]
[ROW][C]117[/C][C]0.3231[/C][C]-0.2355[/C][C]0.1584[/C][C]0.1439[/C][C]4492600.182[/C][C]2697225.7975[/C][C]1642.3233[/C][C]-4.3312[/C][C]2.9994[/C][/ROW]
[ROW][C]118[/C][C]0.3312[/C][C]-0.118[/C][C]0.1565[/C][C]0.1423[/C][C]1378112.3621[/C][C]2634410.872[/C][C]1623.0868[/C][C]-2.3988[/C][C]2.9708[/C][/ROW]
[ROW][C]119[/C][C]0.3392[/C][C]-0.0431[/C][C]0.1514[/C][C]0.1378[/C][C]211540.3347[/C][C]2524280.393[/C][C]1588.7984[/C][C]-0.9398[/C][C]2.8785[/C][/ROW]
[ROW][C]120[/C][C]0.3469[/C][C]0.0012[/C][C]0.1448[/C][C]0.1318[/C][C]168.4809[/C][C]2414536.3968[/C][C]1553.8779[/C][C]0.0265[/C][C]2.7545[/C][/ROW]
[ROW][C]121[/C][C]0.3544[/C][C]0.021[/C][C]0.1397[/C][C]0.1272[/C][C]56870.4096[/C][C]2316300.314[/C][C]1521.9397[/C][C]0.4873[/C][C]2.66[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=315055&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=315055&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
980.0611-0.06890.06890.0666514511.004600-1.46571.4657
990.095-0.08440.07670.0738750110.1547632310.5797795.1796-1.76981.6177
1000.1197-0.19850.11730.10943393825.28961552815.4831246.1202-3.76442.3333
1010.1401-0.2580.15250.13925204368.73712465703.79651570.256-4.66162.9154
1020.1579-0.27560.17710.15985775722.75673127707.58851768.5326-4.91093.3145
1030.1739-0.20960.18250.16483714555.17093225515.51891795.972-3.93833.4185
1040.1885-0.19970.1850.16723428840.73563254561.97841804.0405-3.78383.4706
1050.202-0.24260.19220.17334717313.42733437405.90961854.0242-4.43823.5916
1060.2148-0.09690.18160.1643965763.18413162778.94011778.4203-2.00813.4156
1070.2268-0.04120.16760.1519193905.75192865891.62121692.8945-0.89983.1641
1080.23820.02890.1550.1408109904.11082615347.30211617.20350.67742.938
1090.2490.02780.14440.1314101024.22582405820.37911551.07070.64952.7473
1100.2595-0.03180.13570.1237117314.28182229781.44851493.2453-0.69992.5898
1110.2695-0.09250.13260.1212886943.04532133864.41971460.7753-1.92442.5423
1120.2791-0.19360.13670.12493253374.64022208498.43441486.1018-3.68572.6185
1130.2885-0.23420.14280.13024453729.78482348825.39381532.5878-4.31242.7244
1140.2975-0.2580.14950.1365202098.77492516665.00451586.4-4.66062.8383
1150.3063-0.22410.15370.13964146134.11982607191.06641614.6799-4.16082.9117
1160.3148-0.16660.15440.14042522476.57182602732.40881613.2986-3.24542.9293
1170.3231-0.23550.15840.14394492600.1822697225.79751642.3233-4.33122.9994
1180.3312-0.1180.15650.14231378112.36212634410.8721623.0868-2.39882.9708
1190.3392-0.04310.15140.1378211540.33472524280.3931588.7984-0.93982.8785
1200.34690.00120.14480.1318168.48092414536.39681553.87790.02652.7545
1210.35440.0210.13970.127256870.40962316300.3141521.93970.48732.66



Parameters (Session):
par1 = 24 ; par2 = 1 ; par3 = 0 ; par4 = 0 ; par5 = 1 ; par6 = 1 ; par7 = 1 ; par8 = 0 ; par9 = 0 ; par10 = FALSE ;
Parameters (R input):
par1 = 24 ; par2 = 1 ; par3 = 0 ; par4 = 0 ; par5 = 1 ; par6 = 1 ; par7 = 1 ; par8 = 0 ; par9 = 0 ; par10 = FALSE ;
R code (references can be found in the software module):
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*2
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,fx))
(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')