Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 548.980793854033 -15.6216389244558X[t] + 13.7563540332907M1[t] + 9.10886683738792M2[t] -0.938620358514797M3[t] -5.78610755441745M4[t] -18.6335947503201M5[t] -15.0810819462229M6[t] + 40.1957586427657M7[t] + 43.2953585147247M8[t] + 28.197871318822M9[t] + 9.35038412291931M10[t] -2.74710307298338M11[t] -0.152512804097312t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)548.98079385403319.85426327.650500
X-15.621638924455812.263542-1.27380.2098980.104949
M113.756354033290723.6365910.5820.5637570.281879
M29.1088668373879223.618410.38570.7017360.350868
M3-0.93862035851479723.605222-0.03980.9684750.484237
M4-5.7861075544174523.597035-0.24520.8075210.403761
M5-18.633594750320123.593855-0.78980.4342090.217105
M6-15.081081946222923.595684-0.63910.5262830.263142
M740.195758642765723.6488671.69970.0967650.048383
M843.295358514724725.1710271.720.0929650.046482
M928.19787131882225.1342571.12190.2684370.134218
M109.3503841229193125.1021430.37250.7114440.355722
M11-2.7471030729833825.0747-0.10960.9132950.456648
t-0.1525128040973120.343777-0.44360.6596360.329818


Multiple Linear Regression - Regression Statistics
Multiple R0.54768043660878
R-squared0.299953860643984
Adjusted R-squared0.0779880115798813
F-TEST (value)1.35135139891434
F-TEST (DF numerator)13
F-TEST (DF denominator)41
p-value0.224618905356963
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation35.1624898397931
Sum Squared Residuals50692.4283610756


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1593562.58463508322630.4153649167738
2590557.78463508322732.2153649167733
3580547.58463508322732.4153649167733
4574542.58463508322731.4153649167733
5573529.58463508322743.4153649167734
6573532.98463508322740.0153649167733
7620588.10896286811831.8910371318822
8626591.05604993597934.9439500640206
9620575.8060499359844.1939500640205
10588556.8060499359831.1939500640205
11566544.5560499359821.4439500640205
12557547.1506402048669.8493597951344
13561560.7544814340590.245518565940993
14549555.954481434059-6.95448143405888
15532545.754481434059-13.7544814340589
16526540.754481434059-14.7544814340589
17511527.754481434059-16.7544814340589
18499531.154481434059-32.1544814340589
19555586.27880921895-31.2788092189501
20565589.225896286812-24.2258962868118
21542573.975896286812-31.9758962868118
22527554.975896286812-27.9758962868118
23510542.725896286812-32.7258962868118
24514545.320486555698-31.3204865556978
25517558.924327784891-41.9243277848912
26508554.124327784891-46.1243277848912
27493543.924327784891-50.9243277848912
28490538.924327784891-48.9243277848912
29469525.924327784891-56.9243277848912
30478529.324327784891-51.3243277848911
31528568.827016645326-40.8270166453265
32534571.774103713188-37.7741037131882
33518556.524103713188-38.5241037131882
34506537.524103713188-31.5241037131882
35502525.274103713188-23.2741037131882
36516527.868693982074-11.8686939820743
37528541.472535211268-13.4725352112677
38533536.672535211268-3.67253521126758
39536526.4725352112689.52746478873243
40537521.47253521126815.5274647887324
41524508.47253521126815.5274647887324
42536511.87253521126824.1274647887324
43587566.99686299615920.0031370038412
44597569.9439500640227.0560499359795
45581554.6939500640226.3060499359795
46564535.6939500640228.3060499359795
47558523.4439500640234.5560499359795
48575541.66017925736233.3398207426376
49580555.26402048655624.7359795134442
50575550.46402048655624.5359795134443
51563540.26402048655622.7359795134443
52552535.26402048655616.7359795134443
53537522.26402048655614.7359795134443
54545525.66402048655619.3359795134443
55601580.78834827144720.2116517285532


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.1277397250146870.2554794500293740.872260274985313
180.2110519948381560.4221039896763130.788948005161843
190.1709881088256530.3419762176513060.829011891174347
200.1295382040563320.2590764081126630.870461795943668
210.1884792657513110.3769585315026220.811520734248689
220.1860892271591760.3721784543183530.813910772840824
230.1827678259721790.3655356519443580.817232174027821
240.2010922886058610.4021845772117220.798907711394139
250.3208520562321290.6417041124642580.679147943767871
260.3545719622300700.7091439244601390.64542803776993
270.3168486048097560.6336972096195120.683151395190244
280.3206662395272230.6413324790544460.679333760472777
290.2775740725080150.555148145016030.722425927491985
300.4187518669609460.8375037339218910.581248133039054
310.3272340950015570.6544681900031140.672765904998443
320.2327897081553630.4655794163107260.767210291844637
330.1566901398492390.3133802796984790.84330986015076
340.1027366105496240.2054732210992480.897263389450376
350.08894527540299980.1778905508060000.911054724597
360.3121248162518820.6242496325037630.687875183748118
370.7024240841808660.5951518316382670.297575915819134
380.9400745728809670.1198508542380650.0599254271190326


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level00OK
10% type I error level00OK