Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 74.8625883971812 + 11.4579797137031X[t] + 0.883833817020301Y1[t] + 0.148925289542842Y2[t] + 0.0680524461895959Y3[t] -0.205609460525258Y4[t] -11.0093341354601M1[t] -19.3943249597428M2[t] -15.2870994860705M3[t] -19.6589724216698M4[t] -6.71985108689553M5[t] + 43.0948310810356M6[t] + 5.60929845146943M7[t] -25.8702298473568M8[t] -37.9817208725855M9[t] -24.3098501240444M10[t] -2.82506526052155M11[t] -0.36025434417029t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)74.862588397181228.8499032.59490.0133720.006686
X11.45797971370314.0135112.85490.0069380.003469
Y10.8838338170203010.1502835.88111e-060
Y20.1489252895428420.2059160.72320.4739660.236983
Y30.06805244618959590.2061170.33020.7430890.371544
Y4-0.2056094605252580.158492-1.29730.2023540.101177
M1-11.00933413546015.015681-2.1950.0343460.017173
M2-19.39432495974286.208166-3.1240.0034080.001704
M3-15.28709948607056.004905-2.54580.0150820.007541
M4-19.65897242166985.145907-3.82030.0004790.00024
M5-6.719851086895535.337035-1.25910.2156750.107837
M643.09483108103564.9712888.668700
M75.609298451469438.9373980.62760.5340060.267003
M8-25.870229847356811.089177-2.33290.0250460.012523
M9-37.981720872585512.587194-3.01750.0045310.002266
M10-24.30985012404446.858964-3.54420.0010630.000531
M11-2.825065260521555.321118-0.53090.5985670.299283
t-0.360254344170290.132882-2.71110.0100120.005006


Multiple Linear Regression - Regression Statistics
Multiple R0.99217682046164
R-squared0.984414843061367
Adjusted R-squared0.977442536009874
F-TEST (value)141.189255692705
F-TEST (DF numerator)17
F-TEST (DF denominator)38
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.26424626439006
Sum Squared Residuals1491.14968791514


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1589589.245105710227-0.24510571022708
2584581.6999050246812.30009497531854
3573580.252037244713-7.25203724471278
4567565.7394444797271.26055552027259
5569571.448087073341-2.44808707334080
6621622.056101188426-1.05610118842599
7629632.320912667471-3.32091266747108
8628616.66567727239511.3343227276045
9612607.6290086831274.37099131687261
10595596.503086347834-1.50308634783393
11597598.506709214764-1.50670921476426
12593599.32422816442-6.32422816441955
13590586.8500147789753.14998522102536
14580578.4890327225981.51096727740213
15574572.267461107461.73253889254049
16573561.36135853367211.6386414663281
17573572.0991438896780.900856110321654
18620623.052426352011-3.05242635201137
19626627.912433095191-1.912433095191
20620608.58075142335511.4192485766449
21588594.898019860002-6.89801986000235
22566569.778072414917-3.77807241491693
23557565.050678254163-8.05067825416283
24561555.3406069324735.65939306752667
25549551.248375035676-2.24837503567573
26532536.403761337-4.40376133699972
27526525.4611490321280.538850967871723
28511511.255221731632-0.255221731632379
29499510.993451670755-11.9934516707547
30555550.6950404989214.30495950107884
31565560.7697138741154.23028612588497
32542548.375598169324-6.37559816932438
33527523.3431784168073.65682158319268
34510509.138400578870.861599421130217
35514509.3825759981214.61742400187866
36517516.5592231595630.440776840437527
37508510.36408761182-2.36408761182013
38493497.878684572501-4.87868457250062
39490486.409540337283.59045966271964
40469475.562731866025-6.56273186602509
41478469.9640112824588.03598871754243
42528527.1254969483120.874503051688442
43534533.999455443070.00054455693001933
44518531.297190579777-13.2971905797772
45506507.129793040063-1.12979304006294
46502497.5804406583794.41955934162064
47516511.0600365329524.93996346704843
48528527.7759417435450.224058256455356
49533531.2924168633021.70758313669759
50536530.528616343225.47138365677967
51537535.6098122784191.39018772158094
52524530.081243388943-6.0812433889432
53536530.4953060837695.50469391623143
54587588.07093501233-1.07093501232992
55597595.9974849201531.00251507984708
56581584.080782555148-3.08078255514783


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.6065063098193390.7869873803613230.393493690180661
220.4746464484018240.9492928968036480.525353551598176
230.5287233184939150.942553363012170.471276681506085
240.6485695354792890.7028609290414230.351430464520711
250.5835252613757050.832949477248590.416474738624295
260.4978727373702820.9957454747405640.502127262629718
270.4843820208099010.9687640416198020.515617979190099
280.4936606940002480.9873213880004970.506339305999752
290.826662411588160.3466751768236810.173337588411841
300.8858360687891860.2283278624216280.114163931210814
310.9176619709476720.1646760581046550.0823380290523276
320.9107750355341810.1784499289316380.0892249644658191
330.892458349512560.2150833009748810.107541650487441
340.7883900394805440.4232199210389110.211609960519456
350.7772158703580720.4455682592838550.222784129641928


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