Multiple Linear Regression - Estimated Regression Equation
I.P.C.N.[t] = + 35.3607050481265 + 0.80254709385946T.I.P.[t] + 4.40769055462782M1[t] -1.67120091994249M2[t] -1.61314465658159M3[t] -3.05293292720598M4[t] -2.50303586532053M5[t] -5.2220493813806M6[t] + 13.1270665500967M7[t] + 5.15709840515961M8[t] -10.8793637664784M9[t] -8.40882886848745M10[t] -6.113968161498M11[t] -0.120470689324151t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)35.36070504812658.4395464.18990.0001256.3e-05
T.I.P.0.802547093859460.08149.859300
M14.407690554627822.4792981.77780.0820480.041024
M2-1.671200919942492.48515-0.67250.5046460.252323
M3-1.613144656581592.657938-0.60690.5468910.273445
M4-3.052932927205982.513266-1.21470.2306690.115334
M5-2.503035865320532.503426-0.99980.3226170.161308
M6-5.22204938138062.74159-1.90480.0630760.031538
M713.12706655009672.6000695.04877e-064e-06
M85.157098405159612.456262.09960.0412810.020641
M9-10.87936376647842.72884-3.98680.0002370.000119
M10-8.408828868487452.758882-3.04790.0038120.001906
M11-6.1139681614982.546047-2.40140.0204330.010216
t-0.1204706893241510.030364-3.96750.0002520.000126


Multiple Linear Regression - Regression Statistics
Multiple R0.889237640042933
R-squared0.790743580469125
Adjusted R-squared0.731605896688661
F-TEST (value)13.3712301517351
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value1.52530210684176e-11
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3.87919616466738
Sum Squared Residuals692.215492662624


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1116.1115.5688799925350.531120007464823
2107.5110.412829050658-2.91282905065791
3116.7117.412829050658-0.712829050657896
4112.5114.327730612376-1.82773061237639
5113110.9851856437982.01481435620178
6126.4120.8259455213935.57405447860653
7114.1112.5705366661841.52946333381561
8112.5116.357794821043-3.8577948210432
9112.4114.245436102622-1.84543610262158
10113.1110.7369065261142.36309347388566
11116.3115.2386831159721.06131688402793
12111.7116.015624478059-4.31562447805942
13118.8117.6544389336271.14556106637312
14116.5112.8194068292933.68059317070651
15125.1124.634689392450.465310607549741
16113.1111.1967334433821.90326655661829
17119.6119.009593079450.590406920549952
18114.4119.942080215205-5.54208021520527
19114114.736350316662-0.736350316662142
20117.8118.764372599679-0.964372599678794
21117114.0838631809072.9161368190931
22120.9117.7982574491353.10174255086521
23115117.083477928906-2.08347792890604
24117.3114.3292120780122.97078792198823
25119.4121.826620318753-2.42662031875328
26114.9115.065475189157-0.16547518915718
27125.8125.837446530297-0.0374465302966544
28117.6114.0848394783333.51516052166702
29117.6117.0824165512450.517583448755453
30114.9120.58305438735-5.68305438735006
31121.9118.9887864111742.91121358882552
32117120.288148575069-3.28814857506898
33106.4110.79235659314-4.39235659314032
34110.5121.087637031016-10.5876370310158
35113.6115.95884849456-2.35884849456001
36114.2111.2784696184032.92153038159697
37125.4124.1529433880031.24705661199707
38124.6119.6389301212134.96106987878667
39120.2117.1688744136723.03112558632831
40120.8121.627718657669-0.827718657669112
41111.4115.476258860583-4.07625886058283
42124.1118.0940948934436.00590510655705
43120.2120.352052967793-0.152052967792781
44125.5115.31129309019810.1887069098025
45116112.7976608248463.20233917515381
46117114.2649232302682.73507676973241
47105.7103.3577956180242.34220438197631
48102105.258302911514-3.25830291151429
49106.4106.897117367082-0.49711736708174
5096.9102.463358809678-5.56335880967809
51107.6110.346160612923-2.7461606129235
5298.8101.56297780824-2.76297780823982
53101.1100.1465458649240.953454135075638
54105.7106.054824982608-0.354824982608251
55104.6108.152273638186-3.5522736381862
56103.2105.278390914011-2.07839091401149
57101.6101.4806832984850.119316701514987
58106.7104.3122757634672.38772423653251
5999.598.46119484253821.03880515746181
6010199.31839091401151.6816090859885


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.1179151188326180.2358302376652370.882084881167382
180.6691198976420930.6617602047158140.330880102357907
190.5342016413461240.9315967173077520.465798358653876
200.4260921236038870.8521842472077740.573907876396113
210.3689880387652550.737976077530510.631011961234745
220.2863666608347930.5727333216695870.713633339165207
230.2195438571563150.439087714312630.780456142843685
240.2274552304156680.4549104608313360.772544769584332
250.1811127306155970.3622254612311950.818887269384403
260.1199806922829670.2399613845659340.880019307717033
270.07379943890738790.1475988778147760.926200561092612
280.06930296134015510.138605922680310.930697038659845
290.04676866646871250.0935373329374250.953231333531288
300.06579192133493590.1315838426698720.934208078665064
310.07258375433933730.1451675086786750.927416245660663
320.05430346510692580.1086069302138520.945696534893074
330.04292490785455640.08584981570911280.957075092145444
340.4528415184339080.9056830368678160.547158481566092
350.5200894850421610.9598210299156780.479910514957839
360.432761168990490.8655223379809790.56723883100951
370.3536145868070370.7072291736140730.646385413192963
380.4319119014683530.8638238029367070.568088098531647
390.3556217360839640.7112434721679270.644378263916036
400.247886374143950.49577274828790.75211362585605
410.4987515803396380.9975031606792750.501248419660362
420.4041517305782820.8083034611565650.595848269421718
430.2764462297300080.5528924594600150.723553770269992


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 level20.0740740740740741OK