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 computationSun, 19 Dec 2010 15:30:52 +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/2010/Dec/19/t1292772545b8ymgem4zc3h7tc.htm/, Retrieved Sun, 05 May 2024 07:40:20 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=112502, Retrieved Sun, 05 May 2024 07:40:20 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact110
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [ARIMA Backward Selection] [Paper Box Jenkins...] [2010-12-19 13:23:08] [945bcebba5e7ac34a41d6888338a1ba9]
- RMP     [ARIMA Forecasting] [Paper Box Jenkins...] [2010-12-19 15:30:52] [514029464b0621595fe21c9fa38c7009] [Current]
Feedback Forum

Post a new message
Dataseries X:
36700
35600
80900
174000
169422
153452
173570
193036
174652
105367
95963
82896
121747
120196
103983
81103
70944
57248
47830
60095
60931
82955
99559
77911
70753
69287
88426
91756
96933
174484
232595
266197
290435
304296
322310
415555
490042
545109
545720
505944
477930
466106
424476
383018
364696
391116
435721
511435
553997
555252
544897
540562
505282
507626
474427
469740
491480
538974
576612




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' @ 72.249.76.132

\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' @ 72.249.76.132 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=112502&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' @ 72.249.76.132[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=112502&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=112502&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' @ 72.249.76.132







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[35])
34304296-------
35322310-------
36415555334738.5428278652.7006390824.3850.00240.6680.6680.668
37490042344827.498246220.5683443434.42770.00190.07990.07990.6728
38545109353936.467218345.6624489527.27160.00290.02460.02460.6762
39545720362634.9481194437.7759530832.12020.01640.01670.01670.6808
40505944371161.4874173596.049568726.92590.09060.04170.04170.686
41477930379616.0054155056.9551604175.05570.19540.13510.13510.6915
42466106388040.3556138252.7383637827.9730.27010.24030.24030.697
43424476396452.0695122776.1503670127.98870.42050.30890.30890.7023
44383018404858.4904108335.8075701381.17320.44260.44840.44840.7073
45364696413262.694194720.7578731804.63050.38250.57380.57380.7121
46391116421665.969281775.5139761556.42450.43010.62870.62870.7167
47435721430068.855369383.1501790754.56050.48770.58380.58380.7209
48511435438471.578457453.964819489.19280.35370.50560.50560.7249
49553997446874.233345917.8318847830.63480.30030.37620.37620.7287
50555252455276.859634718.987875834.73220.32060.32270.32270.7323
51544897463679.473923812.395903546.55290.35870.34160.34160.7356
52540562472082.083213161.1886931002.97790.3850.37790.37790.7388
53505282480484.69052734.8208958234.56010.45950.40270.40270.7418
54507626488887.2968-7492.291985266.88460.47050.47420.47420.7446
55474427497289.9028-17541.77661012121.58210.46530.48430.48430.7473
56469740505692.5086-27432.0791038817.09620.44740.54580.54580.7499
57491480514095.1143-37179.04481065369.27340.4680.56270.56270.7523
58538974522497.72-46796.3831091791.8230.47740.54250.54250.7547
59576612530900.3257-56296.02771118096.67920.43940.48930.48930.7569

