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, 15 Dec 2008 11:52:47 -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/2008/Dec/15/t12293672209iz6rrdahb9oslj.htm/, Retrieved Tue, 28 May 2024 05:18:59 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=33784, Retrieved Tue, 28 May 2024 05:18:59 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact189
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [ARIMA Forecasting] [Step 1 ARIMA fore...] [2008-12-13 13:46:33] [38f43994ada0e6172896e12525dcc585]
F         [ARIMA Forecasting] [arima forecasting...] [2008-12-15 18:52:47] [ba53780e6ef414874481f097d8d35fc7] [Current]
Feedback Forum
2008-12-18 21:00:23 [Kim Wester] [reply
STAP 1
Correct. De lijnen vallen binnen het betrouwbaarheidsinterval van 95%. Ook in de Extrapolation Forecast valt de forecast binnen de stippellijn en loopt bijna gelijk met de werkelijke waarden (effen lijn).

STAP 2
Correct. Er is inderdaad een dalende trend waar te nemen. De reeks begint in periode 361 met 60.3993 en eindigt in periode 372 met 566.2788. Ik kan geen directe seizoenaliteit waarnemen, hiervoor zou je lags 12,24,36 etc. moeten bekijken.

STAP 3
Hoe verder vooruit voorspellen, hoe groter de standaardfout, hoe minder betrouwbaar de voorspelling. De student heeft hier het %S.E. verkeerd geïnterpreteerd. Dit moet nog x 100 worden gedaan. Wanneer de standaardfout dan op 5% wordt vastgesteld kan slechts 1 periode vooruit worden voorspeld om binnen deze 5% te vallen (0.0421).

STAP 4
Correct. P(F[t]>Y[t-s]) is kans op stijging IN ZELFDE MAAND ten opzichte van een jaar terug.

STAP 5
Correct. Met uitzonder van de verkeerde interpretatie van %S.E. maar deze heeft geen invloed door de goede PE.

OVERIG
De student heeft veel observaties betreft Unemployment Data. Waar gaat deze reeks precies over? Vrouwen, mannen, België etc.? Daarnaast betreft het cijfers als 235.1, is dit 235,1 werklozen? Of moet het nog maal honderd of duizend?
2008-12-21 19:03:26 [Roland Feldman] [reply
Correcte berekening zie uitleg vorige studente.
De student heeft de methode door.
2008-12-22 09:30:48 [Joris Deboel] [reply
Correcte uitwerking

Post a new message
Dataseries X:
235.1
280.7
264.6
240.7
201.4
240.8
241.1
223.8
206.1
174.7
203.3
220.5
299.5
347.4
338.3
327.7
351.6
396.6
438.8
395.6
363.5
378.8
357
369
464.8
479.1
431.3
366.5
326.3
355.1
331.6
261.3
249
205.5
235.6
240.9
264.9
253.8
232.3
193.8
177
213.2
207.2
180.6
188.6
175.4
199
179.6
225.8
234
200.2
183.6
178.2
203.2
208.5
191.8
172.8
148
159.4
154.5
213.2
196.4
182.8
176.4
153.6
173.2
171
151.2
161.9
157.2
201.7
236.4
356.1
398.3
403.7
384.6
365.8
368.1
367.9
347
343.3
292.9
311.5
300.9
366.9
356.9
329.7
316.2
269
289.3
266.2
253.6
233.8
228.4
253.6
260.1
306.6
309.2
309.5
271
279.9
317.9
298.4
246.7
227.3
209.1
259.9
266
320.6
308.5
282.2
262.7
263.5
313.1
284.3
252.6
250.3
246.5
312.7
333.2
446.4
511.6
515.5
506.4
483.2
522.3
509.8
460.7
405.8
375
378.5
406.8
467.8
469.8
429.8
355.8
332.7
378
360.5
334.7
319.5
323.1
363.6
352.1
411.9
388.6
416.4
360.7
338
417.2
388.4
371.1
331.5
353.7
396.7
447
533.5
565.4
542.3
488.7
467.1
531.3
496.1
444
403.4
386.3
394.1
404.1
462.1
448.1
432.3
386.3
395.2
421.9
382.9
384.2
345.5
323.4
372.6
376
462.7
487
444.2
399.3
394.9
455.4
414
375.5
347
339.4
385.8
378.8
451.8
446.1
422.5
383.1
352.8
445.3
367.5
355.1
326.2
319.8
331.8
340.9
394.1
417.2
369.9
349.2
321.4
405.7
342.9
316.5
284.2
270.9
288.8
278.8
324.4
310.9
299
273
279.3
359.2
305
282.1
250.3
246.5
257.9
266.5
315.9
318.4
295.4
266.4
245.8
362.8
324.9
294.2
289.5
295.2
290.3
272
307.4
328.7
292.9
249.1
230.4
361.5
321.7
277.2
260.7
251
257.6
241.8
287.5
292.3
274.7
254.2
230
339
318.2
287
295.8
284
271
262.7
340.6
379.4
373.3
355.2
338.4
466.9
451
422
429.2
425.9
460.7
463.6
541.4
544.2
517.5
469.4
439.4
549
533
506.1
484
457
481.5
469.5
544.7
541.2
521.5
469.7
434.4
542.6
517.3
485.7
465.8
447
426.6
411.6
467.5
484.5
451.2
417.4
379.9
484.7
455
420.8
416.5
376.3
405.6
405.8
500.8
514
475.5
430.1
414.4
538
526
488.5
520.2
504.4
568.5
610.6
818
830.9
835.9
782
762.3
856.9
820.9
769.6
752.2
724.4
723.1
719.5
817.4
803.3
752.5
689
630.4
765.5
757.7
732.2
702.6
683.3
709.5
702.2
784.8
810.9
755.6
656.8
615.1
745.3
694.1
675.7
643.7
622.1
634.6
588
689.7
673.9
647.9
568.8
545.7
632.6
643.8
593.1
579.7
546
562.9
572.5




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=33784&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[360])
348702.2-------
349784.8-------
350810.9-------
351755.6-------
352656.8-------
353615.1-------
354745.3-------
355694.1-------
356675.7-------
357643.7-------
358622.1-------
359634.6-------
360588-------
361689.7680.3933626.5038736.50580.37260.99941e-040.9994
362673.9678.9134598.7552764.10540.45410.4020.00120.9818
363647.9639.763535.7991752.93930.4440.27720.02240.815
364568.8574.9415456.0305707.61350.46390.14060.11330.4235
365545.7538.5441405.8807689.93550.46310.34760.16080.261
366632.6658.4138493.1503847.51790.39450.87860.18390.7672
367643.8628.0037451.4502833.62980.44020.48250.26430.6485
368593.1597.1427411.7656816.87330.48560.33860.24170.5325
369579.7580.9321386.0813815.45180.49590.45950.29990.4764
370546559.4979357.5999806.39570.45730.43630.30960.4105
371562.9578.3854362.242844.86920.45470.59410.33960.4718
372572.5566.2788342.9893845.25420.48260.50950.43940.4394

\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[360]) \tabularnewline
348 & 702.2 & - & - & - & - & - & - & - \tabularnewline
349 & 784.8 & - & - & - & - & - & - & - \tabularnewline
350 & 810.9 & - & - & - & - & - & - & - \tabularnewline
351 & 755.6 & - & - & - & - & - & - & - \tabularnewline
352 & 656.8 & - & - & - & - & - & - & - \tabularnewline
353 & 615.1 & - & - & - & - & - & - & - \tabularnewline
354 & 745.3 & - & - & - & - & - & - & - \tabularnewline
355 & 694.1 & - & - & - & - & - & - & - \tabularnewline
356 & 675.7 & - & - & - & - & - & - & - \tabularnewline
357 & 643.7 & - & - & - & - & - & - & - \tabularnewline
358 & 622.1 & - & - & - & - & - & - & - \tabularnewline
359 & 634.6 & - & - & - & - & - & - & - \tabularnewline
360 & 588 & - & - & - & - & - & - & - \tabularnewline
361 & 689.7 & 680.3933 & 626.5038 & 736.5058 & 0.3726 & 0.9994 & 1e-04 & 0.9994 \tabularnewline
362 & 673.9 & 678.9134 & 598.7552 & 764.1054 & 0.4541 & 0.402 & 0.0012 & 0.9818 \tabularnewline
363 & 647.9 & 639.763 & 535.7991 & 752.9393 & 0.444 & 0.2772 & 0.0224 & 0.815 \tabularnewline
364 & 568.8 & 574.9415 & 456.0305 & 707.6135 & 0.4639 & 0.1406 & 0.1133 & 0.4235 \tabularnewline
365 & 545.7 & 538.5441 & 405.8807 & 689.9355 & 0.4631 & 0.3476 & 0.1608 & 0.261 \tabularnewline
366 & 632.6 & 658.4138 & 493.1503 & 847.5179 & 0.3945 & 0.8786 & 0.1839 & 0.7672 \tabularnewline
367 & 643.8 & 628.0037 & 451.4502 & 833.6298 & 0.4402 & 0.4825 & 0.2643 & 0.6485 \tabularnewline
368 & 593.1 & 597.1427 & 411.7656 & 816.8733 & 0.4856 & 0.3386 & 0.2417 & 0.5325 \tabularnewline
369 & 579.7 & 580.9321 & 386.0813 & 815.4518 & 0.4959 & 0.4595 & 0.2999 & 0.4764 \tabularnewline
370 & 546 & 559.4979 & 357.5999 & 806.3957 & 0.4573 & 0.4363 & 0.3096 & 0.4105 \tabularnewline
371 & 562.9 & 578.3854 & 362.242 & 844.8692 & 0.4547 & 0.5941 & 0.3396 & 0.4718 \tabularnewline
372 & 572.5 & 566.2788 & 342.9893 & 845.2542 & 0.4826 & 0.5095 & 0.4394 & 0.4394 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=33784&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[360])[/C][/ROW]
[ROW][C]348[/C][C]702.2[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]349[/C][C]784.8[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]350[/C][C]810.9[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]351[/C][C]755.6[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]352[/C][C]656.8[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]353[/C][C]615.1[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]354[/C][C]745.3[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]355[/C][C]694.1[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]356[/C][C]675.7[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]357[/C][C]643.7[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]358[/C][C]622.1[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]359[/C][C]634.6[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]360[/C][C]588[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]361[/C][C]689.7[/C][C]680.3933[/C][C]626.5038[/C][C]736.5058[/C][C]0.3726[/C][C]0.9994[/C][C]1e-04[/C][C]0.9994[/C][/ROW]
[ROW][C]362[/C][C]673.9[/C][C]678.9134[/C][C]598.7552[/C][C]764.1054[/C][C]0.4541[/C][C]0.402[/C][C]0.0012[/C][C]0.9818[/C][/ROW]
[ROW][C]363[/C][C]647.9[/C][C]639.763[/C][C]535.7991[/C][C]752.9393[/C][C]0.444[/C][C]0.2772[/C][C]0.0224[/C][C]0.815[/C][/ROW]
[ROW][C]364[/C][C]568.8[/C][C]574.9415[/C][C]456.0305[/C][C]707.6135[/C][C]0.4639[/C][C]0.1406[/C][C]0.1133[/C][C]0.4235[/C][/ROW]
[ROW][C]365[/C][C]545.7[/C][C]538.5441[/C][C]405.8807[/C][C]689.9355[/C][C]0.4631[/C][C]0.3476[/C][C]0.1608[/C][C]0.261[/C][/ROW]
[ROW][C]366[/C][C]632.6[/C][C]658.4138[/C][C]493.1503[/C][C]847.5179[/C][C]0.3945[/C][C]0.8786[/C][C]0.1839[/C][C]0.7672[/C][/ROW]
[ROW][C]367[/C][C]643.8[/C][C]628.0037[/C][C]451.4502[/C][C]833.6298[/C][C]0.4402[/C][C]0.4825[/C][C]0.2643[/C][C]0.6485[/C][/ROW]
[ROW][C]368[/C][C]593.1[/C][C]597.1427[/C][C]411.7656[/C][C]816.8733[/C][C]0.4856[/C][C]0.3386[/C][C]0.2417[/C][C]0.5325[/C][/ROW]
[ROW][C]369[/C][C]579.7[/C][C]580.9321[/C][C]386.0813[/C][C]815.4518[/C][C]0.4959[/C][C]0.4595[/C][C]0.2999[/C][C]0.4764[/C][/ROW]
[ROW][C]370[/C][C]546[/C][C]559.4979[/C][C]357.5999[/C][C]806.3957[/C][C]0.4573[/C][C]0.4363[/C][C]0.3096[/C][C]0.4105[/C][/ROW]
[ROW][C]371[/C][C]562.9[/C][C]578.3854[/C][C]362.242[/C][C]844.8692[/C][C]0.4547[/C][C]0.5941[/C][C]0.3396[/C][C]0.4718[/C][/ROW]
[ROW][C]372[/C][C]572.5[/C][C]566.2788[/C][C]342.9893[/C][C]845.2542[/C][C]0.4826[/C][C]0.5095[/C][C]0.4394[/C][C]0.4394[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=33784&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=33784&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[360])
348702.2-------
349784.8-------
350810.9-------
351755.6-------
352656.8-------
353615.1-------
354745.3-------
355694.1-------
356675.7-------
357643.7-------
358622.1-------
359634.6-------
360588-------
361689.7680.3933626.5038736.50580.37260.99941e-040.9994
362673.9678.9134598.7552764.10540.45410.4020.00120.9818
363647.9639.763535.7991752.93930.4440.27720.02240.815
364568.8574.9415456.0305707.61350.46390.14060.11330.4235
365545.7538.5441405.8807689.93550.46310.34760.16080.261
366632.6658.4138493.1503847.51790.39450.87860.18390.7672
367643.8628.0037451.4502833.62980.44020.48250.26430.6485
368593.1597.1427411.7656816.87330.48560.33860.24170.5325
369579.7580.9321386.0813815.45180.49590.45950.29990.4764
370546559.4979357.5999806.39570.45730.43630.30960.4105
371562.9578.3854362.242844.86920.45470.59410.33960.4718
372572.5566.2788342.9893845.25420.48260.50950.43940.4394







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPESq.EMSERMSE
3610.04210.01370.001186.61497.21792.6866
3620.064-0.00746e-0425.13372.09451.4472
3630.09030.01270.001166.21075.51762.3489
3640.1177-0.01079e-0437.71823.14321.7729
3650.14340.01330.001151.20744.26732.0657
3660.1465-0.03920.0033666.350555.52927.4518
3670.16710.02520.0021249.522320.79354.56
3680.1877-0.00686e-0416.3431.36191.167
3690.206-0.00212e-041.51820.12650.3557
3700.2251-0.02410.002182.194415.18293.8965
3710.2351-0.02680.0022239.798419.98324.4703
3720.25140.0119e-0438.70313.22531.7959

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & Sq.E & MSE & RMSE \tabularnewline
361 & 0.0421 & 0.0137 & 0.0011 & 86.6149 & 7.2179 & 2.6866 \tabularnewline
362 & 0.064 & -0.0074 & 6e-04 & 25.1337 & 2.0945 & 1.4472 \tabularnewline
363 & 0.0903 & 0.0127 & 0.0011 & 66.2107 & 5.5176 & 2.3489 \tabularnewline
364 & 0.1177 & -0.0107 & 9e-04 & 37.7182 & 3.1432 & 1.7729 \tabularnewline
365 & 0.1434 & 0.0133 & 0.0011 & 51.2074 & 4.2673 & 2.0657 \tabularnewline
366 & 0.1465 & -0.0392 & 0.0033 & 666.3505 & 55.5292 & 7.4518 \tabularnewline
367 & 0.1671 & 0.0252 & 0.0021 & 249.5223 & 20.7935 & 4.56 \tabularnewline
368 & 0.1877 & -0.0068 & 6e-04 & 16.343 & 1.3619 & 1.167 \tabularnewline
369 & 0.206 & -0.0021 & 2e-04 & 1.5182 & 0.1265 & 0.3557 \tabularnewline
370 & 0.2251 & -0.0241 & 0.002 & 182.1944 & 15.1829 & 3.8965 \tabularnewline
371 & 0.2351 & -0.0268 & 0.0022 & 239.7984 & 19.9832 & 4.4703 \tabularnewline
372 & 0.2514 & 0.011 & 9e-04 & 38.7031 & 3.2253 & 1.7959 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=33784&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]361[/C][C]0.0421[/C][C]0.0137[/C][C]0.0011[/C][C]86.6149[/C][C]7.2179[/C][C]2.6866[/C][/ROW]
[ROW][C]362[/C][C]0.064[/C][C]-0.0074[/C][C]6e-04[/C][C]25.1337[/C][C]2.0945[/C][C]1.4472[/C][/ROW]
[ROW][C]363[/C][C]0.0903[/C][C]0.0127[/C][C]0.0011[/C][C]66.2107[/C][C]5.5176[/C][C]2.3489[/C][/ROW]
[ROW][C]364[/C][C]0.1177[/C][C]-0.0107[/C][C]9e-04[/C][C]37.7182[/C][C]3.1432[/C][C]1.7729[/C][/ROW]
[ROW][C]365[/C][C]0.1434[/C][C]0.0133[/C][C]0.0011[/C][C]51.2074[/C][C]4.2673[/C][C]2.0657[/C][/ROW]
[ROW][C]366[/C][C]0.1465[/C][C]-0.0392[/C][C]0.0033[/C][C]666.3505[/C][C]55.5292[/C][C]7.4518[/C][/ROW]
[ROW][C]367[/C][C]0.1671[/C][C]0.0252[/C][C]0.0021[/C][C]249.5223[/C][C]20.7935[/C][C]4.56[/C][/ROW]
[ROW][C]368[/C][C]0.1877[/C][C]-0.0068[/C][C]6e-04[/C][C]16.343[/C][C]1.3619[/C][C]1.167[/C][/ROW]
[ROW][C]369[/C][C]0.206[/C][C]-0.0021[/C][C]2e-04[/C][C]1.5182[/C][C]0.1265[/C][C]0.3557[/C][/ROW]
[ROW][C]370[/C][C]0.2251[/C][C]-0.0241[/C][C]0.002[/C][C]182.1944[/C][C]15.1829[/C][C]3.8965[/C][/ROW]
[ROW][C]371[/C][C]0.2351[/C][C]-0.0268[/C][C]0.0022[/C][C]239.7984[/C][C]19.9832[/C][C]4.4703[/C][/ROW]
[ROW][C]372[/C][C]0.2514[/C][C]0.011[/C][C]9e-04[/C][C]38.7031[/C][C]3.2253[/C][C]1.7959[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=33784&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=33784&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
3610.04210.01370.001186.61497.21792.6866
3620.064-0.00746e-0425.13372.09451.4472
3630.09030.01270.001166.21075.51762.3489
3640.1177-0.01079e-0437.71823.14321.7729
3650.14340.01330.001151.20744.26732.0657
3660.1465-0.03920.0033666.350555.52927.4518
3670.16710.02520.0021249.522320.79354.56
3680.1877-0.00686e-0416.3431.36191.167
3690.206-0.00212e-041.51820.12650.3557
3700.2251-0.02410.002182.194415.18293.8965
3710.2351-0.02680.0022239.798419.98324.4703
3720.25140.0119e-0438.70313.22531.7959



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