Multiple Linear Regression - Estimated Regression Equation

QBEPIL[t] = + 0.13092809560212 -0.965391719746462PBEPIL[t] + 0.0726768479056838PBELUX[t] + 0.0249194280100807PBABD[t] -0.175431578573902PBFRU[t] -0.32265123644768PBEPAL[t] -0.126528622098074PBESTO[t] + 0.283699695169786PBEWIT[t] + 0.115370247801717PBENA[t] -0.0127587588377971PCHSAN[t] -0.161931944644183PWABR[t] + 0.110141558184619PSOCOLA[t] -0.165755390119786PSOBIT[t] -0.276345162564919PSPORT[t] + 0.994011328932661BUDBEER[t] + 0.0564059090374617BUDCHIL[t] -0.332643182408528BUDAMB[t] + 0.265561059722925BUDWATER[t] -0.0351291352891992BUDSISSS[t] + e[t]

Multiple Linear Regression - Ordinary Least Squares
Variable	Parameter	S.D.	T-STAT H0: parameter = 0	2-tail p-value	1-tail p-value
(Intercept)	0.13092809560212	0.567231	0.2308	0.81788	0.40894
PBEPIL	-0.965391719746462	0.169144	-5.7075	0	0
PBELUX	0.0726768479056838	0.101229	0.7179	0.474299	0.23715
PBABD	0.0249194280100807	0.057064	0.4367	0.663183	0.331592
PBFRU	-0.175431578573902	0.127985	-1.3707	0.173226	0.086613
PBEPAL	-0.32265123644768	0.098239	-3.2844	0.001368	0.000684
PBESTO	-0.126528622098074	0.080692	-1.568	0.119717	0.059858
PBEWIT	0.283699695169786	0.121028	2.3441	0.020853	0.010426
PBENA	0.115370247801717	0.197244	0.5849	0.559795	0.279897
PCHSAN	-0.0127587588377971	0.079096	-0.1613	0.872145	0.436072
PWABR	-0.161931944644183	0.114502	-1.4142	0.160094	0.080047
PSOCOLA	0.110141558184619	0.132054	0.8341	0.406034	0.203017
PSOBIT	-0.165755390119786	0.133267	-1.2438	0.216199	0.108099
PSPORT	-0.276345162564919	0.08472	-3.2618	0.001471	0.000735
BUDBEER	0.994011328932661	0.032848	30.2613	0	0
BUDCHIL	0.0564059090374617	0.018751	3.0082	0.003252	0.001626
BUDAMB	-0.332643182408528	0.037748	-8.8121	0	0
BUDWATER	0.265561059722925	0.026688	9.9506	0	0
BUDSISSS	-0.0351291352891992	0.027132	-1.2947	0.198098	0.099049

