Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 58.2998057129362 -0.668637279101902X[t] + 0.961166527491067Y1[t] + 0.0391683255838521Y2[t] + 0.0478769811627857Y3[t] -0.127097092762909Y4[t] -4.4972676862563M1[t] + 6.69352067183267M2[t] + 56.6788489417115M3[t] + 16.6872113068170M4[t] -4.55219702469572M5[t] -14.5874408744148M6[t] -9.10435377427196M7[t] + 9.94245587206924M8[t] + 9.88391350018948M9[t] + 2.43364712654867M10[t] -5.18399963045349M11[t] -0.254141845139373t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)58.299805712936227.4585052.12320.0401370.020069
X-0.6686372791019020.344845-1.9390.0597670.029884
Y10.9611665274910670.1613955.95541e-060
Y20.03916832558385210.2244540.17450.8623710.431186
Y30.04787698116278570.2229870.21470.8311140.415557
Y4-0.1270970927629090.165009-0.77020.4457970.222898
M1-4.49726768625634.845255-0.92820.3590240.179512
M26.693520671832675.0633931.32190.1938890.096944
M356.67884894171155.33530210.623400
M416.687211306817011.2126491.48820.1447270.072364
M5-4.5521970246957210.654938-0.42720.6715550.335778
M6-14.587440874414810.20374-1.42960.1607890.080395
M7-9.104353774271965.147178-1.76880.0847470.042374
M89.942455872069245.1801071.91940.0622780.031139
M99.883913500189485.871441.68340.100290.050145
M102.433647126548676.0639020.40130.6903650.345183
M11-5.183999630453494.995633-1.03770.3057980.152899
t-0.2541418451393730.110433-2.30130.0268030.013401


Multiple Linear Regression - Regression Statistics
Multiple R0.991290024248878
R-squared0.98265591217534
Adjusted R-squared0.975095668764592
F-TEST (value)129.976755877757
F-TEST (DF numerator)17
F-TEST (DF denominator)39
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.82215927009146
Sum Squared Residuals1815.1324271533


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1537540.152218825339-3.15221882533875
2543543.903410726035-0.903410726035087
3594599.296490072511-5.29649007251066
4611607.6296856746123.37031432538824
5613606.9877671646056.01223283539486
6611601.300038181939.69996181807006
7594598.950080254068-4.95008025406777
8595598.189864175547-3.18986417554682
9591597.688809347421-6.68880934742142
10589587.2907820477741.70921795222589
11584580.8857892046513.11421079534892
12573580.144826588557-7.14482658855679
13567564.6361956681052.36380433189497
14569568.7880271632060.211972836793970
15621620.917148911640.0828510883598304
16629632.041762829455-3.04176282945526
17628620.9989068661757.00109313382533
18612612.430837539255-0.430837539255436
19595595.481007231167-0.481007231167442
20597596.5099520440540.490047955945787
21593595.143211543495-2.14321154349531
22590584.1566176633465.84338233665436
23580573.8294675179366.17053248206424
24574569.9885912275254.0114087724753
25573559.44325670290713.5567432970926
26573570.1560678480872.84393215191329
27620620.163157708793-0.163157708792835
28626626.743002786996-0.743002786996366
29620613.6530974495976.34690255040347
30588599.881349474215-11.8813494742152
31566568.699109334762-2.69910933476215
32557565.447020955037-8.44702095503706
33561554.5851990754816.41480092451887
34549553.721074058793-4.72107405879328
35532536.436021271952-4.43602127195213
36526527.362411956453-1.36241195645339
37511514.89463839645-3.8946383964502
38499511.221396197816-12.2213961978163
39555549.5677647244255.43223527557525
40565562.9891736276612.01082637233926
41542555.033829943566-13.0338299435664
42527527.302437158433-0.302437158433059
43510510.641209357457-0.641209357457052
44514509.6663337178084.33366628219154
45517515.4730334989451.52696650105468
46508510.831526230087-2.83152623008697
47493497.848722005461-4.84872200546102
48490485.5041702274654.49582977253489
49469477.873690407199-8.87369040719865
50478467.93109806485610.0689019351442
51528528.055438582632-0.0554385826315939
52534535.596375081276-1.59637508127588
53518524.326398576057-6.32639857605727
54506503.0853376461662.91466235383363
55502493.2285938225468.77140617745442
56516509.1868291075536.81317089244655
57528527.1097465346570.890253465343169


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.2109263101645940.4218526203291880.789073689835406
220.1203440480479370.2406880960958740.879655951952063
230.06040298678582780.1208059735716560.939597013214172
240.03903244282114120.07806488564228230.96096755717886
250.08629661000432070.1725932200086410.91370338999568
260.08099943786147310.1619988757229460.919000562138527
270.04458464102007450.08916928204014890.955415358979925
280.02450776630271790.04901553260543590.975492233697282
290.1822780514348180.3645561028696360.817721948565182
300.6265563965402060.7468872069195880.373443603459794
310.7138290454645490.5723419090709010.286170954535451
320.6202231755566690.7595536488866610.379776824443331
330.5430800487580.9138399024840010.456919951242000
340.4184510844133370.8369021688266730.581548915586664
350.4793007107124570.9586014214249130.520699289287543
360.4351617077967650.870323415593530.564838292203235


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