Multiple Linear Regression - Estimated Regression Equation
Y[t] = -7.25130954706303 + 4.22226300962114X[t] + 1.04736521388181Y1[t] + 0.0376245976777666Y2[t] -0.097101944440974`Y3 `[t] + 7.17062324388718M1[t] -0.749238461059722M2[t] + 15.3898231371423M3[t] + 62.9135695182735M4[t] + 15.1120552978287M5[t] -10.2916108571521M6[t] -8.7424582977394M7[t] + 0.183702098776305M8[t] + 19.7291850870341M9[t] + 17.4629062366240M10[t] + 4.42028691167321M11[t] + 0.0743693373524595t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-7.2513095470630319.602198-0.36990.7136690.356834
X4.222263009621142.9863621.41380.166240.08312
Y11.047365213881810.1691516.191900
Y20.03762459767776660.2447140.15370.8786910.439345
`Y3 `-0.0971019444409740.170431-0.56970.572490.286245
M17.170623243887185.0181261.42890.1618850.080943
M2-0.7492384610597225.345836-0.14020.8893420.444671
M315.38982313714235.0818183.02840.0045950.002298
M462.91356951827355.89023910.68100
M515.112055297828710.6892121.41380.1662640.083132
M6-10.29161085715218.960191-1.14860.2585130.129257
M7-8.74245829773945.499965-1.58950.120930.060465
M80.1837020987763056.8322560.02690.9787020.489351
M919.72918508703416.5222853.02490.0046380.002319
M1017.46290623662406.1582482.83570.0075490.003775
M114.420286911673215.2604420.84030.4064510.203225
t0.07436933735245950.0750440.9910.3284830.164241


Multiple Linear Regression - Regression Statistics
Multiple R0.987452102306002
R-squared0.975061654348542
Adjusted R-squared0.963661267765018
F-TEST (value)85.5288237117979
F-TEST (DF numerator)16
F-TEST (DF denominator)35
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.92125470629104
Sum Squared Residuals1676.63183482746


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1574572.0825666620121.91743333798777
2573557.86794286767215.1320571323275
3573573.779280447688-0.77928044768837
4620621.92238323514-1.92238323514000
5626623.5185053489342.48149465106607
6620606.24175590545113.7582440945486
7588597.243042716267-9.24304271626653
8566571.919526353204-5.91952635320427
9557567.875968514372-10.8759685143719
10561558.5372931495782.46270685042177
11549551.556125416109-2.55612541610872
12532535.666241165886-3.66624116588603
13526524.2661221612381.73387783876224
14511510.6620436831220.337956316877916
15499512.589981879879-13.5899818798793
16555547.6379577332617.36204226673934
17565559.5682988220315.43170117796879
18542547.984854946468-5.98485494646756
19527520.4575140120346.54248598796583
20510511.911180346677-1.91118034667679
21514515.394799793272-1.39479979327210
22517518.209262141834-1.20926214183427
23508510.184339242089-2.18433924208904
24493496.136600758101-3.13660075810136
25490487.0411879186912.95881208130901
26469476.363148444253-7.36314844425336
27478471.9255652618716.07443473812894
28528532.673420197002-4.67342019700206
29534539.692298220361-5.69229822036074
30518521.654505069943-3.65450506994278
31506501.8908339086174.10916609138315
32502497.1383758464134.86162415358684
33516513.6709032554192.32909674458147
34528527.1568316792870.843168320713138
35533527.6721164035235.32788359647704
36536527.6550928485718.34490715142917
37537537.065080726553-0.0650807265530644
38524529.894317643669-5.89431764366887
39536532.2383195631153.76168043688542
40587591.818596133928-4.81859613392812
41597599.220897608674-2.22089760867411
42581585.118884078138-4.11888407813825
43564565.408609363082-1.40860936308243
44558555.0309174537062.96908254629422
45575565.0583284369379.94167156306247
46580582.096613029301-2.09661302930064
47575575.587418938279-0.587418938279294
48563564.542065227442-1.54206522744174
49552558.545042531506-6.54504253150593
50537539.212547361283-2.21254736128322
51545540.4668528474474.53314715255329
52601596.9476427006694.05235729933083


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
200.9563307709332570.08733845813348540.0436692290667427
210.9963173245786640.007365350842672780.00368267542133639
220.9935527149389640.01289457012207180.00644728506103589
230.987411185809430.02517762838113840.0125888141905692
240.9794743816059750.04105123678804990.0205256183940249
250.9893983524955940.0212032950088110.0106016475044055
260.980338156086430.0393236878271390.0196618439135695
270.9852280238420310.02954395231593730.0147719761579686
280.963498178630960.073003642738080.03650182136904
290.9339733180222660.1320533639554670.0660266819777336
300.8618577827087210.2762844345825580.138142217291279
310.792257139273040.4154857214539190.207742860726960
320.6859333545291910.6281332909416180.314066645470809


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level10.0769230769230769NOK
5% type I error level70.538461538461538NOK
10% type I error level90.692307692307692NOK