Multiple Linear Regression - Regression Statistics
Multiple R	0.983383587140146
R-squared	0.967043279456622
Adjusted R-squared	0.961698946395533
F-TEST (value)	180.947420080829
F-TEST (DF numerator)	18
F-TEST (DF denominator)	111
p-value	0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation	0.0222169480518623
Sum Squared Residuals	0.0547887986620453

Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or Index	Actuals	Interpolation Forecast	Residuals Prediction Error
1	15.27	15.2826400794711	-0.0126400794711274
2	15.18	15.1925780798314	-0.0125780798314214
3	15.13	15.121770066655	0.00822993334495348
4	15.14	15.1224862467038	0.0175137532961766
5	15.1	15.0883990784915	0.0116009215084856
6	15.17	15.1389469790316	0.0310530209684475
7	15.11	15.0962941308911	0.0137058691088807
8	15.09	15.0869410447994	0.00305895520056644
9	15.1	15.0792141844608	0.0207858155391562
10	15.06	15.080819268039	-0.0208192680389654
11	15.03	15.0450311776033	-0.0150311776032828
12	15.03	15.0749945416163	-0.0449945416162635
13	15.13	15.1368276592425	-0.00682765924252644
14	15.02	15.0363416643643	-0.0163416643642725
15	15.01	15.0245190142643	-0.0145190142643286
16	15.04	15.0348369340166	0.00516306598336261
17	15.02	15.0325888207322	-0.0125888207322283
18	15	15.030881321354	-0.0308813213540419
19	15.13	15.1622776257355	-0.0322776257354772
20	15.06	15.0561115242984	0.00388847570155548
21	14.9	14.9135497983811	-0.0135497983811083
22	14.91	14.8973274293885	0.0126725706114548
23	14.92	14.9085428086654	0.0114571913345518
24	14.97	14.9537433570646	0.0162566429353979
25	14.97	14.9436988174049	0.0263011825950855
26	15.03	15.0190175802705	0.0109824197295447
27	15.01	14.99466834472	0.0153316552799766
28	15.02	15.0124319324961	0.0075680675038759
29	14.98	14.9825357622808	-0.00253576228077316
30	15.03	15.0218816675603	0.00811833243972474
31	14.99	14.9776060880185	0.0123939119814932
32	15.05	15.0446357556875	0.00536424431249411
33	15.04	15.0485985609887	-0.00859856098873236
34	15.11	15.1212159389511	-0.0112159389511336
35	15.14	15.1563443701894	-0.0163443701893607
36	15.06	15.0640995976528	-0.00409959765278155
37	15.1	15.1078981690388	-0.00789816903880273
38	15.2	15.2111813037661	-0.0111813037661344
39	15.13	15.1254411888401	0.00455881115985261
40	15.21	15.157615516748	0.0523844832519675
41	15.17	15.1779682767948	-0.00796827679482645
42	15.18	15.187289384333	-0.0072893843330293
43	15.21	15.2157155493957	-0.00571554939569099
44	15.25	15.2706593051376	-0.0206593051376366
45	15.18	15.165876003344	0.0141239966559557
46	15.19	15.1907463944392	-0.000746394439168164
47	15.25	15.2434171183608	0.00658288163916944
48	15.21	15.2181136499266	-0.0081136499266401
49	15.2	15.2051873948611	-0.00518739486107712
50	15.28	15.2803121739991	-0.00031217399911541
51	15.41	15.4042448512048	0.0057551487952284
52	15.45	15.4538606631843	-0.00386066318427684
53	15.31	15.3193450779308	-0.0093450779308306
54	15.19	15.1879402424491	0.00205975755093465
55	15.18	15.146873299862	0.0331267001379809
56	15.26	15.207689860352	0.0523101396480299
57	15.24	15.2171484406363	0.0228515593636781
58	15.14	15.1294763186586	0.0105236813414218
59	15.08	15.0867572186061	-0.00675721860609976
60	15.12	15.1294879583488	-0.00948795834878799
61	15.11	15.1036146319712	0.00638536802884227
62	15.08	15.0402459206206	0.0397540793793959
63	15.06	15.0633629465879	-0.00336294658786801
64	15.17	15.1640085703819	0.00599142961813705
65	15.11	15.0907597642701	0.0192402357298724
66	15.03	15.0592055660217	-0.0292055660217504
67	15.02	15.0183256906035	0.00167430939651892
68	15.02	15.0240904833439	-0.00409048334393806
69	15.04	15.0555655838472	-0.0155655838471837
70	15.01	15.0431006159508	-0.0331006159508107
71	15.06	15.0674905606465	-0.00749056064645165
72	15.09	15.1040482293134	-0.0140482293134122
73	15.11	15.0911568390288	0.018843160971234
74	14.94	14.9594244301162	-0.0194244301162209
75	14.94	14.9377041012097	0.00229589879034761
76	14.97	14.9712833624618	-0.00128336246183767
77	14.99	14.9738871990157	0.0161128009842672
78	15.06	15.0500010084061	0.00999899159385736
79	15.03	15.0415918121439	-0.0115918121439201
80	15	15.0433949878574	-0.0433949878573777
81	15.01	15.0048640953844	0.00513590461557218
82	15.02	15.0082385826103	0.0117614173896677
83	15.03	15.0213533666723	0.00864663332766472
84	15.08	15.0793275642218	0.000672435778162952
85	15.13	15.1340836232586	-0.0040836232586152
86	15.15	15.1488829800173	0.0011170199826795
87	15.14	15.1221428336039	0.0178571663961068
88	15.1	15.1390672720908	-0.0390672720908314
89	15.12	15.0982300540773	0.0217699459226564
90	15.23	15.2325149550511	-0.00251495505105216
91	15.24	15.2370821121578	0.00291788784216028
92	15.19	15.2164845074692	-0.0264845074691971
93	15.21	15.2113463290254	-0.0013463290253991
94	15.33	15.3137098290484	0.0162901709515837
95	15.21	15.1996991332429	0.0103008667570881
96	15.19	15.2365076873175	-0.0465076873174865
97	15.32	15.3337645670741	-0.0137645670741451
98	15.51	15.4604199710717	0.049580028928307
99	15.34	15.3295255172128	0.0104744827872232
100	15.23	15.2427127599825	-0.0127127599825153
101	15.4	15.3929864144822	0.00701358551781899
102	15.23	15.2803187711489	-0.0503187711488945
103	15.3	15.2982814958172	0.00171850418280274
104	15.25	15.2790974722109	-0.0290974722109334
105	15.22	15.2106507175201	0.00934928247987057
106	15.24	15.1966921287403	0.0433078712597349
107	15.17	15.1913323702071	-0.0213323702071388
108	15.31	15.2743047638864	0.0356952361136299
109	15.27	15.2572051692675	0.0127948307325424
110	15.16	15.1474829669952	0.0125170330048152
111	15.18	15.1376716203755	0.0423283796244981
112	15.15	15.1383926117099	0.0116073882901491
113	15.11	15.0787601150737	0.031239884926335
114	15.15	15.1090137674282	0.0409862325717554
115	15.11	15.1284065673756	-0.0184065673755863
116	15.2	15.2001273404078	-0.000127340407825702
117	15.1	15.0914381050048	0.00856189499515579
118	15.09	15.0806351856833	0.00936481431673854
119	15.07	15.1118244510617	-0.041824451061726
120	15	15.0178845749721	-0.0178845749721367
121	15.06	15.0873381407234	-0.0273381407233893
122	15.03	15.0208954261102	0.00910457388983726
123	15.06	15.0944531141745	-0.034453114174491
124	15.18	15.2137314220676	-0.0337314220676075
125	15.13	15.1501332003326	-0.0201332003325514
126	14.99	14.9942094976461	-0.0042094976461133
127	14.99	14.9942122213109	-0.00421222131086009
128	15.03	15.0188776343832	0.0111223656168324
129	15.03	15.0050653068687	0.0249346931312824
130	15.05	15.0717147710853	-0.0217147710853385

