Home » date » 2010 » Nov » 27 »

*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, 27 Nov 2010 13:51:50 +0000
 
Cite this page as follows:
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg.htm/, Retrieved Sat, 27 Nov 2010 14:53:22 +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/Nov/27/t12908659926510i07axf12akg.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 «
1579 0 2146 0 2462 0 3695 0 4831 0 5134 0 6250 0 5760 0 6249 0 2917 0 1741 0 2359 0 1511 1 2059 0 2635 0 2867 0 4403 0 5720 0 4502 0 5749 0 5627 0 2846 0 1762 0 2429 0 1169 0 2154 1 2249 0 2687 0 4359 0 5382 0 4459 0 6398 0 4596 0 3024 0 1887 0 2070 0 1351 0 2218 0 2461 1 3028 0 4784 0 4975 0 4607 0 6249 0 4809 0 3157 0 1910 0 2228 0 1594 0 2467 0 2222 0 3607 1 4685 0 4962 0 5770 0 5480 0 5000 0 3228 0 1993 0 2288 0 1580 0 2111 0 2192 0 3601 0 4665 1 4876 0 5813 0 5589 0 5331 0 3075 0 2002 0 2306 0 1507 0 1992 0 2487 0 3490 0 4647 0 5594 1 5611 0 5788 0 6204 0 3013 0 1931 0 2549 0 1504 0 2090 0 2702 0 2939 0 4500 0 6208 0 6415 1 5657 0 5964 0 3163 0 1997 0 2422 0 1376 0 2202 0 2683 0 3303 0 5202 0 5231 0 4880 0 7998 1 4977 0 3531 0 2025 0 2205 0 1442 0 2238 0 2179 0 3218 0 5139 0 4990 0 4914 0 6084 0 5672 1 3548 0 1793 0 2086 0
 
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 time10 seconds
R Server'Gwilym Jenkins' @ 72.249.127.135


Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 3559.40540540541 + 893.594594594594X[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)3559.40540540541153.05500423.255700
X893.594594594594558.8778551.59890.1125150.056258


