Multiple Linear Regression - Estimated Regression Equation
Y_t[t] = + 20.9273860060955 + 0.486433189652739X_1t[t] -0.385377789795854X_2t[t] -0.864929940639701X_4t[t] -0.503718759631577M1[t] -0.507766600114035M2[t] + 0.447784853848473M3[t] + 3.16643897790194M4[t] + 0.255771035076966M5[t] + 0.325357546496257M6[t] -0.775616655495947M7[t] -0.221084905953848M8[t] -1.06540418890865M9[t] + 0.628688971148661M10[t] + 0.991759519914183M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)20.92738600609552.616147.999300
X_1t0.4864331896527390.04504110.799800
X_2t-0.3853777897958540.029986-12.851900
X_4t-0.8649299406397010.215395-4.01550.0001527.6e-05
M1-0.5037187596315772.353852-0.2140.8311990.415599
M2-0.5077666001140352.361114-0.21510.8303790.415189
M30.4477848538484732.3534950.19030.8496780.424839
M43.166438977901942.3574831.34310.1837580.091879
M50.2557710350769662.3662740.10810.9142470.457124
M60.3253575464962572.3546240.13820.8905140.445257
M7-0.7756166554959472.3689-0.32740.7443740.372187
M8-0.2210849059538482.367022-0.09340.9258630.462931
M9-1.065404188908652.356379-0.45210.6526310.326316
M100.6286889711486612.3520490.26730.7900640.395032
M110.9917595199141832.4410820.40630.6858330.342916


