Home » date » 2010 » Nov » 23 »

WS 7 (1)

*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 09:44:46 +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/t1290505393pp49bte87ob6vwh.htm/, Retrieved Tue, 23 Nov 2010 10:43:24 +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/t1290505393pp49bte87ob6vwh.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'Gwilym Jenkins' @ 72.249.127.135


Multiple Linear Regression - Estimated Regression Equation
eu/us[t] = + 3.06886493595529 -1.51139049137114`us/ch`[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)3.068864935955290.08259437.15600
`us/ch`-1.511390491371140.07614-19.850200


Multiple Linear Regression - Regression Statistics
Multiple R0.890375586990514
R-squared0.792768685908702
Adjusted R-squared0.790756731402962
F-TEST (value)394.029131198881
F-TEST (DF numerator)1
F-TEST (DF denominator)103
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.0441024371267238
Sum Squared Residuals0.200337570933212


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11.39541.45394419592521-0.0585441959252147
21.4791.404824004955660.074175995044338
31.46191.406939951643580.0549600483564183
41.4671.409660454528050.0573395454719506
51.47991.422507273704700.0573927262952955
61.45081.403614892562570.0471851074374349
71.46781.416763989837490.0510360101625059
81.48241.430215365210700.0521846347893028
91.51891.495658573487070.0232414265129321
101.53481.520445377545550.0143546224544455
111.56661.558381278878970.0082187211210298
121.54461.543871930161810.00072806983819268
131.58031.565484814188410.0148151858115856
141.57181.545383320653180.0264166793468218
151.58321.559590391272070.023609608727933
161.58011.529664859542920.0504351404570816
171.56051.503517804042200.0569821959578025
181.54161.473441133263910.0681588667360883
191.54791.495658573487070.0522414265129323
201.5581.485834535293160.072165464706845
211.5791.524374992823120.0546250071768806
221.55541.49293807060260.0624619293974002
231.57611.526490939511040.049609060488961
241.5361.483416310506960.0525836894930385
251.56211.505482611680980.0566173883190199
261.57731.528304608100680.0489953918993157
271.5711.521503350889510.0494966491104858
281.59251.532536501476520.0599634985234764
291.58441.524526131872260.0598738681277436
301.56961.501552996403420.0680470035965848
311.5541.480695807622490.0733041923775066
321.50121.434598397635670.0666016023643265
331.46761.410869566921150.0567304330788534
341.4771.407997924987540.0690020750124587
351.4661.403614892562570.0623851074374347
361.42411.381246313290270.0428536867097278
371.42141.358122038772290.0632779612277062
381.44691.403312614464290.0435873855357094
391.46181.423867525146940.0379324748530617
401.38341.366585825523970.0168141744760280
411.34121.35419242349473-0.0129924234947286
421.34371.35540153588783-0.0117015358878258
431.2631.30658362301654-0.0435836230165379
441.27591.32320891842162-0.0473089184216202
451.27431.28814465902181-0.0138446590218099
461.27971.276960369385660.00273963061433678
471.25731.222096894548890.0352031054511093
481.27051.235548269922090.0349517300779062
491.2681.220434365008380.0475656349916176
501.33711.290411744758870.0466882552411336
511.38851.39469768866348-0.00619768866347539
521.4061.45590900356401-0.0499090035640068
531.38551.43051764330897-0.0450176433089713
541.34311.38305998187992-0.0399599818799176
551.32571.37852581040580-0.0528258104058039
561.29781.32018613743888-0.0223861374388779
571.27931.31187348973634-0.0325734897363364
581.29451.31157121163806-0.0170712116380624
591.2891.31897702504578-0.0299770250457812
601.28481.32577828225695-0.0409782822569513
611.26941.30295628583725-0.0335562858372467
621.26361.31610538311218-0.0525053831121759
631.291.272123919813280.0178760801867245
641.35591.36159823690245-0.00569823690244727
651.33051.34225243861290-0.0117524386128965
661.34821.35842431687057-0.0102243168705679
671.31461.31852360789837-0.00392360789836986
681.30271.30476995442689-0.00206995442689231
691.32471.34724002723442-0.0225400272344214
701.32671.35237875490508-0.0256787549050834
711.36211.39651135725312-0.0344113572531205
721.34791.37127113604722-0.0233711360472225
731.40111.42976194806329-0.0286619480632858
741.41351.45530444736746-0.041804447367458
751.39641.42704144517882-0.0306414451788176
761.4011.43777231766755-0.036772317667553
771.39551.43671434432359-0.041214344323593
781.40771.43399384143912-0.0262938414391249
791.39751.42613461088400-0.0286346108839952
801.39491.43006422616156-0.03516422616156
811.41381.44457357487872-0.0307735748787231
821.4211.45001458064766-0.0290145806476592
831.42531.45349077877781-0.0281907787778128
841.41691.43233131189862-0.0154313118986168
851.41741.44472471392786-0.0273247139278602
861.43461.47162746467427-0.0370274646742665
871.42961.46679101510188-0.0371910151018788
881.43111.46784898844584-0.0367489884458387
891.45941.50155299640342-0.0421529964034152
901.47221.51394639843266-0.0417463984326587
911.46691.51288842508870-0.0459884250886985
921.45711.50427349928788-0.0471734992878833
931.47091.50850539266372-0.0376053926637223
941.48931.52936258144464-0.0400625814446442
951.49971.54326737396526-0.0435673739652585
961.47131.51848056990677-0.0471805699067718
971.48461.53178080623084-0.0471808062308382
981.49141.53979117583511-0.048391175835105
991.48591.53102511098515-0.0451251109851523
1001.49571.54780154543937-0.0521015454393721
1011.48431.53208308432911-0.0477830843291124
1021.46191.50608716787753-0.0441871678775285
1031.4341.49354262679915-0.0595426267991481
1041.44261.50366894309133-0.0610689430913345
1051.43181.50487805548443-0.0730780554844318


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
50.09833101225546860.1966620245109370.901668987744531
60.08224164162284630.1644832832456930.917758358377154
70.03941349726717590.07882699453435170.960586502732824
80.06630250570694080.1326050114138820.933697494293059
90.2773729849221480.5547459698442950.722627015077852
100.2342875376942880.4685750753885750.765712462305712
110.1802590483922630.3605180967845250.819740951607737
120.1183478388854770.2366956777709550.881652161114522
130.0860633772424870.1721267544849740.913936622757513
140.06265449159641110.1253089831928220.937345508403589
150.04367997045043990.08735994090087970.95632002954956
160.04315874625292800.08631749250585610.956841253747072
170.04151078047200850.0830215609440170.958489219527991
180.0444915476480540.0889830952961080.955508452351946
190.03665103088250390.07330206176500790.963348969117496
200.04588775318169910.09177550636339810.95411224681830
210.04379557198462870.08759114396925750.956204428015371
220.04424131666197240.08848263332394470.955758683338028
230.03939459554751480.07878919109502950.960605404452485
240.0338403354520310.0676806709040620.966159664547969
250.03380032792957840.06760065585915690.966199672070422
260.0323090345058660.0646180690117320.967690965494134
270.03186975835873570.06373951671747150.968130241641264
280.04345890755251120.08691781510502250.95654109244749
290.06116871476550880.1223374295310180.93883128523449
300.1041659523269510.2083319046539010.89583404767305
310.1957264567816210.3914529135632410.804273543218379
320.2785460802124670.5570921604249350.721453919787533
330.3423832539798910.6847665079597820.657616746020109
340.4971107017368850.994221403473770.502889298263115
350.6571103199376420.6857793601247160.342889680062358
360.7466846636201620.5066306727596760.253315336379838
370.8811484527025950.2377030945948090.118851547297405
380.954731208024080.09053758395183880.0452687919759194
390.9905153523695750.01896929526084960.0094846476304248
400.9968104314465680.00637913710686470.00318956855343235
410.9993028605425280.001394278914944610.000697139457472303
420.999734813925070.0005303721498572760.000265186074928638
430.999988133904652.37321907017121e-051.18660953508560e-05
440.9999993505026161.29899476830146e-066.49497384150728e-07
450.9999991993266761.60134664708633e-068.00673323543164e-07
460.9999984380098673.12398026666057e-061.56199013333028e-06
470.9999987701321182.45973576310743e-061.22986788155371e-06
480.9999992351133761.52977324734788e-067.64886623673941e-07
490.9999999118039381.76392123260769e-078.81960616303845e-08
500.9999999997372835.25433433684218e-102.62716716842109e-10
510.9999999999033661.93267201430468e-109.66336007152342e-11
520.9999999999891972.16067688100372e-111.08033844050186e-11
530.9999999999970455.91047143820719e-122.95523571910359e-12
540.9999999999985572.88658274863735e-121.44329137431868e-12
550.9999999999998872.25236871341928e-131.12618435670964e-13
560.9999999999997784.43212246736198e-132.21606123368099e-13
570.9999999999998223.56433092443109e-131.78216546221555e-13
580.9999999999995429.15270914480455e-134.57635457240227e-13
590.9999999999994671.06631345153693e-125.33156725768467e-13
600.999999999999882.40689570161308e-131.20344785080654e-13
610.9999999999999627.65541770082074e-143.82770885041037e-14
6211.27939285670383e-176.39696428351916e-18
6319.85034280193608e-184.92517140096804e-18
6411.6176404780976e-178.088202390488e-18
6516.55158131620528e-173.27579065810264e-17
6611.81101051449675e-169.05505257248376e-17
6715.29840368619815e-162.64920184309908e-16
6811.31812658880133e-156.59063294400663e-16
690.9999999999999984.67218010782898e-152.33609005391449e-15
700.9999999999999941.27997080192796e-146.3998540096398e-15
710.999999999999992.19861664497143e-141.09930832248572e-14
720.9999999999999627.56661062782402e-143.78330531391201e-14
730.9999999999998862.28385171437755e-131.14192585718878e-13
740.999999999999794.18636116655575e-132.09318058327788e-13
750.9999999999993261.34714552853916e-126.73572764269581e-13
760.999999999998313.3801490942439e-121.69007454712195e-12
770.9999999999975224.95613083956597e-122.47806541978298e-12
780.9999999999914661.70688305530175e-118.53441527650875e-12
790.999999999969246.15219274500657e-113.07609637250328e-11
800.9999999999208241.58352008640905e-107.91760043204523e-11
810.9999999997215045.56991647949637e-102.78495823974818e-10
820.9999999990549791.89004270219084e-099.45021351095422e-10
830.9999999970495895.90082188604896e-092.95041094302448e-09
840.9999999971547755.69044890302593e-092.84522445151297e-09
850.9999999948672231.02655535860365e-085.13277679301823e-09
860.999999986182772.76344618185567e-081.38172309092783e-08
870.9999999680441586.39116831120946e-083.19558415560473e-08
880.9999999655948736.88102549004331e-083.44051274502165e-08
890.999999922145241.55709520505766e-077.78547602528831e-08
900.999999798415514.03168982296953e-072.01584491148477e-07
910.999999289183231.42163353973835e-067.10816769869175e-07
920.999997664181394.67163722084478e-062.33581861042239e-06
930.9999981919210653.61615787026824e-061.80807893513412e-06
940.9999952880408729.42391825643227e-064.71195912821614e-06
950.9999770682171564.58635656884915e-052.29317828442457e-05
960.9999129068848390.0001741862303225518.70931151612753e-05
970.9995979954881370.000804009023726250.000402004511863125
980.998110294182650.003779411634699560.00188970581734978
990.993015939696030.01396812060793810.00698406030396907
1000.9731563708569070.05368725828618670.0268436291430933


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level590.614583333333333NOK
5% type I error level610.635416666666667NOK
10% type I error level780.8125NOK
 
Charts produced by software:
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290505393pp49bte87ob6vwh/10vo071290505477.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290505393pp49bte87ob6vwh/10vo071290505477.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/23/t1290505393pp49bte87ob6vwh/16n3e1290505477.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290505393pp49bte87ob6vwh/16n3e1290505477.ps (open in new window)


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


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


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


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


http://www.freestatistics.org/blog/date/2010/Nov/23/t1290505393pp49bte87ob6vwh/6ankk1290505477.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/23/t1290505393pp49bte87ob6vwh/6ankk1290505477.ps (open in new window)


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


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


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


 
Parameters (Session):
par1 = 0 ; par2 = 36 ;
 
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