Home » date » 2008 » Dec » 12 »

Regressie prof bachelor 1 juli 2005

*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: Fri, 12 Dec 2008 08:27:30 -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/12/t1229095752i0mvobf72xd3ypv.htm/, Retrieved Fri, 12 Dec 2008 16:29:13 +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/12/t1229095752i0mvobf72xd3ypv.htm/},
    year = {2008},
}
@Manual{R,
    title = {R: A Language and Environment for Statistical Computing},
    author = {{R Development Core Team}},
    organization = {R Foundation for Statistical Computing},
    address = {Vienna, Austria},
    year = {2008},
    note = {{ISBN} 3-900051-07-0},
    url = {http://www.R-project.org},
}
 
Original text written by user:
 
IsPrivate?
No (this computation is public)
 
User-defined keywords:
 
Dataseries X:
» Textbox « » Textfile « » CSV «
13363 0 12530 0 11420 0 10948 0 10173 0 10602 0 16094 0 19631 0 17140 0 14345 0 12632 0 12894 0 11808 0 10673 0 9939 0 9890 0 9283 0 10131 0 15864 0 19283 0 16203 0 13919 0 11937 0 11795 0 11268 0 10522 0 9929 0 9725 0 9372 0 10068 0 16230 0 19115 0 18351 0 16265 0 14103 0 14115 0 13327 0 12618 0 12129 0 11775 0 11493 0 12470 0 20792 0 22337 0 21325 0 18581 0 16475 0 16581 0 15745 0 14453 0 13712 0 13766 0 13336 0 15346 0 24446 0 26178 0 24628 0 21282 0 18850 0 18822 0 18060 0 17536 0 16417 0 15842 0 15188 0 16905 0 25430 0 27962 0 26607 0 23364 0 20827 0 20506 0 19181 0 18016 0 17354 0 16256 0 15770 0 17538 0 26899 1 28915 1 25247 1 22856 1 19980 1 19856 1 16994 1 16839 1 15618 1 15883 1 15513 1 17106 1 25272 1 26731 1 22891 1 19583 1 16939 1 16757 1 15435 1 14786 1 13680 1 13208 1 12707 1 14277 1 22436 1 23229 1 18241 1 16145 1 13994 1 14780 1 13100 1 12329 1 12463 1 11532 1 10784 1 13106 1 19491 1 20418 1 16094 1 14491 1 13067 1
 
Output produced by software:

Enter (or paste) a matrix (table) containing all data (time) series. Every column represents a different variable and must be delimited by a space or Tab. Every row represents a period in time (or category) and must be delimited by hard returns. The easiest way to enter data is to copy and paste a block of spreadsheet cells. Please, do not use commas or spaces to seperate groups of digits!


Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time9 seconds
R Server'Herman Ole Andreas Wold' @ 193.190.124.10:1001


Multiple Linear Regression - Estimated Regression Equation
NWWZpb[t] = + 12483.6674186368 -3857.07191842628Dummy[t] -1114.80046221099M1[t] -1996.63418255830M2[t] -2844.66790290561M3[t] -3312.20162325292M4[t] -3916.73534360023M5[t] -2607.66906394754M6[t] + 5234.60440754777M7[t] + 7235.17068720046M8[t] + 4444.03696685315M9[t] + 1770.50324650585M10[t] -516.130473841465M11[t] + 83.93372034731t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)12483.66741863681036.11020912.048600
Dummy-3857.07191842628909.361619-4.24154.8e-052.4e-05
M1-1114.800462210991225.341142-0.90980.3650180.182509
M2-1996.634182558301225.017036-1.62990.1061230.053061
M3-2844.667902905611224.821756-2.32250.0221340.011067
M4-3312.201623252921224.755364-2.70440.0079850.003993
M5-3916.735343600231224.817879-3.19780.0018310.000915
M6-2607.669063947541225.009284-2.12870.0356180.017809
M75234.604407547771225.6869534.27084.3e-052.1e-05
M87235.170687200461225.3687525.904500
M94444.036966853151225.1793423.62730.0004440.000222
M101770.503246505851225.1187821.44520.1513880.075694
M11-516.1304738414651225.187093-0.42130.6744210.337211
t83.9337203473112.5652386.679800


