Home » date » 2010 » Dec » 11 »

Paper MR Time Series

*The author of this computation has been verified*
R Software Module: /rwasp_multipleregression.wasp (opens new window with default values)
Title produced by software: Multiple Regression
Date of computation: Sat, 11 Dec 2010 10:40:35 +0000
 
Cite this page as follows:
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa.htm/, Retrieved Sat, 11 Dec 2010 11:39:36 +0100
 
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/2010/Dec/11/t1292063965uyzbahwa5bhf4qa.htm/},
    year = {2010},
}
@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 = {2010},
    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 «
17848 19592 21092 20899 25890 24965 22225 20977 22897 22785 22769 19637 20203 20450 23083 21738 26766 25280 22574 22729 21378 22902 24989 21116 15169 15846 20927 18273 22538 15596 14034 11366 14861 15149 13577 13026 13190 13196 15826 14733 16307 15703 14589 12043 15057 14053 12698 10888 10045 11549 13767 12434 13116 14211 12266 12602 15714 13742 12745 10491 10057 10900 11771 11992 11933 14504 11727 11477 13578 11555 11846 11397 10066 10269 14279 13870 13695 14420 11424 9704 12464 14301 13464 9893 11572 12380 16692 16052 16459 14761 13654 13480 18068 16560 14530 10650 11651 13735 13360 17818 20613 16231 13862 12004 17734 15034 12609 12320 10833 11350 13648 14890 16325 18045 15616 11926 16855 15083 12520 12355
 
Output produced by software:

Enter (or paste) a matrix (table) containing all data (time) series. Every column represents a different variable and must be delimited by a space or Tab. Every row represents a period in time (or category) and must be delimited by hard returns. The easiest way to enter data is to copy and paste a block of spreadsheet cells. Please, do not use commas or spaces to seperate groups of digits!


Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time13 seconds
R Server'Gwilym Jenkins' @ 72.249.127.135


Multiple Linear Regression - Estimated Regression Equation
Pas[t] = + 17765.0666666667 -878.527777777783M1[t] + 54.2838383838423M2[t] + 2641.59545454547M3[t] + 2536.50707070707M4[t] + 4700.31868686869M5[t] + 3777.23030303032M6[t] + 1672.24191919192M7[t] + 375.453535353541M8[t] + 3474.76515151516M9[t] + 2800.07676767677M10[t] + 1927.88838383839M11[t] -69.5116161616161t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)17765.06666666671143.00544115.542400
M1-878.5277777777831417.702817-0.61970.5367830.268392
M254.28383838384231417.1828370.03830.9695170.484758
M32641.595454545471416.7122131.86460.0649790.032489
M42536.507070707071416.2909971.7910.0761290.038064
M54700.318686868691415.9192313.31960.0012330.000617
M63777.230303030321415.5969552.66830.008810.004405
M71672.241919191921415.3242031.18150.2400130.120007
M8375.4535353535411415.1010030.26530.7912740.395637
M93474.765151515161414.9273782.45580.0156670.007834
M102800.076767676771414.8033481.97910.0503710.025185
M111927.888383838391414.7289241.36270.175830.087915
t-69.51161616161618.37822-8.296700


