Multiple Linear Regression - Estimated Regression Equation
Y[t] = -0.00358137222472382 + 0.0430371388604634X[t] + 1.59792849135609Y1[t] -0.866541593526066Y2[t] -0.115378085010860Y3[t] + 0.314938073658562Y4[t] + 0.114618565818876M1[t] + 0.0598786116445835M2[t] + 0.297454773809027M3[t] + 0.163732537521505M4[t] -0.0342366300054975M5[t] + 0.029629519712166M6[t] + 0.0750588409022986M7[t] + 0.0084280845813315M8[t] -0.0150917423286754M9[t] + 0.503060824356568M10[t] -0.379811338849724M11[t] + 0.00157047152209919t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-0.003581372224723820.668581-0.00540.9957470.497873
X0.04303713886046340.0555750.77440.442270.221135
Y11.597928491356090.14807810.791100
Y2-0.8665415935260660.269219-3.21870.0022410.00112
Y3-0.1153780850108600.273253-0.42220.6746250.337313
Y40.3149380736585620.1544962.03850.0467010.023351
M10.1146185658188760.1943760.58970.5580130.279006
M20.05987861164458350.1576940.37970.7057340.352867
M30.2974547738090270.1629911.8250.0738650.036932
M40.1637325375215050.1731580.94560.3488290.174414
M5-0.03423663000549750.155588-0.220.8267140.413357
M60.0296295197121660.1539720.19240.8481660.424083
M70.07505884090229860.1716190.43740.6636990.33185
M80.00842808458133150.1763250.04780.9620630.481032
M9-0.01509174232867540.168227-0.08970.9288690.464434
M100.5030608243565680.1578993.1860.0024630.001231
M11-0.3798113388497240.202474-1.87590.0664040.033202
t0.001570471522099190.0022530.69710.4889320.244466


Multiple Linear Regression - Regression Statistics
Multiple R0.963039353437112
R-squared0.927444796268571
Adjusted R-squared0.903259728358095
F-TEST (value)38.3478268368572
F-TEST (DF numerator)17
F-TEST (DF denominator)51
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.205259595827174
Sum Squared Residuals2.14870658563588


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
17.97.57161470323220.328385296767800
27.98.01288512534686-0.112885125346857
38.17.961948806766780.138051193233223
48.28.172085405451450.0279145945485524
588.05234894808846-0.0523489480884614
67.57.666951525272-0.166951525271997
76.87.09670805838156-0.296708058381559
86.56.388026909106350.111973090893651
96.66.509498118983810.090501881016189
107.67.454042670897780.145957329102217
1187.928298082361660.0717019176383355
128.17.967683037379110.132316962620889
137.77.77443058382585-0.0744305838258467
147.57.229792673844460.270207326155542
157.67.61040766763255-0.0104076676325478
167.87.90191325373629-0.101913253736286
177.87.83985019807479-0.0398501980747887
187.87.653149363490490.146850636509507
197.57.69135249102222-0.191352491022223
207.57.201293845776150.298706154223852
217.17.44361068233211-0.343610682332107
227.57.406116602246780.09388339775322
237.57.424728950189980.0752710498100245
247.67.501341643269670.0986583567303307
257.77.57937478296220.120625217037794
267.77.70810436401226-0.00810436401225563
277.97.853362743731150.0466372562688485
288.18.065056389987760.0349436100122358
298.28.046428880914720.153571119085279
308.28.066666987810620.133333012189385
318.28.058317191127690.141682808872312
327.98.04470671255945-0.144706712559445
337.37.57487261713057-0.274872617130569
346.97.43023074967045-0.530230749670445
356.66.472903470834810.127096529165192
366.76.687661372347080.0123386276529165
376.97.05927555726046-0.159275557260464
3877.13476466790858-0.134764667908577
397.17.25437660142686-0.154376601426861
407.27.20808543069417-0.00808543069417039
417.17.1362752307029-0.0362752307028975
426.96.97522084231921-0.0752208423192126
4376.813548808863650.186451191136349
446.87.10740645222836-0.307406452228362
456.46.64928047942271-0.249280479422713
466.76.632918730446080.0670812695539187
476.66.61927050628903-0.0192705062890313
486.46.54684575319587-0.14684575319587
496.36.278122024423650.0218779755763539
506.26.34448724193971-0.144487241939710
516.56.50638070936561-0.00638070936561317
526.86.88450813124295-0.0845081312429514
536.86.87465836406415-0.0746583640641462
546.46.59250670494674-0.192506704946743
556.16.047291956052710.0527080439472889
565.85.93104004169687-0.131040041696870
576.15.753040706508480.346959293491515
587.26.976691246738910.223308753261090
597.37.55479899032452-0.254798990324520
606.96.99646819380827-0.096468193808266
616.16.33718234829564-0.237182348295637
625.85.669965926948140.130034073051858
636.26.21352347107705-0.0135234710770500
647.16.968351388887380.13164861111262
657.77.650438378154990.0495616218450148
667.97.745504576160940.154495423839061
677.77.592781494552170.107218505447832
687.47.227526038632830.172473961367174
697.57.069697395622320.430302604377684


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.8164952588836850.3670094822326290.183504741116315
220.7745009636166330.4509980727667340.225499036383367
230.6996605415476210.6006789169047570.300339458452379
240.6053536719174110.7892926561651780.394646328082589
250.5258848910463450.948230217907310.474115108953655
260.4220845343502580.8441690687005150.577915465649742
270.3370099688742120.6740199377484230.662990031125788
280.2629252898999280.5258505797998560.737074710100072
290.2734108604480210.5468217208960410.72658913955198
300.2784694775229190.5569389550458380.721530522477081
310.4614121118986180.9228242237972360.538587888101382
320.4584464527303220.9168929054606430.541553547269678
330.3817213561027450.763442712205490.618278643897255
340.8532650026310510.2934699947378970.146734997368949
350.8020518976001160.3958962047997690.197948102399884
360.7390807632044530.5218384735910930.260919236795547
370.7949404448837940.4101191102324120.205059555116206
380.7699035706086070.4601928587827860.230096429391393
390.719544617727170.560910764545660.28045538227283
400.678373867998040.643252264003920.32162613200196
410.6040287639077240.7919424721845510.395971236092276
420.4977132834938340.9954265669876680.502286716506166
430.6154707734119630.7690584531760730.384529226588037
440.6251701753404740.7496596493190520.374829824659526
450.7429395121896610.5141209756206780.257060487810339
460.9758048730005640.04839025399887160.0241951269994358
470.9362907022739110.1274185954521780.0637092977260889
480.845422537646830.3091549247063410.154577462353171


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