Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 63.2419011471966 + 1.16232044459361X[t] + 0.780421649089665Y1[t] -0.792732218814561Y2[t] + 2.1038959924636Y3[t] -0.00841697355310678Y4[t] + 2.76698178211044M1[t] + 1.94119087812141M2[t] + 15.8696883851779M3[t] + 71.1133254322051M4[t] + 35.4385310945394M5[t] -25.7506260674336M6[t] -19.305462552463M7[t] -9.41876002842492M8[t] + 12.5861140469189M9[t] + 26.7813873646183M10[t] + 19.3890177289188M11[t] -0.268119756372126t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)63.241901147196652.5692791.2030.236610.118305
X1.162320444593610.356313.26210.0023810.00119
Y10.7804216490896650.1308985.96211e-060
Y2-0.7927322188145610.3909-2.0280.049810.024905
Y32.10389599246360.8679912.42390.0203620.010181
Y4-0.008416973553106780.002094-4.01890.0002760.000138
M12.766981782110444.6224430.59860.5530890.276544
M21.941190878121414.8673640.39880.692320.34616
M315.86968838517796.4040882.47810.0178980.008949
M471.11332543220515.92928111.993600
M535.438531094539412.0321872.94530.0055510.002776
M6-25.750626067433612.556784-2.05070.0474260.023713
M7-19.3054625524638.113687-2.37940.0226120.011306
M8-9.418760028424928.46238-1.1130.2728810.13644
M912.58611404691898.9351261.40860.1672990.083649
M1026.78138736461836.7586113.96260.0003250.000163
M1119.38901772891885.7871963.35030.0018680.000934
t-0.2681197563721260.15773-1.69990.0975490.048775


Multiple Linear Regression - Regression Statistics
Multiple R0.991847531674969
R-squared0.983761526089728
Adjusted R-squared0.976300605644468
F-TEST (value)131.855249403537
F-TEST (DF numerator)17
F-TEST (DF denominator)37
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.40981784371308
Sum Squared Residuals1520.17329721456


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1573577.834528310712-4.8345283107124
2567567.74570286082-0.745702860820217
3569568.9923047755550.00769522444461956
4621622.107538716716-1.10753871671601
5629634.579191413877-5.5791914138769
6628627.3592333834780.640766616522358
7612608.9948309820243.0051690179756
8595598.30216041208-3.30216041208038
9597598.332533531781-1.33253353178128
10593595.46570977598-2.46570977598044
11590586.4653906420933.53460935790709
12580573.7974455486726.20255445132768
13574568.7964079286955.20359207130536
14573559.84651665359113.1534833464093
15573566.3245528487446.6754471512564
16620621.779086947154-1.77908694715427
17626625.1568520085740.843147991426047
18620613.6924008775876.30759912241258
19588590.612011865547-2.61201186554723
20566579.929251812658-13.9292518126580
21557564.434531233533-7.4345312335326
22561558.9663065304882.03369346951169
23549550.311340500483-1.31134050048295
24532537.876362565007-5.87636256500654
25526523.5696970216212.43030297837865
26511509.9213169354591.07868306454139
27499508.550830519589-9.55083051958893
28555554.7454835723230.254516427676753
29565551.6134165733213.3865834266802
30542546.338035154327-4.33803515432753
31527521.9901752392845.00982476071635
32510501.6024444762868.39755552371353
33514508.5251773341925.47482266580849
34517515.6655611054311.33443889456896
35508513.473002888583-5.47300288858287
36493495.550991464417-2.55099146441657
37490491.879508483902-1.87950848390173
38469476.67292188871-7.67292188871048
39478478.687651256193-0.687651256192748
40528529.69800806831-1.69800806830980
41534542.644003104468-8.64400310446758
42518521.357515066629-3.35751506662908
43506509.583190652468-3.58319065246789
44502493.1661432989758.83385670102484
45516512.7077579004953.29224209950538
46528528.9024225881-0.902422588100215
47533529.7502659688413.24973403115873
48536533.7752004219052.22479957809542
49537537.91985825507-0.919858255069904
50524529.81354166142-5.81354166141999
51536532.4446605999193.55533940008066
52587582.6698826954974.33011730450333
53597597.006536899762-0.00653689976171934
54581580.2528155179780.747184482021662
55564565.819791260677-1.81979126067682


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.1985290940719200.3970581881438410.80147090592808
220.7388147354875180.5223705290249630.261185264512482
230.8370922891143360.3258154217713280.162907710885664
240.8017419356728680.3965161286542640.198258064327132
250.7198026263354850.560394747329030.280197373664515
260.6758135522093650.648372895581270.324186447790635
270.8403542137856540.3192915724286930.159645786214346
280.8659546089312490.2680907821375020.134045391068751
290.9356585638814820.1286828722370350.0643414361185176
300.8843436211157440.2313127577685130.115656378884256
310.9872848344035050.02543033119299040.0127151655964952
320.981660391537870.03667921692426010.0183396084621300
330.999731156840920.0005376863181618810.000268843159080941
340.9980809326626380.003838134674724020.00191906733736201


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level20.142857142857143NOK
5% type I error level40.285714285714286NOK
10% type I error level40.285714285714286NOK