Multiple Linear Regression - Regression Statistics
Multiple R0.696874486476466
R-squared0.485634049901839
Adjusted R-squared0.42794814895625
F-TEST (value)8.41859175190675
F-TEST (DF numerator)12
F-TEST (DF denominator)107
p-value5.10929076824596e-11
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3163.37457068026
Sum Squared Residuals1070742438.16364


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11784816817.02727272731030.97272727265
21959217680.32727272731911.67272727273
32109220198.1272727273893.872727272738
42089920023.5272727273875.472727272716
52589022117.82727272723772.17272727275
62496521125.22727272733839.77272727273
72222518950.72727272733274.27272727271
82097717584.42727272733392.57272727273
92289720614.22727272732282.77272727273
102278519870.02727272732914.97272727272
112276918928.32727272733840.67272727273
121963716930.92727272732706.07272727273
132020315982.88787878794220.11212121213
142045016846.18787878793603.81212121212
152308319363.98787878793719.01212121212
162173819189.38787878792548.61212121212
172676621283.68787878795482.31212121212
182528020291.08787878794988.91212121212
192257418116.58787878794457.41212121213
202272916750.28787878795978.71212121212
212137819780.08787878791597.91212121212
222290219035.88787878793866.11212121212
232498918094.18787878796894.81212121213
242111616096.78787878795019.21212121213
251516915148.748484848520.2515151515273
261584616012.0484848485-166.048484848485
272092718529.84848484852397.15151515152
281827318355.2484848485-82.2484848484826
292253820449.54848484852088.45151515152
301559619456.9484848485-3860.94848484848
311403417282.4484848485-3248.44848484848
321136615916.1484848485-4550.14848484848
331486118945.9484848485-4084.94848484848
341514918201.7484848485-3052.74848484848
351357717260.0484848485-3683.04848484848
361302615262.6484848485-2236.64848484848
371319014314.6090909091-1124.60909090908
381319615177.9090909091-1981.90909090909
391582617695.7090909091-1869.70909090909
401473317521.1090909091-2788.10909090909
411630719615.4090909091-3308.40909090909
421570318622.8090909091-2919.80909090909
431458916448.3090909091-1859.30909090909
441204315082.0090909091-3039.00909090909
451505718111.8090909091-3054.80909090909
461405317367.6090909091-3314.60909090909
471269816425.9090909091-3727.90909090909
481088814428.5090909091-3540.50909090908
491004513480.4696969697-3435.46969696969
501154914343.7696969697-2794.7696969697
511376716861.5696969697-3094.5696969697
521243416686.9696969697-4252.9696969697
531311618781.2696969697-5665.2696969697
541421117788.6696969697-3577.6696969697
551226615614.1696969697-3348.16969696969
561260214247.8696969697-1645.86969696970
571571417277.6696969697-1563.66969696970
581374216533.4696969697-2791.46969696970
591274515591.7696969697-2846.76969696970
601049113594.3696969697-3103.36969696969
611005712646.3303030303-2589.33030303029
621090013509.6303030303-2609.63030303030
631177116027.4303030303-4256.43030303031
641199215852.8303030303-3860.8303030303
651193317947.1303030303-6014.1303030303
661450416954.5303030303-2450.53030303031
671172714780.0303030303-3053.0303030303
681147713413.7303030303-1936.73030303030
691357816443.5303030303-2865.53030303030
701155515699.3303030303-4144.3303030303
711184614757.6303030303-2911.6303030303
721139712760.2303030303-1363.2303030303
731006611812.1909090909-1746.1909090909
741026912675.4909090909-2406.49090909091
751427915193.2909090909-914.290909090911
761387015018.6909090909-1148.69090909091
771369517112.9909090909-3417.99090909091
781442016120.3909090909-1700.39090909091
791142413945.8909090909-2521.89090909091
80970412579.5909090909-2875.59090909091
811246415609.3909090909-3145.39090909091
821430114865.1909090909-564.190909090909
831346413923.4909090909-459.49090909091
84989311926.0909090909-2033.09090909091
851157210978.0515151515593.948484848494
861238011841.3515151515538.648484848482
871669214359.15151515152332.84848484848
881605214184.55151515151867.44848484848
891645916278.8515151515180.148484848486
901476115286.2515151515-525.251515151519
911365413111.7515151515542.248484848486
921348011745.45151515151734.54848484848
931806814775.25151515153292.74848484848
941656014031.05151515152528.94848484848
951453013089.35151515151440.64848484848
961065011091.9515151515-441.951515151513
971165110143.91212121211507.08787878789
981373511007.21212121212727.78787878788
991336013525.0121212121-165.012121212124
1001781813350.41212121214467.58787878788
1012061315444.71212121215168.28787878788
1021623114452.11212121211778.88787878787
1031386212277.61212121211584.38787878788
1041200410911.31212121211092.68787878788
1051773413941.11212121213792.88787878788
1061503413196.91212121211837.08787878788
1071260912255.2121212121353.787878787878
1081232010257.81212121212062.18787878788
109108339309.772727272721523.22727272728
1101135010173.07272727271176.92727272727
1111364812690.8727272727957.12727272727
1121489012516.27272727272373.72727272727
1131632514610.57272727271714.42727272727
1141804513617.97272727274427.02727272727
1151561611443.47272727274172.52727272727
1161192610077.17272727271848.82727272727
1171685513106.97272727273748.02727272727
1181508312362.77272727272720.22727272727
1191252011421.07272727271098.92727272727
120123559423.672727272732931.32727272727


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.008184384545522340.01636876909104470.991815615454478
170.001918711341441530.003837422682883060.998081288658558
180.0008436644125731230.001687328825146250.999156335587427
190.0003041989900978640.0006083979801957290.999695801009902
200.0001182822516846620.0002365645033693250.999881717748315
210.0008768266113424410.001753653222684880.999123173388658
220.0004455691744321220.0008911383488642450.999554430825568
230.0008004582911997480.001600916582399500.9991995417088
240.0008605387184112840.001721077436822570.999139461281589
250.08021747258865530.1604349451773110.919782527411345
260.2490160517614720.4980321035229430.750983948238528
270.2982822285998810.5965644571997630.701717771400119
280.3643403813013640.7286807626027270.635659618698636
290.6516880232629530.6966239534740940.348311976737047
300.9844014267486680.03119714650266340.0155985732513317
310.9974140815629380.005171836874124520.00258591843706226
320.9998326638739470.0003346722521062730.000167336126053136
330.9998620999301160.0002758001397676830.000137900069883841
340.999904516315220.0001909673695596429.5483684779821e-05
350.999977781961264.44360774804318e-052.22180387402159e-05
360.99998400388223.19922355998216e-051.59961177999108e-05
370.9999880323340652.39353318695689e-051.19676659347844e-05
380.9999857992642552.84014714892668e-051.42007357446334e-05
390.9999869638407852.60723184297822e-051.30361592148911e-05
400.9999785660334364.28679331270899e-052.14339665635450e-05
410.9999826252314773.47495370451106e-051.73747685225553e-05
420.9999739625725185.20748549638256e-052.60374274819128e-05
430.9999781218361164.37563277688306e-052.18781638844153e-05
440.9999684171349566.3165730087111e-053.15828650435555e-05
450.9999492722639520.0001014554720960705.07277360480351e-05
460.9999203156313970.0001593687372063397.96843686031697e-05
470.9998969142304150.0002061715391702330.000103085769585116
480.9998543585193460.0002912829613079890.000145641480653994
490.9997659908365910.0004680183268175600.000234009163408780
500.9996987109242310.0006025781515370090.000301289075768504
510.9995809205006270.0008381589987461890.000419079499373094
520.9993502704725050.001299459054990260.000649729527495128
530.9992324016641420.001535196671715290.000767598335857645
540.9988078758217340.002384248356531750.00119212417826587
550.9982256406700930.003548718659813450.00177435932990673
560.9987795197548620.002440960490275260.00122048024513763
570.9991860461440650.001627907711870720.000813953855935362
580.9989287419509170.002142516098166250.00107125804908312
590.9986689915526640.002662016894672890.00133100844733644
600.9981550970692810.003689805861437710.00184490293071886
610.9978067674231860.004386465153627940.00219323257681397
620.9973019618159470.005396076368105130.00269803818405256
630.996071139824750.007857720350501390.00392886017525070
640.9959401897328120.008119620534376710.00405981026718836
650.9974150240886870.005169951822626090.00258497591131304
660.9968221660679570.006355667864085710.00317783393204285
670.9956265227735850.008746954452830370.00437347722641518
680.9951250466553140.009749906689371440.00487495334468572
690.9944979270684640.01100414586307310.00550207293153656
700.9945417771687530.01091644566249370.00545822283124683
710.9920586634133260.01588267317334710.00794133658667354
720.99199151653290.01601696693419840.00800848346709921
730.9909208618918850.01815827621622940.00907913810811468
740.9893643814020270.02127123719594620.0106356185979731
750.989110878710450.02177824257910110.0108891212895505
760.9902291066687960.01954178666240730.00977089333120367
770.9932006726679420.01359865466411650.00679932733205827
780.9920278490609260.01594430187814840.0079721509390742
790.992467990778020.01506401844396060.00753200922198032
800.9925456281503440.01490874369931210.00745437184965606
810.9991514936224380.001697012755124160.00084850637756208
820.999161001506040.001677996987921690.000838998493960847
830.9987725340268970.002454931946205580.00122746597310279
840.9988912213523520.002217557295296620.00110877864764831
850.998629472671470.002741054657060780.00137052732853039
860.998257671315960.003484657368080160.00174232868404008
870.9993243430432450.001351313913508960.000675656956754481
880.9991967211082080.001606557783584340.000803278891792172
890.9993450737599490.001309852480102280.000654926240051142
900.9996587670154840.0006824659690320830.000341232984516042
910.9996432207204530.0007135585590948670.000356779279547434
920.9993976180022570.001204763995486910.000602381997743457
930.999099252716420.001801494567160830.000900747283580413
940.9985062258812760.002987548237447590.00149377411872379
950.997690854657540.004618290684918660.00230914534245933
960.9977823788251440.00443524234971240.0022176211748562
970.9951798440318340.009640311936331850.00482015596816592
980.9932743879278070.01345122414438560.00672561207219282
990.985398522615490.02920295476901910.0146014773845096
1000.9858839798807370.02823204023852530.0141160201192626
1010.9993727053804940.001254589239012730.000627294619506364
1020.999168438845050.001663122309897660.00083156115494883
1030.9998803026603460.0002393946793081960.000119697339654098
1040.9986169468901750.002766106219649790.00138305310982490


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level670.752808988764045NOK
5% type I error level840.943820224719101NOK
10% type I error level840.943820224719101NOK
 
