Home » date » 2008 » Dec » 14 »

Prof Bach regressie 1 aug 2007 zonder trend

*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: Sun, 14 Dec 2008 10:08:52 -0700
 
Cite this page as follows:
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL http://www.freestatistics.org/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0.htm/, Retrieved Sun, 14 Dec 2008 18:18:41 +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/2008/Dec/14/t1229275121gw0uo401exj6xd0.htm/},
    year = {2008},
}
@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 = {2008},
    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 «
13363 0 12530 0 11420 0 10948 0 10173 0 10602 0 16094 0 19631 0 17140 0 14345 0 12632 0 12894 0 11808 0 10673 0 9939 0 9890 0 9283 0 10131 0 15864 0 19283 0 16203 0 13919 0 11937 0 11795 0 11268 0 10522 0 9929 0 9725 0 9372 0 10068 0 16230 0 19115 0 18351 0 16265 0 14103 0 14115 0 13327 0 12618 0 12129 0 11775 0 11493 0 12470 0 20792 0 22337 0 21325 0 18581 0 16475 0 16581 0 15745 0 14453 0 13712 0 13766 0 13336 0 15346 0 24446 0 26178 0 24628 0 21282 0 18850 0 18822 0 18060 0 17536 0 16417 0 15842 0 15188 0 16905 0 25430 0 27962 0 26607 0 23364 0 20827 0 20506 0 19181 0 18016 0 17354 0 16256 0 15770 0 17538 0 26899 0 28915 0 25247 0 22856 0 19980 0 19856 0 16994 0 16839 0 15618 0 15883 0 15513 0 17106 0 25272 0 26731 0 22891 0 19583 0 16939 0 16757 0 15435 0 14786 0 13680 0 13208 0 12707 0 14277 0 22436 0 23229 1 18241 1 16145 1 13994 1 14780 1 13100 1 12329 1 12463 1 11532 1 10784 1 13106 1 19491 1 20418 1 16094 1 14491 1 13067 1
 
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 time8 seconds
R Server'Herman Ole Andreas Wold' @ 193.190.124.10:1001


Multiple Linear Regression - Estimated Regression Equation
NWWZPB[t] = + 16490.9198691742 -2312.27882256746Dummy[t] -1431.59198691742M1[t] -2229.49198691742M2[t] -2993.59198691742M3[t] -3377.19198691742M4[t] -3897.79198691741M5[t] -2504.79198691742M6[t] + 5035.70801308258M7[t] + 7351.43589533933M8[t] + 4644.23589533933M9[t] + 2054.63589533933M10[t] -148.06410466067M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)16490.91986917421040.71179515.845800
Dummy-2312.27882256746843.512355-2.74130.0071850.003593
M1-1431.591986917421428.723908-1.0020.3186220.159311
M2-2229.491986917421428.723908-1.56050.1216280.060814
M3-2993.591986917421428.723908-2.09530.0385270.019264
M4-3377.191986917421428.723908-2.36380.0199110.009956
M5-3897.791986917411428.723908-2.72820.0074570.003728
M6-2504.791986917421428.723908-1.75320.0824640.041232
M75035.708013082581428.7239083.52460.0006280.000314
M87351.435895339331430.6592875.13851e-061e-06
M94644.235895339331430.6592873.24620.0015660.000783
M102054.635895339331430.6592871.43610.1539050.076953
M11-148.064104660671430.659287-0.10350.9177670.458883


