Free Statistics

of Irreproducible Research!

Author's title

Author*Unverified author*
R Software Modulerwasp_arimaforecasting.wasp
Title produced by softwareARIMA Forecasting
Date of computationWed, 06 Mar 2013 06:41:33 -0500
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2013/Mar/06/t1362571801tdqo1hp6yafa1ky.htm/, Retrieved Fri, 03 May 2024 23:31:38 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=207517, Retrieved Fri, 03 May 2024 23:31:38 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact184
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [ARIMA Forecasting] [] [2013-03-06 11:41:33] [d41d8cd98f00b204e9800998ecf8427e] [Current]
Feedback Forum

Post a new message
Dataseries X:
1369
269
187
284
189
122
42
308
278
653
291
147
342
329
234
720
1090
1690
1953
614
1045
1746
703
708
1247
522
682
1473
1536
2402
1378
1355
1490
2114
1550
1202
1497
1227
1661
1972
2322
3089
2080
1769
2506
2615
2270
931
1496
1910
3080
2517
2886
3196
2470
2159
2815
3217
2475
1861




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time2 seconds
R Server'Gwilym Jenkins' @ jenkins.wessa.net

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

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







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[54])
423089-------
432080-------
441769-------
452506-------
462615-------
472270-------
48931-------
491496-------
501910-------
513080-------
522517-------
532886-------
543196-------
5524702706.96351752.71393661.21310.31320.15760.90110.1576
5621592543.21511368.01273718.41760.26080.54860.90170.1381
5728152918.29441518.00874318.58020.44250.85610.71810.3487
5832172973.01851389.14754556.88940.38140.57750.67110.3913
5924752798.39381047.57714549.21050.35870.31970.72290.3281
6018612120.0732217.55614022.59030.39480.35730.88970.1338