Goldfeld-Quandt test for Heteroskedasticity
p-values	Alternative Hypothesis
breakpoint index	greater	2-sided	less
22	0.561119666349008	0.877760667301983	0.438880333650991
23	0.467908201675986	0.935816403351973	0.532091798324014
24	0.385974857885776	0.771949715771552	0.614025142114224
25	0.265149182354684	0.530298364709368	0.734850817645316
26	0.199484985527734	0.398969971055468	0.800515014472266
27	0.147249164713998	0.294498329427996	0.852750835286002
28	0.102909664873722	0.205819329747445	0.897090335126278
29	0.0838236135847596	0.167647227169519	0.91617638641524
30	0.0538384503445727	0.107676900689145	0.946161549655427
31	0.0333688411890773	0.0667376823781545	0.966631158810923
32	0.0224272554424783	0.0448545108849565	0.977572744557522
33	0.0178106279590692	0.0356212559181385	0.982189372040931
34	0.0123341205530466	0.0246682411060932	0.987665879446953
35	0.0111551196350397	0.0223102392700794	0.98884488036496
36	0.00613160900017682	0.0122632180003536	0.993868390999823
37	0.00431297890770592	0.00862595781541183	0.995687021092294
38	0.00241402898703634	0.00482805797407268	0.997585971012964
39	0.00128116540646157	0.00256233081292314	0.998718834593538
40	0.00808202497330861	0.0161640499466172	0.991917975026691
41	0.00769520321008854	0.0153904064201771	0.992304796789911
42	0.00470950426038692	0.00941900852077384	0.995290495739613
43	0.00292496534561441	0.00584993069122881	0.997075034654386
44	0.00348456065787778	0.00696912131575556	0.996515439342122
45	0.00604461060839241	0.0120892212167848	0.993955389391608
46	0.00382900783441667	0.00765801566883333	0.996170992165583
47	0.00248682942777684	0.00497365885555368	0.997513170572223
48	0.00146079527394132	0.00292159054788265	0.998539204726059
49	0.00102304357589466	0.00204608715178931	0.998976956424105
50	0.000630811846859428	0.00126162369371886	0.999369188153141
51	0.000745429412438234	0.00149085882487647	0.999254570587562
52	0.000832557755340621	0.00166511551068124	0.999167442244659
53	0.000514481683763044	0.00102896336752609	0.999485518316237
54	0.000286593035047322	0.000573186070094643	0.999713406964953
55	0.00114989841062324	0.00229979682124648	0.998850101589377
56	0.0082897822353554	0.0165795644707108	0.991710217764645
57	0.00813257754825138	0.0162651550965028	0.991867422451749
58	0.00607424269336643	0.0121484853867329	0.993925757306634
59	0.00502644307360364	0.0100528861472073	0.994973556926396
60	0.00368664307042902	0.00737328614085804	0.996313356929571
61	0.00316388426001547	0.00632776852003094	0.996836115739985
62	0.0185451958394574	0.0370903916789149	0.981454804160543
63	0.0129808499997936	0.0259616999995872	0.987019150000206
64	0.00942668215620177	0.0188533643124035	0.990573317843798
65	0.00837634314171085	0.0167526862834217	0.991623656858289
66	0.0200067565123435	0.0400135130246869	0.979993243487656
67	0.0146288101119238	0.0292576202238475	0.985371189888076
68	0.0122579114427908	0.0245158228855816	0.987742088557209
69	0.0124426084764839	0.0248852169529677	0.987557391523516
70	0.0202547655201236	0.0405095310402471	0.979745234479876
71	0.0226646541629527	0.0453293083259053	0.977335345837047
72	0.0376529275552526	0.0753058551105053	0.962347072444747
73	0.0314417937859828	0.0628835875719655	0.968558206214017
74	0.029439245859999	0.0588784917199979	0.970560754140001
75	0.021402746216506	0.0428054924330119	0.978597253783494
76	0.0157530886215512	0.0315061772431025	0.984246911378449
77	0.0122757394982948	0.0245514789965897	0.987724260501705
78	0.00858943382186943	0.0171788676437389	0.991410566178131
79	0.00714226954482042	0.0142845390896408	0.99285773045518
80	0.0202958041425018	0.0405916082850037	0.979704195857498
81	0.0139334295683667	0.0278668591367333	0.986066570431633
82	0.0100799792215077	0.0201599584430154	0.989920020778492
83	0.00745906243702023	0.0149181248740405	0.99254093756298
84	0.00482372643885443	0.00964745287770885	0.995176273561146
85	0.00324571391339975	0.0064914278267995	0.9967542860866
86	0.00201261687188145	0.00402523374376289	0.997987383128119
87	0.00241583794632445	0.00483167589264891	0.997584162053676
88	0.00383988782960343	0.00767977565920685	0.996160112170397
89	0.00361491378448708	0.00722982756897415	0.996385086215513
90	0.00268580961886866	0.00537161923773732	0.997314190381131
91	0.00161391509652086	0.00322783019304172	0.998386084903479
92	0.0037639820464462	0.0075279640928924	0.996236017953554
93	0.00407210829069865	0.0081442165813973	0.995927891709301
94	0.00250971771239122	0.00501943542478245	0.997490282287609
95	0.00281730699270756	0.00563461398541512	0.997182693007292
96	0.00267509383747455	0.00535018767494911	0.997324906162525
97	0.00737457884333969	0.0147491576866794	0.99262542115666
98	0.0154639743732156	0.0309279487464312	0.984536025626784
99	0.0126088656194014	0.0252177312388028	0.987391134380599
100	0.0101122142177693	0.0202244284355387	0.989887785782231
101	0.043869961112179	0.0877399222243581	0.956130038887821
102	0.181318384609009	0.362636769218019	0.818681615390991
103	0.124691297878053	0.249382595756107	0.875308702121947
104	0.082837640664494	0.165675281328988	0.917162359335506
105	0.0615314512558484	0.123062902511697	0.938468548744152
106	0.0429466334961088	0.0858932669922176	0.957053366503891
107	0.386075575936307	0.772151151872614	0.613924424063693
108	0.258998934905291	0.517997869810581	0.741001065094709

Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description	# significant tests	% significant tests	OK/NOK
1% type I error level	31	0.35632183908046	NOK
5% type I error level	66	0.758620689655172	NOK
10% type I error level	72	0.827586206896552	NOK