\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[35]) \tabularnewline
34 & 304296 & - & - & - & - & - & - & - \tabularnewline
35 & 322310 & - & - & - & - & - & - & - \tabularnewline
36 & 415555 & 334738.5428 & 278652.7006 & 390824.385 & 0.0024 & 0.668 & 0.668 & 0.668 \tabularnewline
37 & 490042 & 344827.498 & 246220.5683 & 443434.4277 & 0.0019 & 0.0799 & 0.0799 & 0.6728 \tabularnewline
38 & 545109 & 353936.467 & 218345.6624 & 489527.2716 & 0.0029 & 0.0246 & 0.0246 & 0.6762 \tabularnewline
39 & 545720 & 362634.9481 & 194437.7759 & 530832.1202 & 0.0164 & 0.0167 & 0.0167 & 0.6808 \tabularnewline
40 & 505944 & 371161.4874 & 173596.049 & 568726.9259 & 0.0906 & 0.0417 & 0.0417 & 0.686 \tabularnewline
41 & 477930 & 379616.0054 & 155056.9551 & 604175.0557 & 0.1954 & 0.1351 & 0.1351 & 0.6915 \tabularnewline
42 & 466106 & 388040.3556 & 138252.7383 & 637827.973 & 0.2701 & 0.2403 & 0.2403 & 0.697 \tabularnewline
43 & 424476 & 396452.0695 & 122776.1503 & 670127.9887 & 0.4205 & 0.3089 & 0.3089 & 0.7023 \tabularnewline
44 & 383018 & 404858.4904 & 108335.8075 & 701381.1732 & 0.4426 & 0.4484 & 0.4484 & 0.7073 \tabularnewline
45 & 364696 & 413262.6941 & 94720.7578 & 731804.6305 & 0.3825 & 0.5738 & 0.5738 & 0.7121 \tabularnewline
46 & 391116 & 421665.9692 & 81775.5139 & 761556.4245 & 0.4301 & 0.6287 & 0.6287 & 0.7167 \tabularnewline
47 & 435721 & 430068.8553 & 69383.1501 & 790754.5605 & 0.4877 & 0.5838 & 0.5838 & 0.7209 \tabularnewline
48 & 511435 & 438471.5784 & 57453.964 & 819489.1928 & 0.3537 & 0.5056 & 0.5056 & 0.7249 \tabularnewline
49 & 553997 & 446874.2333 & 45917.8318 & 847830.6348 & 0.3003 & 0.3762 & 0.3762 & 0.7287 \tabularnewline
50 & 555252 & 455276.8596 & 34718.987 & 875834.7322 & 0.3206 & 0.3227 & 0.3227 & 0.7323 \tabularnewline
51 & 544897 & 463679.4739 & 23812.395 & 903546.5529 & 0.3587 & 0.3416 & 0.3416 & 0.7356 \tabularnewline
52 & 540562 & 472082.0832 & 13161.1886 & 931002.9779 & 0.385 & 0.3779 & 0.3779 & 0.7388 \tabularnewline
53 & 505282 & 480484.6905 & 2734.8208 & 958234.5601 & 0.4595 & 0.4027 & 0.4027 & 0.7418 \tabularnewline
54 & 507626 & 488887.2968 & -7492.291 & 985266.8846 & 0.4705 & 0.4742 & 0.4742 & 0.7446 \tabularnewline
55 & 474427 & 497289.9028 & -17541.7766 & 1012121.5821 & 0.4653 & 0.4843 & 0.4843 & 0.7473 \tabularnewline
56 & 469740 & 505692.5086 & -27432.079 & 1038817.0962 & 0.4474 & 0.5458 & 0.5458 & 0.7499 \tabularnewline
57 & 491480 & 514095.1143 & -37179.0448 & 1065369.2734 & 0.468 & 0.5627 & 0.5627 & 0.7523 \tabularnewline
58 & 538974 & 522497.72 & -46796.383 & 1091791.823 & 0.4774 & 0.5425 & 0.5425 & 0.7547 \tabularnewline
59 & 576612 & 530900.3257 & -56296.0277 & 1118096.6792 & 0.4394 & 0.4893 & 0.4893 & 0.7569 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=112502&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[35])[/C][/ROW]
[ROW][C]34[/C][C]304296[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]35[/C][C]322310[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]36[/C][C]415555[/C][C]334738.5428[/C][C]278652.7006[/C][C]390824.385[/C][C]0.0024[/C][C]0.668[/C][C]0.668[/C][C]0.668[/C][/ROW]
[ROW][C]37[/C][C]490042[/C][C]344827.498[/C][C]246220.5683[/C][C]443434.4277[/C][C]0.0019[/C][C]0.0799[/C][C]0.0799[/C][C]0.6728[/C][/ROW]
[ROW][C]38[/C][C]545109[/C][C]353936.467[/C][C]218345.6624[/C][C]489527.2716[/C][C]0.0029[/C][C]0.0246[/C][C]0.0246[/C][C]0.6762[/C][/ROW]
[ROW][C]39[/C][C]545720[/C][C]362634.9481[/C][C]194437.7759[/C][C]530832.1202[/C][C]0.0164[/C][C]0.0167[/C][C]0.0167[/C][C]0.6808[/C][/ROW]
[ROW][C]40[/C][C]505944[/C][C]371161.4874[/C][C]173596.049[/C][C]568726.9259[/C][C]0.0906[/C][C]0.0417[/C][C]0.0417[/C][C]0.686[/C][/ROW]
[ROW][C]41[/C][C]477930[/C][C]379616.0054[/C][C]155056.9551[/C][C]604175.0557[/C][C]0.1954[/C][C]0.1351[/C][C]0.1351[/C][C]0.6915[/C][/ROW]
[ROW][C]42[/C][C]466106[/C][C]388040.3556[/C][C]138252.7383[/C][C]637827.973[/C][C]0.2701[/C][C]0.2403[/C][C]0.2403[/C][C]0.697[/C][/ROW]
[ROW][C]43[/C][C]424476[/C][C]396452.0695[/C][C]122776.1503[/C][C]670127.9887[/C][C]0.4205[/C][C]0.3089[/C][C]0.3089[/C][C]0.7023[/C][/ROW]
[ROW][C]44[/C][C]383018[/C][C]404858.4904[/C][C]108335.8075[/C][C]701381.1732[/C][C]0.4426[/C][C]0.4484[/C][C]0.4484[/C][C]0.7073[/C][/ROW]
[ROW][C]45[/C][C]364696[/C][C]413262.6941[/C][C]94720.7578[/C][C]731804.6305[/C][C]0.3825[/C][C]0.5738[/C][C]0.5738[/C][C]0.7121[/C][/ROW]
[ROW][C]46[/C][C]391116[/C][C]421665.9692[/C][C]81775.5139[/C][C]761556.4245[/C][C]0.4301[/C][C]0.6287[/C][C]0.6287[/C][C]0.7167[/C][/ROW]
[ROW][C]47[/C][C]435721[/C][C]430068.8553[/C][C]69383.1501[/C][C]790754.5605[/C][C]0.4877[/C][C]0.5838[/C][C]0.5838[/C][C]0.7209[/C][/ROW]
[ROW][C]48[/C][C]511435[/C][C]438471.5784[/C][C]57453.964[/C][C]819489.1928[/C][C]0.3537[/C][C]0.5056[/C][C]0.5056[/C][C]0.7249[/C][/ROW]
[ROW][C]49[/C][C]553997[/C][C]446874.2333[/C][C]45917.8318[/C][C]847830.6348[/C][C]0.3003[/C][C]0.3762[/C][C]0.3762[/C][C]0.7287[/C][/ROW]
[ROW][C]50[/C][C]555252[/C][C]455276.8596[/C][C]34718.987[/C][C]875834.7322[/C][C]0.3206[/C][C]0.3227[/C][C]0.3227[/C][C]0.7323[/C][/ROW]
[ROW][C]51[/C][C]544897[/C][C]463679.4739[/C][C]23812.395[/C][C]903546.5529[/C][C]0.3587[/C][C]0.3416[/C][C]0.3416[/C][C]0.7356[/C][/ROW]
[ROW][C]52[/C][C]540562[/C][C]472082.0832[/C][C]13161.1886[/C][C]931002.9779[/C][C]0.385[/C][C]0.3779[/C][C]0.3779[/C][C]0.7388[/C][/ROW]
[ROW][C]53[/C][C]505282[/C][C]480484.6905[/C][C]2734.8208[/C][C]958234.5601[/C][C]0.4595[/C][C]0.4027[/C][C]0.4027[/C][C]0.7418[/C][/ROW]
[ROW][C]54[/C][C]507626[/C][C]488887.2968[/C][C]-7492.291[/C][C]985266.8846[/C][C]0.4705[/C][C]0.4742[/C][C]0.4742[/C][C]0.7446[/C][/ROW]
[ROW][C]55[/C][C]474427[/C][C]497289.9028[/C][C]-17541.7766[/C][C]1012121.5821[/C][C]0.4653[/C][C]0.4843[/C][C]0.4843[/C][C]0.7473[/C][/ROW]
[ROW][C]56[/C][C]469740[/C][C]505692.5086[/C][C]-27432.079[/C][C]1038817.0962[/C][C]0.4474[/C][C]0.5458[/C][C]0.5458[/C][C]0.7499[/C][/ROW]
[ROW][C]57[/C][C]491480[/C][C]514095.1143[/C][C]-37179.0448[/C][C]1065369.2734[/C][C]0.468[/C][C]0.5627[/C][C]0.5627[/C][C]0.7523[/C][/ROW]
[ROW][C]58[/C][C]538974[/C][C]522497.72[/C][C]-46796.383[/C][C]1091791.823[/C][C]0.4774[/C][C]0.5425[/C][C]0.5425[/C][C]0.7547[/C][/ROW]
[ROW][C]59[/C][C]576612[/C][C]530900.3257[/C][C]-56296.0277[/C][C]1118096.6792[/C][C]0.4394[/C][C]0.4893[/C][C]0.4893[/C][C]0.7569[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=112502&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=112502&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[35])
34304296-------
35322310-------
36415555334738.5428278652.7006390824.3850.00240.6680.6680.668
37490042344827.498246220.5683443434.42770.00190.07990.07990.6728
38545109353936.467218345.6624489527.27160.00290.02460.02460.6762
39545720362634.9481194437.7759530832.12020.01640.01670.01670.6808
40505944371161.4874173596.049568726.92590.09060.04170.04170.686
41477930379616.0054155056.9551604175.05570.19540.13510.13510.6915
42466106388040.3556138252.7383637827.9730.27010.24030.24030.697
43424476396452.0695122776.1503670127.98870.42050.30890.30890.7023
44383018404858.4904108335.8075701381.17320.44260.44840.44840.7073
45364696413262.694194720.7578731804.63050.38250.57380.57380.7121
46391116421665.969281775.5139761556.42450.43010.62870.62870.7167
47435721430068.855369383.1501790754.56050.48770.58380.58380.7209
48511435438471.578457453.964819489.19280.35370.50560.50560.7249
49553997446874.233345917.8318847830.63480.30030.37620.37620.7287
50555252455276.859634718.987875834.73220.32060.32270.32270.7323
51544897463679.473923812.395903546.55290.35870.34160.34160.7356
52540562472082.083213161.1886931002.97790.3850.37790.37790.7388
53505282480484.69052734.8208958234.56010.45950.40270.40270.7418
54507626488887.2968-7492.291985266.88460.47050.47420.47420.7446
55474427497289.9028-17541.77661012121.58210.46530.48430.48430.7473
56469740505692.5086-27432.0791038817.09620.44740.54580.54580.7499
57491480514095.1143-37179.04481065369.27340.4680.56270.56270.7523
58538974522497.72-46796.3831091791.8230.47740.54250.54250.7547
59576612530900.3257-56296.02771118096.67920.43940.48930.48930.7569







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPESq.EMSERMSE
360.08550.241406531299753.630300
370.14590.42110.331321087251602.30213809275677.9662117512.8745
380.19550.54010.400936546937362.965821388496239.6327146248.0641
390.23660.50490.426933520136244.327524421406240.8064156273.4982
400.27160.36310.414118166325692.641123170390131.1734152218.2319
410.30180.2590.38839665641535.152920919598698.5033144636.0906
420.32840.20120.36166094244828.187518801691002.7439137119.2583
430.35220.07070.3252785340679.885816549647212.3866128645.4321
440.3737-0.05390.2951477007019.227814763798302.0356121506.3714
450.3933-0.11750.27732358723777.275513523290849.5596116289.6851
460.4113-0.07250.2587933300617.631112378746283.0207111259.8143
470.42790.01310.238231946740.018211349846321.1038106535.6575
480.44340.16640.23275323660889.514610886293595.5969104337.4027
490.45780.23970.233211475287144.392710928364563.3681104538.8185
500.47130.21960.23239995028696.47510866142172.2419104240.7894
510.4840.17520.22876596286540.041710599276195.2293102952.7862
520.4960.14510.22384689498998.438510251642242.4769101250.3938
530.50730.05160.2142614906560.5039716268037.922898571.1319
540.5180.03830.205351138998.01999223366509.506996038.3596
550.5282-0.0460.197522712322.22598788333800.142893746.1135
560.5379-0.07110.1911292582871.71248431393279.741491822.6186
570.5471-0.0440.1843511443394.91778071395557.70489840.9459
580.55590.03150.1777271467802.02417732268263.978787933.3171
590.56430.08610.17392089557165.17217497155301.528586586.1149

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & Sq.E & MSE & RMSE \tabularnewline
36 & 0.0855 & 0.2414 & 0 & 6531299753.6303 & 0 & 0 \tabularnewline
37 & 0.1459 & 0.4211 & 0.3313 & 21087251602.302 & 13809275677.9662 & 117512.8745 \tabularnewline
38 & 0.1955 & 0.5401 & 0.4009 & 36546937362.9658 & 21388496239.6327 & 146248.0641 \tabularnewline
39 & 0.2366 & 0.5049 & 0.4269 & 33520136244.3275 & 24421406240.8064 & 156273.4982 \tabularnewline
40 & 0.2716 & 0.3631 & 0.4141 & 18166325692.6411 & 23170390131.1734 & 152218.2319 \tabularnewline
41 & 0.3018 & 0.259 & 0.3883 & 9665641535.1529 & 20919598698.5033 & 144636.0906 \tabularnewline
42 & 0.3284 & 0.2012 & 0.3616 & 6094244828.1875 & 18801691002.7439 & 137119.2583 \tabularnewline
43 & 0.3522 & 0.0707 & 0.3252 & 785340679.8858 & 16549647212.3866 & 128645.4321 \tabularnewline
44 & 0.3737 & -0.0539 & 0.2951 & 477007019.2278 & 14763798302.0356 & 121506.3714 \tabularnewline
45 & 0.3933 & -0.1175 & 0.2773 & 2358723777.2755 & 13523290849.5596 & 116289.6851 \tabularnewline
46 & 0.4113 & -0.0725 & 0.2587 & 933300617.6311 & 12378746283.0207 & 111259.8143 \tabularnewline
47 & 0.4279 & 0.0131 & 0.2382 & 31946740.0182 & 11349846321.1038 & 106535.6575 \tabularnewline
48 & 0.4434 & 0.1664 & 0.2327 & 5323660889.5146 & 10886293595.5969 & 104337.4027 \tabularnewline
49 & 0.4578 & 0.2397 & 0.2332 & 11475287144.3927 & 10928364563.3681 & 104538.8185 \tabularnewline
50 & 0.4713 & 0.2196 & 0.2323 & 9995028696.475 & 10866142172.2419 & 104240.7894 \tabularnewline
51 & 0.484 & 0.1752 & 0.2287 & 6596286540.0417 & 10599276195.2293 & 102952.7862 \tabularnewline
52 & 0.496 & 0.1451 & 0.2238 & 4689498998.4385 & 10251642242.4769 & 101250.3938 \tabularnewline
53 & 0.5073 & 0.0516 & 0.2142 & 614906560.503 & 9716268037.9228 & 98571.1319 \tabularnewline
54 & 0.518 & 0.0383 & 0.205 & 351138998.0199 & 9223366509.5069 & 96038.3596 \tabularnewline
55 & 0.5282 & -0.046 & 0.197 & 522712322.2259 & 8788333800.1428 & 93746.1135 \tabularnewline
56 & 0.5379 & -0.0711 & 0.191 & 1292582871.7124 & 8431393279.7414 & 91822.6186 \tabularnewline
57 & 0.5471 & -0.044 & 0.1843 & 511443394.9177 & 8071395557.704 & 89840.9459 \tabularnewline
58 & 0.5559 & 0.0315 & 0.1777 & 271467802.0241 & 7732268263.9787 & 87933.3171 \tabularnewline
59 & 0.5643 & 0.0861 & 0.1739 & 2089557165.1721 & 7497155301.5285 & 86586.1149 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=112502&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]Sq.E[/C][C]MSE[/C][C]RMSE[/C][/ROW]
[ROW][C]36[/C][C]0.0855[/C][C]0.2414[/C][C]0[/C][C]6531299753.6303[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]37[/C][C]0.1459[/C][C]0.4211[/C][C]0.3313[/C][C]21087251602.302[/C][C]13809275677.9662[/C][C]117512.8745[/C][/ROW]
[ROW][C]38[/C][C]0.1955[/C][C]0.5401[/C][C]0.4009[/C][C]36546937362.9658[/C][C]21388496239.6327[/C][C]146248.0641[/C][/ROW]
[ROW][C]39[/C][C]0.2366[/C][C]0.5049[/C][C]0.4269[/C][C]33520136244.3275[/C][C]24421406240.8064[/C][C]156273.4982[/C][/ROW]
[ROW][C]40[/C][C]0.2716[/C][C]0.3631[/C][C]0.4141[/C][C]18166325692.6411[/C][C]23170390131.1734[/C][C]152218.2319[/C][/ROW]
[ROW][C]41[/C][C]0.3018[/C][C]0.259[/C][C]0.3883[/C][C]9665641535.1529[/C][C]20919598698.5033[/C][C]144636.0906[/C][/ROW]
[ROW][C]42[/C][C]0.3284[/C][C]0.2012[/C][C]0.3616[/C][C]6094244828.1875[/C][C]18801691002.7439[/C][C]137119.2583[/C][/ROW]
[ROW][C]43[/C][C]0.3522[/C][C]0.0707[/C][C]0.3252[/C][C]785340679.8858[/C][C]16549647212.3866[/C][C]128645.4321[/C][/ROW]
[ROW][C]44[/C][C]0.3737[/C][C]-0.0539[/C][C]0.2951[/C][C]477007019.2278[/C][C]14763798302.0356[/C][C]121506.3714[/C][/ROW]
[ROW][C]45[/C][C]0.3933[/C][C]-0.1175[/C][C]0.2773[/C][C]2358723777.2755[/C][C]13523290849.5596[/C][C]116289.6851[/C][/ROW]
[ROW][C]46[/C][C]0.4113[/C][C]-0.0725[/C][C]0.2587[/C][C]933300617.6311[/C][C]12378746283.0207[/C][C]111259.8143[/C][/ROW]
[ROW][C]47[/C][C]0.4279[/C][C]0.0131[/C][C]0.2382[/C][C]31946740.0182[/C][C]11349846321.1038[/C][C]106535.6575[/C][/ROW]
[ROW][C]48[/C][C]0.4434[/C][C]0.1664[/C][C]0.2327[/C][C]5323660889.5146[/C][C]10886293595.5969[/C][C]104337.4027[/C][/ROW]
[ROW][C]49[/C][C]0.4578[/C][C]0.2397[/C][C]0.2332[/C][C]11475287144.3927[/C][C]10928364563.3681[/C][C]104538.8185[/C][/ROW]
[ROW][C]50[/C][C]0.4713[/C][C]0.2196[/C][C]0.2323[/C][C]9995028696.475[/C][C]10866142172.2419[/C][C]104240.7894[/C][/ROW]
[ROW][C]51[/C][C]0.484[/C][C]0.1752[/C][C]0.2287[/C][C]6596286540.0417[/C][C]10599276195.2293[/C][C]102952.7862[/C][/ROW]
[ROW][C]52[/C][C]0.496[/C][C]0.1451[/C][C]0.2238[/C][C]4689498998.4385[/C][C]10251642242.4769[/C][C]101250.3938[/C][/ROW]
[ROW][C]53[/C][C]0.5073[/C][C]0.0516[/C][C]0.2142[/C][C]614906560.503[/C][C]9716268037.9228[/C][C]98571.1319[/C][/ROW]
[ROW][C]54[/C][C]0.518[/C][C]0.0383[/C][C]0.205[/C][C]351138998.0199[/C][C]9223366509.5069[/C][C]96038.3596[/C][/ROW]
[ROW][C]55[/C][C]0.5282[/C][C]-0.046[/C][C]0.197[/C][C]522712322.2259[/C][C]8788333800.1428[/C][C]93746.1135[/C][/ROW]
[ROW][C]56[/C][C]0.5379[/C][C]-0.0711[/C][C]0.191[/C][C]1292582871.7124[/C][C]8431393279.7414[/C][C]91822.6186[/C][/ROW]
[ROW][C]57[/C][C]0.5471[/C][C]-0.044[/C][C]0.1843[/C][C]511443394.9177[/C][C]8071395557.704[/C][C]89840.9459[/C][/ROW]
[ROW][C]58[/C][C]0.5559[/C][C]0.0315[/C][C]0.1777[/C][C]271467802.0241[/C][C]7732268263.9787[/C][C]87933.3171[/C][/ROW]
[ROW][C]59[/C][C]0.5643[/C][C]0.0861[/C][C]0.1739[/C][C]2089557165.1721[/C][C]7497155301.5285[/C][C]86586.1149[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=112502&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=112502&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.PEMAPESq.EMSERMSE
360.08550.241406531299753.630300
370.14590.42110.331321087251602.30213809275677.9662117512.8745
380.19550.54010.400936546937362.965821388496239.6327146248.0641
390.23660.50490.426933520136244.327524421406240.8064156273.4982
400.27160.36310.414118166325692.641123170390131.1734152218.2319
410.30180.2590.38839665641535.152920919598698.5033144636.0906
420.32840.20120.36166094244828.187518801691002.7439137119.2583
430.35220.07070.3252785340679.885816549647212.3866128645.4321
440.3737-0.05390.2951477007019.227814763798302.0356121506.3714
450.3933-0.11750.27732358723777.275513523290849.5596116289.6851
460.4113-0.07250.2587933300617.631112378746283.0207111259.8143
470.42790.01310.238231946740.018211349846321.1038106535.6575
480.44340.16640.23275323660889.514610886293595.5969104337.4027
490.45780.23970.233211475287144.392710928364563.3681104538.8185
500.47130.21960.23239995028696.47510866142172.2419104240.7894
510.4840.17520.22876596286540.041710599276195.2293102952.7862
520.4960.14510.22384689498998.438510251642242.4769101250.3938
530.50730.05160.2142614906560.5039716268037.922898571.1319
540.5180.03830.205351138998.01999223366509.506996038.3596
550.5282-0.0460.197522712322.22598788333800.142893746.1135
560.5379-0.07110.1911292582871.71248431393279.741491822.6186
570.5471-0.0440.1843511443394.91778071395557.70489840.9459
580.55590.03150.1777271467802.02417732268263.978787933.3171
590.56430.08610.17392089557165.17217497155301.528586586.1149



Parameters (Session):
par1 = 24 ; par2 = 1 ; par3 = 2 ; par4 = 0 ; par5 = 1 ; par6 = 1 ; par7 = 0 ; par8 = 0 ; par9 = 1 ; par10 = FALSE ;
Parameters (R input):
par1 = 24 ; par2 = 1 ; par3 = 2 ; par4 = 0 ; par5 = 1 ; par6 = 1 ; par7 = 0 ; par8 = 0 ; par9 = 1 ; 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
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.mape <- array(0, dim=fx)
perf.mape1 <- 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)
for (i in 1:fx) {
locSD <- (ub[i] - forecast$pred[i]) / 1.96
perf.pe[i] = (x[nx+i] - forecast$pred[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.mse[1] = abs(perf.se[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.mse[i] = perf.mse[i-1] + perf.se[i]
perf.mse1[i] = perf.mse[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',7,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,'Sq.E',1,header=TRUE)
a<-table.element(a,'MSE',1,header=TRUE)
a<-table.element(a,'RMSE',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.se[i],4))
a<-table.element(a,round(perf.mse1[i],4))
a<-table.element(a,round(perf.rmse[i],4))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable1.tab')