Multiple Linear Regression - Estimated Regression Equation
Y(t)[t] = + 498.427859024053 + 0.130784812235800`Y(t-1)`[t] + 0.0162915608389134`Y(t-2)`[t] + 0.263994243417347`Y(t-3)`[t] -0.219932791022093`Y(t-4)`[t] + 59.7224027781905X[t] + 47.4989221017373M1[t] + 150.105502994404M2[t] -201.549014116771M3[t] -255.564897907489M4[t] + 196.293610116600M5[t] + 211.074911954083M6[t] + 48.6418087775556M7[t] -47.9260020233859M8[t] + 65.6461246792301M9[t] + 32.5833805008135M10[t] + 89.4593062550886M11[t] -0.262984632943971t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)498.427859024053216.5241192.3020.0269110.013456
`Y(t-1)`0.1307848122358000.1666030.7850.4373150.218657
`Y(t-2)`0.01629156083891340.1591490.10240.9190040.459502
`Y(t-3)`0.2639942434173470.1678971.57240.1241580.062079
`Y(t-4)`-0.2199327910220930.171296-1.28390.2069390.103469
X59.722402778190531.4756111.89740.0653910.032695
M147.498922101737341.6545041.14030.2612950.130647
M2150.10550299440437.2128494.03370.0002550.000128
M3-201.54901411677140.935964-4.92351.7e-058e-06
M4-255.56489790748967.716821-3.7740.0005490.000274
M5196.29361011660078.4886212.50090.0168160.008408
M6211.07491195408375.4530022.79740.0080410.004021
M748.641808777555682.4468480.590.5586980.279349
M8-47.926002023385965.654753-0.730.4698850.234942
M965.646124679230147.5338811.3810.1753350.087668
M1032.583380500813541.8744090.77810.4413160.220658
M1189.459306255088640.8802542.18830.0348640.017432
t-0.2629846329439710.709166-0.37080.7128190.356409


Multiple Linear Regression - Regression Statistics
Multiple R0.955072487884467
R-squared0.912163457113825
Adjusted R-squared0.872868161612115
F-TEST (value)23.2130448560728
F-TEST (DF numerator)17
F-TEST (DF denominator)38
p-value5.32907051820075e-15
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation52.8072951092583
Sum Squared Residuals105967.195836739


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1656693.487785516207-37.4877855162073
2785809.553644535133-24.5536445351328
3412406.7227827241995.27721727580146
4352332.76896464430819.2310353556923
5839809.11449312069229.885506879308
6729759.50633739721-30.5063373972103
7696656.55318681655239.4468131834482
8641695.375584892178-54.3755848921782
9695664.8073047775330.1926952224705
10638653.12871696042-15.1287169604194
11762695.90476678538666.0952332146137
12635647.823166297527-12.8231662975268
13721653.54554356641767.454456433583
14854810.33906072388643.6609392761136
15418416.4180782385341.58192176146643
16367357.9187786653359.08122133466464
17824811.93817045329612.0618295467042
18687741.041725910909-54.0417259109090
19601650.300352599864-49.3003525998645
20676671.8520610626234.14793893737662
21740656.89249297256183.1075070274392
22691640.58614664334550.4138533566552
23683730.547080143013-47.5470801430132
24594639.380896528041-45.3808965280408
25729647.83523666827381.1647633317275
26731775.049586477908-44.0495864779083
27386403.856989735548-17.8569897355479
28331359.70318547452-28.7031854745202
29707769.322017402124-62.3220174021237
30715740.601508600154-25.6015086001542
31657646.43445567866910.5655443213312
32653653.506612652956-0.506612652955813
33642684.76492946806-42.7649294680594
34643632.86427303236710.1357269676335
35718701.12891670231716.8710832976826
36654619.20757277930634.7924272206937
37632661.978404272587-29.9784042725873
38731779.98171023471-48.9817102347105
39392407.262899658113-15.2628996581132
40344318.52866967979925.4713303202008
41792789.2976344600382.70236553996208
42852750.35815779628101.641842203721
43649664.693270449246-15.6932704492463
44629671.11684680186-42.1168468018602
45685755.53527278185-70.5352727818503
46617662.42086336387-45.4208633638693
47715750.419236369283-35.4192363692831
48715691.58836439512623.4116356048739
49629710.153029976516-81.1530299765161
50916842.07599802836273.924001971638
51531504.73924964360726.2607503563933
52357382.080401536038-25.0804015360375
53917899.3276845638517.6723154361493
54828819.4922702954478.50772970455288
55708693.01873445566914.9812655443313
56858765.14889459038292.8511054096175


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.4719058599986090.9438117199972180.528094140001391
220.3402170329308810.6804340658617620.659782967069119
230.2803928882463220.5607857764926430.719607111753678
240.1859214479742510.3718428959485010.81407855202575
250.3177790277957480.6355580555914970.682220972204252
260.6291533899508790.7416932200982430.370846610049121
270.5284671466902360.9430657066195290.471532853309764
280.4306219002109850.861243800421970.569378099789015
290.4950487034518730.9900974069037460.504951296548127
300.4659444157819260.9318888315638510.534055584218074
310.3388590734909850.6777181469819710.661140926509015
320.2287662185263250.457532437052650.771233781473675
330.1698898574895070.3397797149790130.830110142510493
340.09161010583312980.1832202116662600.90838989416687
350.08158878700195640.1631775740039130.918411212998044


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