Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 27.2884150780906 + 7.47895824192816X[t] + 1.07957881958415Y1[t] + 0.0219700856362730Y2[t] -0.140078156472438Y3[t] -18.6096792509571M1[t] -17.3675468737958M2[t] -14.4556056693470M3[t] + 3.85191565250290M4[t] + 1.81841815303683M5[t] -6.79023110683807M6[t] -10.5917907190378M7[t] -5.5146948443727M8[t] -13.0312279400098M9[t] + 0.313573448969398M10[t] + 49.1524062059444M11[t] -0.176355958412839t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)27.288415078090632.4546720.84080.4053280.202664
X7.478958241928163.9323941.90190.0642280.032114
Y11.079578819584150.1593326.775700
Y20.02197008563627300.2353540.09330.9260810.46304
Y3-0.1400781564724380.16043-0.87310.387670.193835
M1-18.609679250957112.046999-1.54480.130090.065045
M2-17.367546873795810.959982-1.58460.1207340.060367
M3-14.455605669347011.530624-1.25370.2170630.108532
M43.8519156525029011.5025590.33490.7394270.369713
M51.818418153036839.0830380.20020.8423140.421157
M6-6.790231106838079.113171-0.74510.4604610.23023
M7-10.59179071903789.953327-1.06410.293490.146745
M8-5.514694844372710.450702-0.52770.6005610.300281
M9-13.031227940009810.161493-1.28240.2069010.103451
M100.31357344896939811.0103390.02850.9774180.488709
M1149.15240620594449.5932025.12378e-064e-06
t-0.1763559584128390.13019-1.35460.1829620.091481


Multiple Linear Regression - Regression Statistics
Multiple R0.989562151332385
R-squared0.979233251349577
Adjusted R-squared0.971129154315266
F-TEST (value)120.831876420492
F-TEST (DF numerator)16
F-TEST (DF denominator)41
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation7.2247844893341
Sum Squared Residuals2140.09794761022


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1613605.1128305380477.88716946195325
2611601.5672700716859.43272992831453
3594599.806309189794-5.80630918979425
4595599.260538136083-4.26053813608336
5591598.036928354917-7.03692835491685
6589587.336906603961.66309339603974
7584580.9718748951623.02812510483808
8573580.99109316811-7.99109316811058
9567561.5931429833995.40685701660145
10569568.7428353368230.257164663176796
11621620.9735089819330.0264910180672184
12629628.6672545460580.332745453941555
13628619.3801380335038.61986196649697
14612612.258032181191-0.258032181190727
15595596.577760976465-1.57776097646458
16597596.1446431932630.85535680673684
17593597.961706422295-4.96170642229492
18590587.2836547569752.71634524302540
19580579.698966072120.301033927880349
20574574.298320161511-0.298320161511326
21573560.32849180301112.6715081969889
22573573.6863194649-0.686319464900039
23620623.167295116661-3.16729511666052
24626624.7188156292311.28118437076930
25620613.442847362276.55715263772948
26588601.579298023127-13.5792980231271
27566568.796071589818-2.7960715898181
28557563.313929120878-6.31392912087777
29561555.3870254098625.61297459013844
30549553.804324141578-4.80432414157761
31532538.220046486752-6.22004648675236
32526523.9439928165492.05600718345097
33511511.081077266847-0.0810772668468236
34499510.305348549865-11.3053485498648
35555546.5237971677088.47620283229231
36565559.4889802195145.51101978048596
37542554.409995879286-12.4099958792862
38527523.0207835415053.97921645849463
39510507.656592959422.3434070405795
40514510.3271647042493.67283529575101
41517514.1633074159772.83669258402338
42508511.086247659018-3.08624765901787
43493496.897720343167-3.89772034316707
44490484.9868127255135.01318727448669
45469482.465297578347-13.4652975783470
46478474.9978498878243.00215011217601
47528533.335398733699-5.33539873369901
48534541.124949605197-7.12494960519685
49518528.654188186894-10.6541881868935
50506505.5746161824910.425383817508676
51502494.1632652845037.83673471549744
52516509.9537248455276.04627515447328
53528524.451032396953.54896760304995
54533529.488866838473.51113316153034
55536529.2113922027996.788607797201
56537535.7797811283161.22021887168424
57524528.531990368397-4.53199036839658
58536527.2676467605888.73235323941201


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
200.1297580417837720.2595160835675440.870241958216228
210.1451759213855000.2903518427710010.8548240786145
220.07380359005255880.1476071801051180.926196409947441
230.04199307147557450.0839861429511490.958006928524425
240.02096008062155350.04192016124310690.979039919378446
250.04525410400561220.09050820801122450.954745895994388
260.5117502309331910.9764995381336190.488249769066809
270.404776716698050.80955343339610.59522328330195
280.4371751264041280.8743502528082550.562824873595872
290.3703624686090780.7407249372181560.629637531390922
300.3706123933170220.7412247866340450.629387606682978
310.4578108567983400.9156217135966790.54218914320166
320.4730010175665280.9460020351330550.526998982433472
330.4882656846867650.976531369373530.511734315313235
340.6257605189487310.7484789621025370.374239481051269
350.6991427129983170.6017145740033670.300857287001683
360.8366550490405670.3266899019188670.163344950959433
370.7841910662763610.4316178674472780.215808933723639
380.7580153622512130.4839692754975730.241984637748787


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