Home » date » 2010 » Nov » 23 »

WS 7 (4)

*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: Tue, 23 Nov 2010 10:16:31 +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/23/t1290507286qb11hditz9mcgvt.htm/, Retrieved Tue, 23 Nov 2010 11:14:46 +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/23/t1290507286qb11hditz9mcgvt.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 «
1.3954 1.0685 1.4790 1.1010 1.4619 1.0996 1.4670 1.0978 1.4799 1.0893 1.4508 1.1018 1.4678 1.0931 1.4824 1.0842 1.5189 1.0409 1.5348 1.0245 1.5666 0.9994 1.5446 1.0090 1.5803 0.9947 1.5718 1.0080 1.5832 0.9986 1.5801 1.0184 1.5605 1.0357 1.5416 1.0556 1.5479 1.0409 1.5580 1.0474 1.5790 1.0219 1.5554 1.0427 1.5761 1.0205 1.5360 1.0490 1.5621 1.0344 1.5773 1.0193 1.5710 1.0238 1.5925 1.0165 1.5844 1.0218 1.5696 1.0370 1.5540 1.0508 1.5012 1.0813 1.4676 1.0970 1.4770 1.0989 1.4660 1.1018 1.4241 1.1166 1.4214 1.1319 1.4469 1.1020 1.4618 1.0884 1.3834 1.1263 1.3412 1.1345 1.3437 1.1337 1.2630 1.1660 1.2759 1.1550 1.2743 1.1782 1.2797 1.1856 1.2573 1.2219 1.2705 1.2130 1.2680 1.2230 1.3371 1.1767 1.3885 1.1077 1.4060 1.0672 1.3855 1.0840 1.3431 1.1154 1.3257 1.1184 1.2978 1.1570 1.2793 1.1625 1.2945 1.1627 1.2890 1.1578 1.2848 1.1533 1.2694 1.1684 1.2636 1 etc...
 
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
eu/us[t] = + 3.14689431591185 -1.52758658767174`us/ch`[t] -0.00114121297467551t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)3.146894315911850.05106461.626200
`us/ch`-1.527586587671740.046768-32.662900
t-0.001141212974675518.7e-05-13.08400


