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 computationFri, 11 Dec 2009 08:59:42 -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/11/t1260547223w20u0ito6ate2ku.htm/, Retrieved Mon, 29 Apr 2024 02:44:57 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=66433, Retrieved Mon, 29 Apr 2024 02:44:57 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact122
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [ARIMA Forecasting] [Paper - Arima For...] [2008-12-14 14:14:00] [7a664918911e34206ce9d0436dd7c1c8]
-   P   [ARIMA Forecasting] [ARIMA forecasting...] [2008-12-15 14:52:51] [12d343c4448a5f9e527bb31caeac580b]
-  MPD      [ARIMA Forecasting] [paper: 10 Forecast] [2009-12-11 15:59:42] [b090d569c0a4c77894e0b029f4429f19] [Current]
Feedback Forum

Post a new message
Dataseries X:
14929387.5
14717825.3
15826281.2
16301309.6
15033016.9
16998460.6
14066462.7
13328937.3
17319718.2
17586426.8
15887037.4
17935679.1
15869489
15892510.9
17556558.1
16791643
15953688.5
18144913.6
14390881
13885708.7
17332571.5
17152595.8
16003877.1
16841467.1
14783398.1
14667847.5
17714362.2
16282088
15014866.2
17722582.4
13876509.4
15495489.6
17799521.1
17920079.1
17248022.4
18813782.4
16249688.3
17823358.5
20424438.3
17814218.7
19699959.6
19776328.1
15679833.1
17119266.5
20092613
20863688.3
20925203.1
21032593
20664684.3
19711511.4
22553293.4
19498332.9
20722827.8
21321275
17960847.7
17789654.9
20003708.5
21169851.7
20422839.4
19810562.3




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time2 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 & 2 seconds \tabularnewline
R Server & 'Gwilym Jenkins' @ 72.249.127.135 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=66433&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]'Gwilym Jenkins' @ 72.249.127.135[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=66433&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=66433&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'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[39])
2717714362.2-------
2816282088-------
2915014866.2-------
3017722582.4-------
3113876509.4-------
3215495489.6-------
3317799521.1-------
3417920079.1-------
3517248022.4-------
3618813782.4-------
3716249688.3-------
3817823358.5-------
3920424438.3-------
4017814218.719048152.846117586698.414120509607.27820.0490.03250.99990.0325
4119699959.617828351.896616164719.295719491984.49750.01370.50660.99950.0011
4219776328.120491638.60318559289.195722423988.01020.23410.7890.99750.5272
4315679833.116667530.852314501307.642618833754.0620.18570.00250.99423e-04
4417119266.518276819.086615913259.042720640379.13050.16860.98440.98950.0375
452009261320583012.395918028169.636123137855.15570.35340.99610.98360.5484
4620863688.320704042.350617975088.001823432996.69950.45440.66970.97720.5796
4720925203.120030633.274717137068.598922924197.95050.27230.28630.97030.3948
482103259321595816.891318546500.311224645133.47150.35870.66680.96310.7743
4920664684.319032263.686415834951.1822229576.19280.15850.11010.9560.1967
5019711511.420603773.20417264900.622923942645.7850.30020.48570.94870.5419
5122553293.423205438.093719730816.200926680059.98650.35650.97560.94160.9416
5219498332.921829069.404617593983.795226064155.01390.14040.36870.96840.7422
5320722827.820609214.080916024653.965525193774.19630.48060.68260.65130.5315
542132127523272555.288718293054.431428252056.1460.22120.84220.91560.8689
5517960847.719448419.561414104509.909724792329.21320.29270.24610.91650.3602
5617789654.921057717.01415384069.933626731364.09430.12950.85770.91320.5866
5720003708.523363909.223617370828.410629356990.03650.13590.96590.85770.8318
5821169851.723484938.172117191907.563529777968.78060.23540.86090.79290.8298
5920422839.422811530.019516231367.078429391692.96060.23840.68760.71290.7615
6019810562.324376713.178617521420.680331232005.6770.09590.87090.83050.8708

\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[39]) \tabularnewline
27 & 17714362.2 & - & - & - & - & - & - & - \tabularnewline
28 & 16282088 & - & - & - & - & - & - & - \tabularnewline
29 & 15014866.2 & - & - & - & - & - & - & - \tabularnewline
30 & 17722582.4 & - & - & - & - & - & - & - \tabularnewline
31 & 13876509.4 & - & - & - & - & - & - & - \tabularnewline
32 & 15495489.6 & - & - & - & - & - & - & - \tabularnewline
33 & 17799521.1 & - & - & - & - & - & - & - \tabularnewline
34 & 17920079.1 & - & - & - & - & - & - & - \tabularnewline
35 & 17248022.4 & - & - & - & - & - & - & - \tabularnewline
36 & 18813782.4 & - & - & - & - & - & - & - \tabularnewline
37 & 16249688.3 & - & - & - & - & - & - & - \tabularnewline
38 & 17823358.5 & - & - & - & - & - & - & - \tabularnewline
39 & 20424438.3 & - & - & - & - & - & - & - \tabularnewline
40 & 17814218.7 & 19048152.8461 & 17586698.4141 & 20509607.2782 & 0.049 & 0.0325 & 0.9999 & 0.0325 \tabularnewline
41 & 19699959.6 & 17828351.8966 & 16164719.2957 & 19491984.4975 & 0.0137 & 0.5066 & 0.9995 & 0.0011 \tabularnewline
42 & 19776328.1 & 20491638.603 & 18559289.1957 & 22423988.0102 & 0.2341 & 0.789 & 0.9975 & 0.5272 \tabularnewline
43 & 15679833.1 & 16667530.8523 & 14501307.6426 & 18833754.062 & 0.1857 & 0.0025 & 0.9942 & 3e-04 \tabularnewline
44 & 17119266.5 & 18276819.0866 & 15913259.0427 & 20640379.1305 & 0.1686 & 0.9844 & 0.9895 & 0.0375 \tabularnewline
45 & 20092613 & 20583012.3959 & 18028169.6361 & 23137855.1557 & 0.3534 & 0.9961 & 0.9836 & 0.5484 \tabularnewline
46 & 20863688.3 & 20704042.3506 & 17975088.0018 & 23432996.6995 & 0.4544 & 0.6697 & 0.9772 & 0.5796 \tabularnewline
47 & 20925203.1 & 20030633.2747 & 17137068.5989 & 22924197.9505 & 0.2723 & 0.2863 & 0.9703 & 0.3948 \tabularnewline
48 & 21032593 & 21595816.8913 & 18546500.3112 & 24645133.4715 & 0.3587 & 0.6668 & 0.9631 & 0.7743 \tabularnewline
49 & 20664684.3 & 19032263.6864 & 15834951.18 & 22229576.1928 & 0.1585 & 0.1101 & 0.956 & 0.1967 \tabularnewline
50 & 19711511.4 & 20603773.204 & 17264900.6229 & 23942645.785 & 0.3002 & 0.4857 & 0.9487 & 0.5419 \tabularnewline
51 & 22553293.4 & 23205438.0937 & 19730816.2009 & 26680059.9865 & 0.3565 & 0.9756 & 0.9416 & 0.9416 \tabularnewline
52 & 19498332.9 & 21829069.4046 & 17593983.7952 & 26064155.0139 & 0.1404 & 0.3687 & 0.9684 & 0.7422 \tabularnewline
53 & 20722827.8 & 20609214.0809 & 16024653.9655 & 25193774.1963 & 0.4806 & 0.6826 & 0.6513 & 0.5315 \tabularnewline
54 & 21321275 & 23272555.2887 & 18293054.4314 & 28252056.146 & 0.2212 & 0.8422 & 0.9156 & 0.8689 \tabularnewline
55 & 17960847.7 & 19448419.5614 & 14104509.9097 & 24792329.2132 & 0.2927 & 0.2461 & 0.9165 & 0.3602 \tabularnewline
56 & 17789654.9 & 21057717.014 & 15384069.9336 & 26731364.0943 & 0.1295 & 0.8577 & 0.9132 & 0.5866 \tabularnewline
57 & 20003708.5 & 23363909.2236 & 17370828.4106 & 29356990.0365 & 0.1359 & 0.9659 & 0.8577 & 0.8318 \tabularnewline
58 & 21169851.7 & 23484938.1721 & 17191907.5635 & 29777968.7806 & 0.2354 & 0.8609 & 0.7929 & 0.8298 \tabularnewline
59 & 20422839.4 & 22811530.0195 & 16231367.0784 & 29391692.9606 & 0.2384 & 0.6876 & 0.7129 & 0.7615 \tabularnewline
60 & 19810562.3 & 24376713.1786 & 17521420.6803 & 31232005.677 & 0.0959 & 0.8709 & 0.8305 & 0.8708 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=66433&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[39])[/C][/ROW]
[ROW][C]27[/C][C]17714362.2[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]28[/C][C]16282088[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]29[/C][C]15014866.2[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]30[/C][C]17722582.4[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]31[/C][C]13876509.4[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]32[/C][C]15495489.6[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]33[/C][C]17799521.1[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]34[/C][C]17920079.1[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]35[/C][C]17248022.4[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]36[/C][C]18813782.4[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]37[/C][C]16249688.3[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]38[/C][C]17823358.5[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]39[/C][C]20424438.3[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]40[/C][C]17814218.7[/C][C]19048152.8461[/C][C]17586698.4141[/C][C]20509607.2782[/C][C]0.049[/C][C]0.0325[/C][C]0.9999[/C][C]0.0325[/C][/ROW]
[ROW][C]41[/C][C]19699959.6[/C][C]17828351.8966[/C][C]16164719.2957[/C][C]19491984.4975[/C][C]0.0137[/C][C]0.5066[/C][C]0.9995[/C][C]0.0011[/C][/ROW]
[ROW][C]42[/C][C]19776328.1[/C][C]20491638.603[/C][C]18559289.1957[/C][C]22423988.0102[/C][C]0.2341[/C][C]0.789[/C][C]0.9975[/C][C]0.5272[/C][/ROW]
[ROW][C]43[/C][C]15679833.1[/C][C]16667530.8523[/C][C]14501307.6426[/C][C]18833754.062[/C][C]0.1857[/C][C]0.0025[/C][C]0.9942[/C][C]3e-04[/C][/ROW]
[ROW][C]44[/C][C]17119266.5[/C][C]18276819.0866[/C][C]15913259.0427[/C][C]20640379.1305[/C][C]0.1686[/C][C]0.9844[/C][C]0.9895[/C][C]0.0375[/C][/ROW]
[ROW][C]45[/C][C]20092613[/C][C]20583012.3959[/C][C]18028169.6361[/C][C]23137855.1557[/C][C]0.3534[/C][C]0.9961[/C][C]0.9836[/C][C]0.5484[/C][/ROW]
[ROW][C]46[/C][C]20863688.3[/C][C]20704042.3506[/C][C]17975088.0018[/C][C]23432996.6995[/C][C]0.4544[/C][C]0.6697[/C][C]0.9772[/C][C]0.5796[/C][/ROW]
[ROW][C]47[/C][C]20925203.1[/C][C]20030633.2747[/C][C]17137068.5989[/C][C]22924197.9505[/C][C]0.2723[/C][C]0.2863[/C][C]0.9703[/C][C]0.3948[/C][/ROW]
[ROW][C]48[/C][C]21032593[/C][C]21595816.8913[/C][C]18546500.3112[/C][C]24645133.4715[/C][C]0.3587[/C][C]0.6668[/C][C]0.9631[/C][C]0.7743[/C][/ROW]
[ROW][C]49[/C][C]20664684.3[/C][C]19032263.6864[/C][C]15834951.18[/C][C]22229576.1928[/C][C]0.1585[/C][C]0.1101[/C][C]0.956[/C][C]0.1967[/C][/ROW]
[ROW][C]50[/C][C]19711511.4[/C][C]20603773.204[/C][C]17264900.6229[/C][C]23942645.785[/C][C]0.3002[/C][C]0.4857[/C][C]0.9487[/C][C]0.5419[/C][/ROW]
[ROW][C]51[/C][C]22553293.4[/C][C]23205438.0937[/C][C]19730816.2009[/C][C]26680059.9865[/C][C]0.3565[/C][C]0.9756[/C][C]0.9416[/C][C]0.9416[/C][/ROW]
[ROW][C]52[/C][C]19498332.9[/C][C]21829069.4046[/C][C]17593983.7952[/C][C]26064155.0139[/C][C]0.1404[/C][C]0.3687[/C][C]0.9684[/C][C]0.7422[/C][/ROW]
[ROW][C]53[/C][C]20722827.8[/C][C]20609214.0809[/C][C]16024653.9655[/C][C]25193774.1963[/C][C]0.4806[/C][C]0.6826[/C][C]0.6513[/C][C]0.5315[/C][/ROW]
[ROW][C]54[/C][C]21321275[/C][C]23272555.2887[/C][C]18293054.4314[/C][C]28252056.146[/C][C]0.2212[/C][C]0.8422[/C][C]0.9156[/C][C]0.8689[/C][/ROW]
[ROW][C]55[/C][C]17960847.7[/C][C]19448419.5614[/C][C]14104509.9097[/C][C]24792329.2132[/C][C]0.2927[/C][C]0.2461[/C][C]0.9165[/C][C]0.3602[/C][/ROW]
[ROW][C]56[/C][C]17789654.9[/C][C]21057717.014[/C][C]15384069.9336[/C][C]26731364.0943[/C][C]0.1295[/C][C]0.8577[/C][C]0.9132[/C][C]0.5866[/C][/ROW]
[ROW][C]57[/C][C]20003708.5[/C][C]23363909.2236[/C][C]17370828.4106[/C][C]29356990.0365[/C][C]0.1359[/C][C]0.9659[/C][C]0.8577[/C][C]0.8318[/C][/ROW]
[ROW][C]58[/C][C]21169851.7[/C][C]23484938.1721[/C][C]17191907.5635[/C][C]29777968.7806[/C][C]0.2354[/C][C]0.8609[/C][C]0.7929[/C][C]0.8298[/C][/ROW]
[ROW][C]59[/C][C]20422839.4[/C][C]22811530.0195[/C][C]16231367.0784[/C][C]29391692.9606[/C][C]0.2384[/C][C]0.6876[/C][C]0.7129[/C][C]0.7615[/C][/ROW]
[ROW][C]60[/C][C]19810562.3[/C][C]24376713.1786[/C][C]17521420.6803[/C][C]31232005.677[/C][C]0.0959[/C][C]0.8709[/C][C]0.8305[/C][C]0.8708[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=66433&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=66433&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[39])
2717714362.2-------
2816282088-------
2915014866.2-------
3017722582.4-------
3113876509.4-------
3215495489.6-------
3317799521.1-------
3417920079.1-------
3517248022.4-------
3618813782.4-------
3716249688.3-------
3817823358.5-------
3920424438.3-------
4017814218.719048152.846117586698.414120509607.27820.0490.03250.99990.0325
4119699959.617828351.896616164719.295719491984.49750.01370.50660.99950.0011
4219776328.120491638.60318559289.195722423988.01020.23410.7890.99750.5272
4315679833.116667530.852314501307.642618833754.0620.18570.00250.99423e-04
4417119266.518276819.086615913259.042720640379.13050.16860.98440.98950.0375
452009261320583012.395918028169.636123137855.15570.35340.99610.98360.5484
4620863688.320704042.350617975088.001823432996.69950.45440.66970.97720.5796
4720925203.120030633.274717137068.598922924197.95050.27230.28630.97030.3948
482103259321595816.891318546500.311224645133.47150.35870.66680.96310.7743
4920664684.319032263.686415834951.1822229576.19280.15850.11010.9560.1967
5019711511.420603773.20417264900.622923942645.7850.30020.48570.94870.5419
5122553293.423205438.093719730816.200926680059.98650.35650.97560.94160.9416
5219498332.921829069.404617593983.795226064155.01390.14040.36870.96840.7422
5320722827.820609214.080916024653.965525193774.19630.48060.68260.65130.5315
542132127523272555.288718293054.431428252056.1460.22120.84220.91560.8689
5517960847.719448419.561414104509.909724792329.21320.29270.24610.91650.3602
5617789654.921057717.01415384069.933626731364.09430.12950.85770.91320.5866
5720003708.523363909.223617370828.410629356990.03650.13590.96590.85770.8318
5821169851.723484938.172117191907.563529777968.78060.23540.86090.79290.8298
5920422839.422811530.019516231367.078429391692.96060.23840.68760.71290.7615
6019810562.324376713.178617521420.680331232005.6770.09590.87090.83050.8708







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPESq.EMSERMSE
400.0391-0.06480.00311522593477018.3972504451286.5901269266.5061
410.04760.1050.0053502915395455.29166805495021.680408418.2844
420.0481-0.03490.0017511669115633.98424365195982.5707156093.5488
430.0663-0.05930.0028975546849919.6846454611900.9371215533.3197
440.066-0.06330.0031339927990856.7663806094802.7027252598.6833
450.0633-0.02380.0011240491567520.74811451979405.7499107013.9216
460.06720.00774e-0425486829154.7331213658531.177834837.6023
470.07370.04470.0021800255172305.47538107389157.4035195211.1399
480.072-0.02610.0012317221151779.30515105769132.3479122905.5293
490.08570.08580.00412664797059635.71126895098077.891356223.3823
500.0827-0.04330.0021796131126814.47537911006038.7845194707.4884
510.0764-0.02810.0013425292701517.42420252033405.5916142309.6392
520.099-0.10680.00515432332653707.05258682507319.383508608.4027
530.11350.00553e-0412908077172.9689614670341.569924792.5461
540.1092-0.08380.0043807494765218.43181309274534.211425804.2679
550.1402-0.07650.00362212870042924.65105374763948.793324614.7932
560.1375-0.15520.007410680229980709.9508582380033.806713149.6197
570.1309-0.14380.006811290948902680.3537664233460.968733255.9127
580.1367-0.09860.00475359625373097.41255220255861.781505193.2856
590.1472-0.10470.0055705842875696.67271706803604.603521255.0274
600.1435-0.18730.008920849733846145.7992844468864.08996415.8112

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & Sq.E & MSE & RMSE \tabularnewline
40 & 0.0391 & -0.0648 & 0.0031 & 1522593477018.39 & 72504451286.5901 & 269266.5061 \tabularnewline
41 & 0.0476 & 0.105 & 0.005 & 3502915395455.29 & 166805495021.680 & 408418.2844 \tabularnewline
42 & 0.0481 & -0.0349 & 0.0017 & 511669115633.984 & 24365195982.5707 & 156093.5488 \tabularnewline
43 & 0.0663 & -0.0593 & 0.0028 & 975546849919.68 & 46454611900.9371 & 215533.3197 \tabularnewline
44 & 0.066 & -0.0633 & 0.003 & 1339927990856.76 & 63806094802.7027 & 252598.6833 \tabularnewline
45 & 0.0633 & -0.0238 & 0.0011 & 240491567520.748 & 11451979405.7499 & 107013.9216 \tabularnewline
46 & 0.0672 & 0.0077 & 4e-04 & 25486829154.733 & 1213658531.1778 & 34837.6023 \tabularnewline
47 & 0.0737 & 0.0447 & 0.0021 & 800255172305.475 & 38107389157.4035 & 195211.1399 \tabularnewline
48 & 0.072 & -0.0261 & 0.0012 & 317221151779.305 & 15105769132.3479 & 122905.5293 \tabularnewline
49 & 0.0857 & 0.0858 & 0.0041 & 2664797059635.71 & 126895098077.891 & 356223.3823 \tabularnewline
50 & 0.0827 & -0.0433 & 0.0021 & 796131126814.475 & 37911006038.7845 & 194707.4884 \tabularnewline
51 & 0.0764 & -0.0281 & 0.0013 & 425292701517.424 & 20252033405.5916 & 142309.6392 \tabularnewline
52 & 0.099 & -0.1068 & 0.0051 & 5432332653707.05 & 258682507319.383 & 508608.4027 \tabularnewline
53 & 0.1135 & 0.0055 & 3e-04 & 12908077172.9689 & 614670341.5699 & 24792.5461 \tabularnewline
54 & 0.1092 & -0.0838 & 0.004 & 3807494765218.43 & 181309274534.211 & 425804.2679 \tabularnewline
55 & 0.1402 & -0.0765 & 0.0036 & 2212870042924.65 & 105374763948.793 & 324614.7932 \tabularnewline
56 & 0.1375 & -0.1552 & 0.0074 & 10680229980709.9 & 508582380033.806 & 713149.6197 \tabularnewline
57 & 0.1309 & -0.1438 & 0.0068 & 11290948902680.3 & 537664233460.968 & 733255.9127 \tabularnewline
58 & 0.1367 & -0.0986 & 0.0047 & 5359625373097.41 & 255220255861.781 & 505193.2856 \tabularnewline
59 & 0.1472 & -0.1047 & 0.005 & 5705842875696.67 & 271706803604.603 & 521255.0274 \tabularnewline
60 & 0.1435 & -0.1873 & 0.0089 & 20849733846145.7 & 992844468864.08 & 996415.8112 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=66433&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]40[/C][C]0.0391[/C][C]-0.0648[/C][C]0.0031[/C][C]1522593477018.39[/C][C]72504451286.5901[/C][C]269266.5061[/C][/ROW]
[ROW][C]41[/C][C]0.0476[/C][C]0.105[/C][C]0.005[/C][C]3502915395455.29[/C][C]166805495021.680[/C][C]408418.2844[/C][/ROW]
[ROW][C]42[/C][C]0.0481[/C][C]-0.0349[/C][C]0.0017[/C][C]511669115633.984[/C][C]24365195982.5707[/C][C]156093.5488[/C][/ROW]
[ROW][C]43[/C][C]0.0663[/C][C]-0.0593[/C][C]0.0028[/C][C]975546849919.68[/C][C]46454611900.9371[/C][C]215533.3197[/C][/ROW]
[ROW][C]44[/C][C]0.066[/C][C]-0.0633[/C][C]0.003[/C][C]1339927990856.76[/C][C]63806094802.7027[/C][C]252598.6833[/C][/ROW]
[ROW][C]45[/C][C]0.0633[/C][C]-0.0238[/C][C]0.0011[/C][C]240491567520.748[/C][C]11451979405.7499[/C][C]107013.9216[/C][/ROW]
[ROW][C]46[/C][C]0.0672[/C][C]0.0077[/C][C]4e-04[/C][C]25486829154.733[/C][C]1213658531.1778[/C][C]34837.6023[/C][/ROW]
[ROW][C]47[/C][C]0.0737[/C][C]0.0447[/C][C]0.0021[/C][C]800255172305.475[/C][C]38107389157.4035[/C][C]195211.1399[/C][/ROW]
[ROW][C]48[/C][C]0.072[/C][C]-0.0261[/C][C]0.0012[/C][C]317221151779.305[/C][C]15105769132.3479[/C][C]122905.5293[/C][/ROW]
[ROW][C]49[/C][C]0.0857[/C][C]0.0858[/C][C]0.0041[/C][C]2664797059635.71[/C][C]126895098077.891[/C][C]356223.3823[/C][/ROW]
[ROW][C]50[/C][C]0.0827[/C][C]-0.0433[/C][C]0.0021[/C][C]796131126814.475[/C][C]37911006038.7845[/C][C]194707.4884[/C][/ROW]
[ROW][C]51[/C][C]0.0764[/C][C]-0.0281[/C][C]0.0013[/C][C]425292701517.424[/C][C]20252033405.5916[/C][C]142309.6392[/C][/ROW]
[ROW][C]52[/C][C]0.099[/C][C]-0.1068[/C][C]0.0051[/C][C]5432332653707.05[/C][C]258682507319.383[/C][C]508608.4027[/C][/ROW]
[ROW][C]53[/C][C]0.1135[/C][C]0.0055[/C][C]3e-04[/C][C]12908077172.9689[/C][C]614670341.5699[/C][C]24792.5461[/C][/ROW]
[ROW][C]54[/C][C]0.1092[/C][C]-0.0838[/C][C]0.004[/C][C]3807494765218.43[/C][C]181309274534.211[/C][C]425804.2679[/C][/ROW]
[ROW][C]55[/C][C]0.1402[/C][C]-0.0765[/C][C]0.0036[/C][C]2212870042924.65[/C][C]105374763948.793[/C][C]324614.7932[/C][/ROW]
[ROW][C]56[/C][C]0.1375[/C][C]-0.1552[/C][C]0.0074[/C][C]10680229980709.9[/C][C]508582380033.806[/C][C]713149.6197[/C][/ROW]
[ROW][C]57[/C][C]0.1309[/C][C]-0.1438[/C][C]0.0068[/C][C]11290948902680.3[/C][C]537664233460.968[/C][C]733255.9127[/C][/ROW]
[ROW][C]58[/C][C]0.1367[/C][C]-0.0986[/C][C]0.0047[/C][C]5359625373097.41[/C][C]255220255861.781[/C][C]505193.2856[/C][/ROW]
[ROW][C]59[/C][C]0.1472[/C][C]-0.1047[/C][C]0.005[/C][C]5705842875696.67[/C][C]271706803604.603[/C][C]521255.0274[/C][/ROW]
[ROW][C]60[/C][C]0.1435[/C][C]-0.1873[/C][C]0.0089[/C][C]20849733846145.7[/C][C]992844468864.08[/C][C]996415.8112[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=66433&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=66433&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
400.0391-0.06480.00311522593477018.3972504451286.5901269266.5061
410.04760.1050.0053502915395455.29166805495021.680408418.2844
420.0481-0.03490.0017511669115633.98424365195982.5707156093.5488
430.0663-0.05930.0028975546849919.6846454611900.9371215533.3197
440.066-0.06330.0031339927990856.7663806094802.7027252598.6833
450.0633-0.02380.0011240491567520.74811451979405.7499107013.9216
460.06720.00774e-0425486829154.7331213658531.177834837.6023
470.07370.04470.0021800255172305.47538107389157.4035195211.1399
480.072-0.02610.0012317221151779.30515105769132.3479122905.5293
490.08570.08580.00412664797059635.71126895098077.891356223.3823
500.0827-0.04330.0021796131126814.47537911006038.7845194707.4884
510.0764-0.02810.0013425292701517.42420252033405.5916142309.6392
520.099-0.10680.00515432332653707.05258682507319.383508608.4027
530.11350.00553e-0412908077172.9689614670341.569924792.5461
540.1092-0.08380.0043807494765218.43181309274534.211425804.2679
550.1402-0.07650.00362212870042924.65105374763948.793324614.7932
560.1375-0.15520.007410680229980709.9508582380033.806713149.6197
570.1309-0.14380.006811290948902680.3537664233460.968733255.9127
580.1367-0.09860.00475359625373097.41255220255861.781505193.2856
590.1472-0.10470.0055705842875696.67271706803604.603521255.0274
600.1435-0.18730.008920849733846145.7992844468864.08996415.8112



Parameters (Session):
par1 = 1 ; par2 = 1 ; par3 = 0 ; par4 = 12 ;
Parameters (R input):
par1 = 21 ; par2 = 1.0 ; par3 = 1 ; par4 = 1 ; par5 = 12 ; par6 = 2 ; par7 = 1 ; 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,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.mape <- array(0, dim=fx)
perf.se <- array(0, dim=fx)
perf.mse <- 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.mape[i] = perf.mape[i] + abs(perf.pe[i])
perf.se[i] = (x[nx+i] - forecast$pred[i])^2
perf.mse[i] = perf.mse[i] + perf.se[i]
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 = perf.mape / fx
perf.mse = perf.mse / fx
perf.rmse = sqrt(perf.mse)
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:12] <- 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.mape[i],4))
a<-table.element(a,round(perf.se[i],4))
a<-table.element(a,round(perf.mse[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')