Multiple Linear Regression - Estimated Regression Equation
Y(t)[t] = + 27.5646541936156 + 0.719237622037051T.I.P.[t] + 0.351615816868488`Y(t-1)`[t] -0.225481858966781`Y(t-3)`[t] -2.87531712508168M1[t] -1.25845267587132M2[t] -1.64388521197177M3[t] + 11.4973887999212M4[t] + 5.12018350407216M5[t] -8.78441952464868M6[t] -5.16373479336386M7[t] -4.47697332405873M8[t] + 1.16759647044438M9[t] + 6.50191392593397M10[t] -1.4199990435579M11[t] -0.100533009976323t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)27.564654193615611.1542382.47120.017710.008855
T.I.P.0.7192376220370510.1105766.504400
`Y(t-1)`0.3516158168684880.1115723.15150.0030330.001516
`Y(t-3)`-0.2254818589667810.111906-2.01490.0505010.025251
M1-2.875317125081682.810467-1.02310.3122710.156136
M2-1.258452675871322.606872-0.48270.6318450.315922
M3-1.643885211971772.585307-0.63590.5284030.264202
M411.49738879992123.7932593.0310.004210.002105
M55.120183504072162.9508221.73520.0902230.045111
M6-8.784419524648682.498781-3.51550.0010870.000543
M7-5.163734793363862.503896-2.06230.0455560.022778
M8-4.476973324058732.606334-1.71770.0933920.046696
M91.167596470444382.8413130.41090.683260.34163
M106.501913925933972.9025032.24010.0305670.015283
M11-1.41999904355792.854385-0.49750.6215080.310754
t-0.1005330099763230.034392-2.92310.0056180.002809


Multiple Linear Regression - Regression Statistics
Multiple R0.913268637606618
R-squared0.834059604435848
Adjusted R-squared0.773349703619695
F-TEST (value)13.7384445242568
F-TEST (DF numerator)15
F-TEST (DF denominator)41
p-value1.75230940868687e-11
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3.62948298030304
Sum Squared Residuals540.099014876688


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1112.5113.381553606476-0.881553606475701
2113111.9798257784021.02017422159778
3126.4120.9591894664515.44081053354928
4114.1115.923764694843-1.82376469484289
5112.5115.6531277182-3.15312771820009
6112.4110.6506078480071.74939215199312
7113.1111.6585902120491.44140978795053
8116.3114.9375098214411.36249017855949
9111.7116.954220862602-5.2542208626023
10118.8118.0392510965220.760748903478475
11116.5113.0144394255893.48556057441113
12125.1125.207122437768-0.107122437768481
13113.1113.0095303229670.0904696770330307
14119.6117.4420663581442.15793364185637
15114.4120.682876458172-6.28287645817183
16114113.5992589564920.40074104350817
17117.8116.3757303333941.42426966660554
18117115.1643380605551.83566193944535
19120.9119.7160938294181.18390617058195
20115118.227537471127-3.22753747112682
21117.3114.0377363430993.26226365690091
22119.4122.077808405588-2.67780840558763
23114.9115.620632274021-0.720632274021336
24125.8124.5489267535711.25107324642868
25117.6115.7978593186791.80214068132096
26117.6117.747169815461-0.147169815460565
27114.9120.485429220739-5.58542922073857
28121.9116.6605894963235.23941050367726
29117121.05924208641-4.0592420864103
30106.4111.909661827175-5.50966182717538
31110.5117.244765335077-6.74476533507725
32113.6113.832417391967-0.232417391966923
33114.2113.2907105407410.909289459258885
34125.4125.506831410408-0.106831410408123
35124.6122.2338878233482.36611217665222
36120.2120.979059221943-0.779059221943333
37120.8119.3249848375141.47501516248608
38111.4115.334922753339-3.93492275333866
39124.1117.4267045380046.67329546199609
40120.2120.484848620233-0.284848620232935
41125.5117.4884410666498.01155893335099
42116114.7102888231071.28971117689341
43117114.9783081498942.02169185010586
44105.7102.9975253343642.70247466563643
45102103.042269176072-1.04226917607191
46106.4104.3761090874832.02389091251728
4796.9102.031040477042-5.13104047704201
48107.6107.964891586717-0.364891586716859
4998.8101.286071914364-2.48607191436437
50101.1100.1960152946550.903984705345068
51105.7105.945800316635-0.245800316634972
52104.6108.13153823211-3.5315382321096
53103.2105.423458795346-2.22345879534613
54101.6100.9651034411570.634896558843497
55106.7104.6022424735612.09775752643891
5699.5100.105009981102-0.605009981102175
5710198.87506307748562.12493692251442


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.6816132087120210.6367735825759580.318386791287979
200.5310042878508660.9379914242982680.468995712149134
210.6284291597652470.7431416804695070.371570840234753
220.4990385844221850.998077168844370.500961415577815
230.447666255007480.8953325100149610.55233374499252
240.3365006136590020.6730012273180040.663499386340998
250.27071391460650.5414278292130.7292860853935
260.1918915978727080.3837831957454150.808108402127293
270.2457544180302070.4915088360604130.754245581969793
280.422530022808630.845060045617260.57746997719137
290.3666107884563090.7332215769126180.633389211543691
300.38479177421070.7695835484214010.6152082257893
310.6607694539564950.6784610920870090.339230546043505
320.5754092178729040.8491815642541920.424590782127096
330.4810182042250570.9620364084501140.518981795774943
340.7157539490594220.5684921018811560.284246050940578
350.5968694110930250.8062611778139510.403130588906975
360.515315625563610.969368748872780.48468437443639
370.38103557304720.76207114609440.6189644269528
380.2874165261213090.5748330522426180.712583473878691


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