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, 20 Dec 2009 05:47:44 -0700
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2009/Dec/20/t1261313396lvkb13xywx2r0jo.htm/, Retrieved Sat, 27 Apr 2024 05:36:22 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=69863, Retrieved Sat, 27 Apr 2024 05:36:22 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact101
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [ARIMA Forecasting] [] [2009-12-07 09:54:52] [b98453cac15ba1066b407e146608df68]
- R PD    [ARIMA Forecasting] [ARIMA Forecasting...] [2009-12-20 12:47:44] [fe2edc5b0acc9545190e03904e9be55e] [Current]
Feedback Forum

Post a new message
Dataseries X:
921365
987921
1132614
1332224
1418133
1411549
1695920
1636173
1539653
1395314
1127575
1036076
989236
1008380
1207763
1368839
1469798
1498721
1761769
1653214
1599104
1421179
1163995
1037735
1015407
1039210
1258049
1469445
1552346
1549144
1785895
1662335
1629440
1467430
1202209
1076982
1039367
1063449
1335135
1491602
1591972
1641248
1898849
1798580
1762444
1622044
1368955
1262973
1195650
1269530
1479279
1607819
1712466
1721766
1949843
1821326
1757802
1590367
1260647
1149235




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time1 seconds
R Server'Gwilym Jenkins' @ 72.249.127.135

\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 & 1 seconds \tabularnewline
R Server & 'Gwilym Jenkins' @ 72.249.127.135 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=69863&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]1 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Gwilym Jenkins' @ 72.249.127.135[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=69863&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=69863&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 time1 seconds
R Server'Gwilym Jenkins' @ 72.249.127.135







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[36])
241037735-------
251015407-------
261039210-------
271258049-------
281469445-------
291552346-------
301549144-------
311785895-------
321662335-------
331629440-------
341467430-------
351202209-------
361076982-------
3710393671052453.4334992260.75851112646.10840.3350.21220.88620.2122
3810634491076220.0205991096.12841161343.91250.38440.80190.80290.493
3913351351292853.6431188599.16641397108.11950.213310.74361
4014916021500008.30431379625.93531620390.67330.44560.99640.69061
4115919721584421.44321449830.08521719012.80110.45620.91180.67981
4216412481583838.55471436401.27131731275.8380.22270.45690.67771
4318988491823142.97771663892.63581982393.31960.17570.98740.67671
4417985801701337.70581531092.02961871583.38210.13150.01150.67331
4517624441666177.9151485605.18961846750.64040.1480.07530.6551
4616220441503000.37671312660.08141693340.67210.11010.00380.64291
4713689551238421.04641038790.52041438051.57240.11e-040.63890.9435
4812629731113383.0301904875.79811321890.26210.07980.00810.63390.6339
4911956501088854.4635850767.06381326941.86320.18970.07590.65810.5389
5012695301112621.0505848243.97841376998.12270.12240.26910.64230.6042
5114792791329254.67311040975.53291617533.81320.15390.65770.48410.9568
5216078191536409.33441226063.57711846755.09160.3260.64090.61140.9981
5317124661620822.47331289878.19491951766.75170.29360.53070.56780.9994
5417217661620239.58471269905.8271970573.34240.2850.30290.45320.9988
5519498431859544.00771490839.01972228248.99570.31560.7680.41721
5618213261737738.73591351535.42862123942.04320.33570.14090.37870.9996
5717578021702578.94511299636.49152105521.39870.39410.28180.38550.9988
5815903671539401.40681120387.98541958414.82820.40580.15350.34950.9847
5912606471274822.0765840331.71561709312.43740.47450.07730.33560.8139
6011492351149784.0602700349.41521599218.70510.4990.31440.31080.6246