Charts produced by software:
http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/10jbq41292064021.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/10jbq41292064021.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/1data1292064021.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/1data1292064021.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/2data1292064021.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/2data1292064021.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/351sv1292064021.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/351sv1292064021.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/451sv1292064021.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/451sv1292064021.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/5yb9y1292064021.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/5yb9y1292064021.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/6yb9y1292064021.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/6yb9y1292064021.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/79kqj1292064021.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/79kqj1292064021.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/89kqj1292064021.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/89kqj1292064021.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/99kqj1292064021.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/11/t1292063965uyzbahwa5bhf4qa/99kqj1292064021.ps (open in new window)


 
Parameters (Session):
par1 = 1 ; par2 = Include Monthly Dummies ; par3 = Linear Trend ;
 
Parameters (R input):
par1 = 1 ; par2 = Include Monthly Dummies ; par3 = Linear Trend ;
 
R code (references can be found in the software module):
library(lattice)
library(lmtest)
n25 <- 25 #minimum number of obs. for Goldfeld-Quandt test
par1 <- as.numeric(par1)
x <- t(y)
k <- length(x[1,])
n <- length(x[,1])
x1 <- cbind(x[,par1], x[,1:k!=par1])
mycolnames <- c(colnames(x)[par1], colnames(x)[1:k!=par1])
colnames(x1) <- mycolnames #colnames(x)[par1]
x <- x1
if (par3 == 'First Differences'){
x2 <- array(0, dim=c(n-1,k), dimnames=list(1:(n-1), paste('(1-B)',colnames(x),sep='')))
for (i in 1:n-1) {
for (j in 1:k) {
x2[i,j] <- x[i+1,j] - x[i,j]
}
}
x <- x2
}
if (par2 == 'Include Monthly Dummies'){
x2 <- array(0, dim=c(n,11), dimnames=list(1:n, paste('M', seq(1:11), sep ='')))
for (i in 1:11){
x2[seq(i,n,12),i] <- 1
}
x <- cbind(x, x2)
}
if (par2 == 'Include Quarterly Dummies'){
x2 <- array(0, dim=c(n,3), dimnames=list(1:n, paste('Q', seq(1:3), sep ='')))
for (i in 1:3){
x2[seq(i,n,4),i] <- 1
}
x <- cbind(x, x2)
}
k <- length(x[1,])
if (par3 == 'Linear Trend'){
x <- cbind(x, c(1:n))
colnames(x)[k+1] <- 't'
}
x
k <- length(x[1,])
df <- as.data.frame(x)
(mylm <- lm(df))
(mysum <- summary(mylm))
if (n > n25) {
kp3 <- k + 3
nmkm3 <- n - k - 3
gqarr <- array(NA, dim=c(nmkm3-kp3+1,3))
numgqtests <- 0
numsignificant1 <- 0
numsignificant5 <- 0
numsignificant10 <- 0
for (mypoint in kp3:nmkm3) {
j <- 0
numgqtests <- numgqtests + 1
for (myalt in c('greater', 'two.sided', 'less')) {
j <- j + 1
gqarr[mypoint-kp3+1,j] <- gqtest(mylm, point=mypoint, alternative=myalt)$p.value
}
if (gqarr[mypoint-kp3+1,2] < 0.01) numsignificant1 <- numsignificant1 + 1
if (gqarr[mypoint-kp3+1,2] < 0.05) numsignificant5 <- numsignificant5 + 1
if (gqarr[mypoint-kp3+1,2] < 0.10) numsignificant10 <- numsignificant10 + 1
}
gqarr
}
bitmap(file='test0.png')
plot(x[,1], type='l', main='Actuals and Interpolation', ylab='value of Actuals and Interpolation (dots)', xlab='time or index')
points(x[,1]-mysum$resid)
grid()
dev.off()
bitmap(file='test1.png')
plot(mysum$resid, type='b', pch=19, main='Residuals', ylab='value of Residuals', xlab='time or index')
grid()
dev.off()
bitmap(file='test2.png')
hist(mysum$resid, main='Residual Histogram', xlab='values of Residuals')
grid()
dev.off()
bitmap(file='test3.png')
densityplot(~mysum$resid,col='black',main='Residual Density Plot', xlab='values of Residuals')
dev.off()
bitmap(file='test4.png')
qqnorm(mysum$resid, main='Residual Normal Q-Q Plot')
qqline(mysum$resid)
grid()
dev.off()
(myerror <- as.ts(mysum$resid))
bitmap(file='test5.png')
dum <- cbind(lag(myerror,k=1),myerror)
dum
dum1 <- dum[2:length(myerror),]
dum1
z <- as.data.frame(dum1)
z
plot(z,main=paste('Residual Lag plot, lowess, and regression line'), ylab='values of Residuals', xlab='lagged values of Residuals')
lines(lowess(z))
abline(lm(z))
grid()
dev.off()
bitmap(file='test6.png')
acf(mysum$resid, lag.max=length(mysum$resid)/2, main='Residual Autocorrelation Function')
grid()
dev.off()
bitmap(file='test7.png')
pacf(mysum$resid, lag.max=length(mysum$resid)/2, main='Residual Partial Autocorrelation Function')
grid()
dev.off()
bitmap(file='test8.png')
opar <- par(mfrow = c(2,2), oma = c(0, 0, 1.1, 0))
plot(mylm, las = 1, sub='Residual Diagnostics')
par(opar)
dev.off()
if (n > n25) {
bitmap(file='test9.png')
plot(kp3:nmkm3,gqarr[,2], main='Goldfeld-Quandt test',ylab='2-sided p-value',xlab='breakpoint')
grid()
dev.off()
}
load(file='createtable')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Estimated Regression Equation', 1, TRUE)
a<-table.row.end(a)
myeq <- colnames(x)[1]
myeq <- paste(myeq, '[t] = ', sep='')
for (i in 1:k){
if (mysum$coefficients[i,1] > 0) myeq <- paste(myeq, '+', '')
myeq <- paste(myeq, mysum$coefficients[i,1], sep=' ')
if (rownames(mysum$coefficients)[i] != '(Intercept)') {
myeq <- paste(myeq, rownames(mysum$coefficients)[i], sep='')
if (rownames(mysum$coefficients)[i] != 't') myeq <- paste(myeq, '[t]', sep='')
}
}
myeq <- paste(myeq, ' + e[t]')
a<-table.row.start(a)
a<-table.element(a, myeq)
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,hyperlink('http://www.xycoon.com/ols1.htm','Multiple Linear Regression - Ordinary Least Squares',''), 6, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Variable',header=TRUE)
a<-table.element(a,'Parameter',header=TRUE)
a<-table.element(a,'S.D.',header=TRUE)
a<-table.element(a,'T-STAT<br />H0: parameter = 0',header=TRUE)
a<-table.element(a,'2-tail p-value',header=TRUE)
a<-table.element(a,'1-tail p-value',header=TRUE)
a<-table.row.end(a)
for (i in 1:k){
a<-table.row.start(a)
a<-table.element(a,rownames(mysum$coefficients)[i],header=TRUE)
a<-table.element(a,mysum$coefficients[i,1])
a<-table.element(a, round(mysum$coefficients[i,2],6))
a<-table.element(a, round(mysum$coefficients[i,3],4))
a<-table.element(a, round(mysum$coefficients[i,4],6))
a<-table.element(a, round(mysum$coefficients[i,4]/2,6))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable2.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Regression Statistics', 2, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Multiple R',1,TRUE)
a<-table.element(a, sqrt(mysum$r.squared))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'R-squared',1,TRUE)
a<-table.element(a, mysum$r.squared)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Adjusted R-squared',1,TRUE)
a<-table.element(a, mysum$adj.r.squared)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (value)',1,TRUE)
a<-table.element(a, mysum$fstatistic[1])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF numerator)',1,TRUE)
a<-table.element(a, mysum$fstatistic[2])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF denominator)',1,TRUE)
a<-table.element(a, mysum$fstatistic[3])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'p-value',1,TRUE)
a<-table.element(a, 1-pf(mysum$fstatistic[1],mysum$fstatistic[2],mysum$fstatistic[3]))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Residual Statistics', 2, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Residual Standard Deviation',1,TRUE)
a<-table.element(a, mysum$sigma)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Sum Squared Residuals',1,TRUE)
a<-table.element(a, sum(myerror*myerror))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable3.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Actuals, Interpolation, and Residuals', 4, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Time or Index', 1, TRUE)
a<-table.element(a, 'Actuals', 1, TRUE)
a<-table.element(a, 'Interpolation<br />Forecast', 1, TRUE)
a<-table.element(a, 'Residuals<br />Prediction Error', 1, TRUE)
a<-table.row.end(a)
for (i in 1:n) {
a<-table.row.start(a)
a<-table.element(a,i, 1, TRUE)
a<-table.element(a,x[i])
a<-table.element(a,x[i]-mysum$resid[i])
a<-table.element(a,mysum$resid[i])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable4.tab')
if (n > n25) {
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Goldfeld-Quandt test for Heteroskedasticity',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'p-values',header=TRUE)
a<-table.element(a,'Alternative Hypothesis',3,header=TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'breakpoint index',header=TRUE)
a<-table.element(a,'greater',header=TRUE)
a<-table.element(a,'2-sided',header=TRUE)
a<-table.element(a,'less',header=TRUE)
a<-table.row.end(a)
for (mypoint in kp3:nmkm3) {
a<-table.row.start(a)
a<-table.element(a,mypoint,header=TRUE)
a<-table.element(a,gqarr[mypoint-kp3+1,1])
a<-table.element(a,gqarr[mypoint-kp3+1,2])
a<-table.element(a,gqarr[mypoint-kp3+1,3])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable5.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Description',header=TRUE)
a<-table.element(a,'# significant tests',header=TRUE)
a<-table.element(a,'% significant tests',header=TRUE)
a<-table.element(a,'OK/NOK',header=TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'1% type I error level',header=TRUE)
a<-table.element(a,numsignificant1)
a<-table.element(a,numsignificant1/numgqtests)
if (numsignificant1/numgqtests < 0.01) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'5% type I error level',header=TRUE)
a<-table.element(a,numsignificant5)
a<-table.element(a,numsignificant5/numgqtests)
if (numsignificant5/numgqtests < 0.05) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'10% type I error level',header=TRUE)
a<-table.element(a,numsignificant10)
a<-table.element(a,numsignificant10/numgqtests)
if (numsignificant10/numgqtests < 0.1) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable6.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