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 computationMon, 14 Dec 2009 06:37:19 -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/14/t1260797932lwidlcupymrlklh.htm/, Retrieved Sun, 05 May 2024 20:17:30 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=67554, Retrieved Sun, 05 May 2024 20:17:30 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact99
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [ARIMA Forecasting] [] [2009-12-14 13:34:18] [2f9700e78f159997f527be4a316457f5]
-   P     [ARIMA Forecasting] [] [2009-12-14 13:37:19] [dd88bf4749af0c195ad4f54cb428da1c] [Current]
Feedback Forum

Post a new message
Dataseries X:
6802.96
7132.68
7073.29
7264.5
7105.33
7218.71
7225.72
7354.25
7745.46
8070.26
8366.33
8667.51
8854.34
9218.1
9332.9
9358.31
9248.66
9401.2
9652.04
9957.38
10110.63
10169.26
10343.78
10750.21
11337.5
11786.96
12083.04
12007.74
11745.93
11051.51
11445.9
11924.88
12247.63
12690.91
12910.7
13202.12
13654.67
13862.82
13523.93
14211.17
14510.35
14289.23
14111.82
13086.59
13351.54
13747.69
12855.61
12926.93
12121.95
11731.65
11639.51
12163.78
12029.53
11234.18
9852.13
9709.04
9332.75
7108.6
6691.49
6143.05




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=67554&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=67554&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=67554&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[40])
3913523.93-------
4014211.17-------
4114510.3514475.225313920.741715029.70890.45060.82470.82470.8247
4214289.2314653.220113688.761915617.67830.22970.61420.61420.8155
4314111.8214773.203113421.329716125.07640.16880.75860.75860.7924
4413086.5914854.081413139.9316568.23270.02160.8020.8020.7689
4513351.5414908.599912857.813216959.38670.06840.95920.95920.7475
4613747.6914945.349912582.18117308.51870.16030.90690.90690.7287
4712855.6114970.122312316.602317623.64240.05920.81670.81670.7125
4812926.9314986.82112062.544817911.09720.08370.92340.92340.6984
4912121.9514998.077211820.294118175.86040.0380.89930.89930.6863
5011731.6515005.664911589.497218421.83250.03020.9510.9510.6757
5111639.5115010.779611369.481718652.07740.03480.96120.96120.6665
5212163.7815014.227311159.44118869.01350.07360.95690.95690.6585
5312029.5315016.551310958.538919074.56370.07460.91590.91590.6514
5411234.1815018.117910765.966119270.26970.04060.91580.91580.645
559852.1315019.173910580.968919457.37890.01120.95270.95270.6394
569709.0415019.885710402.860819636.91070.01210.98590.98590.6343
579332.7515020.365610231.024819809.70640.010.98510.98510.6297
587108.615020.68910064.910919976.46729e-040.98780.98780.6256
596691.4915020.90719904.030920137.78327e-040.99880.99880.6218
606143.0515021.0549747.952620294.15555e-040.9990.9990.6183

