Home » date » 2009 » Jun » 02 »

Opgave 10 - Aantal maandelijkse passagiers - William Baeyaert 202

*Unverified author*
R Software Module: rwasp_exponentialsmoothing.wasp (opens new window with default values)
Title produced by software: Exponential Smoothing
Date of computation: Tue, 02 Jun 2009 06:55:53 -0600
 
Cite this page as follows:
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL http://www.freestatistics.org/blog/date/2009/Jun/02/t1243947385geicaenlp03vl0w.htm/, Retrieved Tue, 02 Jun 2009 14:56:25 +0200
 
BibTeX entries for LaTeX users:
@Manual{KEY,
    author = {{YOUR NAME}},
    publisher = {Office for Research Development and Education},
    title = {Statistical Computations at FreeStatistics.org, URL http://www.freestatistics.org/blog/date/2009/Jun/02/t1243947385geicaenlp03vl0w.htm/},
    year = {2009},
}
@Manual{R,
    title = {R: A Language and Environment for Statistical Computing},
    author = {{R Development Core Team}},
    organization = {R Foundation for Statistical Computing},
    address = {Vienna, Austria},
    year = {2009},
    note = {{ISBN} 3-900051-07-0},
    url = {http://www.R-project.org},
}
 
Original text written by user:
 
IsPrivate?
No (this computation is public)
 
User-defined keywords:
 
Dataseries X:
» Textbox « » Textfile « » CSV «
112 118 132 129 121 135 148 148 136 119 104 118 115 126 141 135 125 149 170 170 158 133 114 140 145 150 178 163 172 178 199 199 184 162 146 166 171 180 193 181 183 218 230 242 209 191 172 194 196 196 236 235 229 243 264 272 237 211 180 201 204 188 235 227 234 264 302 293 259 229 203 229 242 233 267 269 270 315 364 347 312 274 237 278 284 277 317 313 318 374 413 405 355 306 271 306 315 301 356 348 355 422 465 467 404 347 305 336 340 318 362 348 363 435 491 505 404 359 310 337 360 342 406 396 420 472 548 559 463 407 362 405 417 391 419 461 472 535 622 606 508 461 390 432
 
Output produced by software:


Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time3 seconds
R Server'Sir Ronald Aylmer Fisher' @ 193.190.124.24


Estimated Parameters of Exponential Smoothing
ParameterValue
alpha0.275592931492602
beta0.0326927269946913
gamma0.870730972375243


Interpolation Forecasts of Exponential Smoothing
tObservedFittedResiduals
13115111.0818087088673.91819129113324
14126122.3314538747443.66854612525647
15141137.4390153761593.56098462384085
16135132.3233832202962.67661677970437
17125123.4796828181491.52031718185104
18149147.667290233191.33270976680993
19170162.4432448019017.5567551980989
20170165.5295923942204.47040760577954
21158153.8877144649354.11228553506467
22133136.318642929538-3.31864292953799
23114119.090609201624-5.09060920162445
24140133.9887149606766.01128503932392
25145134.83037010966710.1696298903335
26150149.7051460153830.294853984617163
27178166.54082485992611.459175140074
28163161.7497291200721.25027087992819
29172149.75750588289222.2424941171083
30178185.647729927993-7.64772992799348
31199206.262157804506-7.26215780450633
32199203.180877899402-4.18087789940165
33184186.419241979637-2.41924197963704
34162158.1477827595293.85221724047076
35146138.3687169810757.63128301892533
36166169.141347816421-3.14134781642136
37171170.3609458701970.639054129803043
38180177.4381780479152.56182195208476
39193206.247937689474-13.2479376894740
40181185.96072416093-4.96072416092983
41183184.798364145761-1.7983641457605
42218195.6843597335522.3156402664498
43230227.4983879410402.50161205896046
44242229.00476968852012.9952303114803
45209215.630988418272-6.63098841827184
46191186.2865983510924.71340164890827
47172166.0376439935615.96235600643919
48194192.8425095100681.15749048993183
49196198.309952885672-2.30995288567220
50196206.984486038047-10.9844860380474
51236224.19294089622011.8070591037797
52235214.06541785566020.9345821443404
53229222.6752524471116.32474755288877
54243256.738013695478-13.7380136954783
55264268.357973304409-4.35797330440869
56272275.595124348777-3.59512434877661
57237240.950022441516-3.95002244151587
58211216.418700337473-5.41870033747318
59180191.302342357418-11.3023423574182
60201212.165187519306-11.1651875193057
61204211.884585973222-7.8845859732215
62188213.27848237778-25.2784823777802
63235241.844280631674-6.84428063167385
64227231.126644343173-4.12664434317313
65234222.84756235743411.1524376425660
66264244.40357368198319.5964263180174
67302270.92543678752731.0745632124733
68293288.4633043826434.53669561735745
69259253.3255731144335.67442688556693
70229228.4572425854860.542757414514483
71203198.7667237110574.23327628894268
72229226.325370930042.67462906995985
73242232.5076979211179.49230207888297
74233226.1554706830856.84452931691496
75267284.984135370836-17.9841353708361
76269271.954055875778-2.95405587577795
77270274.414364054023-4.41436405402328
78315301.11087543872713.8891245612733
79364337.4814839970326.5185160029703
80347335.98551213635611.0144878636440
81312297.83665553117314.163344468827
82274267.3004377139306.69956228607032
83237236.9925415061960.00745849380362529
84278266.90068203576511.0993179642347
85284281.6339304999882.36606950001163
86277269.9672327496987.0327672503015
87317320.174971097683-3.17497109768345
88313321.276901514021-8.27690151402084
89318322.045741716532-4.04574171653167
90374367.9511939083846.04880609161643
91413417.203241898467-4.20324189846684
92405394.60621928243210.3937807175679
93355352.3066369650032.69336303499716
94306308.449783989776-2.44978398977639
95271266.6963131926584.30368680734244
96306309.394151440327-3.39415144032654
97315315.103159698907-0.103159698907064
98301304.405343346895-3.40534334689534
99356349.0581654503576.94183454964292
100348349.292530352986-1.29253035298638
101355355.07317102392-0.0731710239201107
102422414.3609383733027.63906162669832
103465462.0911562758412.90884372415928
104467448.9797178527318.0202821472701
105404397.6350099221276.36499007787268
106347345.4509662878931.54903371210713
107305304.2430311120760.756968887923563
108336345.615225431214-9.6152254312135
109340352.616275490588-12.6162754905881
110318334.810864863463-16.8108648634631
111362386.941342201636-24.9413422016360
112348372.19081066778-24.1908106677798
113363372.090086438254-9.09008643825427
114435435.498520155351-0.498520155351457
115491478.41837009478412.5816299052164
116505476.29775492899328.7022450710072
117404417.219149854212-13.2191498542122
118359354.4369029627564.56309703724361
119310311.876475452214-1.87647545221392
120337345.975115388032-8.97511538803184
121360350.6430581403119.35694185968907
122342334.9945802071037.00541979289682
123406390.68587542554115.3141245744593
124396386.4988658447959.50113415520485
125420407.13076227323412.8692377267661
126472491.605011219989-19.6050112199886
127548543.7800465587614.21995344123911
128559549.9353273917319.06467260826867
129463449.6387467094113.3612532905901
130407399.9130342117787.08696578822219
131362348.3972126674713.6027873325298
132405386.65208470331218.3479152966885
133417413.9167814674463.08321853255381
134391392.451160427232-1.45116042723186
135419460.170497130599-41.1704971305986
136461435.42175557133825.5782444286622
137472465.0951028577886.90489714221167
138535534.3526743898890.647325610110556
139622616.7353661862345.26463381376573
140606627.551069242217-21.5510692422174
141508510.133139879421-2.13313987942115
142461446.16279163776914.8372083622311
143390395.452817969961-5.45281796996073
144432434.572452493994-2.57245249399358


Extrapolation Forecasts of Exponential Smoothing
tForecast95% Lower Bound95% Upper Bound
145447.055907793737427.306081839849466.805733747625
146419.712252491671399.132529133901440.291975849441
147464.867062938288442.962936376511486.771189500064
148496.083938082048472.83286932562519.335006838475
149507.532607460904483.137451881794531.927763040015
150575.450839384529548.708168067459602.1935107016
151666.592241551563636.628745108617696.555737994509
152657.91364795573627.18198410402688.645311807441
153550.308727275637521.63972761337578.977726937903
154492.985286976114465.015260234125520.955313718102
155420.2072394493393.468712587960446.94576631064
156465.63445928396443.300359438503487.968559129416
 
Charts produced by software:
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2009/Jun/02/t1243947385geicaenlp03vl0w/1dkk31243947346.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2009/Jun/02/t1243947385geicaenlp03vl0w/1dkk31243947346.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2009/Jun/02/t1243947385geicaenlp03vl0w/2zkgm1243947346.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2009/Jun/02/t1243947385geicaenlp03vl0w/2zkgm1243947346.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2009/Jun/02/t1243947385geicaenlp03vl0w/35jx31243947346.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2009/Jun/02/t1243947385geicaenlp03vl0w/35jx31243947346.ps (open in new window)


 
Parameters (Session):
par1 = 12 ; par2 = Triple ; par3 = multiplicative ;
 
Parameters (R input):
par1 = 12 ; par2 = Triple ; par3 = multiplicative ;
 
R code (references can be found in the software module):
par1 <- as.numeric(par1)
if (par2 == 'Single') K <- 1
if (par2 == 'Double') K <- 2
if (par2 == 'Triple') K <- par1
nx <- length(x)
nxmK <- nx - K
x <- ts(x, frequency = par1)
if (par2 == 'Single') fit <- HoltWinters(x, gamma=0, beta=0)
if (par2 == 'Double') fit <- HoltWinters(x, gamma=0)
if (par2 == 'Triple') fit <- HoltWinters(x, seasonal=par3)
fit
myresid <- x - fit$fitted[,'xhat']
bitmap(file='test1.png')
op <- par(mfrow=c(2,1))
plot(fit,ylab='Observed (black) / Fitted (red)',main='Interpolation Fit of Exponential Smoothing')
plot(myresid,ylab='Residuals',main='Interpolation Prediction Errors')
par(op)
dev.off()
bitmap(file='test2.png')
p <- predict(fit, par1, prediction.interval=TRUE)
np <- length(p[,1])
plot(fit,p,ylab='Observed (black) / Fitted (red)',main='Extrapolation Fit of Exponential Smoothing')
dev.off()
bitmap(file='test3.png')
op <- par(mfrow = c(2,2))
acf(as.numeric(myresid),lag.max = nx/2,main='Residual ACF')
spectrum(myresid,main='Residals Periodogram')
cpgram(myresid,main='Residal Cumulative Periodogram')
qqnorm(myresid,main='Residual Normal QQ Plot')
qqline(myresid)
par(op)
dev.off()
load(file='createtable')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Estimated Parameters of Exponential Smoothing',2,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Parameter',header=TRUE)
a<-table.element(a,'Value',header=TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'alpha',header=TRUE)
a<-table.element(a,fit$alpha)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'beta',header=TRUE)
a<-table.element(a,fit$beta)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'gamma',header=TRUE)
a<-table.element(a,fit$gamma)
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,'Interpolation Forecasts of Exponential Smoothing',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'t',header=TRUE)
a<-table.element(a,'Observed',header=TRUE)
a<-table.element(a,'Fitted',header=TRUE)
a<-table.element(a,'Residuals',header=TRUE)
a<-table.row.end(a)
for (i in 1:nxmK) {
a<-table.row.start(a)
a<-table.element(a,i+K,header=TRUE)
a<-table.element(a,x[i+K])
a<-table.element(a,fit$fitted[i,'xhat'])
a<-table.element(a,myresid[i])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable1.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Extrapolation Forecasts of Exponential Smoothing',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'t',header=TRUE)
a<-table.element(a,'Forecast',header=TRUE)
a<-table.element(a,'95% Lower Bound',header=TRUE)
a<-table.element(a,'95% Upper Bound',header=TRUE)
a<-table.row.end(a)
for (i in 1:np) {
a<-table.row.start(a)
a<-table.element(a,nx+i,header=TRUE)
a<-table.element(a,p[i,'fit'])
a<-table.element(a,p[i,'lwr'])
a<-table.element(a,p[i,'upr'])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable2.tab')
 





Copyright

Creative Commons License

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 License.

Software written by Ed van Stee & Patrick Wessa


Disclaimer

Information provided on this web site is provided "AS IS" without warranty of any kind, either express or implied, including, without limitation, warranties of merchantability, fitness for a particular purpose, and noninfringement. We use reasonable efforts to include accurate and timely information and periodically update the information, and software without notice. However, we make no warranties or representations as to the accuracy or completeness of such information (or software), and we assume no liability or responsibility for errors or omissions in the content of this web site, or any software bugs in online applications. Your use of this web site is AT YOUR OWN RISK. Under no circumstances and under no legal theory shall we be liable to you or any other person for any direct, indirect, special, incidental, exemplary, or consequential damages arising from your access to, or use of, this web site.


Privacy Policy

We may request personal information to be submitted to our servers in order to be able to:

  • personalize online software applications according to your needs
  • enforce strict security rules with respect to the data that you upload (e.g. statistical data)
  • manage user sessions of online applications
  • alert you about important changes or upgrades in resources or applications

We NEVER allow other companies to directly offer registered users information about their products and services. Banner references and hyperlinks of third parties NEVER contain any personal data of the visitor.

We do NOT sell, nor transmit by any means, personal information, nor statistical data series uploaded by you to third parties.

We carefully protect your data from loss, misuse, alteration, and destruction. However, at any time, and under any circumstance you are solely responsible for managing your passwords, and keeping them secret.

We store a unique ANONYMOUS USER ID in the form of a small 'Cookie' on your computer. This allows us to track your progress when using this website which is necessary to create state-dependent features. The cookie is used for NO OTHER PURPOSE. At any time you may opt to disallow cookies from this website - this will not affect other features of this website.

We examine cookies that are used by third-parties (banner and online ads) very closely: abuse from third-parties automatically results in termination of the advertising contract without refund. We have very good reason to believe that the cookies that are produced by third parties (banner ads) do NOT cause any privacy or security risk.

FreeStatistics.org is safe. There is no need to download any software to use the applications and services contained in this website. Hence, your system's security is not compromised by their use, and your personal data - other than data you submit in the account application form, and the user-agent information that is transmitted by your browser - is never transmitted to our servers.

As a general rule, we do not log on-line behavior of individuals (other than normal logging of webserver 'hits'). However, in cases of abuse, hacking, unauthorized access, Denial of Service attacks, illegal copying, hotlinking, non-compliance with international webstandards (such as robots.txt), or any other harmful behavior, our system engineers are empowered to log, track, identify, publish, and ban misbehaving individuals - even if this leads to ban entire blocks of IP addresses, or disclosing user's identity.


FreeStatistics.org is powered by