Home » date » 2011 » May » 19 »

IKO opdracht 10 werknemers x1000 Marin Peeters MAR 201B

*Unverified author*
R Software Module: /rwasp_exponentialsmoothing.wasp (opens new window with default values)
Title produced by software: Exponential Smoothing
Date of computation: Thu, 19 May 2011 17:08:50 +0000
 
Cite this page as follows:
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL http://www.freestatistics.org/blog/date/2011/May/19/t1305824721tgbo67h6o6a1z5v.htm/, Retrieved Thu, 19 May 2011 19:05:21 +0200
 
Original text written by user:
 
IsPrivate?
No (this computation is public)
 
User-defined keywords:
KDGP2W102
 
Dataseries X:
» Textbox « » Textfile « » CSV «
3893.9 3799.2 3769.6 3768.6 3854.9 3778.5 3779.7 3803.2 3900.3 3792.6 3767.4 3752.6 3829.6 3722.6 3692.9 3681 3762.9 3661.7 3633.1 3621.5 3710 3619.4 3595.2 3573.2 3650.1 3554.2 3537 3528.6 3597.1 3521.9 3516.5 3515.7 3600.2 3517.1 3513.7 3528.2 3608.3 3502.5 3502.5 3495.3 3543.8 3425.3 3418.4 3406.4 3446.1 3341.1 3347 3354.9 3399 3288.9 3279 3275.2 3314 3227.1 3225.3 3228.6 3287.1 3210.1 3213.1 3228 3287 3211 3199.8 3166.3 3164 3156.7 3156 3165.5 3179.2 3182.5 3179.5 3193.5 3219.6 3221.9 3210.1
 
Output produced by software:


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


Estimated Parameters of Exponential Smoothing
ParameterValue
alpha0.445237169833869
beta0.612003677861392
gammaFALSE


Interpolation Forecasts of Exponential Smoothing
tObservedFittedResiduals
33769.63704.565.1000000000004
43768.63656.52382948956112.076170510439
53854.93660.00247161576194.897528384241
63778.53753.463261726825.0367382732024
73779.73778.117894713491.58210528650579
83803.23792.7607560734810.4392439265207
93900.33814.1917007945386.1082992054698
103792.63892.77669518382-100.176695183817
113767.43861.12386024016-93.7238602401621
123752.63806.80555386658-54.2055538665822
133829.63755.3119692522874.288030747723
143722.63781.27101128997-58.6710112899746
153692.93732.04467048096-39.1446704809555
1636813680.845776963750.154223036247913
173762.93647.18623531314115.713764686859
183661.73696.50856870722-34.8085687072203
193633.13669.32788939067-36.2278893906732
203621.53631.64365462591-10.1436546259124
2137103602.80907888328107.190921116724
223619.43655.42432709343-36.0243270934257
233595.23634.45867042543-39.2586704254254
243573.23601.3554949804-28.1554949803985
253650.13565.5238656264784.5761343735298
263554.23602.93042685883-48.7304268588314
2735373567.70555467901-30.7055546790061
283528.63532.13916768493-3.53916768492809
293597.13507.7038895250489.396110474961
303521.93549.00611036664-27.1061103666352
313516.53531.05115524126-14.5511552412599
323515.73514.721135286890.97886471310676
333600.23505.5723851635594.627614836454
343517.13563.90431408603-46.8043140860273
353513.73546.51193416001-32.8119341600068
363528.23526.408663407541.79133659246281
373608.33522.2001705416586.0998294583528
383502.53578.99001818999-76.4900181899939
393502.53542.54630305138-40.0463030513847
403495.33511.41659611134-16.1165961113352
413543.83486.5497246973157.2502753026897
423425.33509.9484549551-84.6484549550992
433418.43447.10301076511-28.7030107651117
443406.43401.345366674995.05463332500585
453446.13371.9952012862274.1047987137754
463341.13393.58131450031-52.4813145003081
4733473344.506120241842.49387975816398
483354.93320.587475164734.3125248353044
4933993320.18538316378.8146168369981
503288.93361.07321824492-72.1732182449191
5132793315.06940871984-36.0694087198367
523275.23275.31191993245-0.111919932451201
5333143251.5335449844762.4664550155285
543227.13272.63867211733-45.538672117329
553225.33233.24721573869-7.94721573868628
563228.63208.4273617380220.1726382619786
573287.13201.6242893029985.4757106970142
583210.13247.18757366303-37.0875736630287
593213.13228.07525444115-14.9752544411522
6032283214.7276027039913.2723972960116
6132873217.5734083552669.4265916447443
6232113264.3389773553-53.3389773552994
633199.83241.91058538151-42.1105853815075
643166.33213.00691282751-46.7069128275116
6531643169.32976791475-5.32976791474857
663156.73142.6229745724214.0770254275817
6731563128.3926103809627.6073896190378
683165.53127.7091161011437.7908838988646
693179.23141.8572084667337.3427915332682
703182.53165.9812106806116.5187893193915
713179.53185.33474488548-5.83474488547881
723193.53193.145763907370.35423609262898
733219.63203.8088719582915.7911280417143
743221.93225.6479318105-3.74793181049927
753210.13237.76621406174-27.6662140617373


Extrapolation Forecasts of Exponential Smoothing
tForecast95% Lower Bound95% Upper Bound
763231.696510280643119.257039051533344.13598150976
773237.944833348423099.54250057613376.34716612074
783244.193156416193066.565658858643421.82065397374
793250.441479483963023.045330897983477.83762806995
803256.689802551742971.1989017993542.18070330448
813262.938125619512912.485456721963613.39079451707
823269.186448687282847.852291808913690.52060556566
833275.434771755062777.94240252333772.92714098681
843281.683094822832703.216987433723860.14920221194
853287.93141789062624.02403067393951.83880510731
863294.179740958382540.637433692834047.72204822392
873300.428064026152453.280252426164147.57587562614
 
Charts produced by software:
http://www.freestatistics.org/blog/date/2011/May/19/t1305824721tgbo67h6o6a1z5v/1hjvo1305824926.png (open in new window)
http://www.freestatistics.org/blog/date/2011/May/19/t1305824721tgbo67h6o6a1z5v/1hjvo1305824926.ps (open in new window)


http://www.freestatistics.org/blog/date/2011/May/19/t1305824721tgbo67h6o6a1z5v/2pzpl1305824926.png (open in new window)
http://www.freestatistics.org/blog/date/2011/May/19/t1305824721tgbo67h6o6a1z5v/2pzpl1305824926.ps (open in new window)


http://www.freestatistics.org/blog/date/2011/May/19/t1305824721tgbo67h6o6a1z5v/3trem1305824926.png (open in new window)
http://www.freestatistics.org/blog/date/2011/May/19/t1305824721tgbo67h6o6a1z5v/3trem1305824926.ps (open in new window)


 
Parameters (Session):
par1 = 12 ; par2 = Double ; par3 = additive ;
 
Parameters (R input):
par1 = 12 ; par2 = Double ; par3 = additive ;
 
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=F, beta=F)
if (par2 == 'Double') fit <- HoltWinters(x, gamma=F)
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