Home » date » 2008 » Dec » 18 »

Dummie

*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: Thu, 18 Dec 2008 06:54:29 -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/18/t12296085194h5l7b14vmxgmc2.htm/, Retrieved Thu, 18 Dec 2008 14:55:19 +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/18/t12296085194h5l7b14vmxgmc2.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 «
19 0 23 0 22 0 23 0 25 0 25 0 23 0 22 0 21 0 16 0 21 0 21 0 26 0 23 0 22 0 22 0 22 0 12 0 20 0 18 0 23 0 25 0 28 0 28 0 29 0 31 0 33 0 32 0 33 0 35 0 33 0 36 0 30 0 34 0 34 0 35 0 33 0 28 0 27 0 23 0 23 0 24 0 24 0 20 0 16 1 6 1 2 1 12 1 19 1 21 1 22 1 20 1 21 1 20 1 19 1 17 1 17 1 17 1 16 1 12 1 11 1 7 1 2 1 9 1 11 1 10 1 7 1 9 1 15 1 5 1 14 1 14 1 17 1 19 1 17 1 16 1 14 1 20 1 16 1 18 1 18 1 14 1 13 1 14 1 14 1 17 1 18 1 15 1 9 1 9 1 9 1 10 1 6 1 12 1 11 1 15 1 19 1 18 1 15 1 16 1 14 1 18 1 18 1 18 1 18 1 22 1 21 1 12 1 19 1 21 1 19 1 22 1 22 1 21 1 19 1 18 1 18 1 19 1 12 1 16 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 time7 seconds
R Server'Sir Ronald Aylmer Fisher' @ 193.190.124.24


Multiple Linear Regression - Estimated Regression Equation
Vertrouwen[t] = + 25.6136363636364 -10.5215311004785Aanslag[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)25.61363636363640.77876132.890200
Aanslag-10.52153110047850.978562-10.75200


