Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 145.45625 -16.640625X[t] -0.528124999999965M1[t] -11.328125M2[t] -20.1281250000000M3[t] -23.1281250000000M4[t] -21.6M5[t] -24.6M6[t] -29.4M7[t] -32.2000000000001M8[t] -38.6M9[t] -37.2M10[t] -6.00000000000003M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)145.456255.04309928.842600
X-16.6406253.057828-5.4422e-061e-06
M1-0.5281249999999656.946049-0.0760.9397160.469858
M2-11.3281256.946049-1.63090.1096010.054801
M3-20.12812500000006.946049-2.89780.0056920.002846
M4-23.12812500000006.946049-3.32970.0016980.000849
M5-21.66.919074-3.12180.0030720.001536
M6-24.66.919074-3.55540.0008730.000437
M7-29.46.919074-4.24910.0001015e-05
M8-32.20000000000016.919074-4.65382.7e-051.3e-05
M9-38.66.919074-5.57881e-061e-06
M10-37.26.919074-5.37642e-061e-06
M11-6.000000000000036.919074-0.86720.3902560.195128


Multiple Linear Regression - Regression Statistics
Multiple R0.847811656096568
R-squared0.718784604213205
Adjusted R-squared0.646984928693172
F-TEST (value)10.0109728770662
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value2.53967291641288e-09
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation10.9400171875473
Sum Squared Residuals5625.14687500001


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1161144.92812500000016.0718750000002
2149134.12812514.87187500
3139125.32812513.671875
4135122.32812512.6718750000000
5130123.856256.14375000000002
6127120.856256.14375000000003
7122116.056255.94374999999993
8117113.256253.74374999999995
9112106.856255.14374999999999
10113108.256254.74375000000006
11149139.456259.54374999999998
12157145.4562511.54375
13157144.92812512.0718750000000
14147134.12812512.871875
15137125.32812511.671875
16132122.3281259.671875
17125123.856251.14374999999999
18123120.856252.14374999999999
19117116.056250.943750000000015
20114113.256250.743750000000012
21111106.856254.14375000000001
22112108.256253.74374999999999
23144139.456254.54375
24150145.456254.54374999999997
25149144.9281254.07187499999995
26134134.128125-0.128124999999997
27123125.328125-2.32812499999999
28116122.328125-6.328125
29117123.85625-6.85625000000001
30111120.85625-9.85625
31105116.05625-11.0562500000000
32102113.25625-11.25625
3395106.85625-11.85625
3493108.25625-15.25625
35124139.45625-15.45625
36130145.45625-15.4562500000000
37124144.928125-20.9281250000001
38115134.128125-19.128125
39106125.328125-19.328125
40105122.328125-17.328125
41105107.215625-2.215625
42101104.215625-3.21562500000001
439599.415625-4.41562499999998
449396.615625-3.61562499999998
458490.215625-6.215625
468791.615625-4.61562500000002
47116122.815625-6.815625
48120128.815625-8.81562500000002
49117128.2875-11.2875000000000
50109117.4875-8.48749999999999
51105108.6875-3.68749999999999
52107105.68751.31250000000001
53109107.2156251.784375
54109104.2156254.78437499999999
5510899.4156258.58437500000002
5610796.61562510.3843750000000
579990.2156258.784375
5810391.61562511.3843750000000
59131122.8156258.18437500000001
60137128.8156258.18437499999999


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.02345077719730190.04690155439460390.976549222802698
170.01453690429410070.02907380858820130.9854630957059
180.006657843033257770.01331568606651550.993342156966742
190.003971757727548150.00794351545509630.996028242272452
200.001487256947020100.002974513894040200.99851274305298
210.0004840576764608560.0009681153529217120.999515942323539
220.0001554295096756550.0003108590193513110.999844570490324
230.0001425378521058360.0002850757042116730.999857462147894
240.0002952306956168320.0005904613912336640.999704769304383
250.005458692608177690.01091738521635540.994541307391822
260.07556656813656860.1511331362731370.924433431863431
270.2798075413485090.5596150826970180.720192458651491
280.5138083197776070.9723833604447870.486191680222393
290.53726177193990.92547645612020.4627382280601
300.583235597045360.833528805909280.41676440295464
310.6086090853310460.7827818293379090.391390914668955
320.602160252303320.795679495393360.39783974769668
330.6232099467250540.7535801065498930.376790053274946
340.6675530674872570.6648938650254860.332446932512743
350.7099350508820150.5801298982359710.290064949117985
360.7309476727698120.5381046544603770.269052327230188
370.8072710903549810.3854578192900370.192728909645019
380.818783685343290.3624326293134210.181216314656710
390.7974733812964920.4050532374070150.202526618703507
400.740847025285020.518305949429960.25915297471498
410.6275722982455810.7448554035088370.372427701754419
420.5134974607851190.9730050784297630.486502539214881
430.4308660301285650.861732060257130.569133969871435
440.3509837632312470.7019675264624940.649016236768753


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level60.206896551724138NOK
5% type I error level100.344827586206897NOK
10% type I error level100.344827586206897NOK