Home » date » 2010 » Nov » 11 »

ws 6 - Multiple Regression

*The author of this computation has been verified*
R Software Module: /rwasp_multipleregression.wasp (opens new window with default values)
Title produced by software: Multiple Regression
Date of computation: Thu, 11 Nov 2010 15:39:58 +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/11/t1289489976iy2zv1fzwz2sk0v.htm/, Retrieved Thu, 11 Nov 2010 16:39:36 +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/11/t1289489976iy2zv1fzwz2sk0v.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 87,28 255,00 2 87,28 280,20 3 87,09 299,90 4 86,92 339,20 5 87,59 374,20 6 90,72 393,50 7 90,69 389,20 8 90,30 381,70 9 89,55 375,20 10 88,94 369,00 11 88,41 357,40 12 87,82 352,10 1 87,07 346,50 2 86,82 342,90 3 86,40 340,30 4 86,02 328,30 5 85,66 322,90 6 85,32 314,30 7 85,00 308,90 8 84,67 294,00 9 83,94 285,60 10 82,83 281,20 11 81,95 280,30 12 81,19 278,80 1 80,48 274,50 2 78,86 270,40 3 69,47 263,40 4 68,77 259,90 5 70,06 258,00 6 73,95 262,70 7 75,80 284,70 8 77,79 311,30 9 81,57 322,10 10 83,07 327,00 11 84,34 331,30 12 85,10 333,30 1 85,25 321,40 2 84,26 327,00 3 83,63 320,00 4 86,44 314,70 5 85,30 316,70 6 84,10 314,40 7 83,36 321,30 8 82,48 318,20 9 81,58 307,20 10 80,47 301,30 11 79,34 287,50 12 82,13 277,70 1 81,69 274,40 2 80,70 258,80 3 79,88 253,30 4 79,16 251,00 5 78,38 248,40 6 77,42 249,50 7 76,47 246,10 8 75,46 244,50 9 74,48 243,60 10 78,27 244,00 11 80,70 240,80 12 79,91 249,80 1 78,75 248,00 2 77,78 259,40 3 81,14 260,50 4 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 time12 seconds
R Server'Sir Ronald Aylmer Fisher' @ 193.190.124.24


Multiple Linear Regression - Estimated Regression Equation
USA[t] = + 133.224950912669 + 0.365739299248267Month[t] + 1.88330332389205Colombia[t] + 0.148037063510924t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)133.2249509126698.28146616.087100
Month0.3657392992482670.4749740.770.4417990.220899
Colombia1.883303323892050.08715121.609800
t0.1480370635109240.0157879.377100


