Multiple Linear Regression - Estimated Regression Equation
BEL_20[t] = -260.706690926404 + 0.0250525591118981Nikkei[t] + 0.102631890756772DJ_Indust[t] + 0.006957119094245Goudprijs[t] -10.2630504431514Conjunct_Seizoenzuiver[t] + 12.9959047466191Cons_vertrouw[t] -7.33394620617855Alg_consumptie_index_BE[t] -165.868025333682Gem_rente_kasbon_5j[t] + 0.806808871155089Y1[t] -0.114390996301673Y2[t] + 0.181991078938916Y3[t] -0.0730288844595162Y4[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-260.706690926404157.937258-1.65070.1015050.050753
Nikkei0.02505255911189810.0072143.47270.0007250.000362
DJ_Indust0.1026318907567720.0194855.26731e-060
Goudprijs0.0069571190942450.0035851.94040.0547580.027379
Conjunct_Seizoenzuiver-10.26305044315143.080988-3.33110.0011610.00058
Cons_vertrouw12.99590474661912.9367314.42532.2e-051.1e-05
Alg_consumptie_index_BE-7.3339462061785510.299251-0.71210.4778420.238921
Gem_rente_kasbon_5j-165.86802533368225.569328-6.48700
Y10.8068088711550890.0853449.453600
Y2-0.1143909963016730.112468-1.01710.3112250.155613
Y30.1819910789389160.1114771.63250.1052760.052638
Y4-0.07302888445951620.073509-0.99350.3225470.161274


Multiple Linear Regression - Regression Statistics
Multiple R0.990305665787982
R-squared0.980705311691779
Adjusted R-squared0.978875642972896
F-TEST (value)536.001573164823
F-TEST (DF numerator)11
F-TEST (DF denominator)116
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation110.643967300128
Sum Squared Residuals1420082.14998977


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
13173.953467.20395684971-293.253956849713
23165.263166.33400475918-1.07400475917596
33092.713253.24318993043-160.533189930426
43053.053097.78756228371-44.7375622837136
53181.963068.70449700179113.255502998209
62999.933069.456961988-69.5269619880009
73249.573054.34084232542195.229157674582
83210.523274.95114213856-64.431142138561
93030.293206.83415388342-176.544153883423
102803.473051.18046483841-247.710464838414
112767.632869.72876856238-102.098768562381
122882.62903.61905785664-21.0190578566352
132863.362847.0988190816216.2611809183754
142897.062838.3428010763758.7171989236346
153012.612894.63433382927117.975666170726
163142.953017.40273750787125.547262492127
173032.933022.0778954568910.8521045431094
183045.782931.82647547135113.953524528646
193110.523007.28256317961103.237436820385
203013.243113.06577998169-99.8257799816897
212987.13041.88708251668-54.7870825166776
222995.552993.170537084362.37946291564232
232833.182925.48578054612-92.3057805461233
242848.962831.0015634015917.9584365984119
252794.832891.44310757541-96.6131075754113
262845.262847.5657863162-2.30578631619529
272915.022869.7422068177545.277793182248
282892.632834.9581861888757.6718138111332
292604.422694.55960606494-90.1396060649419
302641.652440.86718632355200.782813676453
312659.812537.94838063762121.861619362381
322638.532556.1221340153782.4078659846257
332720.252612.97029490253107.27970509747
342745.882670.942119320974.937880679098
352735.72703.5595112311932.1404887688128
362811.72644.58139788928167.118602110724
372799.432718.2563437139881.1736562860207
382555.282635.76316212094-80.4831621209376
392304.982377.52624607223-72.546246072231
402214.952224.75260418944-9.80260418944235
412065.812111.78229724053-45.9722972405347
421940.491961.13332624318-20.6433262431819
4320421916.43449107842125.565508921578
441995.371942.1546453086853.2153546913235
451946.811940.682668516026.12733148397533
461765.91861.52507793266-95.6250779326628
471635.251679.2992266262-44.0492266261958
481833.421684.40793861533149.012061384672
491910.431960.85359447305-50.4235944730495
501959.672113.92544550314-154.255445503144
511969.62113.67604473085-144.07604473085
522061.412057.960912966133.44908703386985
532093.482222.85733855074-129.377338550744
542120.882084.8785993604336.0014006395703
552174.562200.45878078965-25.8987807896495
562196.722272.17210730731-75.452107307312
572350.442363.07965422396-12.6396542239555
582440.252514.1510039829-73.9010039828977
592408.642551.04381936523-142.403819365229
602472.812554.96536232685-82.1553623268483
612407.62492.46870431742-84.8687043174208
622454.622541.96451296828-87.3445129682793
632448.052462.0851575135-14.0351575135041
642497.842486.1072920684111.7327079315883
652645.642555.7017972826489.9382027173589
662756.762577.8866697528178.873330247205
672849.272719.98898167275129.281018327251
682921.442875.6816207673445.7583792326578
692981.852927.9053600262953.9446399737078
703080.583083.64995305582-3.0699530558192
713106.223182.89048690123-76.6704869012327
723119.313141.57100875059-22.261008750592
733061.263105.43361308601-44.1736130860067
743097.313088.52672821318.78327178690254
753161.693159.257263625942.43273637405727
763257.163202.9952252001254.1647747998809
773277.013216.6109047640760.3990952359311
783295.323286.420538724328.89946127567834
793363.993330.0641990291333.9258009708689
803494.173450.1728820479543.9971179520542
813667.033607.0359795915459.9940204084565
823813.063748.0178628000165.0421371999933
833917.963827.0225917609790.9374082390337
843895.513904.05484933636-8.54484933636026
853801.063825.15358404066-24.093584040661
863570.123726.30798898261-156.187988982612
873701.613522.69765525564178.912344744364
883862.273684.16509310029178.104906899715
893970.13818.89667219032151.203327809679
904138.524021.74361967929116.776380320708
914199.754184.1576802365815.592319763425
924290.894124.76619869132166.123801308677
934443.914317.89482363685126.015176363151
944502.644447.5286837633555.1113162366501
954356.984419.2951666984-62.3151666984014
964591.274398.5798222448192.6901777552
974696.964671.3213779044925.638622095512
984621.44629.46956744007-8.06956744006972
994562.844584.77454273744-21.9345427374353
1004202.524488.22698001557-285.706980015571
1014296.494225.0807520574571.4092479425464
1024435.234422.2808913506712.9491086493269
1034105.184281.92776215144-176.747762151443
1044116.684145.17490964838-28.4949096483841
1053844.494025.45204593649-180.962045936491
1063720.983789.66113769446-68.6811376944588
1073674.43746.02102646824-71.6210264682444
1083857.623730.77000425409126.849995745909
1093801.063811.2136841969-10.1536841968965
1103504.373569.6541459628-65.2841459627997
1113032.63196.51429632775-163.914296327754
1123047.032863.23668579991183.79331420009
1132962.342955.675564389886.66443561011828
1142197.822520.05182648897-322.231826488974
1152014.451967.5399936654846.9100063345203
1161862.831940.45550701668-77.6255070166772
1171905.411767.08456288793138.325437112074
1181810.991801.858557419389.13144258061918
1191670.071725.45280795337-55.382807953366
1201864.441732.7451791336131.694820866399
1212052.021959.2147827569392.8052172430666
1222029.62068.29470960025-38.6947096002482
1232070.832080.140736216-9.31073621600352
1242293.412253.8164293133839.5935706866216
1252443.272435.665687866877.60431213312592
1262513.172506.789818301836.38018169816949
1272466.922617.09648544227-150.17648544227
1282502.662545.26478975177-42.6047897517722


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
150.8002349189794880.3995301620410240.199765081020512
160.8230517611766340.3538964776467330.176948238823366
170.7320926496611970.5358147006776060.267907350338803
180.6455304261977920.7089391476044150.354469573802208
190.5565251699935370.8869496600129270.443474830006463
200.6213601350885310.7572797298229380.378639864911469
210.8515798843924030.2968402312151950.148420115607598
220.8495037346495040.3009925307009910.150496265350496
230.8535314943871460.2929370112257090.146468505612854
240.8054615178944220.3890769642111570.194538482105578
250.7902434361572160.4195131276855680.209756563842784
260.7383098257063580.5233803485872840.261690174293642
270.682916938365540.634166123268920.31708306163446
280.6135166507817890.7729666984364220.386483349218211
290.5618172169881330.8763655660237340.438182783011867
300.5442051044268560.9115897911462870.455794895573144
310.4939165542202930.9878331084405860.506083445779707
320.4410782908065470.8821565816130950.558921709193453
330.4033456039440570.8066912078881140.596654396055943
340.3739186523567060.7478373047134120.626081347643294
350.3637777867762460.7275555735524920.636222213223754
360.3806316132544660.7612632265089310.619368386745534
370.3567115515655870.7134231031311730.643288448434413
380.3756147346906290.7512294693812580.624385265309371
390.4071528034118030.8143056068236070.592847196588197
400.3705143337785120.7410286675570240.629485666221488
410.3181634180211430.6363268360422850.681836581978857
420.2808633806815930.5617267613631850.719136619318407
430.2745249217551020.5490498435102030.725475078244898
440.2678344898916060.5356689797832130.732165510108394
450.2378852254813870.4757704509627730.762114774518613
460.2297458841571730.4594917683143460.770254115842827
470.2511732355144760.5023464710289530.748826764485524
480.2508542091793850.5017084183587690.749145790820615
490.2086163478653020.4172326957306040.791383652134698
500.2124842214698930.4249684429397870.787515778530107
510.2384027141328390.4768054282656770.761597285867161
520.1966696433165290.3933392866330580.803330356683471
530.2035494165656120.4070988331312240.796450583434388
540.1799372764926280.3598745529852570.820062723507372
550.1491970213273180.2983940426546350.850802978672682
560.1516323312566740.3032646625133470.848367668743326
570.1278098079778730.2556196159557470.872190192022127
580.1105587472069270.2211174944138540.889441252793073
590.1343608768619170.2687217537238330.865639123138083
600.1922759465842940.3845518931685890.807724053415706
610.2011155320704120.4022310641408250.798884467929588
620.3304073228541910.6608146457083820.669592677145809
630.3643645440620770.7287290881241550.635635455937923
640.4390995716802680.8781991433605360.560900428319732
650.5297050959309430.9405898081381140.470294904069057
660.6786844623665060.6426310752669880.321315537633494
670.7272300461654530.5455399076690940.272769953834547
680.7108622562773520.5782754874452970.289137743722648
690.7091512894368850.581697421126230.290848710563115
700.6876720891553930.6246558216892140.312327910844607
710.6594780058683220.6810439882633570.340521994131678
720.6285771145856470.7428457708287070.371422885414353
730.5816960318674120.8366079362651760.418303968132588
740.5313119270183010.9373761459633980.468688072981699
750.4807103253175210.9614206506350420.519289674682479
760.4632129183736930.9264258367473870.536787081626307
770.4454465577009050.890893115401810.554553442299095
780.4141867590737930.8283735181475870.585813240926207
790.3747358538833820.7494717077667630.625264146116618
800.460759150765490.921518301530980.53924084923451
810.5817371512163410.8365256975673170.418262848783659
820.6441524059922170.7116951880155660.355847594007783
830.6117084322879150.776583135424170.388291567712085
840.777441560870680.4451168782586410.222558439129321
850.9166392834793160.1667214330413690.0833607165206845
860.9956184703718170.008763059256365270.00438152962818263
870.995073068065860.00985386386827940.0049269319341397
880.9931929404071650.01361411918566950.00680705959283473
890.9903160982674280.0193678034651440.00968390173257202
900.9896986614922040.02060267701559250.0103013385077963
910.9870088849723250.02598223005535070.0129911150276754
920.9814774280613230.03704514387735460.0185225719386773
930.97217794434760.05564411130479960.0278220556523998
940.960132247482180.07973550503563930.0398677525178196
950.9595908262487090.08081834750258260.0404091737512913
960.9573200166458790.0853599667082420.042679983354121
970.9496327643363960.1007344713272090.0503672356636043
980.9511345839382770.09773083212344540.0488654160617227
990.9644375512898730.07112489742025430.0355624487101272
1000.982135743937860.03572851212427920.0178642560621396
1010.9756294675110930.04874106497781310.0243705324889066
1020.9616434712477920.07671305750441620.0383565287522081
1030.965576933608040.0688461327839210.0344230663919605
1040.980594335714480.03881132857103840.0194056642855192
1050.9901150366293060.01976992674138870.00988496337069437
1060.9903714776734140.01925704465317280.00962852232658638
1070.9832362576116050.03352748477678910.0167637423883946
1080.971596302264950.05680739547010010.02840369773505
1090.9558481773072170.0883036453855650.0441518226927825
1100.9176741842860310.1646516314279380.082325815713969
1110.9781752697163170.04364946056736620.0218247302836831
1120.9489599529761410.1020800940477170.0510400470238586
1130.906675212779650.1866495744406990.0933247872203497


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level20.0202020202020202NOK
5% type I error level140.141414141414141NOK
10% type I error level240.242424242424242NOK