\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[54]) \tabularnewline
42 & 3089 & - & - & - & - & - & - & - \tabularnewline
43 & 2080 & - & - & - & - & - & - & - \tabularnewline
44 & 1769 & - & - & - & - & - & - & - \tabularnewline
45 & 2506 & - & - & - & - & - & - & - \tabularnewline
46 & 2615 & - & - & - & - & - & - & - \tabularnewline
47 & 2270 & - & - & - & - & - & - & - \tabularnewline
48 & 931 & - & - & - & - & - & - & - \tabularnewline
49 & 1496 & - & - & - & - & - & - & - \tabularnewline
50 & 1910 & - & - & - & - & - & - & - \tabularnewline
51 & 3080 & - & - & - & - & - & - & - \tabularnewline
52 & 2517 & - & - & - & - & - & - & - \tabularnewline
53 & 2886 & - & - & - & - & - & - & - \tabularnewline
54 & 3196 & - & - & - & - & - & - & - \tabularnewline
55 & 2470 & 2706.9635 & 1752.7139 & 3661.2131 & 0.3132 & 0.1576 & 0.9011 & 0.1576 \tabularnewline
56 & 2159 & 2543.2151 & 1368.0127 & 3718.4176 & 0.2608 & 0.5486 & 0.9017 & 0.1381 \tabularnewline
57 & 2815 & 2918.2944 & 1518.0087 & 4318.5802 & 0.4425 & 0.8561 & 0.7181 & 0.3487 \tabularnewline
58 & 3217 & 2973.0185 & 1389.1475 & 4556.8894 & 0.3814 & 0.5775 & 0.6711 & 0.3913 \tabularnewline
59 & 2475 & 2798.3938 & 1047.5771 & 4549.2105 & 0.3587 & 0.3197 & 0.7229 & 0.3281 \tabularnewline
60 & 1861 & 2120.0732 & 217.5561 & 4022.5903 & 0.3948 & 0.3573 & 0.8897 & 0.1338 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=207517&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[54])[/C][/ROW]
[ROW][C]42[/C][C]3089[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]43[/C][C]2080[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]44[/C][C]1769[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]45[/C][C]2506[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]46[/C][C]2615[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]47[/C][C]2270[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]48[/C][C]931[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]49[/C][C]1496[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]50[/C][C]1910[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]51[/C][C]3080[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]52[/C][C]2517[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]53[/C][C]2886[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]54[/C][C]3196[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]55[/C][C]2470[/C][C]2706.9635[/C][C]1752.7139[/C][C]3661.2131[/C][C]0.3132[/C][C]0.1576[/C][C]0.9011[/C][C]0.1576[/C][/ROW]
[ROW][C]56[/C][C]2159[/C][C]2543.2151[/C][C]1368.0127[/C][C]3718.4176[/C][C]0.2608[/C][C]0.5486[/C][C]0.9017[/C][C]0.1381[/C][/ROW]
[ROW][C]57[/C][C]2815[/C][C]2918.2944[/C][C]1518.0087[/C][C]4318.5802[/C][C]0.4425[/C][C]0.8561[/C][C]0.7181[/C][C]0.3487[/C][/ROW]
[ROW][C]58[/C][C]3217[/C][C]2973.0185[/C][C]1389.1475[/C][C]4556.8894[/C][C]0.3814[/C][C]0.5775[/C][C]0.6711[/C][C]0.3913[/C][/ROW]
[ROW][C]59[/C][C]2475[/C][C]2798.3938[/C][C]1047.5771[/C][C]4549.2105[/C][C]0.3587[/C][C]0.3197[/C][C]0.7229[/C][C]0.3281[/C][/ROW]
[ROW][C]60[/C][C]1861[/C][C]2120.0732[/C][C]217.5561[/C][C]4022.5903[/C][C]0.3948[/C][C]0.3573[/C][C]0.8897[/C][C]0.1338[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=207517&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=207517&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[54])
423089-------
432080-------
441769-------
452506-------
462615-------
472270-------
48931-------
491496-------
501910-------
513080-------
522517-------
532886-------
543196-------
5524702706.96351752.71393661.21310.31320.15760.90110.1576
5621592543.21511368.01273718.41760.26080.54860.90170.1381
5728152918.29441518.00874318.58020.44250.85610.71810.3487
5832172973.01851389.14754556.88940.38140.57750.67110.3913
5924752798.39381047.57714549.21050.35870.31970.72290.3281
6018612120.0732217.55614022.59030.39480.35730.88970.1338







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPESq.EMSERMSE
550.1799-0.0875056151.681300
560.2358-0.15110.1193147621.2533101886.4673319.1966
570.2448-0.03540.091310669.741171480.8919267.3591
580.27180.08210.08959526.996668492.4181261.7106
590.3192-0.11560.0943104583.548875710.6442275.1557
600.4578-0.12220.09967118.924874278.691272.5412

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & Sq.E & MSE & RMSE \tabularnewline
55 & 0.1799 & -0.0875 & 0 & 56151.6813 & 0 & 0 \tabularnewline
56 & 0.2358 & -0.1511 & 0.1193 & 147621.2533 & 101886.4673 & 319.1966 \tabularnewline
57 & 0.2448 & -0.0354 & 0.0913 & 10669.7411 & 71480.8919 & 267.3591 \tabularnewline
58 & 0.2718 & 0.0821 & 0.089 & 59526.9966 & 68492.4181 & 261.7106 \tabularnewline
59 & 0.3192 & -0.1156 & 0.0943 & 104583.5488 & 75710.6442 & 275.1557 \tabularnewline
60 & 0.4578 & -0.1222 & 0.099 & 67118.9248 & 74278.691 & 272.5412 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=207517&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]55[/C][C]0.1799[/C][C]-0.0875[/C][C]0[/C][C]56151.6813[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]56[/C][C]0.2358[/C][C]-0.1511[/C][C]0.1193[/C][C]147621.2533[/C][C]101886.4673[/C][C]319.1966[/C][/ROW]
[ROW][C]57[/C][C]0.2448[/C][C]-0.0354[/C][C]0.0913[/C][C]10669.7411[/C][C]71480.8919[/C][C]267.3591[/C][/ROW]
[ROW][C]58[/C][C]0.2718[/C][C]0.0821[/C][C]0.089[/C][C]59526.9966[/C][C]68492.4181[/C][C]261.7106[/C][/ROW]
[ROW][C]59[/C][C]0.3192[/C][C]-0.1156[/C][C]0.0943[/C][C]104583.5488[/C][C]75710.6442[/C][C]275.1557[/C][/ROW]
[ROW][C]60[/C][C]0.4578[/C][C]-0.1222[/C][C]0.099[/C][C]67118.9248[/C][C]74278.691[/C][C]272.5412[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=207517&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=207517&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
550.1799-0.0875056151.681300
560.2358-0.15110.1193147621.2533101886.4673319.1966
570.2448-0.03540.091310669.741171480.8919267.3591
580.27180.08210.08959526.996668492.4181261.7106
590.3192-0.11560.0943104583.548875710.6442275.1557
600.4578-0.12220.09967118.924874278.691272.5412



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