Multiple Linear Regression - Regression Statistics
Multiple R0.775501662206986
R-squared0.601402828085799
Adjusted R-squared0.598043863153937
F-TEST (value)179.044092536135
F-TEST (DF numerator)3
F-TEST (DF denominator)356
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation31.0769825639322
Sum Squared Residuals343817.268919304


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1255298.113441384726-43.113441384726
2280.2298.627217747485-18.4272177474852
3299.9298.7831664787051.11683352129503
4339.2298.97678127640240.2232187235976
5374.2300.75237086616973.4476291338306
6393.5307.16088663271186.3391133672894
7389.2307.61816389575381.5818361042469
8381.7307.39745196219474.3025480378056
9375.2306.49875083203568.7012491679655
10369305.86371216722063.1362878327805
11357.4305.37933776831652.020662231684
12352.1304.78196516997947.3180348300212
13346.5299.4943924488447.0056075511602
14342.9299.53734298062643.362657019374
15340.3299.26013194735041.0398680526495
16328.3299.05825304703129.2417469529693
17322.9298.89404021318924.0059597868112
18314.3298.76749344582515.5325065541754
19308.9298.67861274493810.2213872550616
20294298.570899010813-4.57089901081322
21285.6297.709863947131-12.1098639471312
22281.2296.13317362037-14.9331736203702
23280.3294.989643058104-14.6896430581044
24278.8294.072108894706-15.2721088947056
25274.5288.859868306522-14.3598683065223
26270.4286.322693284576-15.9226932845764
27263.4269.152251435989-5.75225143598927
28259.9268.347715472024-8.44771547202402
29258271.290953122604-13.2909531226039
30262.7279.130779415303-16.4307794153032
31284.7283.1286669272631.57133307273733
32311.3287.39021690456723.909783095433
33322.1295.02287983163827.0771201683619
34327298.36161118023528.6383888197646
35331.3301.26718276433830.0328172356625
36333.3303.21226965325530.0877303467454
37321.4299.61966992361821.7803300763815
38327298.26897599572528.7310240042755
39320297.59627126443222.4037287355683
40314.7303.40212996732811.2978700326724
41316.7301.7689405408514.9310594591502
42314.4300.02275291493914.3772470850614
43321.3299.14288481801822.1571151819824
44318.2297.99935425575220.2006457442482
45307.2296.81815762700810.3818423729918
46301.3295.2414673002476.05853269975283
47287.5293.627110907008-6.12711090700837
48277.7299.395303543426-21.6953035434264
49274.4294.691554852694-20.2915548526939
50258.8293.3408609248-34.5408609247999
51253.3292.310328561968-39.0103285619676
52251291.468126531525-40.4681265315245
53248.4290.512926301648-42.1129263016479
54249.5289.218731473471-39.7187314734708
55246.1287.943369678533-41.8433696785325
56244.5286.555009684161-42.0550096841607
57243.6285.223148789506-41.6231487895057
58244292.874644749816-48.8746447498158
59240.8297.964848189633-57.1648481896326
60249.8296.990814926517-47.1908149265171
61248290.931087842582-42.9310878425823
62259.4289.618059981166-30.2180599811662
63260.5296.459735512203-35.9597355122027
64260.8296.860513675528-36.0605136755283
65261.3295.396821548201-34.0968215482009
66259.5293.801298188201-34.301298188201
67256.6292.620101559457-36.0201015594573
68257.9291.043411232696-33.1434112326964
69256.5289.805715504236-33.3057155042359
70254.2301.543979677392-47.3439796773918
71253.3298.93147252249-45.6314725224901
72253.8296.431963567022-42.6319635670220
73255.5290.202739183937-34.702739183937
74257.1288.343553358592-31.2435533585922
75257.3286.107706868469-28.807706868469
76253.2289.804265848606-36.6042658486058
77252.8289.658886048003-36.8588860480027
78252287.554870790552-35.554870790552
79250.7285.507354632818-34.807354632818
80252.2283.196176009739-30.9961760097391
81250288.606541014618-38.6065410146176
82251290.099635105801-39.0996351058007
83253.4289.91658923872-36.5165892387198
84251.2287.680742748597-36.4807427485966
85255.6283.184157423492-27.5841574234922
86261.1281.004810033086-19.9048100330857
87258.9279.748281271386-20.8482812713865
88259.9280.205558534429-20.3055585344289
89261.2280.079011767065-18.8790117670648
90264.7279.368640969294-14.6686409692941
91267.1276.887965047065-9.78796504706494
92266.4280.207863362423-13.8078633624233
93267.7281.738623520084-14.0386235200842
94268.6279.578109162917-10.9781091629166
95267.5278.660574999518-11.1605749995179
96268.5280.624494921674-12.124494921674
97268.5274.037442907049-5.53744290704943
98270.5271.274271486236-0.774271486236447
99270.9274.481171602161-3.5811716021613
100270.1268.9872103617051.11278963829518
101269.3264.2465704508055.0534295491948
102269.8267.9242963977031.87570360229696
103270.1264.6338000462005.46619995379971
104264.9261.9836268248212.91637317517912
105263.7265.925015237064-2.22501523706359
106264.8262.9170143841451.88298561585537
107263.7269.60802564927-5.90802564926975
108255.9270.084135945551-14.1841359455511
109276.2276.736706297888-0.536706297887616
110360.1295.36786063648864.7321393635117
111380.5323.52852979398356.9714702060173
112373.7326.6977638434347.0022361565703
113369.8329.09484353008140.7051564699191
114366.6327.64998443599238.9500155640076
115359.3325.15047548052434.1495245194757
116345.8322.74513169125123.0548683087492
117326.2319.8689620710046.33103792899566
118324.5318.1604405115716.33955948842908
119328.1320.6516853644177.44831463558327
120327.5317.7943487774099.70565122259083
121324.4310.92480126420113.4751987357992
122316.5308.7642869070337.7357130929667
123310.9306.3966091842384.50339081576231
124301.5304.179595727353-2.67959572735338
125291.7301.962582270469-10.2625822704691
126290.4300.046897345408-9.64689734540759
127287.4298.093546353868-10.6935463538682
128277.7296.422690860913-18.7226908609126
129281.6294.977831766824-13.3778317668240
130288298.297730082182-10.2977300821824
131276301.918956929363-25.9189569293635
132272.9300.568263001470-27.6682630014696
133283296.919164172117-13.9191641721165
134283.3301.048882916748-17.7488829167485
135276.8298.361043628891-21.5610436288912
136284.5300.419128717242-15.9191287172419
137282.7299.689924886232-16.9899248862323
138281.2297.077417731331-15.8774177313307
139287.4294.803905174730-7.40390517472968
140283.1292.605724751084-9.50572475108426
141284290.332212194483-6.33221219448327
142285.5293.426114110975-7.92611411097454
143289.2302.094593866186-12.8945938661863
144292.5299.91524647578-7.41524647577987
145296.4296.1719824802320.22801751976767
146305.2290.97934977159914.2206502284014
147303.9289.81698617609414.0830138239061
148311.5302.4969020111969.00309798880434
149316.3299.82789575657716.4721042434227
150316.7301.88598084492814.8140191550720
151322.5301.40160644602421.0983935539756
152317.1299.09042782294518.0095721770545
153309.8296.68508403367213.114915966328
154303.8296.5020381665917.29796183340885
155290.3297.976299224535-7.67629922453527
156293.7295.420291169350-1.72029116935046
157291.7288.2494151243193.45058487568064
158296.5285.37324550407311.1267544959271
159289.1289.615962448138-0.515962448138259
160288.5294.27300612346-5.77300612345998
161293.8291.6039998688422.19600013115839
162297.7289.0856578801358.61434211986537
163305.4286.79331229029518.6066877097053
164302.7284.48213366721618.2178663327842
165302.5296.8418879372565.65811206274406
166303295.8113555744247.18864442557634
167294.5293.6696742504950.830325749504923
168294.1291.3773286606552.72267133934492
169294.5285.0916051778539.40839482214674
170297.1283.43958271813713.6604172818634
171289.4286.2886552025223.11134479747804
172292.4293.695321730726-1.29532173072603
173287.9292.024466237770-4.12446623777045
174286.6290.353610744815-3.75361074481483
175280.5288.776920418054-8.27692041805388
176272.4287.087231891859-14.6872318918594
177269.2284.776053268781-15.5760532687805
178270.6288.623276514829-18.0232765148286
179267.3287.988237850014-20.6882378500136
180262.5286.11021899143-23.6102189914299
181266.8282.23512376321-15.4351237632099
182268.8275.667679628135-6.867679628135
183263.1272.678511808455-9.57851180845498
184261.2271.949307977445-10.7493079774455
185266271.238937179675-5.23893717967482
186262.5270.509733348665-8.00973334866525
187265.2263.8669570806351.33304291936531
188261.3258.0716673083553.22833269164452
189253.7257.530793809735-3.83079380973516
190249.2256.989920311115-7.78992031111481
191239.1256.486712878972-17.3867128789723
192236.4255.945839380352-19.5458393803519
193235.2251.129092490186-15.9290924901859
194245.2250.738883257477-5.53888325747689
195246.2250.367507058007-4.16750705800683
196247.7255.796705096124-8.09670509612426
197251.4256.931971555768-5.53197155576781
198253.3256.127435591803-2.82743559180258
199254.8255.699560292616-0.899560292615746
200250268.096980629134-18.0969806291338
201249.3267.574940163752-18.2749401637523
202241.5267.052899698371-25.5528996983709
203243.3267.039351130440-23.7393511304403
204248266.065317867325-18.0653178673248
205253261.305070076875-8.3050700768755
206252.9274.719474208295-21.8194742082952
207251.5312.240160885533-60.7401608855331
208251.6310.550472359339-58.9504723593386
209253.5309.482273930028-55.9822739300285
210259.8311.804021483724-52.004021483724
211334.1309.90716959190124.1928304080986
212448347.333691102945100.666308897055
213445.8374.59037466497171.209625335029
214445380.01957270308864.9804272969117
215448.2380.02485716839768.1751428316033
216438.2372.85475596967665.3452440303236
217439.8365.26955319338974.530446806611
218423.4364.08835656464559.3116434353546
219410.8360.68486201370950.1151379862909
220408.4359.72966178383348.6703382161675
221406.7365.94984721798540.7501527820154
222405.9360.09805834598945.8019416540113
223402.7356.92056019391945.7794398060806
224405.1350.54144639123454.5585536087663
225399.6348.28676686787251.3132331321284
226386.5342.67980742798243.8201925720183
227381.4343.41958018960837.9804198103921
228375.2343.76385925321731.4361407467832
229357.7328.00512005123829.694879948762
230359333.41548505611625.5845149438835
231355333.08177492312421.9182250768758
232352.7328.05863951364124.6413604863592
233344.4329.98489336931914.4151066306809
234343.8328.31403787636315.4859621236365
235338333.9127332136314.08726678636881
236339364.163869060646-25.1638690606458
237333.3368.312420838517-35.0124208385166
238334.4373.590954610723-39.1909546107227
239328.3374.180063106438-45.8800631064376
240330.7360.079405675794-29.3794056757945
241330347.145621459654-17.1456214596537
242331.6383.423327943123-51.8233279431228
243351.2466.595287191504-115.395287191504
244389.4448.370195481537-58.9701954815373
245410.9495.043736312891-84.1437363128906
246442.8495.670510875083-52.8705108750832
247462.8422.28346480831940.5165351916815
248466.9410.1979419342456.70205806576
249461.7401.59653020936260.1034697906383
250439.2391.31897852621947.8810214737806
251430.3382.47273736923547.8272626307649
252416.1396.86645922907919.2335407709213
253402.5392.5770372696029.92296273039758
254397.3406.311602966084-9.0116029660838
255403.3378.46283127102924.8371687289712
256395.9382.14055721792713.7594427820734
257387.8361.01517838916626.7848216108338
258378.6358.57216853341520.0278314665852
259377.1360.95041518682716.1495848131728
260370.4359.14772846119911.2522715388008
261362343.80409083678718.1959091632127
262350.3341.2292497483649.07075025163648
263348.2351.969363159857-3.76936315985657
264344.6354.517107112419-9.91710711241913
265343.5348.344381829051-4.84438182905084
266342.8343.377745519284-0.577745519284172
267347.6346.0949867709971.50501322900297
268346.6343.8214742143962.778525785604
269349.5341.2654661592118.23453384078883
270342.1341.8922407214040.207759278596141
271342331.16269624052810.8373037594724
272342.8326.87404912736215.9259508726380
273339.3319.47795152977519.8220484702254
274348.2319.93522879281728.2647712071829
275333.7337.097406538782-3.39740653878196
276334.7360.643982552741-25.9439825527409
277354339.34833157851914.6516684214806
278367.7330.27609402266837.4239059773319
279363.3332.84267100847030.4573289915304
280358.4325.50307251059932.896927489401
281353.1323.85105005088229.2489499491177
282343.1314.21382149786328.8861785021367
283344.6314.12494079697730.4750592030229
284344.4307.12433689740737.2756631025930
285333.9306.05613846809727.8438615319031
286331.7308.71688062009322.9831193799069
287324.3311.69778433715112.6022156628492
288321.2309.34893964759411.8510603524059
289322.4299.35310861672523.0468913832751
290321.7287.92674190600933.7732580939914
291320.5288.83601196678531.6639880332149
292312.8295.37635896599917.4236410340012
293309.7303.2538513251766.4461486748241
294315.6283.69161425524631.9083857447542
295309.7283.47090232168726.2290976783128
296304.6285.15232674525919.4476732547406
297302.5287.36107609952115.1389239004785
298301.5276.83869498427324.6613050157267
299298.8282.98354828547015.8164517145303
300291.3281.7458525570099.55414744299075
301293.6281.88219340867911.7178065913207
302294.6279.62751388531714.9724861146828
303285.9289.877968432598-3.97796843259828
304297.6296.1734859997061.42651400029400
305301.1285.50044061854615.5995593814536
306293.8281.13646137242512.6635386275748
307297.7268.63661176709029.0633882329096
308292.9265.68511001388827.2148899861117
309292.1276.42522342538115.6747765746188
310287.2276.93899978814010.2610002118596
311288.2283.7806753191774.4193246808231
312283.8270.86649898258612.9335010174142
313299.9274.9389437811924.9610562188098
314292.4272.85376155697819.5462384430216
315293.3267.30330121680525.9966987831948
316300.8272.71366622168428.0863337783163
317293.7276.0712306035217.6287693964801
318293.1270.12527656532922.9747234346707
319294.4278.13460015717916.2653998428211
320292.1273.13029778093418.9697022190657
321291.9274.52922670592317.3707732940772
322282.5272.7642060467739.73579395322735
323277.9274.8411241683623.05887583163774
324287.5278.1610224837219.33897751627943
325289.2286.3014024619322.89859753806818
326285.6287.342503755381-1.74250375538075
327293.2292.3762080954810.823791904519113
328290.8289.0668787107391.73312128926081
329283.1292.556274325248-9.45627432524781
330275303.277554703502-28.2775547035019
331287.8287.915084045851-0.115084045851151
332287.8290.274497666025-2.47449766602455
333287.4303.594736631250-16.1947366312497
334284301.942714171533-17.942714171533
335277.8317.918410823446-40.1184108234459
336277.6336.568398195286-58.9683981952855
337304.9334.143446526462-29.2434465264624
338294360.420812360065-66.4208123600647
339300.9387.206670091118-86.306670091118
340324373.689836690881-49.6898366908814
341332.9368.779699480831-35.8796994808315
342341.6356.39284807493-14.7928480749302
343333.4338.431418830308-5.03141883030843
344348.2338.8321969936349.36780300636593
345344.7330.38144953466714.3185504653329
346344.7349.295099371852-4.59509937185162
347329.3356.890096232445-27.5900962324449
348323.5357.535703827877-34.0357038278765
349323.2382.493982488444-59.2939824884437
350317.4365.285874573379-47.8858745733788
351330.1354.405665826591-24.3056658265910
352329.2357.122907078304-27.9229070783040
353334.9351.101620907158-16.2016209071578
354315.8338.451107035912-22.6511070359115
355315.4341.300179520297-25.9001795202969
356319.6353.358605258514-33.7586052585143
357317.3346.885326289634-29.585326289634
358313.8344.724811932466-30.9248119324665
359315.8368.177222780231-52.3772227802308
360311.3383.34309900287-72.0430990028701


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
70.1525180421472440.3050360842944890.847481957852755
80.3812953287985430.7625906575970870.618704671201457
90.5521967958100990.8956064083798020.447803204189901
100.5815042041649060.8369915916701880.418495795835094
110.5659531824968010.8680936350063970.434046817503198
120.4984563890532210.9969127781064430.501543610946779
130.4030642233680810.8061284467361620.596935776631919
140.3176992891504710.6353985783009420.682300710849529
150.2433041421790630.4866082843581260.756695857820937
160.1890914871923020.3781829743846040.810908512807698
170.1449788238683360.2899576477366730.855021176131664
180.1138956617602480.2277913235204960.886104338239752
190.08776376254043460.1755275250808690.912236237459565
200.07713746299805540.1542749259961110.922862537001945
210.05704272045541230.1140854409108250.942957279544588
220.03888827526355470.07777655052710930.961111724736445
230.03051854859157790.06103709718315580.969481451408422
240.02614411523469720.05228823046939430.973855884765303
250.02723495009583190.05446990019166370.972765049904168
260.04277564039875640.08555128079751280.957224359601244
270.6193121303455180.7613757393089630.380687869654482
280.672727288266070.6545454234678610.327272711733930
290.6402362769544810.7195274460910370.359763723045519
300.585007255255250.8299854894894990.414992744744749
310.5381881502962450.923623699407510.461811849703755
320.5251413387514830.9497173224970350.474858661248517
330.4848299823287380.9696599646574760.515170017671262
340.4392786199573110.8785572399146220.560721380042689
350.3945190526793840.7890381053587690.605480947320616
360.3528041569728140.7056083139456290.647195843027186
370.3093029782482310.6186059564964630.690697021751769
380.2752297777865010.5504595555730020.724770222213499
390.2382220913343680.4764441826687360.761777908665632
400.2165279790421440.4330559580842890.783472020957856
410.1869221354691190.3738442709382390.81307786453088
420.1583681050606610.3167362101213220.841631894939339
430.1339035441680190.2678070883360370.866096455831981
440.1120312585685210.2240625171370420.887968741431479
450.09219573917228830.1843914783445770.907804260827712
460.07517433117502310.1503486623500460.924825668824977
470.06349340958197470.1269868191639490.936506590418025
480.07568514686888070.1513702937377610.92431485313112
490.06841290127739220.1368258025547840.931587098722608
500.07012854704151380.1402570940830280.929871452958486
510.07163400530904720.1432680106180940.928365994690953
520.0708271660872610.1416543321745220.929172833912739
530.06864110047158050.1372822009431610.93135889952842
540.06193096964545920.1238619392909180.93806903035454
550.05549750297274110.1109950059454820.944502497027259
560.04834667489522350.0966933497904470.951653325104777
570.04091406356946380.08182812713892760.959085936430536
580.04377341845288580.08754683690577170.956226581547114
590.06206284406088510.1241256881217700.937937155939115
600.06376725806788390.1275345161357680.936232741932116
610.05416775174846830.1083355034969370.945832248251532
620.04562501202696760.09125002405393530.954374987973032
630.03794630060143890.07589260120287770.962053699398561
640.03139486394955210.06278972789910410.968605136050448
650.0255125283989410.0510250567978820.974487471601059
660.02067337207658840.04134674415317680.979326627923412
670.01676557387544100.03353114775088210.98323442612456
680.01371856252370610.02743712504741220.986281437476294
690.01131661131110940.02263322262221880.98868338868889
700.01101125947162680.02202251894325350.988988740528373
710.009755825190605840.01951165038121170.990244174809394
720.008125899458149570.01625179891629910.99187410054185
730.007314022712359310.01462804542471860.99268597728764
740.007037639401440560.01407527880288110.99296236059856
750.007332324769164290.01466464953832860.992667675230836
760.006422291355098710.01284458271019740.993577708644901
770.00564964019276070.01129928038552140.99435035980724
780.005230028283043010.01046005656608600.994769971716957
790.005107873440642740.01021574688128550.994892126559357
800.005546221201804340.01109244240360870.994453778798196
810.0049355896304490.0098711792608980.99506441036955
820.00432546152960830.00865092305921660.995674538470392
830.003852544314011650.00770508862802330.996147455685988
840.003556857006925150.007113714013850310.996443142993075
850.004406303476559340.008812606953118670.99559369652344
860.006522166737361340.01304433347472270.993477833262639
870.009053475041439580.01810695008287920.99094652495856
880.01180549778883310.02361099557766620.988194502211167
890.01517944141127620.03035888282255240.984820558588724
900.02056915149160130.04113830298320250.979430848508399
910.03045284441031930.06090568882063860.96954715558968
920.03670225792602860.07340451585205710.963297742073971
930.04170872185399180.08341744370798360.958291278146008
940.04920867722046160.09841735444092330.950791322779538
950.05601832403132370.1120366480626470.943981675968676
960.05957749565028870.1191549913005770.940422504349711
970.07814218961858630.1562843792371730.921857810381414
980.1033301832955340.2066603665910690.896669816704466
990.1203493009349460.2406986018698920.879650699065054
1000.1458369955014160.2916739910028310.854163004498584
1010.1769013416520460.3538026833040910.823098658347954
1020.1956590896231080.3913181792462170.804340910376891
1030.2161298296697340.4322596593394690.783870170330266
1040.2252902054635180.4505804109270360.774709794536482
1050.2236725999620810.4473451999241630.776327400037919
1060.222381982812940.444763965625880.77761801718706
1070.2130154631811510.4260309263623020.786984536818849
1080.1986351916570780.3972703833141570.801364808342922
1090.2089463063425790.4178926126851590.79105369365742
1100.4776477860157640.9552955720315290.522352213984236
1110.6223620404444210.7552759191111580.377637959555579
1120.6609538228157650.6780923543684690.339046177184235
1130.6648135677984730.6703728644030550.335186432201527
1140.6611792308679010.6776415382641970.338820769132099
1150.6492062619276860.7015874761446280.350793738072314
1160.6247630956573750.750473808685250.375236904342625
1170.5943921254435330.8112157491129330.405607874556467
1180.5630257997683990.8739484004632020.436974200231601
1190.5314239753109660.9371520493780680.468576024689034
1200.4999297879020470.9998595758040940.500070212097953
1210.4706103418373080.9412206836746170.529389658162692
1220.4394703670648540.8789407341297080.560529632935146
1230.4083839695064990.8167679390129990.591616030493501
1240.3780627182849990.7561254365699970.621937281715001
1250.3510459435581860.7020918871163720.648954056441814
1260.3241776856857050.6483553713714090.675822314314295
1270.2986058024613620.5972116049227250.701394197538638
1280.2783880499248950.556776099849790.721611950075105
1290.2560569632497780.5121139264995560.743943036750222
1300.2338462310991620.4676924621983240.766153768900838
1310.2248343693640120.4496687387280240.775165630635988
1320.2174447382060170.4348894764120340.782555261793983
1330.1984739092003370.3969478184006730.801526090799663
1340.1837344386021270.3674688772042540.816265561397873
1350.171774406788350.34354881357670.82822559321165
1360.1571566801663910.3143133603327830.842843319833609
1370.1439448445389220.2878896890778440.856055155461078
1380.1310372617109200.2620745234218390.86896273828908
1390.1180627102682780.2361254205365560.881937289731722
1400.1067105033862330.2134210067724650.893289496613767
1410.09717533687634450.1943506737526890.902824663123656
1420.08757483939830060.1751496787966010.9124251606017
1430.07860471238537670.1572094247707530.921395287614623
1440.06993115460504370.1398623092100870.930068845394956
1450.06161281732468980.1232256346493800.93838718267531
1460.05947144245859920.1189428849171980.9405285575414
1470.057544837959360.115089675918720.94245516204064
1480.05057740453717940.1011548090743590.94942259546282
1490.04676379330035320.09352758660070640.953236206699647
1500.04225804572241260.08451609144482510.957741954277587
1510.0401030265182970.0802060530365940.959896973481703
1520.03760680349565260.07521360699130520.962393196504347
1530.0344754114098590.0689508228197180.965524588590141
1540.03056108754552780.06112217509105560.969438912454472
1550.0264102555700590.0528205111401180.973589744429941
1560.02289455418561330.04578910837122650.977105445814387
1570.01992202390952120.03984404781904230.980077976090479
1580.01840834082620180.03681668165240360.981591659173798
1590.01567668947357070.03135337894714140.98432331052643
1600.01319439488414400.02638878976828790.986805605115856
1610.01121527607360240.02243055214720480.988784723926398
1620.009951672817543250.01990334563508650.990048327182457
1630.009861741916241020.01972348383248200.990138258083759
1640.00990762004378210.01981524008756420.990092379956218
1650.008310613580034320.01662122716006860.991689386419966
1660.007027005889548880.01405401177909780.992972994110451
1670.005878312015019120.01175662403003820.99412168798498
1680.004981468818131460.009962937636262920.995018531181869
1690.00429489817731190.00858979635462380.995705101822688
1700.003862798365621030.007725596731242050.99613720163438
1710.003187471258566670.006374942517133340.996812528741433
1720.002563568525180570.005127137050361130.99743643147482
1730.002071754194920010.004143508389840020.99792824580508
1740.001675737218342810.003351474436685620.998324262781657
1750.001374404195316620.002748808390633250.998625595804683
1760.001169315764356720.002338631528713440.998830684235643
1770.001007255665821140.002014511331642280.998992744334179
1780.000892345402937340.001784690805874680.999107654597063
1790.0008214273087475550.001642854617495110.999178572691252
1800.0007956820177759880.001591364035551980.999204317982224
1810.0006775025685224690.001355005137044940.999322497431477
1820.0005691418584336640.001138283716867330.999430858141566
1830.0004903693603567810.0009807387207135620.999509630639643
1840.0004293798641680950.000858759728336190.999570620135832
1850.0003798962910683550.0007597925821367110.999620103708932
1860.0003406749932665260.0006813499865330520.999659325006733
1870.0003355692422860810.0006711384845721620.999664430757714
1880.0003560504540845680.0007121009081691360.999643949545915
1890.0003603603955239690.0007207207910479380.999639639604476
1900.0003656859482975450.000731371896595090.999634314051702
1910.0003930003993023420.0007860007986046850.999606999600698
1920.0004513598376321520.0009027196752643040.999548640162368
1930.000455509563445930.000911019126891860.999544490436554
1940.0004556924250030280.0009113848500060560.999544307574997
1950.0004652339409423240.0009304678818846480.999534766059058
1960.0004758281006127860.0009516562012255710.999524171899387
1970.0004917146180946980.0009834292361893960.999508285381905
1980.0005200393221173460.001040078644234690.999479960677883
1990.000564066507220810.001128133014441620.99943593349278
2000.0007082930248114880.001416586049622980.999291706975189
2010.0009519473991100390.001903894798220080.99904805260089
2020.001614253840160150.003228507680320290.99838574615984
2030.002924453978095670.005848907956191340.997075546021904
2040.005362051254667690.01072410250933540.994637948745332
2050.007176439663777250.01435287932755450.992823560336223
2060.01256120314449370.02512240628898750.987438796855506
2070.06904206317385750.1380841263477150.930957936826142
2080.2484058289424210.4968116578848410.75159417105758
2090.5720981902529760.8558036194940470.427901809747024
2100.8631810006005150.2736379987989690.136818999399485
2110.8765263481163780.2469473037672430.123473651883622
2120.9502851300955520.09942973980889660.0497148699044483
2130.9605709242354440.0788581515291110.0394290757645555
2140.9659643972501860.06807120549962820.0340356027498141
2150.9732770347731910.05344593045361720.0267229652268086
2160.9779124151491260.04417516970174790.0220875848508739
2170.985218540949540.02956291810091910.0147814590504596
2180.9865976877465150.02680462450697050.0134023122534853
2190.985993881054640.02801223789071880.0140061189453594
2200.9852287159870210.02954256802595780.0147712840129789
2210.9838107529316480.03237849413670420.0161892470683521
2220.9827495859227460.03450082815450740.0172504140772537
2230.981534374012220.03693125197555980.0184656259877799
2240.9823623874792720.03527522504145620.0176376125207281
2250.9823302470750440.0353395058499120.017669752924956
2260.980346544730620.03930691053876150.0196534552693808
2270.977199276459450.04560144708109890.0228007235405495
2280.972856025685890.05428794862822020.0271439743141101
2290.9675143174877730.06497136502445480.0324856825122274
2300.961300520326160.07739895934767920.0386994796738396
2310.9544096502068530.09118069958629430.0455903497931471
2320.9463437671493320.1073124657013350.0536562328506675
2330.9395480084034950.1209039831930100.0604519915965048
2340.9317682898240550.1364634203518900.0682317101759448
2350.929935552468490.1401288950630200.0700644475315102
2360.958098213404160.08380357319167950.0419017865958397
2370.9822910168215970.03541796635680610.0177089831784030
2380.9942035120279560.01159297594408790.00579648797204393
2390.9988842246484170.002231550703166370.00111577535158318
2400.9996385331899020.0007229336201962660.000361466810098133
2410.9997951883300480.0004096233399038070.000204811669951903
2420.9999824512697563.50974604880052e-051.75487302440026e-05
2430.9999999988193922.36121633662557e-091.18060816831279e-09
2440.9999999999338861.32227698571989e-106.61138492859947e-11
2450.9999999999996666.67886989300014e-133.33943494650007e-13
2460.9999999999999341.31246180227729e-136.56230901138644e-14
2470.9999999999999715.7618232324002e-142.8809116162001e-14
2480.9999999999999983.42156404031782e-151.71078202015891e-15
24916.41666054623938e-173.20833027311969e-17
25016.12758743309155e-183.06379371654578e-18
25114.37824577909827e-192.18912288954914e-19
25213.69385772831007e-191.84692886415503e-19
25317.49906971075625e-193.74953485537812e-19
25411.62541363361778e-188.1270681680889e-19
25511.59854368190288e-187.99271840951442e-19
25612.65134843102411e-181.32567421551205e-18
25712.89662705884839e-181.44831352942419e-18
25814.81095556964706e-182.40547778482353e-18
25918.59337344231709e-184.29668672115854e-18
26011.8153903287893e-179.0769516439465e-18
26113.61484487708757e-171.80742243854378e-17
26218.3413181801553e-174.17065909007765e-17
26311.65230342823828e-168.2615171411914e-17
26412.54570789863448e-161.27285394931724e-16
26513.75032064803265e-161.87516032401632e-16
26616.08238977986988e-163.04119488993494e-16
26711.14020808104177e-155.70104040520887e-16
2680.9999999999999992.16259761190226e-151.08129880595113e-15
2690.9999999999999984.64330435528173e-152.32165217764086e-15
2700.9999999999999967.76927962247223e-153.88463981123611e-15
2710.9999999999999921.60167361530509e-148.00836807652544e-15
2720.9999999999999833.43770654384394e-141.71885327192197e-14
2730.9999999999999647.25670717303159e-143.62835358651579e-14
2740.9999999999999371.25409966125044e-136.27049830625218e-14
2750.9999999999999061.87114069967507e-139.35570349837534e-14
2760.9999999999999666.88797793475748e-143.44398896737874e-14
2770.9999999999999251.50428997350949e-137.52144986754746e-14
2780.999999999999931.40888783049179e-137.04443915245896e-14
2790.9999999999999131.73752043203049e-138.68760216015243e-14
2800.9999999999999081.8371082676079e-139.1855413380395e-14
2810.9999999999998872.26126671199656e-131.13063335599828e-13
2820.9999999999998383.23037671399395e-131.61518835699697e-13
2830.9999999999998153.69504937490087e-131.84752468745044e-13
2840.9999999999998762.48262739409633e-131.24131369704816e-13
2850.999999999999843.20614961675171e-131.60307480837585e-13
2860.999999999999774.61050668398325e-132.30525334199163e-13
2870.9999999999995369.28230294306314e-134.64115147153157e-13
2880.9999999999990641.87168069237253e-129.35840346186263e-13
2890.9999999999984723.05657617160361e-121.52828808580180e-12
2900.9999999999983853.22970352911345e-121.61485176455673e-12
2910.9999999999983353.33057915170095e-121.66528957585047e-12
2920.9999999999969666.06764062592692e-123.03382031296346e-12
2930.9999999999934611.3077470285513e-116.5387351427565e-12
2940.999999999993741.25211239658257e-116.26056198291286e-12
2950.9999999999917461.65087791163569e-118.25438955817844e-12
2960.9999999999858792.82429098130162e-111.41214549065081e-11
2970.9999999999739395.21226684560267e-112.60613342280133e-11
2980.9999999999609447.81119403193683e-113.90559701596842e-11
2990.9999999999309941.38012169586727e-106.90060847933635e-11
3000.9999999998537542.92491249514547e-101.46245624757274e-10
3010.9999999996831126.33776514639886e-103.16888257319943e-10
3020.999999999346211.30758130924315e-096.53790654621574e-10
3030.9999999986827932.63441335527951e-091.31720667763976e-09
3040.9999999972469975.50600676897706e-092.75300338448853e-09
3050.999999995399.22000186513806e-094.61000093256903e-09
3060.9999999909468261.81063481889717e-089.05317409448587e-09
3070.9999999872634222.54731550537981e-081.27365775268990e-08
3080.9999999793796124.1240776242797e-082.06203881213985e-08
3090.999999963075697.38486198113183e-083.69243099056591e-08
3100.9999999269850731.46029854733957e-077.30149273669785e-08
3110.9999998584472132.83105573228237e-071.41552786614118e-07
3120.9999997251229675.49754066259366e-072.74877033129683e-07
3130.9999995871763518.256472974128e-074.128236487064e-07
3140.9999992450136981.50997260462847e-067.54986302314235e-07
3150.9999987398059832.52038803478766e-061.26019401739383e-06
3160.9999984913650463.01726990841515e-061.50863495420758e-06
3170.9999975464206024.90715879636592e-062.45357939818296e-06
3180.9999962288099597.54238008228105e-063.77119004114053e-06
3190.9999943019951981.13960096032939e-055.69800480164694e-06
3200.999991273000231.74539995405076e-058.7269997702538e-06
3210.99998690627692.61874461996315e-051.30937230998158e-05
3220.9999756771413454.86457173095208e-052.43228586547604e-05
3230.9999539638351959.20723296091406e-054.60361648045703e-05
3240.9999234492239230.0001531015521531077.65507760765536e-05
3250.9998599059114640.000280188177072840.00014009408853642
3260.999747631109820.0005047377803598270.000252368890179914
3270.9995616604562730.0008766790874529560.000438339543726478
3280.9992401547830440.001519690433911790.000759845216955897
3290.9987409734570340.002518053085932640.00125902654296632
3300.9985247827744570.002950434451085010.00147521722554251
3310.997545258495820.004909483008359060.00245474150417953
3320.9960837841549480.007832431690104180.00391621584505209
3330.9944044999209740.01119100015805270.00559550007902634
3340.9937920894837740.01241582103245160.00620791051622582
3350.9975024235021480.004995152995703440.00249757649785172
3360.999938218803530.0001235623929389596.17811964694796e-05
3370.999974833586845.0332826321577e-052.51664131607885e-05
3380.9999994983794061.00324118794562e-065.01620593972812e-07
3390.9999999847380783.05238430549174e-081.52619215274587e-08
3400.9999999869729582.60540835791899e-081.30270417895950e-08
3410.9999999638028547.23942914450505e-083.61971457225253e-08
3420.999999836831593.2633681893593e-071.63168409467965e-07
3430.9999996888019246.22396152868475e-073.11198076434238e-07
3440.999999073125821.85374835989413e-069.26874179947065e-07
3450.9999969127343016.17453139703702e-063.08726569851851e-06
3460.9999975972540124.80549197651771e-062.40274598825885e-06
3470.9999891977319062.16045361873419e-051.08022680936709e-05
3480.9999474473431830.0001051053136349735.25526568174866e-05
3490.9998012678278380.0003974643443234350.000198732172161717
3500.9999303898764360.0001392202471279316.96101235639656e-05
3510.9995958153108140.000808369378371310.000404184689185655
3520.9978692366247310.004261526750537440.00213076337526872
3530.9986222253252210.002755549349557340.00137777467477867


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level1540.443804034582133NOK
5% type I error level2050.590778097982709NOK
10% type I error level2370.68299711815562NOK
 
Charts produced by software:
http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/108tdg1289489981.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/108tdg1289489981.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/1j9g41289489981.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/1j9g41289489981.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/2u1xp1289489981.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/2u1xp1289489981.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/3u1xp1289489981.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/3u1xp1289489981.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/4u1xp1289489981.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/4u1xp1289489981.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/5u1xp1289489981.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/5u1xp1289489981.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/64sea1289489981.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/64sea1289489981.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/7x1vv1289489981.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/7x1vv1289489981.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/8x1vv1289489981.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/8x1vv1289489981.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/9x1vv1289489981.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/11/t1289489976iy2zv1fzwz2sk0v/9x1vv1289489981.ps (open in new window)


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