\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[40]) \tabularnewline
39 & 13523.93 & - & - & - & - & - & - & - \tabularnewline
40 & 14211.17 & - & - & - & - & - & - & - \tabularnewline
41 & 14510.35 & 14475.2253 & 13920.7417 & 15029.7089 & 0.4506 & 0.8247 & 0.8247 & 0.8247 \tabularnewline
42 & 14289.23 & 14653.2201 & 13688.7619 & 15617.6783 & 0.2297 & 0.6142 & 0.6142 & 0.8155 \tabularnewline
43 & 14111.82 & 14773.2031 & 13421.3297 & 16125.0764 & 0.1688 & 0.7586 & 0.7586 & 0.7924 \tabularnewline
44 & 13086.59 & 14854.0814 & 13139.93 & 16568.2327 & 0.0216 & 0.802 & 0.802 & 0.7689 \tabularnewline
45 & 13351.54 & 14908.5999 & 12857.8132 & 16959.3867 & 0.0684 & 0.9592 & 0.9592 & 0.7475 \tabularnewline
46 & 13747.69 & 14945.3499 & 12582.181 & 17308.5187 & 0.1603 & 0.9069 & 0.9069 & 0.7287 \tabularnewline
47 & 12855.61 & 14970.1223 & 12316.6023 & 17623.6424 & 0.0592 & 0.8167 & 0.8167 & 0.7125 \tabularnewline
48 & 12926.93 & 14986.821 & 12062.5448 & 17911.0972 & 0.0837 & 0.9234 & 0.9234 & 0.6984 \tabularnewline
49 & 12121.95 & 14998.0772 & 11820.2941 & 18175.8604 & 0.038 & 0.8993 & 0.8993 & 0.6863 \tabularnewline
50 & 11731.65 & 15005.6649 & 11589.4972 & 18421.8325 & 0.0302 & 0.951 & 0.951 & 0.6757 \tabularnewline
51 & 11639.51 & 15010.7796 & 11369.4817 & 18652.0774 & 0.0348 & 0.9612 & 0.9612 & 0.6665 \tabularnewline
52 & 12163.78 & 15014.2273 & 11159.441 & 18869.0135 & 0.0736 & 0.9569 & 0.9569 & 0.6585 \tabularnewline
53 & 12029.53 & 15016.5513 & 10958.5389 & 19074.5637 & 0.0746 & 0.9159 & 0.9159 & 0.6514 \tabularnewline
54 & 11234.18 & 15018.1179 & 10765.9661 & 19270.2697 & 0.0406 & 0.9158 & 0.9158 & 0.645 \tabularnewline
55 & 9852.13 & 15019.1739 & 10580.9689 & 19457.3789 & 0.0112 & 0.9527 & 0.9527 & 0.6394 \tabularnewline
56 & 9709.04 & 15019.8857 & 10402.8608 & 19636.9107 & 0.0121 & 0.9859 & 0.9859 & 0.6343 \tabularnewline
57 & 9332.75 & 15020.3656 & 10231.0248 & 19809.7064 & 0.01 & 0.9851 & 0.9851 & 0.6297 \tabularnewline
58 & 7108.6 & 15020.689 & 10064.9109 & 19976.4672 & 9e-04 & 0.9878 & 0.9878 & 0.6256 \tabularnewline
59 & 6691.49 & 15020.9071 & 9904.0309 & 20137.7832 & 7e-04 & 0.9988 & 0.9988 & 0.6218 \tabularnewline
60 & 6143.05 & 15021.054 & 9747.9526 & 20294.1555 & 5e-04 & 0.999 & 0.999 & 0.6183 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=67554&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[40])[/C][/ROW]
[ROW][C]39[/C][C]13523.93[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]40[/C][C]14211.17[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]41[/C][C]14510.35[/C][C]14475.2253[/C][C]13920.7417[/C][C]15029.7089[/C][C]0.4506[/C][C]0.8247[/C][C]0.8247[/C][C]0.8247[/C][/ROW]
[ROW][C]42[/C][C]14289.23[/C][C]14653.2201[/C][C]13688.7619[/C][C]15617.6783[/C][C]0.2297[/C][C]0.6142[/C][C]0.6142[/C][C]0.8155[/C][/ROW]
[ROW][C]43[/C][C]14111.82[/C][C]14773.2031[/C][C]13421.3297[/C][C]16125.0764[/C][C]0.1688[/C][C]0.7586[/C][C]0.7586[/C][C]0.7924[/C][/ROW]
[ROW][C]44[/C][C]13086.59[/C][C]14854.0814[/C][C]13139.93[/C][C]16568.2327[/C][C]0.0216[/C][C]0.802[/C][C]0.802[/C][C]0.7689[/C][/ROW]
[ROW][C]45[/C][C]13351.54[/C][C]14908.5999[/C][C]12857.8132[/C][C]16959.3867[/C][C]0.0684[/C][C]0.9592[/C][C]0.9592[/C][C]0.7475[/C][/ROW]
[ROW][C]46[/C][C]13747.69[/C][C]14945.3499[/C][C]12582.181[/C][C]17308.5187[/C][C]0.1603[/C][C]0.9069[/C][C]0.9069[/C][C]0.7287[/C][/ROW]
[ROW][C]47[/C][C]12855.61[/C][C]14970.1223[/C][C]12316.6023[/C][C]17623.6424[/C][C]0.0592[/C][C]0.8167[/C][C]0.8167[/C][C]0.7125[/C][/ROW]
[ROW][C]48[/C][C]12926.93[/C][C]14986.821[/C][C]12062.5448[/C][C]17911.0972[/C][C]0.0837[/C][C]0.9234[/C][C]0.9234[/C][C]0.6984[/C][/ROW]
[ROW][C]49[/C][C]12121.95[/C][C]14998.0772[/C][C]11820.2941[/C][C]18175.8604[/C][C]0.038[/C][C]0.8993[/C][C]0.8993[/C][C]0.6863[/C][/ROW]
[ROW][C]50[/C][C]11731.65[/C][C]15005.6649[/C][C]11589.4972[/C][C]18421.8325[/C][C]0.0302[/C][C]0.951[/C][C]0.951[/C][C]0.6757[/C][/ROW]
[ROW][C]51[/C][C]11639.51[/C][C]15010.7796[/C][C]11369.4817[/C][C]18652.0774[/C][C]0.0348[/C][C]0.9612[/C][C]0.9612[/C][C]0.6665[/C][/ROW]
[ROW][C]52[/C][C]12163.78[/C][C]15014.2273[/C][C]11159.441[/C][C]18869.0135[/C][C]0.0736[/C][C]0.9569[/C][C]0.9569[/C][C]0.6585[/C][/ROW]
[ROW][C]53[/C][C]12029.53[/C][C]15016.5513[/C][C]10958.5389[/C][C]19074.5637[/C][C]0.0746[/C][C]0.9159[/C][C]0.9159[/C][C]0.6514[/C][/ROW]
[ROW][C]54[/C][C]11234.18[/C][C]15018.1179[/C][C]10765.9661[/C][C]19270.2697[/C][C]0.0406[/C][C]0.9158[/C][C]0.9158[/C][C]0.645[/C][/ROW]
[ROW][C]55[/C][C]9852.13[/C][C]15019.1739[/C][C]10580.9689[/C][C]19457.3789[/C][C]0.0112[/C][C]0.9527[/C][C]0.9527[/C][C]0.6394[/C][/ROW]
[ROW][C]56[/C][C]9709.04[/C][C]15019.8857[/C][C]10402.8608[/C][C]19636.9107[/C][C]0.0121[/C][C]0.9859[/C][C]0.9859[/C][C]0.6343[/C][/ROW]
[ROW][C]57[/C][C]9332.75[/C][C]15020.3656[/C][C]10231.0248[/C][C]19809.7064[/C][C]0.01[/C][C]0.9851[/C][C]0.9851[/C][C]0.6297[/C][/ROW]
[ROW][C]58[/C][C]7108.6[/C][C]15020.689[/C][C]10064.9109[/C][C]19976.4672[/C][C]9e-04[/C][C]0.9878[/C][C]0.9878[/C][C]0.6256[/C][/ROW]
[ROW][C]59[/C][C]6691.49[/C][C]15020.9071[/C][C]9904.0309[/C][C]20137.7832[/C][C]7e-04[/C][C]0.9988[/C][C]0.9988[/C][C]0.6218[/C][/ROW]
[ROW][C]60[/C][C]6143.05[/C][C]15021.054[/C][C]9747.9526[/C][C]20294.1555[/C][C]5e-04[/C][C]0.999[/C][C]0.999[/C][C]0.6183[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=67554&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=67554&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[40])
3913523.93-------
4014211.17-------
4114510.3514475.225313920.741715029.70890.45060.82470.82470.8247
4214289.2314653.220113688.761915617.67830.22970.61420.61420.8155
4314111.8214773.203113421.329716125.07640.16880.75860.75860.7924
4413086.5914854.081413139.9316568.23270.02160.8020.8020.7689
4513351.5414908.599912857.813216959.38670.06840.95920.95920.7475
4613747.6914945.349912582.18117308.51870.16030.90690.90690.7287
4712855.6114970.122312316.602317623.64240.05920.81670.81670.7125
4812926.9314986.82112062.544817911.09720.08370.92340.92340.6984
4912121.9514998.077211820.294118175.86040.0380.89930.89930.6863
5011731.6515005.664911589.497218421.83250.03020.9510.9510.6757
5111639.5115010.779611369.481718652.07740.03480.96120.96120.6665
5212163.7815014.227311159.44118869.01350.07360.95690.95690.6585
5312029.5315016.551310958.538919074.56370.07460.91590.91590.6514
5411234.1815018.117910765.966119270.26970.04060.91580.91580.645
559852.1315019.173910580.968919457.37890.01120.95270.95270.6394
569709.0415019.885710402.860819636.91070.01210.98590.98590.6343
579332.7515020.365610231.024819809.70640.010.98510.98510.6297
587108.615020.68910064.910919976.46729e-040.98780.98780.6256
596691.4915020.90719904.030920137.78327e-040.99880.99880.6218
606143.0515021.0549747.952620294.15555e-040.9990.9990.6183







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPESq.EMSERMSE
410.01950.002401233.744200
420.0336-0.02480.0136132488.781866861.263258.5754
430.0467-0.04480.024437427.5561190383.3607436.3294
440.0589-0.1190.04783124025.7153923793.9494961.142
450.0702-0.10440.05912424435.60271223922.281106.3102
460.0807-0.08010.06261434389.17031259000.09511122.0517
470.0904-0.14120.07384471162.40121717880.42451310.6794
480.0996-0.13740.08184243150.87752033539.23111426.0222
490.1081-0.19180.0948272107.90232726713.52791651.2763
500.1162-0.21820.106410719173.38123525959.51331877.7538
510.1238-0.22460.117211365458.40244238641.23042058.7961
520.131-0.18980.12328125049.61334562508.59572136.0029
530.1379-0.19890.1298922296.27144897876.87842213.1147
540.1445-0.2520.137814318185.99685570756.10122360.2449
550.1508-0.3440.151626698342.72266979261.87592641.8293
560.1568-0.35360.164228205082.50028305875.6652881.9916
570.1627-0.37870.176832348970.96849720175.38873117.7196
580.1683-0.52670.196362601152.771412658007.46553557.8094
590.1738-0.55450.215169379188.520715643332.78423955.1653
600.1791-0.5910.233978818955.52318802113.92114336.1404

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & Sq.E & MSE & RMSE \tabularnewline
41 & 0.0195 & 0.0024 & 0 & 1233.7442 & 0 & 0 \tabularnewline
42 & 0.0336 & -0.0248 & 0.0136 & 132488.7818 & 66861.263 & 258.5754 \tabularnewline
43 & 0.0467 & -0.0448 & 0.024 & 437427.5561 & 190383.3607 & 436.3294 \tabularnewline
44 & 0.0589 & -0.119 & 0.0478 & 3124025.7153 & 923793.9494 & 961.142 \tabularnewline
45 & 0.0702 & -0.1044 & 0.0591 & 2424435.6027 & 1223922.28 & 1106.3102 \tabularnewline
46 & 0.0807 & -0.0801 & 0.0626 & 1434389.1703 & 1259000.0951 & 1122.0517 \tabularnewline
47 & 0.0904 & -0.1412 & 0.0738 & 4471162.4012 & 1717880.4245 & 1310.6794 \tabularnewline
48 & 0.0996 & -0.1374 & 0.0818 & 4243150.8775 & 2033539.2311 & 1426.0222 \tabularnewline
49 & 0.1081 & -0.1918 & 0.094 & 8272107.9023 & 2726713.5279 & 1651.2763 \tabularnewline
50 & 0.1162 & -0.2182 & 0.1064 & 10719173.3812 & 3525959.5133 & 1877.7538 \tabularnewline
51 & 0.1238 & -0.2246 & 0.1172 & 11365458.4024 & 4238641.2304 & 2058.7961 \tabularnewline
52 & 0.131 & -0.1898 & 0.1232 & 8125049.6133 & 4562508.5957 & 2136.0029 \tabularnewline
53 & 0.1379 & -0.1989 & 0.129 & 8922296.2714 & 4897876.8784 & 2213.1147 \tabularnewline
54 & 0.1445 & -0.252 & 0.1378 & 14318185.9968 & 5570756.1012 & 2360.2449 \tabularnewline
55 & 0.1508 & -0.344 & 0.1516 & 26698342.7226 & 6979261.8759 & 2641.8293 \tabularnewline
56 & 0.1568 & -0.3536 & 0.1642 & 28205082.5002 & 8305875.665 & 2881.9916 \tabularnewline
57 & 0.1627 & -0.3787 & 0.1768 & 32348970.9684 & 9720175.3887 & 3117.7196 \tabularnewline
58 & 0.1683 & -0.5267 & 0.1963 & 62601152.7714 & 12658007.4655 & 3557.8094 \tabularnewline
59 & 0.1738 & -0.5545 & 0.2151 & 69379188.5207 & 15643332.7842 & 3955.1653 \tabularnewline
60 & 0.1791 & -0.591 & 0.2339 & 78818955.523 & 18802113.9211 & 4336.1404 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=67554&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]41[/C][C]0.0195[/C][C]0.0024[/C][C]0[/C][C]1233.7442[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]42[/C][C]0.0336[/C][C]-0.0248[/C][C]0.0136[/C][C]132488.7818[/C][C]66861.263[/C][C]258.5754[/C][/ROW]
[ROW][C]43[/C][C]0.0467[/C][C]-0.0448[/C][C]0.024[/C][C]437427.5561[/C][C]190383.3607[/C][C]436.3294[/C][/ROW]
[ROW][C]44[/C][C]0.0589[/C][C]-0.119[/C][C]0.0478[/C][C]3124025.7153[/C][C]923793.9494[/C][C]961.142[/C][/ROW]
[ROW][C]45[/C][C]0.0702[/C][C]-0.1044[/C][C]0.0591[/C][C]2424435.6027[/C][C]1223922.28[/C][C]1106.3102[/C][/ROW]
[ROW][C]46[/C][C]0.0807[/C][C]-0.0801[/C][C]0.0626[/C][C]1434389.1703[/C][C]1259000.0951[/C][C]1122.0517[/C][/ROW]
[ROW][C]47[/C][C]0.0904[/C][C]-0.1412[/C][C]0.0738[/C][C]4471162.4012[/C][C]1717880.4245[/C][C]1310.6794[/C][/ROW]
[ROW][C]48[/C][C]0.0996[/C][C]-0.1374[/C][C]0.0818[/C][C]4243150.8775[/C][C]2033539.2311[/C][C]1426.0222[/C][/ROW]
[ROW][C]49[/C][C]0.1081[/C][C]-0.1918[/C][C]0.094[/C][C]8272107.9023[/C][C]2726713.5279[/C][C]1651.2763[/C][/ROW]
[ROW][C]50[/C][C]0.1162[/C][C]-0.2182[/C][C]0.1064[/C][C]10719173.3812[/C][C]3525959.5133[/C][C]1877.7538[/C][/ROW]
[ROW][C]51[/C][C]0.1238[/C][C]-0.2246[/C][C]0.1172[/C][C]11365458.4024[/C][C]4238641.2304[/C][C]2058.7961[/C][/ROW]
[ROW][C]52[/C][C]0.131[/C][C]-0.1898[/C][C]0.1232[/C][C]8125049.6133[/C][C]4562508.5957[/C][C]2136.0029[/C][/ROW]
[ROW][C]53[/C][C]0.1379[/C][C]-0.1989[/C][C]0.129[/C][C]8922296.2714[/C][C]4897876.8784[/C][C]2213.1147[/C][/ROW]
[ROW][C]54[/C][C]0.1445[/C][C]-0.252[/C][C]0.1378[/C][C]14318185.9968[/C][C]5570756.1012[/C][C]2360.2449[/C][/ROW]
[ROW][C]55[/C][C]0.1508[/C][C]-0.344[/C][C]0.1516[/C][C]26698342.7226[/C][C]6979261.8759[/C][C]2641.8293[/C][/ROW]
[ROW][C]56[/C][C]0.1568[/C][C]-0.3536[/C][C]0.1642[/C][C]28205082.5002[/C][C]8305875.665[/C][C]2881.9916[/C][/ROW]
[ROW][C]57[/C][C]0.1627[/C][C]-0.3787[/C][C]0.1768[/C][C]32348970.9684[/C][C]9720175.3887[/C][C]3117.7196[/C][/ROW]
[ROW][C]58[/C][C]0.1683[/C][C]-0.5267[/C][C]0.1963[/C][C]62601152.7714[/C][C]12658007.4655[/C][C]3557.8094[/C][/ROW]
[ROW][C]59[/C][C]0.1738[/C][C]-0.5545[/C][C]0.2151[/C][C]69379188.5207[/C][C]15643332.7842[/C][C]3955.1653[/C][/ROW]
[ROW][C]60[/C][C]0.1791[/C][C]-0.591[/C][C]0.2339[/C][C]78818955.523[/C][C]18802113.9211[/C][C]4336.1404[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=67554&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=67554&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
410.01950.002401233.744200
420.0336-0.02480.0136132488.781866861.263258.5754
430.0467-0.04480.024437427.5561190383.3607436.3294
440.0589-0.1190.04783124025.7153923793.9494961.142
450.0702-0.10440.05912424435.60271223922.281106.3102
460.0807-0.08010.06261434389.17031259000.09511122.0517
470.0904-0.14120.07384471162.40121717880.42451310.6794
480.0996-0.13740.08184243150.87752033539.23111426.0222
490.1081-0.19180.0948272107.90232726713.52791651.2763
500.1162-0.21820.106410719173.38123525959.51331877.7538
510.1238-0.22460.117211365458.40244238641.23042058.7961
520.131-0.18980.12328125049.61334562508.59572136.0029
530.1379-0.19890.1298922296.27144897876.87842213.1147
540.1445-0.2520.137814318185.99685570756.10122360.2449
550.1508-0.3440.151626698342.72266979261.87592641.8293
560.1568-0.35360.164228205082.50028305875.6652881.9916
570.1627-0.37870.176832348970.96849720175.38873117.7196
580.1683-0.52670.196362601152.771412658007.46553557.8094
590.1738-0.55450.215169379188.520715643332.78423955.1653
600.1791-0.5910.233978818955.52318802113.92114336.1404



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