Multiple Linear Regression - Regression Statistics
Multiple R0.703474736883576
R-squared0.494876705433416
Adjusted R-squared0.490595999547259
F-TEST (value)115.606331898133
F-TEST (DF numerator)1
F-TEST (DF denominator)118
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation5.1657174025047
Sum Squared Residuals3148.78708133971


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11925.6136363636364-6.61363636363642
22325.6136363636364-2.61363636363636
32225.6136363636364-3.61363636363636
42325.6136363636364-2.61363636363636
52525.6136363636364-0.613636363636363
62525.6136363636364-0.613636363636363
72325.6136363636364-2.61363636363636
82225.6136363636364-3.61363636363636
92125.6136363636364-4.61363636363636
101625.6136363636364-9.61363636363636
112125.6136363636364-4.61363636363636
122125.6136363636364-4.61363636363636
132625.61363636363640.386363636363637
142325.6136363636364-2.61363636363636
152225.6136363636364-3.61363636363636
162225.6136363636364-3.61363636363636
172225.6136363636364-3.61363636363636
181225.6136363636364-13.6136363636364
192025.6136363636364-5.61363636363636
201825.6136363636364-7.61363636363636
212325.6136363636364-2.61363636363636
222525.6136363636364-0.613636363636363
232825.61363636363642.38636363636364
242825.61363636363642.38636363636364
252925.61363636363643.38636363636364
263125.61363636363645.38636363636364
273325.61363636363647.38636363636364
283225.61363636363646.38636363636364
293325.61363636363647.38636363636364
303525.61363636363649.38636363636364
313325.61363636363647.38636363636364
323625.613636363636410.3863636363636
333025.61363636363644.38636363636364
343425.61363636363648.38636363636364
353425.61363636363648.38636363636364
363525.61363636363649.38636363636364
373325.61363636363647.38636363636364
382825.61363636363642.38636363636364
392725.61363636363641.38636363636364
402325.6136363636364-2.61363636363636
412325.6136363636364-2.61363636363636
422425.6136363636364-1.61363636363636
432425.6136363636364-1.61363636363636
442025.6136363636364-5.61363636363636
451615.09210526315790.907894736842105
46615.0921052631579-9.0921052631579
47215.0921052631579-13.0921052631579
481215.0921052631579-3.09210526315790
491915.09210526315793.90789473684210
502115.09210526315795.9078947368421
512215.09210526315796.9078947368421
522015.09210526315794.90789473684211
532115.09210526315795.9078947368421
542015.09210526315794.90789473684211
551915.09210526315793.90789473684210
561715.09210526315791.90789473684211
571715.09210526315791.90789473684211
581715.09210526315791.90789473684211
591615.09210526315790.907894736842105
601215.0921052631579-3.09210526315790
611115.0921052631579-4.09210526315789
62715.0921052631579-8.0921052631579
63215.0921052631579-13.0921052631579
64915.0921052631579-6.09210526315789
651115.0921052631579-4.09210526315789
661015.0921052631579-5.09210526315789
67715.0921052631579-8.0921052631579
68915.0921052631579-6.09210526315789
691515.0921052631579-0.0921052631578948
70515.0921052631579-10.0921052631579
711415.0921052631579-1.09210526315790
721415.0921052631579-1.09210526315790
731715.09210526315791.90789473684211
741915.09210526315793.90789473684210
751715.09210526315791.90789473684211
761615.09210526315790.907894736842105
771415.0921052631579-1.09210526315790
782015.09210526315794.90789473684211
791615.09210526315790.907894736842105
801815.09210526315792.90789473684211
811815.09210526315792.90789473684211
821415.0921052631579-1.09210526315790
831315.0921052631579-2.09210526315790
841415.0921052631579-1.09210526315790
851415.0921052631579-1.09210526315790
861715.09210526315791.90789473684211
871815.09210526315792.90789473684211
881515.0921052631579-0.0921052631578948
89915.0921052631579-6.09210526315789
90915.0921052631579-6.09210526315789
91915.0921052631579-6.09210526315789
921015.0921052631579-5.09210526315789
93615.0921052631579-9.0921052631579
941215.0921052631579-3.09210526315790
951115.0921052631579-4.09210526315789
961515.0921052631579-0.0921052631578948
971915.09210526315793.90789473684210
981815.09210526315792.90789473684211
991515.0921052631579-0.0921052631578948
1001615.09210526315790.907894736842105
1011415.0921052631579-1.09210526315790
1021815.09210526315792.90789473684211
1031815.09210526315792.90789473684211
1041815.09210526315792.90789473684211
1051815.09210526315792.90789473684211
1062215.09210526315796.9078947368421
1072115.09210526315795.9078947368421
1081215.0921052631579-3.09210526315790
1091915.09210526315793.90789473684210
1102115.09210526315795.9078947368421
1111915.09210526315793.90789473684210
1122215.09210526315796.9078947368421
1132215.09210526315796.9078947368421
1142115.09210526315795.9078947368421
1151915.09210526315793.90789473684210
1161815.09210526315792.90789473684211
1171815.09210526315792.90789473684211
1181915.09210526315793.90789473684210
1191215.0921052631579-3.09210526315790
1201615.09210526315790.907894736842105


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
50.1285163477791050.2570326955582090.871483652220895
60.07691700749853240.1538340149970650.923082992501468
70.03049932510294070.06099865020588140.96950067489706
80.01202596243546120.02405192487092240.987974037564539
90.005821216045101970.01164243209020390.994178783954898
100.03958657459575820.07917314919151630.960413425404242
110.02114997626941380.04229995253882760.978850023730586
120.01093162504369170.02186325008738350.989068374956308
130.01271682082316810.02543364164633620.987283179176832
140.006649036124994620.01329807224998920.993350963875005
150.003302320579803430.006604641159606870.996697679420197
160.001601519629308310.003203039258616630.998398480370692
170.0007612530607483320.001522506121496660.999238746939252
180.04090031283419480.08180062566838950.959099687165805
190.03166228825154750.06332457650309510.968337711748452
200.03518782607019930.07037565214039860.9648121739298
210.02649170163988760.05298340327977510.973508298360112
220.02479667760305820.04959335520611630.975203322396942
230.04220007517531690.08440015035063380.957799924824683
240.05971565345612630.1194313069122530.940284346543874
250.09024245922255370.1804849184451070.909757540777446
260.1668258891177400.3336517782354800.83317411088226
270.3231165465112030.6462330930224060.676883453488797
280.4280696209756940.8561392419513880.571930379024306
290.5510021346269430.8979957307461140.448997865373057
300.7174303555655430.5651392888689140.282569644434457
310.7768098762645480.4463802474709050.223190123735452
320.8832324927285240.2335350145429520.116767507271476
330.8737336606193950.2525326787612100.126266339380605
340.9096888863562850.1806222272874300.0903111136437151
350.9365456505702750.1269086988594490.0634543494297246
360.964603394236050.07079321152789810.0353966057639491
370.9743641056515870.05127178869682570.0256358943484128
380.968356948364140.06328610327172130.0316430516358607
390.9600911561577650.07981768768446970.0399088438422349
400.9492268373354850.1015463253290300.0507731626645149
410.9360514812200810.1278970375598380.0639485187799191
420.919217077906220.1615658441875610.0807829220937804
430.901223102139810.1975537957203810.0987768978601906
440.8925068796734450.2149862406531100.107493120326555
450.865645456063870.2687090878722600.134354543936130
460.9007263380550280.1985473238899430.0992736619449717
470.9563348657848640.08733026843027110.0436651342151356
480.9490139568033810.1019720863932380.0509860431966188
490.958246150597390.08350769880521850.0417538494026093
500.9695725500793270.06085489984134660.0304274499206733
510.9787570039716370.04248599205672690.0212429960283634
520.9786932287890560.04261354242188740.0213067712109437
530.980560567712740.03887886457452170.0194394322872609
540.979455928041690.04108814391662130.0205440719583107
550.9759089237923650.04818215241526930.0240910762076346
560.9683775557279740.06324488854405230.0316224442720262
570.959021320100060.081957359799880.04097867989994
580.9475687922481120.1048624155037750.0524312077518877
590.9323715342324350.135256931535130.067628465767565
600.9222229597152130.1555540805695730.0777770402847867
610.9162503681998350.167499263600330.083749631800165
620.9432321475256670.1135357049486660.0567678524743329
630.9900877981633470.01982440367330620.00991220183665308
640.991599723630140.01680055273972060.00840027636986032
650.9905212098328310.01895758033433770.00947879016716886
660.9907100410267460.01857991794650810.00928995897325404
670.9952198140915830.009560371816833940.00478018590841697
680.9963426721574050.007314655685190350.00365732784259518
690.9946366721946760.01072665561064800.00536332780532402
700.9989487719818730.002102456036253310.00105122801812666
710.9984537285197140.00309254296057170.00154627148028585
720.997756825599420.004486348801159660.00224317440057983
730.9967773569120480.006445286175903090.00322264308795155
740.9961836591319530.007632681736094460.00381634086804723
750.9945520381516250.01089592369675000.00544796184837501
760.992033179007360.01593364198528060.00796682099264029
770.9889486473429950.02210270531400940.0110513526570047
780.9885069212569870.02298615748602550.0114930787430127
790.9835680948025530.03286381039489370.0164319051974468
800.9787448381654920.04251032366901650.0212551618345083
810.972695178317680.05460964336464110.0273048216823206
820.9635028924252960.07299421514940880.0364971075747044
830.9546221640454080.09075567190918370.0453778359545918
840.9409885866136780.1180228267726450.0590114133863225
850.9243615429078060.1512769141843880.0756384570921942
860.9025272469288620.1949455061422770.0974727530711383
870.8805815512608550.2388368974782890.119418448739145
880.8483847895517880.3032304208964230.151615210448212
890.8813373347871590.2373253304256830.118662665212841
900.9143590790211760.1712818419576480.0856409209788242
910.945172011668670.1096559766626590.0548279883313293
920.9621171342310760.07576573153784860.0378828657689243
930.996428091977660.007143816044681490.00357190802234074
940.9975974407542790.004805118491442180.00240255924572109
950.9992055218928270.001588956214346220.00079447810717311
960.9989698321456030.002060335708793090.00103016785439654
970.9982480716400880.003503856719823160.00175192835991158
980.9968912254347160.006217549130568770.00310877456528439
990.9960635519749130.00787289605017440.0039364480250872
1000.9941349582543380.01173008349132480.00586504174566238
1010.994902859863890.01019428027221970.00509714013610987
1020.9910568585609450.01788628287810940.0089431414390547
1030.9846810419016710.03063791619665730.0153189580983287
1040.974421804085440.05115639182911980.0255781959145599
1050.958436267423560.08312746515288130.0415637325764407
1060.953753668053340.09249266389332120.0462463319466606
1070.9394242280359770.1211515439280450.0605757719640225
1080.975169199892620.049661600214760.02483080010738
1090.9543993000664670.0912013998670670.0456006999335335
1100.9338929989659180.1322140020681630.0661070010340815
1110.8854704242601030.2290591514797940.114529575739897
1120.8719015672090410.2561968655819180.128098432790959
1130.8737389210671630.2525221578656750.126261078932837
1140.8598089001461740.2803821997076510.140191099853826
1150.7687246935869170.4625506128261660.231275306413083


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level170.153153153153153NOK
5% type I error level450.405405405405405NOK
10% type I error level690.621621621621622NOK
 
Charts produced by software:
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/10tqzg1229608456.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/10tqzg1229608456.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/1tcm41229608456.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/1tcm41229608456.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/2i1fy1229608456.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/2i1fy1229608456.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/32u4g1229608456.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/32u4g1229608456.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/4feab1229608456.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/4feab1229608456.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/5jwe11229608456.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/5jwe11229608456.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/6iyzx1229608456.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/6iyzx1229608456.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/7m0eo1229608456.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/7m0eo1229608456.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/8icda1229608456.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/8icda1229608456.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/92j491229608456.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/18/t12296085194h5l7b14vmxgmc2/92j491229608456.ps (open in new window)


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