Multiple Linear Regression - Regression Statistics
Multiple R0.775783195581086
R-squared0.601839566546002
Adjusted R-squared0.556764800494606
F-TEST (value)13.3520286241699
F-TEST (DF numerator)12
F-TEST (DF denominator)106
p-value2.22044604925031e-16
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3109.44888314795
Sum Squared Residuals1024879269.83246


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11336315059.3278822567-1696.32788225675
21253014261.4278822567-1731.42788225674
31142013497.3278822567-2077.32788225674
41094813113.7278822567-2165.72788225674
51017312593.1278822567-2420.12788225675
61060213986.1278822567-3384.12788225675
71609421526.6278822567-5432.62788225674
81963123842.3557645135-4211.35576451349
91714021135.1557645135-3995.15576451349
101434518545.5557645135-4200.5557645135
111263216342.8557645135-3710.85576451349
121289416490.9198691742-3596.91986917416
131180815059.3278822567-3251.32788225675
141067314261.4278822567-3588.42788225675
15993913497.3278822567-3558.32788225675
16989013113.7278822567-3223.72788225675
17928312593.1278822567-3310.12788225675
181013113986.1278822567-3855.12788225675
191586421526.6278822567-5662.62788225674
201928323842.3557645135-4559.35576451349
211620321135.1557645135-4932.15576451349
221391918545.5557645135-4626.55576451349
231193716342.8557645135-4405.85576451349
241179516490.9198691742-4695.91986917416
251126815059.3278822567-3791.32788225674
261052214261.4278822567-3739.42788225675
27992913497.3278822567-3568.32788225675
28972513113.7278822567-3388.72788225675
29937212593.1278822567-3221.12788225675
301006813986.1278822567-3918.12788225675
311623021526.6278822567-5296.62788225674
321911523842.3557645135-4727.35576451349
331835121135.1557645135-2784.15576451349
341626518545.5557645135-2280.55576451349
351410316342.8557645135-2239.85576451349
361411516490.9198691742-2375.91986917416
371332715059.3278822567-1732.32788225675
381261814261.4278822567-1643.42788225675
391212913497.3278822567-1368.32788225675
401177513113.7278822567-1338.72788225675
411149312593.1278822567-1100.12788225675
421247013986.1278822567-1516.12788225675
432079221526.6278822567-734.627882256746
442233723842.3557645135-1505.35576451349
452132521135.1557645135189.844235486509
461858118545.555764513535.4442354865088
471647516342.8557645135132.144235486509
481658116490.919869174290.0801308258388
491574515059.3278822567685.672117743254
501445314261.4278822567191.572117743255
511371213497.3278822567214.672117743253
521376613113.7278822567652.272117743254
531333612593.1278822567742.872117743254
541534613986.12788225671359.87211774325
552444621526.62788225672919.37211774325
562617823842.35576451352335.64423548651
572462821135.15576451353492.84423548651
582128218545.55576451352736.44423548651
591885016342.85576451352507.14423548651
601882216490.91986917422331.08013082584
611806015059.32788225673000.67211774325
621753614261.42788225673274.57211774325
631641713497.32788225672919.67211774325
641584213113.72788225672728.27211774325
651518812593.12788225672594.87211774325
661690513986.12788225672918.87211774325
672543021526.62788225673903.37211774325
682796223842.35576451354119.64423548651
692660721135.15576451355471.84423548651
702336418545.55576451354818.44423548651
712082716342.85576451354484.14423548651
722050616490.91986917424015.08013082584
731918115059.32788225674121.67211774325
741801614261.42788225673754.57211774325
751735413497.32788225673856.67211774326
761625613113.72788225673142.27211774325
771577012593.12788225673176.87211774325
781753813986.12788225673551.87211774325
792689921526.62788225675372.37211774326
802891523842.35576451355072.64423548651
812524721135.15576451354111.84423548651
822285618545.55576451354310.44423548651
831998016342.85576451353637.14423548651
841985616490.91986917423365.08013082584
851699415059.32788225671934.67211774325
861683914261.42788225672577.57211774325
871561813497.32788225672120.67211774325
881588313113.72788225672769.27211774325
891551312593.12788225672919.87211774325
901710613986.12788225673119.87211774325
912527221526.62788225673745.37211774325
922673123842.35576451352888.64423548651
932289121135.15576451351755.84423548651
941958318545.55576451351037.44423548651
951693916342.8557645135596.144235486508
961675716490.9198691742266.080130825839
971543515059.3278822567375.672117743254
981478614261.4278822567524.572117743254
991368013497.3278822567182.672117743253
1001320813113.727882256794.2721177432538
1011270712593.1278822567113.872117743254
1021427713986.1278822567290.872117743255
1032243621526.6278822567909.372117743253
1042322921530.07694194601698.92305805397
1051824118822.8769419460-581.876941946035
1061614516233.2769419460-88.276941946034
1071399414030.5769419460-36.5769419460345
1081478014178.6410466067601.358953393296
1091310012747.0490596893352.950940310712
1101232911949.1490596893379.850940310712
1111246311185.04905968931277.95094031071
1121153210801.4490596893730.550940310712
1131078410280.8490596893503.150940310711
1141310611673.84905968931432.15094031071
1151949119214.3490596893276.650940310712
1162041821530.0769419460-1112.07694194603
1171609418822.8769419460-2728.87694194603
1181449116233.2769419460-1742.27694194603
1191306714030.5769419460-963.576941946035


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.08421738444415760.1684347688883150.915782615555842
170.03320203514856850.0664040702971370.966797964851432
180.01156663676335070.02313327352670150.98843336323665
190.004066461015829070.008132922031658140.99593353898417
200.001363997851284290.002727995702568580.998636002148716
210.0006031462258977940.001206292451795590.999396853774102
220.0002151710034649080.0004303420069298160.999784828996535
238.61034912603937e-050.0001722069825207870.99991389650874
244.90826036308051e-059.81652072616103e-050.99995091739637
254.1190603799295e-058.238120759859e-050.9999588093962
262.71556793382321e-055.43113586764641e-050.999972844320662
271.39652609587655e-052.79305219175310e-050.999986034739041
287.0086490159231e-061.40172980318462e-050.999992991350984
293.00055633973898e-066.00111267947796e-060.99999699944366
301.52140151437362e-063.04280302874725e-060.999998478598486
311.37675420479531e-062.75350840959062e-060.999998623245795
321.30538462101237e-062.61076924202473e-060.999998694615379
333.58449616437575e-067.1689923287515e-060.999996415503836
341.63801712482232e-053.27603424964463e-050.999983619828752
353.69827948991034e-057.39655897982067e-050.9999630172051
367.89113463016479e-050.0001578226926032960.999921088653698
378.96279764984394e-050.0001792559529968790.999910372023502
380.0001234223108308570.0002468446216617150.99987657768917
390.0002181721410354150.000436344282070830.999781827858965
400.0003350808037702060.0006701616075404120.99966491919623
410.0006255053940393860.001251010788078770.99937449460596
420.001863714179690990.003727428359381990.998136285820309
430.04751926823047910.09503853646095810.952480731769521
440.1380444640371900.2760889280743790.86195553596281
450.3099070764155340.6198141528310670.690092923584466
460.4755251642856410.9510503285712810.524474835714359
470.6101737121988050.7796525756023890.389826287801195
480.7302689412878520.5394621174242960.269731058712148
490.7927292917550120.4145414164899760.207270708244988
500.840403631939570.3191927361208600.159596368060430
510.8781255533038760.2437488933922480.121874446696124
520.9053775664585970.1892448670828060.094622433541403
530.9262617088172340.1474765823655330.0737382911827663
540.958801285498570.08239742900285890.0411987145014295
550.9919016679877560.01619666402448770.00809833201224383
560.997216406411890.005567187176219460.00278359358810973
570.9989768531185020.002046293762995680.00102314688149784
580.9993773002245390.001245399550922540.00062269977546127
590.999527509907520.0009449801849588440.000472490092479422
600.9996154945896870.0007690108206257780.000384505410312889
610.9996823780771860.0006352438456274070.000317621922813703
620.9997587761655330.0004824476689332840.000241223834466642
630.9997770272604130.0004459454791742860.000222972739587143
640.9997657767219220.0004684465561559830.000234223278077991
650.9997363873155920.0005272253688163370.000263612684408168
660.9997371741513190.0005256516973620760.000262825848681038
670.99981673524010.0003665295198009200.000183264759900460
680.999857397184630.0002852056307382630.000142602815369131
690.9999606372191287.87255617441137e-053.93627808720568e-05
700.9999802622475663.947550486721e-051.9737752433605e-05
710.9999875774003872.4845199225049e-051.24225996125245e-05
720.9999883860596642.32278806713434e-051.16139403356717e-05
730.9999910201980891.79596038227008e-058.97980191135042e-06
740.9999903071990611.93856018777517e-059.69280093887587e-06
750.9999898453951172.03092097664312e-051.01546048832156e-05
760.9999849093376723.01813246556691e-051.50906623278345e-05
770.999977802666884.43946662409892e-052.21973331204946e-05
780.9999688504779366.22990441282865e-053.11495220641432e-05
790.9999846912314483.06175371050798e-051.53087685525399e-05
800.9999892644980232.14710039541850e-051.07355019770925e-05
810.9999950390566239.92188675414077e-064.96094337707038e-06
820.9999982755367613.44892647754887e-061.72446323877444e-06
830.9999989406901822.11861963694115e-061.05930981847057e-06
840.9999988898758952.22024821008485e-061.11012410504243e-06
850.9999974141772765.17164544897424e-062.58582272448712e-06
860.9999954126935839.17461283409436e-064.58730641704718e-06
870.9999891906670252.16186659506241e-051.08093329753121e-05
880.9999836081191273.2783761746893e-051.63918808734465e-05
890.9999795736991744.0852601652346e-052.0426300826173e-05
900.9999696486775746.07026448519516e-053.03513224259758e-05
910.9999803780909143.92438181725552e-051.96219090862776e-05
920.99997488712995.0225740200059e-052.51128701000295e-05
930.9999925891115881.48217768244930e-057.41088841224648e-06
940.9999919881251811.60237496375266e-058.01187481876329e-06
950.9999833071574023.33856851966503e-051.66928425983251e-05
960.999934853324080.0001302933518391546.51466759195769e-05
970.9997669199741580.0004661600516835660.000233080025841783
980.999237117448620.001525765102759720.000762882551379858
990.9976139004250570.004772199149886650.00238609957494332
1000.9925044265165670.01499114696686660.00749557348343329
1010.9778202133034640.04435957339307250.0221797866965362
1020.9486353091959940.1027293816080120.0513646908040058
1030.8673209270833040.2653581458333920.132679072916696


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level680.772727272727273NOK
5% type I error level720.818181818181818NOK
10% type I error level750.852272727272727NOK
 
Charts produced by software:
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/10iw8j1229274518.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/10iw8j1229274518.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/1cgsw1229274518.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/1cgsw1229274518.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/21t6e1229274518.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/21t6e1229274518.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/3674g1229274518.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/3674g1229274518.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/424va1229274518.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/424va1229274518.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/5lpgi1229274518.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/5lpgi1229274518.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/6tc2b1229274518.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/6tc2b1229274518.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/7u6r71229274518.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/7u6r71229274518.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/8esu41229274518.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/8esu41229274518.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/958941229274518.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/14/t1229275121gw0uo401exj6xd0/958941229274518.ps (open in new window)


 
Parameters (Session):
par1 = 1 ; par2 = Include Monthly Dummies ; par3 = No Linear Trend ;
 
Parameters (R input):
par1 = 1 ; par2 = Include Monthly Dummies ; par3 = No 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