Multiple Linear Regression - Regression Statistics
Multiple R0.918349480127501
R-squared0.843365767650451
Adjusted R-squared0.810636226562486
F-TEST (value)25.7677235798627
F-TEST (DF numerator)14
F-TEST (DF denominator)67
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.22277306424807
Sum Squared Residuals1194.73142759331


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1-3-7.513726334838994.51372633483899
2-4-5.118214114307211.11821411430721
3-7-3.78416590935774-3.21583409064226
4-7-3.07281301771376-3.92718698228624
5-7-4.05151027954556-2.94848972045444
6-3-1.95397941929012-1.04602058070988
70-1.198313491705451.19831349170545
8-5-2.98865436818795-2.01134563181205
9-3-3.029612184301570.029612184301569
1031.273032875292631.72696712470737
112-1.148834426751933.14883442675193
12-7-5.83503039618816-1.16496960381184
13-1-1.196975908162270.196975908162268
140-2.538624801319382.53862480131938
15-30.720513045814369-3.72051304581437
1646.08032495665419-2.08032495665419
1721.021813455504490.978186544495507
1831.476777756719641.52322224328036
190-3.017266002018943.01726600201894
20-10-3.72680406053019-6.27319593946981
21-10-7.87510027119728-2.12489972880272
22-9-4.72858858099064-4.27141141900936
23-22-12.9278849918645-9.07211500813547
24-16-15.2847697196889-0.715230280311065
25-18-18.2344165052020.234416505201991
26-14-17.3597723274273.35977232742697
27-12-17.95261307145685.95261307145676
28-17-19.8892990054082.88929900540802
29-23-21.3801543053331-1.61984569466685
30-28-23.4515303134297-4.54846968657031
31-31-28.5587875101185-2.44121248988152
32-21-26.54495619161825.54495619161816
33-19-25.13169617078756.13169617078747
34-22-24.45683735490292.4568373549029
35-22-21.5725082288396-0.427491771160411
36-25-23.7530070053908-1.24699299460919
37-16-19.43516321977233.43516321977227
38-22-19.8365516208734-2.16344837912662
39-21-14.2445039185378-6.75549608146217
40-10-11.41791335581861.41791335581859
41-7-10.36866626881423.36866626881424
42-5-10.46678536306435.46678536306426
43-4-5.201403435404021.20140343540402
447-2.182099850348769.18209985034876
4560.650972813381795.34902718661821
4635.04779223402398-2.04779223402398
47106.125131620596593.87486837940341
4806.65603945023413-6.65603945023413
49-21.42165008118152-3.42165008118152
50-12.67987274195742-3.67987274195742
512-0.2114726632297162.21147266322972
5287.011860415995870.988139584004133
53-6-1.85082328013664-4.14917671986336
54-4-0.524047999472908-3.47595200052709
5541.31930178489192.6806982151081
5676.061584212417680.938415787582318
5730.8788531486465932.12114685135341
583-2.150843261908245.15084326190824
5980.9406783958827467.05932160411725
603-1.327113702907574.32711370290757
61-3-2.33790876861857-0.662091231381435
6240.1228152264121453.87718477358785
63-5-6.100031261722851.10003126172285
64-10.686474330825723-1.68647433082572
655-0.1705244147225145.17052441472251
660-1.294758891954161.29475889195416
67-6-4.30885996530785-1.69114003469215
68-13-11.1518814604137-1.84811853958628
69-15-7.00693259244911-7.99306740755089
70-8-9.759187651873861.75918765187386
71-20-15.4165823690233-4.58341763097671
72-10-15.45611862605875.45611862605867
73-22-17.7034593445874-4.29654065541256
74-25-19.9495251044426-5.05047489555738
75-10-14.42772622150954.42772622150947
76-8-10.39863432453542.39863432453541
77-9-8.20013490695238-0.799865093047616
78-5-5.78567576950850.785675769508497
79-7-3.03467138033715-3.96532861966285
80-11-5.46718828131891-5.53281171868109
81-11-7.48648474329295-3.51351525670705
82-16-11.225368259641-4.77463174035903


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
180.1519813990427440.3039627980854880.848018600957256
190.06232139136344680.1246427827268940.937678608636553
200.08876970297516450.1775394059503290.911230297024836
210.04218428544045270.08436857088090550.957815714559547
220.02540845624230480.05081691248460950.974591543757695
230.01531779884737710.03063559769475420.984682201152623
240.1066735906262570.2133471812525130.893326409373743
250.08494928530715130.1698985706143030.915050714692849
260.09392492658780960.1878498531756190.90607507341219
270.3178352704465180.6356705408930370.682164729553482
280.2987407853663190.5974815707326380.701259214633681
290.2296917300879480.4593834601758960.770308269912052
300.2210192720971840.4420385441943680.778980727902816
310.1653808353048990.3307616706097970.834619164695101
320.3557007559371860.7114015118743730.644299244062813
330.4140142526193960.8280285052387930.585985747380604
340.3796221395365630.7592442790731270.620377860463437
350.3073522022901960.6147044045803910.692647797709804
360.2441883502814090.4883767005628180.755811649718591
370.2530373111250540.5060746222501090.746962688874946
380.2289847375222870.4579694750445740.771015262477713
390.2619512070990080.5239024141980150.738048792900992
400.2410932888241720.4821865776483430.758906711175828
410.2634385606628170.5268771213256340.736561439337183
420.299200002675420.5984000053508410.70079999732458
430.2594286688912240.5188573377824480.740571331108776
440.5999462143054840.8001075713890320.400053785694516
450.7703364653954960.4593270692090080.229663534604504
460.7289118752779280.5421762494441440.271088124722072
470.7674297625936060.4651404748127880.232570237406394
480.8813184004311530.2373631991376940.118681599568847
490.8618725998882510.2762548002234970.138127400111749
500.8299355674062830.3401288651874340.170064432593717
510.7872191372748960.4255617254502070.212780862725104
520.722008549480070.555982901039860.27799145051993
530.7483251230503650.5033497538992690.251674876949635
540.7627539171072770.4744921657854470.237246082892723
550.7151793441428310.5696413117143380.284820655857169
560.653871152556510.6922576948869810.34612884744349
570.6356216938302240.7287566123395530.364378306169776
580.5823693192946470.8352613614107050.417630680705353
590.726974977717970.546050044564060.27302502228203
600.8036889367353710.3926221265292580.196311063264629
610.7122069691854740.5755860616290520.287793030814526
620.6661124327094280.6677751345811440.333887567290572
630.810802163402650.37839567319470.18919783659735
640.6884758701807680.6230482596384640.311524129819232


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level10.0212765957446809OK
10% type I error level30.0638297872340425OK