\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[36]) \tabularnewline
24 & 1037735 & - & - & - & - & - & - & - \tabularnewline
25 & 1015407 & - & - & - & - & - & - & - \tabularnewline
26 & 1039210 & - & - & - & - & - & - & - \tabularnewline
27 & 1258049 & - & - & - & - & - & - & - \tabularnewline
28 & 1469445 & - & - & - & - & - & - & - \tabularnewline
29 & 1552346 & - & - & - & - & - & - & - \tabularnewline
30 & 1549144 & - & - & - & - & - & - & - \tabularnewline
31 & 1785895 & - & - & - & - & - & - & - \tabularnewline
32 & 1662335 & - & - & - & - & - & - & - \tabularnewline
33 & 1629440 & - & - & - & - & - & - & - \tabularnewline
34 & 1467430 & - & - & - & - & - & - & - \tabularnewline
35 & 1202209 & - & - & - & - & - & - & - \tabularnewline
36 & 1076982 & - & - & - & - & - & - & - \tabularnewline
37 & 1039367 & 1052453.4334 & 992260.7585 & 1112646.1084 & 0.335 & 0.2122 & 0.8862 & 0.2122 \tabularnewline
38 & 1063449 & 1076220.0205 & 991096.1284 & 1161343.9125 & 0.3844 & 0.8019 & 0.8029 & 0.493 \tabularnewline
39 & 1335135 & 1292853.643 & 1188599.1664 & 1397108.1195 & 0.2133 & 1 & 0.7436 & 1 \tabularnewline
40 & 1491602 & 1500008.3043 & 1379625.9353 & 1620390.6733 & 0.4456 & 0.9964 & 0.6906 & 1 \tabularnewline
41 & 1591972 & 1584421.4432 & 1449830.0852 & 1719012.8011 & 0.4562 & 0.9118 & 0.6798 & 1 \tabularnewline
42 & 1641248 & 1583838.5547 & 1436401.2713 & 1731275.838 & 0.2227 & 0.4569 & 0.6777 & 1 \tabularnewline
43 & 1898849 & 1823142.9777 & 1663892.6358 & 1982393.3196 & 0.1757 & 0.9874 & 0.6767 & 1 \tabularnewline
44 & 1798580 & 1701337.7058 & 1531092.0296 & 1871583.3821 & 0.1315 & 0.0115 & 0.6733 & 1 \tabularnewline
45 & 1762444 & 1666177.915 & 1485605.1896 & 1846750.6404 & 0.148 & 0.0753 & 0.655 & 1 \tabularnewline
46 & 1622044 & 1503000.3767 & 1312660.0814 & 1693340.6721 & 0.1101 & 0.0038 & 0.6429 & 1 \tabularnewline
47 & 1368955 & 1238421.0464 & 1038790.5204 & 1438051.5724 & 0.1 & 1e-04 & 0.6389 & 0.9435 \tabularnewline
48 & 1262973 & 1113383.0301 & 904875.7981 & 1321890.2621 & 0.0798 & 0.0081 & 0.6339 & 0.6339 \tabularnewline
49 & 1195650 & 1088854.4635 & 850767.0638 & 1326941.8632 & 0.1897 & 0.0759 & 0.6581 & 0.5389 \tabularnewline
50 & 1269530 & 1112621.0505 & 848243.9784 & 1376998.1227 & 0.1224 & 0.2691 & 0.6423 & 0.6042 \tabularnewline
51 & 1479279 & 1329254.6731 & 1040975.5329 & 1617533.8132 & 0.1539 & 0.6577 & 0.4841 & 0.9568 \tabularnewline
52 & 1607819 & 1536409.3344 & 1226063.5771 & 1846755.0916 & 0.326 & 0.6409 & 0.6114 & 0.9981 \tabularnewline
53 & 1712466 & 1620822.4733 & 1289878.1949 & 1951766.7517 & 0.2936 & 0.5307 & 0.5678 & 0.9994 \tabularnewline
54 & 1721766 & 1620239.5847 & 1269905.827 & 1970573.3424 & 0.285 & 0.3029 & 0.4532 & 0.9988 \tabularnewline
55 & 1949843 & 1859544.0077 & 1490839.0197 & 2228248.9957 & 0.3156 & 0.768 & 0.4172 & 1 \tabularnewline
56 & 1821326 & 1737738.7359 & 1351535.4286 & 2123942.0432 & 0.3357 & 0.1409 & 0.3787 & 0.9996 \tabularnewline
57 & 1757802 & 1702578.9451 & 1299636.4915 & 2105521.3987 & 0.3941 & 0.2818 & 0.3855 & 0.9988 \tabularnewline
58 & 1590367 & 1539401.4068 & 1120387.9854 & 1958414.8282 & 0.4058 & 0.1535 & 0.3495 & 0.9847 \tabularnewline
59 & 1260647 & 1274822.0765 & 840331.7156 & 1709312.4374 & 0.4745 & 0.0773 & 0.3356 & 0.8139 \tabularnewline
60 & 1149235 & 1149784.0602 & 700349.4152 & 1599218.7051 & 0.499 & 0.3144 & 0.3108 & 0.6246 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=69863&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[36])[/C][/ROW]
[ROW][C]24[/C][C]1037735[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]25[/C][C]1015407[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]26[/C][C]1039210[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]27[/C][C]1258049[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]28[/C][C]1469445[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]29[/C][C]1552346[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]30[/C][C]1549144[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]31[/C][C]1785895[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]32[/C][C]1662335[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]33[/C][C]1629440[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]34[/C][C]1467430[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]35[/C][C]1202209[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]36[/C][C]1076982[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]37[/C][C]1039367[/C][C]1052453.4334[/C][C]992260.7585[/C][C]1112646.1084[/C][C]0.335[/C][C]0.2122[/C][C]0.8862[/C][C]0.2122[/C][/ROW]
[ROW][C]38[/C][C]1063449[/C][C]1076220.0205[/C][C]991096.1284[/C][C]1161343.9125[/C][C]0.3844[/C][C]0.8019[/C][C]0.8029[/C][C]0.493[/C][/ROW]
[ROW][C]39[/C][C]1335135[/C][C]1292853.643[/C][C]1188599.1664[/C][C]1397108.1195[/C][C]0.2133[/C][C]1[/C][C]0.7436[/C][C]1[/C][/ROW]
[ROW][C]40[/C][C]1491602[/C][C]1500008.3043[/C][C]1379625.9353[/C][C]1620390.6733[/C][C]0.4456[/C][C]0.9964[/C][C]0.6906[/C][C]1[/C][/ROW]
[ROW][C]41[/C][C]1591972[/C][C]1584421.4432[/C][C]1449830.0852[/C][C]1719012.8011[/C][C]0.4562[/C][C]0.9118[/C][C]0.6798[/C][C]1[/C][/ROW]
[ROW][C]42[/C][C]1641248[/C][C]1583838.5547[/C][C]1436401.2713[/C][C]1731275.838[/C][C]0.2227[/C][C]0.4569[/C][C]0.6777[/C][C]1[/C][/ROW]
[ROW][C]43[/C][C]1898849[/C][C]1823142.9777[/C][C]1663892.6358[/C][C]1982393.3196[/C][C]0.1757[/C][C]0.9874[/C][C]0.6767[/C][C]1[/C][/ROW]
[ROW][C]44[/C][C]1798580[/C][C]1701337.7058[/C][C]1531092.0296[/C][C]1871583.3821[/C][C]0.1315[/C][C]0.0115[/C][C]0.6733[/C][C]1[/C][/ROW]
[ROW][C]45[/C][C]1762444[/C][C]1666177.915[/C][C]1485605.1896[/C][C]1846750.6404[/C][C]0.148[/C][C]0.0753[/C][C]0.655[/C][C]1[/C][/ROW]
[ROW][C]46[/C][C]1622044[/C][C]1503000.3767[/C][C]1312660.0814[/C][C]1693340.6721[/C][C]0.1101[/C][C]0.0038[/C][C]0.6429[/C][C]1[/C][/ROW]
[ROW][C]47[/C][C]1368955[/C][C]1238421.0464[/C][C]1038790.5204[/C][C]1438051.5724[/C][C]0.1[/C][C]1e-04[/C][C]0.6389[/C][C]0.9435[/C][/ROW]
[ROW][C]48[/C][C]1262973[/C][C]1113383.0301[/C][C]904875.7981[/C][C]1321890.2621[/C][C]0.0798[/C][C]0.0081[/C][C]0.6339[/C][C]0.6339[/C][/ROW]
[ROW][C]49[/C][C]1195650[/C][C]1088854.4635[/C][C]850767.0638[/C][C]1326941.8632[/C][C]0.1897[/C][C]0.0759[/C][C]0.6581[/C][C]0.5389[/C][/ROW]
[ROW][C]50[/C][C]1269530[/C][C]1112621.0505[/C][C]848243.9784[/C][C]1376998.1227[/C][C]0.1224[/C][C]0.2691[/C][C]0.6423[/C][C]0.6042[/C][/ROW]
[ROW][C]51[/C][C]1479279[/C][C]1329254.6731[/C][C]1040975.5329[/C][C]1617533.8132[/C][C]0.1539[/C][C]0.6577[/C][C]0.4841[/C][C]0.9568[/C][/ROW]
[ROW][C]52[/C][C]1607819[/C][C]1536409.3344[/C][C]1226063.5771[/C][C]1846755.0916[/C][C]0.326[/C][C]0.6409[/C][C]0.6114[/C][C]0.9981[/C][/ROW]
[ROW][C]53[/C][C]1712466[/C][C]1620822.4733[/C][C]1289878.1949[/C][C]1951766.7517[/C][C]0.2936[/C][C]0.5307[/C][C]0.5678[/C][C]0.9994[/C][/ROW]
[ROW][C]54[/C][C]1721766[/C][C]1620239.5847[/C][C]1269905.827[/C][C]1970573.3424[/C][C]0.285[/C][C]0.3029[/C][C]0.4532[/C][C]0.9988[/C][/ROW]
[ROW][C]55[/C][C]1949843[/C][C]1859544.0077[/C][C]1490839.0197[/C][C]2228248.9957[/C][C]0.3156[/C][C]0.768[/C][C]0.4172[/C][C]1[/C][/ROW]
[ROW][C]56[/C][C]1821326[/C][C]1737738.7359[/C][C]1351535.4286[/C][C]2123942.0432[/C][C]0.3357[/C][C]0.1409[/C][C]0.3787[/C][C]0.9996[/C][/ROW]
[ROW][C]57[/C][C]1757802[/C][C]1702578.9451[/C][C]1299636.4915[/C][C]2105521.3987[/C][C]0.3941[/C][C]0.2818[/C][C]0.3855[/C][C]0.9988[/C][/ROW]
[ROW][C]58[/C][C]1590367[/C][C]1539401.4068[/C][C]1120387.9854[/C][C]1958414.8282[/C][C]0.4058[/C][C]0.1535[/C][C]0.3495[/C][C]0.9847[/C][/ROW]
[ROW][C]59[/C][C]1260647[/C][C]1274822.0765[/C][C]840331.7156[/C][C]1709312.4374[/C][C]0.4745[/C][C]0.0773[/C][C]0.3356[/C][C]0.8139[/C][/ROW]
[ROW][C]60[/C][C]1149235[/C][C]1149784.0602[/C][C]700349.4152[/C][C]1599218.7051[/C][C]0.499[/C][C]0.3144[/C][C]0.3108[/C][C]0.6246[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=69863&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=69863&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[36])
241037735-------
251015407-------
261039210-------
271258049-------
281469445-------
291552346-------
301549144-------
311785895-------
321662335-------
331629440-------
341467430-------
351202209-------
361076982-------
3710393671052453.4334992260.75851112646.10840.3350.21220.88620.2122
3810634491076220.0205991096.12841161343.91250.38440.80190.80290.493
3913351351292853.6431188599.16641397108.11950.213310.74361
4014916021500008.30431379625.93531620390.67330.44560.99640.69061
4115919721584421.44321449830.08521719012.80110.45620.91180.67981
4216412481583838.55471436401.27131731275.8380.22270.45690.67771
4318988491823142.97771663892.63581982393.31960.17570.98740.67671
4417985801701337.70581531092.02961871583.38210.13150.01150.67331
4517624441666177.9151485605.18961846750.64040.1480.07530.6551
4616220441503000.37671312660.08141693340.67210.11010.00380.64291
4713689551238421.04641038790.52041438051.57240.11e-040.63890.9435
4812629731113383.0301904875.79811321890.26210.07980.00810.63390.6339
4911956501088854.4635850767.06381326941.86320.18970.07590.65810.5389
5012695301112621.0505848243.97841376998.12270.12240.26910.64230.6042
5114792791329254.67311040975.53291617533.81320.15390.65770.48410.9568
5216078191536409.33441226063.57711846755.09160.3260.64090.61140.9981
5317124661620822.47331289878.19491951766.75170.29360.53070.56780.9994
5417217661620239.58471269905.8271970573.34240.2850.30290.45320.9988
5519498431859544.00771490839.01972228248.99570.31560.7680.41721
5618213261737738.73591351535.42862123942.04320.33570.14090.37870.9996
5717578021702578.94511299636.49152105521.39870.39410.28180.38550.9988
5815903671539401.40681120387.98541958414.82820.40580.15350.34950.9847
5912606471274822.0765840331.71561709312.43740.47450.07730.33560.8139
6011492351149784.0602700349.41521599218.70510.4990.31440.31080.6246







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPESq.EMSERMSE
370.0292-0.01240171254740.381500
380.0404-0.01190.0122163098963.4416167176851.911512929.6888
390.04110.03270.0191787713151.5693707355618.464126596.158
400.0409-0.00560.015770665952.0001548183201.848123413.3125
410.04330.00480.013557010908.2689449948743.132321211.9953
420.04750.03620.01733295844414.5629924264688.370730401.7218
430.04460.04150.02075731401819.32911610998564.221940137.2466
440.05110.05720.02539456063774.28262591631715.479550908.0712
450.05530.05780.02899267159118.51483333356982.483457735.2317
460.06460.07920.033914171384239.04194417159708.139366461.7161
470.08220.10540.040417039113040.32975564610011.065774596.3137
480.09550.13440.048322377159100.57566965655768.524883460.5042
490.11160.09810.052111405286610.33837307165833.279785481.962
500.12120.1410.058424620418422.36618543826732.500292432.8228
510.11060.11290.062122507298674.12269474724861.941797338.1984
520.10310.04650.06115099340343.78199201263329.556795923.2158
530.10420.05650.06088398535993.0099154044074.465695676.7687
540.11030.06270.060910307612996.04389218131236.775596011.0995
550.10120.04860.06038153908004.05239162119487.684995718.961
560.11340.04810.05976986830717.00169053355049.150795149.1201
570.12070.03240.05843049585793.10788767461275.053493634.7226
580.13890.03310.05722597491688.23238487008112.016192124.9592
590.1739-0.01110.0552200932793.45248126743967.730790148.4552
600.1994-5e-040.0529301467.067788142196.869488250.4515

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & Sq.E & MSE & RMSE \tabularnewline
37 & 0.0292 & -0.0124 & 0 & 171254740.3815 & 0 & 0 \tabularnewline
38 & 0.0404 & -0.0119 & 0.0122 & 163098963.4416 & 167176851.9115 & 12929.6888 \tabularnewline
39 & 0.0411 & 0.0327 & 0.019 & 1787713151.5693 & 707355618.4641 & 26596.158 \tabularnewline
40 & 0.0409 & -0.0056 & 0.0157 & 70665952.0001 & 548183201.8481 & 23413.3125 \tabularnewline
41 & 0.0433 & 0.0048 & 0.0135 & 57010908.2689 & 449948743.1323 & 21211.9953 \tabularnewline
42 & 0.0475 & 0.0362 & 0.0173 & 3295844414.5629 & 924264688.3707 & 30401.7218 \tabularnewline
43 & 0.0446 & 0.0415 & 0.0207 & 5731401819.3291 & 1610998564.2219 & 40137.2466 \tabularnewline
44 & 0.0511 & 0.0572 & 0.0253 & 9456063774.2826 & 2591631715.4795 & 50908.0712 \tabularnewline
45 & 0.0553 & 0.0578 & 0.0289 & 9267159118.5148 & 3333356982.4834 & 57735.2317 \tabularnewline
46 & 0.0646 & 0.0792 & 0.0339 & 14171384239.0419 & 4417159708.1393 & 66461.7161 \tabularnewline
47 & 0.0822 & 0.1054 & 0.0404 & 17039113040.3297 & 5564610011.0657 & 74596.3137 \tabularnewline
48 & 0.0955 & 0.1344 & 0.0483 & 22377159100.5756 & 6965655768.5248 & 83460.5042 \tabularnewline
49 & 0.1116 & 0.0981 & 0.0521 & 11405286610.3383 & 7307165833.2797 & 85481.962 \tabularnewline
50 & 0.1212 & 0.141 & 0.0584 & 24620418422.3661 & 8543826732.5002 & 92432.8228 \tabularnewline
51 & 0.1106 & 0.1129 & 0.0621 & 22507298674.1226 & 9474724861.9417 & 97338.1984 \tabularnewline
52 & 0.1031 & 0.0465 & 0.0611 & 5099340343.7819 & 9201263329.5567 & 95923.2158 \tabularnewline
53 & 0.1042 & 0.0565 & 0.0608 & 8398535993.009 & 9154044074.4656 & 95676.7687 \tabularnewline
54 & 0.1103 & 0.0627 & 0.0609 & 10307612996.0438 & 9218131236.7755 & 96011.0995 \tabularnewline
55 & 0.1012 & 0.0486 & 0.0603 & 8153908004.0523 & 9162119487.6849 & 95718.961 \tabularnewline
56 & 0.1134 & 0.0481 & 0.0597 & 6986830717.0016 & 9053355049.1507 & 95149.1201 \tabularnewline
57 & 0.1207 & 0.0324 & 0.0584 & 3049585793.1078 & 8767461275.0534 & 93634.7226 \tabularnewline
58 & 0.1389 & 0.0331 & 0.0572 & 2597491688.2323 & 8487008112.0161 & 92124.9592 \tabularnewline
59 & 0.1739 & -0.0111 & 0.0552 & 200932793.4524 & 8126743967.7307 & 90148.4552 \tabularnewline
60 & 0.1994 & -5e-04 & 0.0529 & 301467.06 & 7788142196.8694 & 88250.4515 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=69863&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]37[/C][C]0.0292[/C][C]-0.0124[/C][C]0[/C][C]171254740.3815[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]38[/C][C]0.0404[/C][C]-0.0119[/C][C]0.0122[/C][C]163098963.4416[/C][C]167176851.9115[/C][C]12929.6888[/C][/ROW]
[ROW][C]39[/C][C]0.0411[/C][C]0.0327[/C][C]0.019[/C][C]1787713151.5693[/C][C]707355618.4641[/C][C]26596.158[/C][/ROW]
[ROW][C]40[/C][C]0.0409[/C][C]-0.0056[/C][C]0.0157[/C][C]70665952.0001[/C][C]548183201.8481[/C][C]23413.3125[/C][/ROW]
[ROW][C]41[/C][C]0.0433[/C][C]0.0048[/C][C]0.0135[/C][C]57010908.2689[/C][C]449948743.1323[/C][C]21211.9953[/C][/ROW]
[ROW][C]42[/C][C]0.0475[/C][C]0.0362[/C][C]0.0173[/C][C]3295844414.5629[/C][C]924264688.3707[/C][C]30401.7218[/C][/ROW]
[ROW][C]43[/C][C]0.0446[/C][C]0.0415[/C][C]0.0207[/C][C]5731401819.3291[/C][C]1610998564.2219[/C][C]40137.2466[/C][/ROW]
[ROW][C]44[/C][C]0.0511[/C][C]0.0572[/C][C]0.0253[/C][C]9456063774.2826[/C][C]2591631715.4795[/C][C]50908.0712[/C][/ROW]
[ROW][C]45[/C][C]0.0553[/C][C]0.0578[/C][C]0.0289[/C][C]9267159118.5148[/C][C]3333356982.4834[/C][C]57735.2317[/C][/ROW]
[ROW][C]46[/C][C]0.0646[/C][C]0.0792[/C][C]0.0339[/C][C]14171384239.0419[/C][C]4417159708.1393[/C][C]66461.7161[/C][/ROW]
[ROW][C]47[/C][C]0.0822[/C][C]0.1054[/C][C]0.0404[/C][C]17039113040.3297[/C][C]5564610011.0657[/C][C]74596.3137[/C][/ROW]
[ROW][C]48[/C][C]0.0955[/C][C]0.1344[/C][C]0.0483[/C][C]22377159100.5756[/C][C]6965655768.5248[/C][C]83460.5042[/C][/ROW]
[ROW][C]49[/C][C]0.1116[/C][C]0.0981[/C][C]0.0521[/C][C]11405286610.3383[/C][C]7307165833.2797[/C][C]85481.962[/C][/ROW]
[ROW][C]50[/C][C]0.1212[/C][C]0.141[/C][C]0.0584[/C][C]24620418422.3661[/C][C]8543826732.5002[/C][C]92432.8228[/C][/ROW]
[ROW][C]51[/C][C]0.1106[/C][C]0.1129[/C][C]0.0621[/C][C]22507298674.1226[/C][C]9474724861.9417[/C][C]97338.1984[/C][/ROW]
[ROW][C]52[/C][C]0.1031[/C][C]0.0465[/C][C]0.0611[/C][C]5099340343.7819[/C][C]9201263329.5567[/C][C]95923.2158[/C][/ROW]
[ROW][C]53[/C][C]0.1042[/C][C]0.0565[/C][C]0.0608[/C][C]8398535993.009[/C][C]9154044074.4656[/C][C]95676.7687[/C][/ROW]
[ROW][C]54[/C][C]0.1103[/C][C]0.0627[/C][C]0.0609[/C][C]10307612996.0438[/C][C]9218131236.7755[/C][C]96011.0995[/C][/ROW]
[ROW][C]55[/C][C]0.1012[/C][C]0.0486[/C][C]0.0603[/C][C]8153908004.0523[/C][C]9162119487.6849[/C][C]95718.961[/C][/ROW]
[ROW][C]56[/C][C]0.1134[/C][C]0.0481[/C][C]0.0597[/C][C]6986830717.0016[/C][C]9053355049.1507[/C][C]95149.1201[/C][/ROW]
[ROW][C]57[/C][C]0.1207[/C][C]0.0324[/C][C]0.0584[/C][C]3049585793.1078[/C][C]8767461275.0534[/C][C]93634.7226[/C][/ROW]
[ROW][C]58[/C][C]0.1389[/C][C]0.0331[/C][C]0.0572[/C][C]2597491688.2323[/C][C]8487008112.0161[/C][C]92124.9592[/C][/ROW]
[ROW][C]59[/C][C]0.1739[/C][C]-0.0111[/C][C]0.0552[/C][C]200932793.4524[/C][C]8126743967.7307[/C][C]90148.4552[/C][/ROW]
[ROW][C]60[/C][C]0.1994[/C][C]-5e-04[/C][C]0.0529[/C][C]301467.06[/C][C]7788142196.8694[/C][C]88250.4515[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=69863&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=69863&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
370.0292-0.01240171254740.381500
380.0404-0.01190.0122163098963.4416167176851.911512929.6888
390.04110.03270.0191787713151.5693707355618.464126596.158
400.0409-0.00560.015770665952.0001548183201.848123413.3125
410.04330.00480.013557010908.2689449948743.132321211.9953
420.04750.03620.01733295844414.5629924264688.370730401.7218
430.04460.04150.02075731401819.32911610998564.221940137.2466
440.05110.05720.02539456063774.28262591631715.479550908.0712
450.05530.05780.02899267159118.51483333356982.483457735.2317
460.06460.07920.033914171384239.04194417159708.139366461.7161
470.08220.10540.040417039113040.32975564610011.065774596.3137
480.09550.13440.048322377159100.57566965655768.524883460.5042
490.11160.09810.052111405286610.33837307165833.279785481.962
500.12120.1410.058424620418422.36618543826732.500292432.8228
510.11060.11290.062122507298674.12269474724861.941797338.1984
520.10310.04650.06115099340343.78199201263329.556795923.2158
530.10420.05650.06088398535993.0099154044074.465695676.7687
540.11030.06270.060910307612996.04389218131236.775596011.0995
550.10120.04860.06038153908004.05239162119487.684995718.961
560.11340.04810.05976986830717.00169053355049.150795149.1201
570.12070.03240.05843049585793.10788767461275.053493634.7226
580.13890.03310.05722597491688.23238487008112.016192124.9592
590.1739-0.01110.0552200932793.45248126743967.730790148.4552
600.1994-5e-040.0529301467.067788142196.869488250.4515



Parameters (Session):
par1 = FALSE ; par2 = 0.5 ; par3 = 1 ; par4 = 1 ; par5 = 12 ; par6 = 3 ; par7 = 1 ; par8 = 2 ; par9 = 1 ;
Parameters (R input):
par1 = 24 ; par2 = 1 ; par3 = 1 ; par4 = 1 ; par5 = 12 ; par6 = 0 ; 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')