Multiple Linear Regression - Regression Statistics
Multiple R0.960534672716085
R-squared0.922626857489797
Adjusted R-squared0.92110973704842
F-TEST (value)608.1434488172
F-TEST (DF numerator)2
F-TEST (DF denominator)102
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.0270799927376016
Sum Squared Residuals0.0747992526801926


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11.39541.51352683400991-0.118126834009909
21.4791.462739056935910.0162609430640904
31.46191.46373646518397-0.00183646518397477
41.4671.465344908067110.00165509193289207
51.47991.477188181087640.00271181891235740
61.45081.45695213576707-0.00615213576707027
71.46781.46910092610514-0.00130092610513892
81.48241.481555233760740.000844766239258157
91.51891.54655852003225-0.0276585200322531
101.53481.57046972709539-0.0356697270953941
111.56661.60767093747128-0.0410709374712793
121.54461.59186489325496-0.0472648932549552
131.58031.61256816848399-0.0322681684839853
141.57181.59111005389328-0.0193100538932756
151.58321.60432815484271-0.0211281548427146
161.58011.572940727432140.00715927256786147
171.56051.545372266490740.0151277335092582
181.54161.51383208042140.0277679195786015
191.54791.535146390285500.0127536097145021
201.5581.524075864490960.0339241355090443
211.5791.561888109501910.0171118904980901
221.55541.528973095503660.0264269044963377
231.57611.56174430477530.0143556952247007
241.5361.517066874051980.0189331259480208
251.56211.538228425257310.0238715747426889
261.57731.560153769756480.0171462302435212
271.5711.552138417137280.0188615828627195
281.59251.562148586252610.0303514137473912
291.58441.552911164363270.0314888356367271
301.56961.528550635255990.041049364744013
311.5541.506328727371440.0476712726285585
321.50121.458596123472780.0426038765272222
331.46761.433471801071660.0341281989283441
341.4771.429428173580400.047571826419596
351.4661.423856959501480.0421430404985193
361.42411.400107465029260.0239925349707368
371.42141.375594177263210.0458058227367899
381.44691.420127803259920.0267721967400806
391.46181.439761767877580.0220382321224202
401.38341.380725023230150.00267497676985486
411.34121.36705760023656-0.0258576002365614
421.34371.36713845653202-0.0234384565320235
431.2631.31665619677555-0.0536561967755506
441.27591.33231843626526-0.056418436265264
451.27431.29573721445660-0.0214372144566043
461.27971.28329186073316-0.00359186073315770
471.25731.226699254626000.0306007453740021
481.27051.23915356228160.0313464377183991
491.2681.222736483430210.0452635165697921
501.33711.292322529464730.0447774705352658
511.38851.39658479103941-0.00808479103940915
521.4061.45731083486544-0.0513108348654394
531.38551.43050616721788-0.0450061672178783
541.34311.38139873539031-0.0382987353903103
551.32571.37567476265262-0.0499747626526192
561.29781.31556870739381-0.0177687073938144
571.27931.30602576818694-0.0267257681869442
581.29451.30457903789473-0.0100790378947345
591.2891.31092299919965-0.0219229991996508
601.28481.31665592586950-0.0318559258694980
611.26941.29244815542098-0.0230481554209789
621.26361.30459694575905-0.0409969457590478
631.291.259002963083120.0309970369168756
641.35591.348294876098620.00760512390138371
651.33051.327600554801740.00289944519825767
661.34821.342804518315150.00539548168484533
671.31461.301335019425950.0132649805740548
681.30271.286292768503460.0164072314965433
691.32471.32807673864236-0.00337673864235721
701.32671.33212932006577-0.00542932006576573
711.36211.37559363545110-0.0134936354511049
721.34791.34894172646231-0.00104172646231135
731.40111.40691811443053-0.00581811443053234
741.41351.43159311478751-0.0180931147875092
751.39641.40188603262337-0.00548603262337207
761.4011.41159068442117-0.0105906844211662
771.39551.40938016083512-0.0138801608351203
781.40771.405489292002640.00221070799736438
791.39751.396404628772070.00109537122793278
801.39491.39923514092534-0.00433514092533808
811.41381.412758759192310.00104124080768851
821.4211.417116857933250.00388314206674577
831.42531.419489094110220.00581090588977628
841.41691.396961668908140.0199383310918563
851.41741.408346665952380.00905333404762343
861.43461.434396494238260.000203505761741944
871.42961.428367004183030.00123299581696705
881.43111.428295101819730.00280489818027217
891.45941.46121906975013-0.00181906975013220
901.47221.47260406679436-0.000404066794365051
911.46691.47039354320832-0.00349354320831896
921.45711.46054508668391-0.00344508668391482
931.47091.463681116154720.00721888384527997
941.48931.483620598089910.00567940191008534
951.49971.496533181721820.00316681827818095
961.47131.470339548709330.00096045129067302
971.48461.482641097706160.00195890229383685
981.49141.489596093646150.00180390635385247
991.48591.479594878462980.00630512153702406
1001.49571.495409876611460.00029012338854309
1011.48431.478381763125000.00591823687500459
1021.46191.450966060842370.0109339391576343
1031.4341.43714587919001-0.00314587919001482
1041.44261.44623949635274-0.00363949635273973
1051.43181.44632035264820-0.0145203526482020


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
60.5647492589718330.8705014820563340.435250741028167
70.4016399038830820.8032798077661650.598360096116918
80.372557796208740.745115592417480.62744220379126
90.6763503013338580.6472993973322830.323649698666142
100.6427088266423380.7145823467153230.357291173357662
110.6425245901619450.7149508196761110.357475409838055
120.6147927583984280.7704144832031450.385207241601572
130.5825791378556290.8348417242887430.417420862144371
140.5196476796712680.9607046406574650.480352320328732
150.4708205404062780.9416410808125550.529179459593722
160.3959188599852510.7918377199705010.604081140014749
170.3806476185538270.7612952371076540.619352381446173
180.3902823388804390.7805646777608790.60971766111956
190.3878749848749650.775749969749930.612125015125035
200.3264962939364260.6529925878728510.673503706063574
210.2681586674949860.5363173349899720.731841332505014
220.2430989254436960.4861978508873920.756901074556304
230.2099259930637050.419851986127410.790074006936295
240.2495507168486580.4991014336973170.750449283151342
250.2166944790866960.4333889581733930.783305520913304
260.1836793391876730.3673586783753460.816320660812327
270.1606499448980480.3212998897960970.839350055101952
280.1229861772199160.2459723544398310.877013822780084
290.09583845229659230.1916769045931850.904161547703408
300.08022028859050230.1604405771810050.919779711409498
310.07806511487357190.1561302297471440.921934885126428
320.1289098847670530.2578197695341060.871090115232947
330.2321063785232300.4642127570464610.76789362147677
340.3035017476890260.6070034953780510.696498252310974
350.4109547636168240.8219095272336480.589045236383176
360.5813694933807690.8372610132384630.418630506619231
370.7329045012096340.5341909975807330.267095498790366
380.8650826789513260.2698346420973480.134917321048674
390.9671760082401860.06564798351962710.0328239917598135
400.9941204780420450.01175904391590950.00587952195795477
410.9993130383403320.001373923319335310.000686961659667655
420.9998273237831950.0003453524336093020.000172676216804651
430.9999916317189441.67365621114710e-058.36828105573552e-06
440.9999993936392331.21272153381855e-066.06360766909273e-07
450.999999198917551.60216490196375e-068.01082450981874e-07
460.9999984288190743.14236185245212e-061.57118092622606e-06
470.9999987095738882.58085222400450e-061.29042611200225e-06
480.9999991659452611.66810947793880e-068.34054738969401e-07
490.9999998914549662.17090067775693e-071.08545033887846e-07
500.9999999996803466.39307924060609e-103.19653962030305e-10
510.9999999999280451.43910698201954e-107.19553491009772e-11
520.9999999999803493.93022442263613e-111.96511221131806e-11
530.9999999999864532.70944793630686e-111.35472396815343e-11
540.9999999999866872.66264255233636e-111.33132127616818e-11
550.9999999999981653.6699022156932e-121.8349511078466e-12
560.9999999999957758.45003601120456e-124.22501800560228e-12
570.9999999999960957.81046599029504e-123.90523299514752e-12
580.9999999999889832.20341930849873e-111.10170965424936e-11
590.999999999985722.85600187890865e-111.42800093945433e-11
600.9999999999966816.63745278938776e-123.31872639469388e-12
610.9999999999987122.57666857797557e-121.28833428898779e-12
6214.02576789407143e-162.01288394703572e-16
6315.55663949613671e-172.77831974806835e-17
6411.38003103621412e-166.9001551810706e-17
6516.03209932550747e-163.01604966275374e-16
6612.01824773121104e-151.00912386560552e-15
670.9999999999999983.40901842958178e-151.70450921479089e-15
6811.58772159011483e-157.93860795057417e-16
690.9999999999999967.37740973175052e-153.68870486587526e-15
700.9999999999999843.2311781528179e-141.61558907640895e-14
710.999999999999975.92805433815337e-142.96402716907669e-14
720.9999999999998672.66395263036691e-131.33197631518346e-13
730.999999999999451.09925779342188e-125.49628896710942e-13
740.9999999999997475.06846428839487e-132.53423214419743e-13
750.999999999999121.75827086867666e-128.79135434338331e-13
760.9999999999989282.14477784392273e-121.07238892196136e-12
770.999999999999794.19042496351513e-132.09521248175756e-13
780.9999999999989882.02413004628655e-121.01206502314327e-12
790.9999999999955848.8320450035694e-124.4160225017847e-12
800.9999999999931181.37635472822496e-116.88177364112479e-12
810.999999999976054.7898486903637e-112.39492434518185e-11
820.99999999989352.13000383466694e-101.06500191733347e-10
830.9999999994916641.01667109309592e-095.0833554654796e-10
840.9999999998800962.39807920647698e-101.19903960323849e-10
850.9999999997992754.01450324457317e-102.00725162228659e-10
860.9999999988555192.28896272362232e-091.14448136181116e-09
870.9999999940171.19659981687334e-085.98299908436672e-09
880.999999979215974.15680591897576e-082.07840295948788e-08
890.9999998949424752.10115049466120e-071.05057524733060e-07
900.9999995033884029.93223195108437e-074.96611597554219e-07
910.9999985503656312.89926873766898e-061.44963436883449e-06
920.999997077743885.84451223979454e-062.92225611989727e-06
930.9999852039736682.95920526643151e-051.47960263321575e-05
940.9999283305779610.0001433388440773597.16694220386793e-05
950.9997009138610950.000598172277809430.000299086138904715
960.9991042160572350.001791567885530180.000895783942765092
970.9978976858084050.004204628383189190.00210231419159459
980.9957108836713630.008578232657273660.00428911632863683
990.98731471636520.02537056726959870.0126852836347993


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level580.617021276595745NOK
5% type I error level600.638297872340426NOK
10% type I error level610.648936170212766NOK
 
Charts produced by software:
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/10ogw51290507380.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/10ogw51290507380.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/1hxht1290507380.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/1hxht1290507380.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/2hxht1290507380.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/2hxht1290507380.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/3s6ge1290507380.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/3s6ge1290507380.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/4s6ge1290507380.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/4s6ge1290507380.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/5s6ge1290507380.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/5s6ge1290507380.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/62xfz1290507380.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/62xfz1290507380.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/7d6w21290507380.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/7d6w21290507380.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/8d6w21290507380.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/8d6w21290507380.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/9d6w21290507380.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290507286qb11hditz9mcgvt/9d6w21290507380.ps (open in new window)


 
Parameters (Session):
par1 = 0 ; par2 = 36 ;
 
Parameters (R input):
par1 = 1 ; par2 = Do not include Seasonal 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