Multiple Linear Regression - Regression Statistics
Multiple R0.842742362483911
R-squared0.710214689524964
Adjusted R-squared0.674336508228055
F-TEST (value)19.7951697620232
F-TEST (DF numerator)13
F-TEST (DF denominator)105
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2665.32908203119
Sum Squared Residuals745917807.129727


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11336311452.80067677311910.19932322686
21253010654.90067677311875.09932322686
3114209890.800676773151529.19932322685
4109489507.200676773151440.79932322685
5101738986.600676773151186.39932322685
61060210379.6006767731222.399323226853
71609418305.8078686158-2211.80786861577
81963120390.3078686158-759.307868615773
91714017683.1078686158-543.107868615774
101434515093.5078686158-748.50786861577
111263212890.8078686158-258.807868615775
121289413490.8720628045-596.872062804548
131180812460.0053209409-652.005320940865
141067311662.1053209409-989.105320940868
15993910898.0053209409-959.005320940865
16989010514.4053209409-624.405320940864
1792839993.80532094086-710.805320940865
181013111386.8053209409-1255.80532094086
191586419313.0125127835-3449.01251278349
201928321397.5125127835-2114.51251278349
211620318690.3125127835-2487.31251278349
221391916100.7125127835-2181.71251278349
231193713898.0125127835-1961.01251278349
241179514498.0767069723-2703.07670697227
251126813467.2099651086-2199.20996510858
261052212669.3099651086-2147.30996510858
27992911905.2099651086-1976.20996510858
28972511521.6099651086-1796.60996510858
29937211001.0099651086-1629.00996510858
301006812394.0099651086-2326.00996510858
311623020320.2171569512-4090.21715695121
321911522404.7171569512-3289.71715695121
331835119697.5171569512-1346.51715695121
341626517107.9171569512-842.917156951213
351410314905.2171569512-802.217156951212
361411515505.28135114-1390.28135113999
371332714474.4146092763-1147.41460927630
381261813676.5146092763-1058.51460927630
391212912912.4146092763-783.414609276305
401177512528.8146092763-753.814609276303
411149312008.2146092763-515.214609276303
421247013401.2146092763-931.214609276304
432079221327.4218011189-535.42180111893
442233723411.9218011189-1074.92180111893
452132520704.7218011189620.27819888107
461858118115.1218011189465.878198881068
471647515912.4218011189562.578198881068
481658116512.485995307768.5140046922939
491574515481.6192534440263.380746555977
501445314683.7192534440-230.719253444023
511371213919.6192534440-207.619253444023
521376613536.0192534440229.980746555977
531333613015.4192534440320.580746555977
541534614408.4192534440937.580746555977
552444622334.62644528672111.37355471335
562617824419.12644528671758.87355471335
572462821711.92644528672916.07355471335
582128219122.32644528662159.67355471335
591885016919.62644528671930.37355471335
601882217519.69063947541302.30936052457
611806016488.82389761171571.17610238826
621753615690.92389761171845.07610238826
631641714926.82389761171490.17610238826
641584214543.22389761171298.77610238826
651518814022.62389761171165.37610238826
661690515415.62389761171489.37610238826
672543023341.83108945442088.16891054563
682796225426.33108945442535.66891054563
692660722719.13108945443887.86891054563
702336420129.53108945443234.46891054563
712082717926.83108945442900.16891054563
722050618526.89528364311979.10471635686
731918117496.02854177951684.97145822054
741801616698.12854177951317.87145822054
751735415934.02854177951419.97145822054
761625615550.4285417795705.571458220538
771577015029.8285417795740.171458220537
781753816422.82854177951115.17145822054
792689920491.96381519586407.03618480418
802891522576.46381519586338.53618480419
812524719869.26381519585377.73618480419
822285617279.66381519585576.33618480418
831998015076.96381519584903.03618480419
841985615677.02800938464178.97199061541
851699414646.16126752092347.83873247909
861683913848.26126752092990.73873247909
871561813084.16126752092533.83873247910
881588312700.56126752093182.43873247909
891551312179.96126752093333.03873247910
901710613572.96126752093533.03873247910
912527221499.16845936353772.83154063647
922673123583.66845936353147.33154063647
932289120876.46845936352014.53154063647
941958318286.86845936351296.13154063647
951693916084.1684593635854.831540636467
961675716684.232653552372.7673464476922
971543515653.3659116886-218.365911688625
981478614855.4659116886-69.4659116886235
991368014091.3659116886-411.365911688624
1001320813707.7659116886-499.765911688625
1011270713187.1659116886-480.165911688624
1021427714580.1659116886-303.165911688625
1032243622506.3731035313-70.373103531251
1042322924590.8731035313-1361.87310353125
1051824121883.6731035313-3642.67310353125
1061614519294.0731035313-3149.07310353125
1071399417091.3731035313-3097.37310353125
1081478017691.4372977200-2911.43729772003
1091310016660.5705558563-3560.57055585634
1101232915862.6705558563-3533.67055585634
1111246315098.5705558563-2635.57055585634
1121153214714.9705558563-3182.97055585634
1131078414194.3705558563-3410.37055585634
1141310615587.3705558563-2481.37055585634
1151949123513.5777476990-4022.57774769897
1162041825598.0777476990-5180.07774769897
1171609422890.8777476990-6796.87774769897
1181449120301.2777476990-5810.27774769897
1191306718098.5777476990-5031.57774769897


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.001908865006012830.003817730012025670.998091134993987
180.0007471326747591840.001494265349518370.99925286732524
190.0003192400337328670.0006384800674657350.999680759966267
208.20397326328893e-050.0001640794652657790.999917960267367
211.23381462231860e-052.46762924463719e-050.999987661853777
222.60073385489949e-065.20146770979898e-060.999997399266145
233.94477002103068e-077.88954004206137e-070.999999605522998
245.9416196757433e-081.18832393514866e-070.999999940583803
258.02092574769096e-091.60418514953819e-080.999999991979074
261.25845093642548e-092.51690187285097e-090.99999999874155
273.39167485847695e-106.78334971695391e-100.999999999660833
288.75624518675319e-111.75124903735064e-100.999999999912438
294.83798819969427e-119.67597639938854e-110.99999999995162
302.56455876411299e-115.12911752822598e-110.999999999974354
318.77312677307273e-111.75462535461455e-100.999999999912269
323.80932450968513e-117.61864901937026e-110.999999999961907
335.26630702150071e-091.05326140430014e-080.999999994733693
341.33383682735301e-072.66767365470603e-070.999999866616317
354.23553631720444e-078.47107263440889e-070.999999576446368
369.04893014496906e-071.80978602899381e-060.999999095106985
378.63440083377134e-071.72688016675427e-060.999999136559917
389.06866061547026e-071.81373212309405e-060.999999093133938
391.14892643750004e-062.29785287500008e-060.999998851073562
401.21017937094570e-062.42035874189141e-060.99999878982063
411.54886698546416e-063.09773397092831e-060.999998451133015
423.34840255328215e-066.69680510656431e-060.999996651597447
430.0001507123275762460.0003014246551524930.999849287672424
440.0004519572766860110.0009039145533720220.999548042723314
450.001518806255999040.003037612511998090.998481193744
460.003320671273048470.006641342546096930.996679328726952
470.00605670948599290.01211341897198580.993943290514007
480.01186746948287160.02373493896574330.988132530517128
490.01569765653747760.03139531307495530.984302343462522
500.02498341501590300.04996683003180590.975016584984097
510.04488850062156350.08977700124312690.955111499378437
520.078111868799940.156223737599880.92188813120006
530.1470762909995100.2941525819990200.85292370900049
540.3338456541543450.6676913083086890.666154345845655
550.7075066852325020.5849866295349960.292493314767498
560.8756803186143950.2486393627712090.124319681385605
570.922337752162630.1553244956747390.0776622478373695
580.9527201436925840.0945597126148320.047279856307416
590.9738540201298660.05229195974026890.0261459798701344
600.9881196849002120.0237606301995760.011880315099788
610.9905420884766630.0189158230466740.009457911523337
620.9928830518008130.01423389639837310.00711694819918656
630.9963130834989570.007373833002086850.00368691650104343
640.99859288975220.0028142204956010.0014071102478005
650.9997523275548680.0004953448902637620.000247672445131881
660.9999922330619351.55338761291326e-057.76693806456629e-06
670.9999997205730455.58853909590853e-072.79426954795427e-07
680.9999999141197121.71760575361143e-078.58802876805715e-08
690.9999999693466366.13067271579869e-083.06533635789935e-08
700.999999954257739.14845396523973e-084.57422698261986e-08
710.999999908378571.83242858902981e-079.16214294514905e-08
720.9999997904308224.1913835533259e-072.09569177666295e-07
730.9999997132614925.73477016958044e-072.86738508479022e-07
740.9999993759044351.24819112996480e-066.24095564982399e-07
750.999998825901422.34819715873153e-061.17409857936577e-06
760.9999973952139835.20957203312668e-062.60478601656334e-06
770.9999942601314631.14797370738581e-055.73986853692906e-06
780.999986814261852.63714763017924e-051.31857381508962e-05
790.999975853480764.82930384806374e-052.41465192403187e-05
800.9999503941410459.9211717909528e-054.9605858954764e-05
810.999957117304538.57653909383306e-054.28826954691653e-05
820.9999625265833587.4946833283213e-053.74734166416065e-05
830.9999330702998020.0001338594003968636.69297001984317e-05
840.9998777177206760.0002445645586488710.000122282279324436
850.999889736324420.000220527351159390.000110263675579695
860.9998061561783330.0003876876433334860.000193843821666743
870.9998259460938010.0003481078123975690.000174053906198784
880.99963680505510.0007263898898007580.000363194944900379
890.9992144031771280.001571193645744170.000785596822872087
900.9984064898247180.003187020350564340.00159351017528217
910.997009491872520.005981016254958930.00299050812747947
920.9970204784511350.005959043097730140.00297952154886507
930.9998722237731990.0002555524536021890.000127776226801095
940.9999376467016310.0001247065967377146.23532983688571e-05
950.9998742212019180.0002515575961645170.000125778798082259
960.9996526591834460.0006946816331072030.000347340816553602
970.9992036658246250.001592668350749280.00079633417537464
980.9982770499246330.003445900150733180.00172295007536659
990.996319730061080.007360539877840.00368026993892
1000.9893555153247470.02128896935050530.0106444846752526
1010.9685911314916640.06281773701667150.0314088685083357
1020.934798693639450.1304026127211000.0652013063605499


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level670.77906976744186NOK
5% type I error level750.872093023255814NOK
10% type I error level790.91860465116279NOK
 
Charts produced by software:
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/10mbn41229095635.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/10mbn41229095635.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/1jqm41229095635.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/1jqm41229095635.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/2f24d1229095635.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/2f24d1229095635.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/3vrv71229095635.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/3vrv71229095635.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/48s5j1229095635.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/48s5j1229095635.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/58mzq1229095635.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/58mzq1229095635.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/6pgso1229095635.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/6pgso1229095635.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/7jldp1229095635.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/7jldp1229095635.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/80ffa1229095635.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/80ffa1229095635.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/9pxg41229095635.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Dec/12/t1229095752i0mvobf72xd3ypv/9pxg41229095635.ps (open in new window)


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