Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 574.162403631772 -8.1741746581782X[t] + 1.58594568458370M1[t] + 21.2938136298923M2[t] + 34.184264109383M3[t] + 25.3668466435652M4[t] -24.6887689042899M5[t] -26.8887689042899M6[t] -15.1983184247992M7[t] -9.87135143847206M8[t] -0.090450479490666M9[t] + 3.61909904101863M10[t] + 2.23651650683645M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)574.16240363177218.9918430.232100
X-8.17417465817823.155104-2.59080.0127140.006357
M11.5859456845837024.4097420.0650.9484720.474236
M221.293813629892324.3797080.87340.3868730.193437
M334.18426410938324.3711321.40270.1672910.083646
M425.366846643565224.3862411.04020.3035630.151782
M5-24.688768904289924.36623-1.01320.3161350.158067
M6-26.888768904289924.36623-1.10350.2754170.137708
M7-15.198318424799224.360101-0.62390.5357080.267854
M8-9.8713514384720624.356832-0.40530.687110.343555
M9-0.09045047949066624.350946-0.00370.9970520.498526
M103.6190990410186324.3531530.14860.8824980.441249
M112.2365165068364524.3502920.09180.9272090.463605


Multiple Linear Regression - Regression Statistics
Multiple R0.551464014387481
R-squared0.304112559164356
Adjusted R-squared0.126439170014830
F-TEST (value)1.71163819534292
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0.094537415037612
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation38.5010623246821
Sum Squared Residuals69669.5946060655


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1564583.105106508717-19.1051065087171
2581603.630391919843-22.6303919198431
3597614.06859000188-17.0685900018803
4587613.425347194241-26.4253471942407
5536557.647809385661-21.6478093856610
6524548.908469659118-24.9084696591184
7537553.242162946249-16.2421629462487
8536559.386547398394-23.3865473983936
9533558.541021301743-25.5410213017433
10528560.615735890617-32.615735890617
11516554.328648561528-38.3286485615279
12502548.005044725602-46.0050447256024
13506536.512310957101-30.512310957101
14518550.498256641685-32.4982566416848
15534564.206124586993-30.2061245869933
16528551.301619792086-23.3016197920864
17478502.063421710049-24.0634217100492
18469505.585343970774-36.5853439707739
19490525.449969108443-35.4499691084428
20493528.324683697316-35.3246836973165
21508544.64492438284-36.6449243828404
22517549.171891369167-32.1718913691675
23514551.058978698257-37.0589786982567
24510550.457297123056-40.4572971230559
25527557.765165068364-30.7651650683643
26542584.012372740215-42.0123727402154
27565598.537658151342-33.5376581513417
28555588.902823219706-33.9028232197061
29499538.847207671851-39.847207671851
30511536.647207671851-25.6472076718511
31526544.250570822253-18.2505708222527
32532549.57753780858-17.5775378085798
33549559.358438767561-10.3584387675612
34561563.885405753888-2.8854057538883
35557559.233153356435-2.23315335643485
36566557.8140543154168.18594568458379
37588561.85225239745326.1477476025466
38620579.92528541112640.0747145888737
39626589.54606602734636.4539339726543
40620579.9112310957140.0887689042899
41573529.03819808203743.9618019179628
42573524.38594568458448.6140543154162
43574537.7112310957136.2887689042899
44580546.30786794530933.6921320546915
45590551.18426410938338.815735890617
46593554.89381362989238.1061863701077
47597553.5112310957143.4887689042899
48595555.36180191796339.6381980820372
49612557.76516506836454.2348349316357
50628570.9336932871357.0663067128697
51629584.64156123243944.3584387675612
52621577.45897869825743.5410213017433
53569527.40336315040241.5966368495984
54567528.47303301367338.5269669863271
55573539.34606602734633.6539339726543
56584541.40336315040242.5966368495984
57589555.27135143847233.7286485615279
58591561.43315335643529.5668466435652
59595560.8679882880734.1320117119295
60594555.36180191796338.6381980820372


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.004150374666641970.008300749333283940.995849625333358
170.0005833512168985940.001166702433797190.999416648783101
180.0001086631959592470.0002173263919184940.99989133680404
199.22595830294697e-050.0001845191660589390.99990774041697
202.88810563720328e-055.77621127440656e-050.999971118943628
211.36370213994757e-052.72740427989514e-050.9999863629786
226.77336906762662e-061.35467381352532e-050.999993226630932
235.64301710395524e-061.12860342079105e-050.999994356982896
242.56100458012116e-055.12200916024231e-050.9999743899542
250.0002408322570448680.0004816645140897360.999759167742955
260.001595544312016410.003191088624032820.998404455687984
270.001476263251485970.002952526502971940.998523736748514
280.001346020971499870.002692041942999740.9986539790285
290.004922093735145410.009844187470290820.995077906264855
300.003422543809912500.006845087619824990.996577456190088
310.004557430000588610.009114860001177210.995442569999411
320.01504648104684030.03009296209368050.98495351895316
330.06292488181808690.1258497636361740.937075118181913
340.2289937332147010.4579874664294020.771006266785299
350.8940695506107180.2118608987785650.105930449389282
360.9995307522736620.0009384954526756760.000469247726337838
370.9999999911535381.76929241069276e-088.84646205346381e-09
380.9999999957909368.41812861216765e-094.20906430608383e-09
390.9999999819472673.61054652711620e-081.80527326355810e-08
400.9999998922357882.15528424826655e-071.07764212413328e-07
410.9999998858392642.28321472155226e-071.14160736077613e-07
420.9999999423393781.15321244310672e-075.76606221553361e-08
430.9999982903420123.41931597681473e-061.70965798840737e-06
440.9999966787808296.64243834242217e-063.32121917121109e-06


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