Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 249.278046103183 + 1.72722283205269X[t] + 0.672557628979011M1[t] -1.25466520307351M2[t] -39.6530186608123M3[t] -48.85268935236M4[t] -51.2527991218441M5[t] -37.3987925356751M6[t] -28.3992316136114M7[t] -17.6175631174533M8[t] -10.9085620197585M9[t] -6.92689352360042M10[t] -2.63622392974752M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)249.27804610318314.94808516.676300
X1.727222832052690.12911213.377800
M10.6725576289790118.2599520.08140.9354510.467725
M2-1.254665203073518.254097-0.1520.8798340.439917
M3-39.65301866081239.145656-4.33577.6e-053.8e-05
M4-48.852689352369.544759-5.11836e-063e-06
M5-51.25279912184419.40503-5.44952e-061e-06
M6-37.39879253567518.820238-4.24010.0001045.2e-05
M7-28.39923161361148.484545-3.34720.0016140.000807
M8-17.61756311745338.402217-2.09680.0414210.020711
M9-10.90856201975858.361048-1.30470.1983510.099176
M10-6.926893523600428.30644-0.83390.4085450.204273
M11-2.636223929747528.256197-0.31930.7509120.375456


Multiple Linear Regression - Regression Statistics
Multiple R0.896840328544436
R-squared0.804322574903692
Adjusted R-squared0.75436238126208
F-TEST (value)16.0992685631585
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value8.59312621059871e-13
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation13.0416734552831
Sum Squared Residuals7994.00658616908


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1423446.854006586170-23.8540065861696
2427448.381229418222-21.3812294182216
3441473.890120746433-32.8901207464325
4449480.235455543359-31.2354555433589
5452476.108122941822-24.1081229418222
6462469.235455543359-7.23545554335892
7455460.962788144896-5.9627881448957
8461464.835565312843-3.83556531284300
9461462.908452250274-1.90845225027441
10463461.7084522502741.29154774972559
11462457.3630076838644.63699231613612
12456451.3631174533484.63688254665204
13455443.39956092206411.6004390779365
14456443.19956092206412.8004390779363
15472466.9812294182225.01877058177828
16472471.5993413830950.400658616904519
17471469.1992316136111.80076838638860
18465465.781009879254-0.781009879253558
19459457.508342480791.49165751920967
20465459.6538968166855.34610318331505
21468454.27233809001113.7276619099890
22467454.79956092206412.2004390779363
23463448.726893523614.2731064763996
24460446.1814489571913.8185510428101
25462441.67233809001120.3276619099892
26461441.47233809001119.527661909989
27476458.34511525795817.6548847420417
28476459.50878155872716.4912184412733
29471455.3814489571915.6185510428101
30453443.3271130625699.6728869374314
31443433.3272228320539.67277716794731
32442432.0183315038429.98166849615806
33444440.4545554335893.54544456641054
34438434.0728869374313.9271130625686
35427428.000219538968-1.00021953896817
36424425.454774972558-1.45477497255762
37416414.0367727771681.96322722283220
38406408.65510428101-2.65510428100992
39431423.8006586169057.1993413830955
40434424.9643249176739.03567508232711
41418412.2008781558735.79912184412733
42412410.5098792535681.49012074643247
43404403.9644346871570.0355653128430213
44409413.018880351262-4.01888035126236
45412419.727881448957-7.72788144895719
46406416.800658616905-10.8006586169045
47398410.727991218441-12.7279912184413
48397409.909769484083-12.9097694840834
49385395.037321624588-10.0373216245882
50390398.291767288694-8.29176728869379
51413409.9828759604833.01712403951701
52413407.6920965971465.30790340285399
53401400.1103183315040.889681668496137
54397400.146542261251-3.1465422612514
55397402.237211855104-5.2372118551043
56409416.473326015368-7.47332601536774
57419426.636772777168-7.63677277716795
58424430.618441273326-6.61844127332602
59428433.181888035126-5.18188803512624
60430434.090889132821-4.09088913282107


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.8227740926801150.3544518146397700.177225907319885
170.8430664067600730.3138671864798550.156933593239927
180.9105368225973230.1789263548053530.0894631774026766
190.955437759074870.0891244818502590.0445622409251295
200.9812811062160340.03743778756793090.0187188937839655
210.9937620319334170.01247593613316560.00623796806658282
220.9946327380489260.01073452390214830.00536726195107413
230.9985099079211720.002980184157655960.00149009207882798
240.999075069905150.001849860189700200.000924930094850099
250.999775299730060.0004494005398781310.000224700269939066
260.9999522658904449.54682191113312e-054.77341095556656e-05
270.9998926413877980.0002147172244032200.000107358612201610
280.999935179374950.0001296412500980836.48206250490413e-05
290.9999753979710884.92040578248489e-052.46020289124245e-05
300.9999989301197072.13976058567414e-061.06988029283707e-06
310.9999992293780571.54124388674602e-067.70621943373008e-07
320.9999997680554384.6388912463921e-072.31944562319605e-07
330.9999995581196878.83760626570498e-074.41880313285249e-07
340.9999999157685561.68462887994463e-078.42314439972317e-08
350.999999952272269.5455478169989e-084.77277390849945e-08
360.9999999770809324.58381359462264e-082.29190679731132e-08
370.999999977055494.58890186888941e-082.29445093444471e-08
380.999999892805152.1438970039435e-071.07194850197175e-07
390.9999990521443341.89571133181989e-069.47855665909943e-07
400.9999939274363941.21451272126162e-056.0725636063081e-06
410.9999547684488119.0463102376881e-054.52315511884405e-05
420.9997039129217870.0005921741564257520.000296087078212876
430.9994097900476420.001180419904716950.000590209952358475
440.9995348725648380.000930254870323650.000465127435161825


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level220.758620689655172NOK
5% type I error level250.862068965517241NOK
10% type I error level260.896551724137931NOK