Multiple Linear Regression - Estimated Regression Equation
Y(t)[t] = + 17.8886662901039 + 0.593242377727027T.I.P.[t] + 0.205154983132475`Y(t-1)`[t] + 0.115152970700046`Y(t-2)`[t] + 1.45879444891351M1[t] -2.14950402416359M2[t] -1.21608635241409M3[t] -1.28121836133137M4[t] + 10.7917317668094M5[t] + 4.87747224861314M6[t] -7.95768982198349M7[t] -4.45922797316631M8[t] -3.79312308338614M9[t] + 0.925313075396341M10[t] + 6.08788829036564M11[t] -0.089662245098952t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)17.888666290103911.0427921.61990.112730.056365
T.I.P.0.5932423777270270.1096495.41043e-061e-06
`Y(t-1)`0.2051549831324750.1174051.74740.0878750.043937
`Y(t-2)`0.1151529707000460.1166050.98750.3290310.164515
M11.458794448913512.8682140.50860.6136890.306844
M2-2.149504024163592.497623-0.86060.3943340.197167
M3-1.216086352414092.806613-0.43330.6670190.333509
M4-1.281218361331372.863701-0.44740.6568860.328443
M510.79173176680943.0401263.54980.0009660.000483
M64.877472248613142.7212541.79240.080280.04014
M7-7.957689821983492.744783-2.89920.0059260.002963
M8-4.459227973166312.985327-1.49370.1427250.071363
M9-3.793123083386142.56813-1.4770.1471360.073568
M100.9253130753963412.7136310.3410.7348130.367407
M116.087888290365642.7461912.21680.0321020.016051
t-0.0896622450989520.033877-2.64670.0113940.005697


Multiple Linear Regression - Regression Statistics
Multiple R0.90677540764535
R-squared0.82224163991039
Adjusted R-squared0.758756511306957
F-TEST (value)12.9517204737289
F-TEST (DF numerator)15
F-TEST (DF denominator)42
p-value3.16494608298967e-11
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3.71652920335122
Sum Squared Residuals580.128751413224


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1116.7116.793696026955-0.0936960269545876
2112.5112.865685087896-0.365685087895518
3113111.1189577405131.88104225948694
4126.4119.956328069216.44367193079011
5114.1115.169270746585-1.06927074658506
6112.5116.964979688501-4.46497968850097
7112.4112.677267470406-0.277267470405825
8113.1111.5506374652831.54936253471654
9116.3113.9795761964962.32042380350423
10111.7115.489377680468-3.78937768046757
11118.8118.0293673876690.770632612330495
12116.5113.7872256093612.71277439063878
13125.1124.2820746343010.817925365698592
14113.1113.303607748095-0.203607748094534
15119.6118.1336488002641.46635119973557
16114.4120.718765463526-6.31876546352574
17114115.0610643142-1.06106431419985
18117.8117.3342450136890.46575498631052
19117113.6263144471143.37368555288624
20120.9118.3170833951222.58291660487787
21115117.465835537643-2.46583553764267
22117.3114.866949719352.43305028064981
23119.4122.105286134203-2.70528613420306
24114.9116.208143231518-1.30814323151785
25125.8124.9046713490210.895328650978765
26117.6115.3905333817062.20946661829429
27117.6117.705560936027-0.105560936026954
28114.9121.293127106314-6.39312710631384
29121.9118.069409805043.83059019495954
30117120.131595722189-3.13159572218863
31106.4111.931494519179-5.53149451917855
32110.5118.47450128476-7.9745012847599
33113.6113.2729522335480.327047766452166
34114.2111.1197101510433.08028984895724
35125.4123.0203837616422.37961623835808
36124.6120.4554698129084.14453018709216
37120.2121.170464168876-0.970464168875844
38120.8120.92701698131-0.127016981309569
39111.4116.522604829398-5.12260482939778
40124.1118.54249368495.55750631509989
41120.2120.243288612376-0.043288612376111
42125.5117.1560261781188.3439738218825
43116114.9545471086531.04545289134669
44117116.3721185018240.627881498176457
45105.7106.389912151036-0.689912151036261
46102105.790051599615-3.79005159961503
47106.4106.844962716486-0.444962716485515
4896.9102.449161346213-5.5491613462131
49107.6108.249093820847-0.649093820846925
5098.8100.313156800995-1.51315680099467
51101.199.21922769379781.88077230620222
52105.7104.989285676050.710714323949584
53104.6106.256966521799-1.65696652179852
54103.2104.413153397503-1.21315339750343
55101.6100.2103764546491.38962354535145
56106.7103.4856593530113.21434064698903
5799.598.99172388127750.508276118722536
5810198.93391084952442.06608915047556


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.8051327333793450.3897345332413090.194867266620655
200.7050336050579320.5899327898841360.294966394942068
210.5871037035473560.8257925929052890.412896296452644
220.6180237729193760.7639524541612470.381976227080624
230.5140448156183470.9719103687633060.485955184381653
240.4262109615699520.8524219231399050.573789038430048
250.3247051113675810.6494102227351630.675294888632419
260.2927107875746520.5854215751493040.707289212425348
270.2168165865433260.4336331730866530.783183413456674
280.2742513418458690.5485026836917380.725748658154131
290.3363323203048310.6726646406096620.663667679695169
300.2767511704450430.5535023408900860.723248829554957
310.2242203369019020.4484406738038040.775779663098098
320.5494314599984170.9011370800031650.450568540001583
330.4553825838536710.9107651677073410.54461741614633
340.402350090750460.8047001815009190.59764990924954
350.3055331972282860.6110663944565730.694466802771714
360.451352713699890.902705427399780.54864728630011
370.3441789460235170.6883578920470330.655821053976483
380.2298648270540480.4597296541080960.770135172945952
390.3099201993602350.619840398720470.690079800639765


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