Multiple Linear Regression - Estimated Regression Equation
Y(t)[t] = + 20.0671702470839 + 0.688595272943731T.I.P.[t] + 0.278503576120453`Y(t-1)`[t] + 0.193058224490072`Y(t-2)`[t] -0.338193109465919`Y(t-3)`[t] + 0.070699095273498`Y(t-4)`[t] -1.27620287842946M1[t] + 1.02349878003249M2[t] + 12.4875141879310M3[t] + 5.84323690683027M4[t] -6.6780209838056M5[t] -3.98147706592191M6[t] -2.25560893189417M7[t] + 1.76076039900308M8[t] + 8.23238768247252M9[t] + 0.579379111442313M10[t] + 0.792972106293582M11[t] -0.0934952638383165t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)20.067170247083912.0635661.66350.1044490.052225
T.I.P.0.6885952729437310.1131986.083100
`Y(t-1)`0.2785035761204530.118642.34750.0242120.012106
`Y(t-2)`0.1930582244900720.1301471.48340.146220.07311
`Y(t-3)`-0.3381931094659190.133198-2.5390.0153320.007666
`Y(t-4)`0.0706990952734980.1148350.61570.5417910.270895
M1-1.276202878429462.903066-0.43960.6627130.331357
M21.023498780032492.8119650.3640.717890.358945
M312.48751418793103.1013824.02640.0002610.000131
M45.843236906830272.6807372.17970.0355440.017772
M5-6.67802098380562.684944-2.48720.0173810.008691
M6-3.981477065921913.058419-1.30180.2008180.100409
M7-2.255608931894172.598024-0.86820.3907340.195367
M81.760760399003082.7662720.63650.528260.26413
M98.232387682472522.7139113.03340.0043440.002172
M100.5793791114423132.7065120.21410.8316380.415819
M110.7929721062935823.0770520.25770.7980250.399013
t-0.09349526383831650.035915-2.60320.0130990.00655


Multiple Linear Regression - Regression Statistics
Multiple R0.921362250010479
R-squared0.848908395744372
Adjusted R-squared0.781314783314223
F-TEST (value)12.5590032138262
F-TEST (DF numerator)17
F-TEST (DF denominator)38
p-value9.74198499648082e-11
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3.59658263510853
Sum Squared Residuals491.545452744239


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1113111.9626211858051.03737881419492
2126.4120.6576513117035.74234868829665
3114.1115.203847217153-1.10384721715255
4112.5117.352638178784-4.85263817878449
5112.4109.4716422985982.92835770140159
6113.1111.8183450664541.28165493354592
7116.3115.2948010122971.00519898770294
8111.7115.688858764459-3.98885876445923
9118.8118.887491165437-0.0874911654367105
10116.5112.3681782687744.13182173122608
11125.1125.191566616575-0.0915666165749797
12113.1113.338599129718-0.238599129718491
13119.6117.9020430439161.69795695608434
14114.4119.767153111741-5.36715311174095
15114115.503680682146-1.50368068214638
16117.8115.0017482060512.79825179394927
17117115.4331460426341.56685395736592
18120.9119.4852670012141.41473299878611
19115118.257000802004-3.25700080200372
20117.3114.3231534199892.97684658001139
21119.4121.581668828844-2.18166882884439
22114.9116.653105546511-1.75310554651093
23125.8124.0264268272661.77357317273388
24117.6116.0141288495071.58587115049293
25117.6118.338877996084-0.73887799608428
26114.9120.397458784236-5.49745878423554
27121.9117.5515196671624.34848033283803
28117119.718847061142-2.71884706114193
29106.4113.719296116099-7.31929611609895
30110.5116.683075441909-6.18307544190925
31113.6113.2967187141070.303281285892692
32114.2112.9545968508961.24540314910410
33125.4125.3302787739070.0697212260929037
34124.6121.5063676507413.09363234925947
35120.2121.516380145983-1.31638014598302
36120.8120.6691716395530.130828360447137
37111.4114.033022571698-2.63302257169836
38124.1119.8510685469324.2489314530676
39120.2118.7267989810521.47320101894758
40125.5119.1927986635976.30720133640251
41116114.0476830413061.95231695869420
42117116.4875331486570.512466851343351
43105.7103.2721035615922.42789643840797
44102104.316649295843-2.31664929584264
45106.4104.2005612318122.19943876818819
4696.9102.372348533975-5.4723485339746
47107.6107.965626410176-0.365626410175878
4898.8100.278100381222-1.47810038122158
49101.1100.4634352024970.636564797503383
50105.7104.8266682453880.873331754612235
51104.6107.814153452487-3.21415345248668
52103.2104.733967890425-1.53396789042537
53101.6100.7282325013630.871767498637248
54106.7103.7257793417662.97422065823387
5599.599.9793759099999-0.479375909999884
5610198.91674166881362.08325833118638


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.7676323855574140.4647352288851710.232367614442586
220.6394003739623840.7211992520752330.360599626037616
230.5438409506432660.9123180987134680.456159049356734
240.4433579125496570.8867158250993140.556642087450343
250.317157343594010.634314687188020.68284265640599
260.3394692097534770.6789384195069530.660530790246523
270.4809326673114370.9618653346228750.519067332688563
280.3682014686355940.7364029372711890.631798531364406
290.3798288617782870.7596577235565740.620171138221713
300.6730558540838960.6538882918322070.326944145916103
310.5433831708038370.9132336583923260.456616829196163
320.419406631534740.838813263069480.58059336846526
330.5151882124286110.9696235751427780.484811787571389
340.3705474299432480.7410948598864960.629452570056752
350.3120368529283940.6240737058567880.687963147071606


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