Multiple Linear Regression - Regression Statistics
Multiple R0.145622439036970
R-squared0.0212058947510761
Adjusted R-squared0.0129110294523564
F-TEST (value)2.55650863364222
F-TEST (DF numerator)1
F-TEST (DF denominator)118
p-value0.112515184877864
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation1612.53452664851
Sum Squared Residuals306831576.756757


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
115793559.4054054054-1980.40540540540
221463559.4054054054-1413.40540540540
324623559.40540540540-1097.40540540541
436953559.40540540541135.594594594595
548313559.405405405401271.59459459459
651343559.405405405401574.59459459459
762503559.405405405412690.59459459459
857603559.405405405412200.59459459459
962493559.405405405412689.59459459459
1029173559.40540540541-642.405405405405
1117413559.40540540540-1818.40540540541
1223593559.40540540540-1200.40540540541
1315114453-2942
1420593559.40540540540-1500.40540540541
1526353559.40540540541-924.405405405405
1628673559.40540540541-692.405405405405
1744033559.40540540541843.594594594595
1857203559.405405405412160.59459459459
1945023559.40540540541942.594594594595
2057493559.405405405412189.59459459459
2156273559.405405405412067.59459459459
2228463559.40540540541-713.405405405405
2317623559.40540540540-1797.40540540541
2424293559.40540540540-1130.40540540541
2511693559.40540540541-2390.40540540541
2621544453-2299
2722493559.40540540540-1310.40540540541
2826873559.40540540541-872.405405405405
2943593559.40540540541799.594594594595
3053823559.405405405401822.59459459459
3144593559.40540540541899.594594594595
3263983559.405405405412838.59459459459
3345963559.405405405401036.59459459459
3430243559.40540540541-535.405405405405
3518873559.40540540540-1672.40540540541
3620703559.40540540540-1489.40540540541
3713513559.40540540541-2208.40540540541
3822183559.40540540540-1341.40540540541
3924614453-1992
4030283559.40540540541-531.405405405405
4147843559.405405405401224.59459459459
4249753559.405405405401415.59459459459
4346073559.405405405401047.59459459459
4462493559.405405405412689.59459459459
4548093559.405405405401249.59459459459
4631573559.40540540541-402.405405405405
4719103559.40540540540-1649.40540540541
4822283559.40540540540-1331.40540540541
4915943559.40540540540-1965.40540540541
5024673559.40540540540-1092.40540540541
5122223559.40540540540-1337.40540540541
5236074453-846
5346853559.405405405401125.59459459459
5449623559.405405405401402.59459459459
5557703559.405405405412210.59459459459
5654803559.405405405411920.59459459459
5750003559.405405405401440.59459459459
5832283559.40540540541-331.405405405405
5919933559.40540540540-1566.40540540541
6022883559.40540540540-1271.40540540541
6115803559.40540540540-1979.40540540541
6221113559.40540540540-1448.40540540541
6321923559.40540540540-1367.40540540541
6436013559.4054054054141.5945945945947
6546654453212.000000000000
6648763559.405405405401316.59459459459
6758133559.405405405412253.59459459459
6855893559.405405405412029.59459459459
6953313559.405405405401771.59459459459
7030753559.40540540541-484.405405405405
7120023559.40540540540-1557.40540540541
7223063559.40540540540-1253.40540540541
7315073559.40540540541-2052.40540540541
7419923559.40540540540-1567.40540540541
7524873559.40540540540-1072.40540540541
7634903559.40540540541-69.4054054054053
7746473559.405405405401087.59459459459
78559444531141
7956113559.405405405412051.59459459459
8057883559.405405405412228.59459459459
8162043559.405405405412644.59459459459
8230133559.40540540541-546.405405405405
8319313559.40540540540-1628.40540540541
8425493559.40540540541-1010.40540540541
8515043559.40540540541-2055.40540540541
8620903559.40540540540-1469.40540540541
8727023559.40540540541-857.405405405405
8829393559.40540540541-620.405405405405
8945003559.40540540541940.594594594595
9062083559.405405405412648.59459459459
91641544531962
9256573559.405405405412097.59459459459
9359643559.405405405412404.59459459459
9431633559.40540540541-396.405405405405
9519973559.40540540540-1562.40540540541
9624223559.40540540540-1137.40540540541
9713763559.40540540541-2183.40540540541
9822023559.40540540540-1357.40540540541
9926833559.40540540541-876.405405405405
10033033559.40540540541-256.405405405405
10152023559.405405405401642.59459459459
10252313559.405405405401671.59459459459
10348803559.405405405401320.59459459459
104799844533545
10549773559.405405405401417.59459459459
10635313559.40540540541-28.4054054054053
10720253559.40540540540-1534.40540540541
10822053559.40540540540-1354.40540540541
10914423559.40540540541-2117.40540540541
11022383559.40540540540-1321.40540540541
11121793559.40540540540-1380.40540540541
11232183559.40540540541-341.405405405405
11351393559.405405405401579.59459459459
11449903559.405405405401430.59459459459
11549143559.405405405401354.59459459459
11660843559.405405405412524.59459459459
117567244531219
11835483559.40540540541-11.4054054054053
11917933559.40540540540-1766.40540540541
12020863559.40540540540-1473.40540540541


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
50.5393773723477070.9212452553045860.460622627652293
60.604286841366130.791426317267740.39571315863387
70.7728706873107640.4542586253784730.227129312689236
80.7852052968909180.4295894062181640.214794703109082
90.822850690294810.3542986194103810.177149309705190
100.7833801592167580.4332396815664840.216619840783242
110.8213716741948930.3572566516102150.178628325805107
120.7994928096907530.4010143806184950.200507190309247
130.7578599495527310.4842801008945370.242140050447269
140.751108318725410.497783362549180.24889168127459
150.7034644003113230.5930711993773540.296535599688677
160.6414743975752830.7170512048494340.358525602424717
170.5857618921097650.828476215780470.414238107890235
180.6334934428687430.7330131142625140.366506557131257
190.5786722931684810.8426554136630390.421327706831519
200.6150754195374950.769849160925010.384924580462505
210.630927409728510.738145180542980.36907259027149
220.5887004099978020.8225991800043960.411299590002198
230.6239288594441630.7521422811116740.376071140555837
240.5990956321479310.8018087357041380.400904367852069
250.679116462001870.6417670759962610.320883537998131
260.6638567763349020.6722864473301970.336143223665098
270.6449325929973770.7101348140052450.355067407002623
280.6019685067588130.7960629864823740.398031493241187
290.5560804597459350.887839080508130.443919540254065
300.5724098356823490.8551803286353030.427590164317651
310.5286918228928640.9426163542142720.471308177107136
320.6439407195288940.7121185609422120.356059280471106
330.6059896365702850.7880207268594310.394010363429715
340.5583215687251330.8833568625497350.441678431274867
350.5721427302859610.8557145394280780.427857269714039
360.5693327057837540.8613345884324930.430667294216246
370.6230772038431150.753845592313770.376922796156885
380.6069129558230230.7861740883539540.393087044176977
390.6187763503118130.7624472993763740.381223649688187
400.5700883426769040.8598233146461920.429911657323096
410.5487734865355720.9024530269288550.451226513464428
420.5378990453380560.9242019093238870.462100954661944
430.506292137874460.987415724251080.49370786212554
440.6072468763090980.7855062473818040.392753123690902
450.5852445791119290.8295108417761430.414755420888071
460.5363963259056930.9272073481886150.463603674094308
470.5459107469443340.9081785061113330.454089253055666
480.5328715422138080.9342569155723840.467128457786192
490.5648426930213930.8703146139572140.435157306978607
500.5377120861010190.9245758277979620.462287913898981
510.5231179344854760.9537641310290480.476882065514524
520.5402512795074540.9194974409850930.459748720492546
530.5151040215377530.9697919569244950.484895978462247
540.5050347838528260.9899304322943470.494965216147174
550.5581761709923680.8836476580152640.441823829007632
560.5848686212673260.8302627574653490.415131378732674
570.5773409579402960.8453180841194070.422659042059704
580.5278471449171190.9443057101657610.472152855082881
590.5292950085515350.941409982896930.470704991448465
600.5120355641815620.9759288716368760.487964435818438
610.5446350937819970.9107298124360060.455364906218003
620.5376110062174640.9247779875650710.462388993782536
630.5257269305073130.9485461389853750.474273069492687
640.4729462010074330.9458924020148670.527053798992567
650.489106580613220.978213161226440.51089341938678
660.4737957243570780.9475914487141570.526204275642922
670.5321354488107710.9357291023784570.467864551189229
680.5707753468347660.8584493063304670.429224653165233
690.5892117317234620.8215765365530760.410788268276538
700.5409989601810940.9180020796378110.459001039818906
710.538952135639810.922095728720380.46104786436019
720.5186191837982450.962761632403510.481380816201755
730.5568745723734970.8862508552530060.443125427626503
740.5575721308519670.8848557382960660.442427869148033
750.5296314100262640.9407371799474720.470368589973736
760.4750564437836570.9501128875673150.524943556216343
770.4461937279897620.8923874559795240.553806272010238
780.4528614922944490.9057229845888980.547138507705551
790.4917887915876410.9835775831752810.508211208412359
800.5519722999051050.896055400189790.448027700094895
810.6632536181250370.6734927637499270.336746381874963
820.6142905347740790.7714189304518430.385709465225921
830.6136308577291980.7727382845416040.386369142270802
840.5780631393576640.8438737212846720.421936860642336
850.6162123619921260.7675752760157480.383787638007874
860.6095120852029080.7809758295941840.390487914797092
870.5695834269857260.8608331460285490.430416573014274
880.5202147854359490.9595704291281020.479785214564051
890.4796023634970960.9592047269941930.520397636502903
900.5942481594736790.8115036810526420.405751840526321
910.5801998090783930.8396003818432140.419800190921607
920.6354868174867010.7290263650265980.364513182513299
930.7333799123937560.5332401752124880.266620087606244
940.6776320966235140.6447358067529710.322367903376486
950.6662554999771320.6674890000457360.333744500022868
960.6296013491655790.7407973016688420.370398650834421
970.6830921079609260.6338157840781470.316907892039074
980.6674714090592180.6650571818815640.332528590940782
990.6232806801737590.7534386396524820.376719319826241
1000.5546725218089840.8906549563820320.445327478191016
1010.5570150628827480.8859698742345030.442984937117252
1020.5710504386983960.8578991226032080.428949561301604
1030.5593701584453520.8812596831092950.440629841554648
1040.6116985139963060.7766029720073880.388301486003694
1050.6180744012674220.7638511974651560.381925598732578
1060.5346925314395660.9306149371208690.465307468560434
1070.5004002998287220.9991994003425550.499599700171277
1080.4555281998267820.9110563996535640.544471800173218
1090.5163778166898740.9672443666202510.483622183310126
1100.4942855647680840.9885711295361680.505714435231916
1110.5002797219553810.9994405560892380.499720278044619
1120.4087047006009830.8174094012019670.591295299399017
1130.3447711874344880.6895423748689770.655228812565512
1140.2788510291695390.5577020583390780.721148970830461
1150.2237614235884850.447522847176970.776238576411515


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level00OK
10% type I error level00OK
 
Charts produced by software:
http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/10vgdt1290865899.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/10vgdt1290865899.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/16xg01290865899.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/16xg01290865899.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/2hpx21290865899.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/2hpx21290865899.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/3hpx21290865899.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/3hpx21290865899.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/4hpx21290865899.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/4hpx21290865899.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/5rye51290865899.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/5rye51290865899.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/6rye51290865899.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/6rye51290865899.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/727eq1290865899.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/727eq1290865899.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/827eq1290865899.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/827eq1290865899.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/9vgdt1290865899.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/27/t12908659926510i07axf12akg/9vgdt1290865899.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