Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 104.978382790316 + 1.33316588097806X[t] -0.0404063636190839`Y-1`[t] + 0.149771378690737`Y-2`[t] + 15.9683744756981M1[t] -10.3645147838434M2[t] + 23.2324200251082M3[t] + 50.5247874887435M4[t] -76.4952318017308M5[t] -150.366438656282M6[t] + 89.9676465933025M7[t] + 92.380418573932M8[t] -18.7460270834543M9[t] -2.90954882184988M10[t] + 4.9443989866286M11[t] + 0.819374350182732t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)104.97838279031695.5822051.09830.2783280.139164
X1.333165880978060.1687937.898200
`Y-1`-0.04040636361908390.112674-0.35860.7216810.36084
`Y-2`0.1497713786907370.1052951.42240.1622970.081149
M115.968374475698127.8456930.57350.5693920.284696
M2-10.364514783843425.659976-0.40390.6883230.344161
M323.232420025108227.4161240.84740.4015750.200788
M450.524787488743528.8060081.7540.0867310.043366
M5-76.495231801730835.512308-2.1540.0370210.01851
M6-150.36643865628244.611142-3.37060.0016180.000809
M789.967646593302552.1172411.72630.0916520.045826
M892.38041857393244.5927462.07160.0444770.022238
M9-18.746027083454330.517866-0.61430.5423540.271177
M10-2.9095488218498828.604565-0.10170.9194660.459733
M114.944398986628627.5155370.17970.8582560.429128
t0.8193743501827320.3009932.72220.00940.0047


Multiple Linear Regression - Regression Statistics
Multiple R0.975945174039772
R-squared0.95246898273152
Adjusted R-squared0.935493619421349
F-TEST (value)56.1089011957001
F-TEST (DF numerator)15
F-TEST (DF denominator)42
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation37.3795930765591
Sum Squared Residuals58683.827099904


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1825779.47560813066845.5243918693321
2677683.093442228357-6.0934422283567
3656662.820448195537-6.82044819553671
4785830.927631197472-45.9276311974719
5412399.07337493970512.9266250602948
6352303.08749103430348.9125089656967
7839861.420723111472-22.4207231114720
8729770.663559470421-41.6635594704212
9696645.7514037962250.2485962037806
10641672.595966490038-31.5959664900384
11695699.879837246604-4.87983724660396
12638624.00981262174613.9901873782538
13762780.505469078087-18.5054690780867
14635624.1259989685210.8740010314800
15721698.24355783666622.7564421633339
16854849.1744683121284.82553168787193
17418410.5203041431677.47969585683312
18367344.34242428009122.6575757199086
19824820.8854446543573.11455534564345
20687674.0291155670612.9708844329398
21601625.704743208535-24.7047432085354
22676698.640987664726-22.6409876647261
23740676.73866929379463.261330706206
24691663.92933433481727.0706656651828
25683730.944173762604-47.9441737626042
26594617.09199346669-23.0919934666902
27729657.90579560133171.0942043986688
28731752.555642005693-21.5556420056934
29386426.520950100033-40.5209501000329
30331322.3812158483768.6187841516245
31707723.392943112444-16.3929431124440
32715700.52853913253414.4714608674659
33657676.87507056659-19.8750705665903
34653627.74803748695125.2519625130490
35642685.222378018083-43.2223780180825
36643655.6125861281-12.6125861281004
37718740.037069235623-22.0370692356233
38654627.65339793190626.3466020680939
39632698.552387741094-66.5523877410941
40731736.632023652018-5.63202365201774
41392420.492452688246-28.4924526882461
42344386.631070988954-42.6310709889543
43792796.257577265702-4.25757726570202
44852819.52628647126332.4737135287366
45649649.907984069405-0.907984069405233
46629638.424971264057-9.42497126405656
47685700.15911544152-15.1591154415196
48617645.448266915336-28.4482669153362
49715672.03767979301842.962320206982
50715723.035167404527-8.03516740452706
51629649.477810625372-20.4778106253720
52916847.71023483268968.289765167311
53531482.39291812884948.6070818711511
54357394.557797848276-37.5577978482756
55917877.04331185602639.9566881439745
56828846.252499358721-18.2524993587212
57708712.76079835925-4.76079835924968
58858819.59003709422838.4099629057722


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.008675816114451930.01735163222890390.991324183885548
200.02224019351983850.0444803870396770.977759806480161
210.1506273062272190.3012546124544380.849372693772781
220.1210003866175160.2420007732350320.878999613382484
230.1004465550468710.2008931100937420.899553444953129
240.07982095230852420.1596419046170480.920179047691476
250.0829341591972780.1658683183945560.917065840802722
260.05175589662619640.1035117932523930.948244103373804
270.1400352093418510.2800704186837020.85996479065815
280.1879957602673490.3759915205346990.81200423973265
290.1335333592375550.2670667184751100.866466640762445
300.2964899361398780.5929798722797550.703510063860122
310.2124962448862230.4249924897724460.787503755113777
320.2144044267381840.4288088534763670.785595573261817
330.2460059728749330.4920119457498660.753994027125067
340.2830631153930040.5661262307860080.716936884606996
350.2478469520119140.4956939040238290.752153047988086
360.1922815236971000.3845630473941990.8077184763029
370.1699094819748960.3398189639497910.830090518025104
380.2308858963871560.4617717927743120.769114103612844
390.3570622692761440.7141245385522880.642937730723856


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