Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 1793.72489341894 + 1.6063977661368X[t] + 0.427962828713485`yt-3`[t] -252.499755260931M1[t] + 603.668966609273M2[t] -90.4715413427234M3[t] + 312.032103289648M4[t] -47.4313553108066M5[t] + 234.187147811827M6[t] + 590.986007695037M7[t] + 311.521538341208M8[t] + 430.915726239081M9[t] + 618.343590382069M10[t] -185.133169059902M11[t] -9.78223844663726t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)1793.724893418942025.6731840.88550.3808150.190407
X1.60639776613683.0602660.52490.6023340.301167
`yt-3`0.4279628287134850.1296773.30020.0019480.000974
M1-252.499755260931333.21998-0.75780.4527290.226365
M2603.668966609273345.1161881.74920.0873960.043698
M3-90.4715413427234351.353336-0.25750.7980250.399013
M4312.032103289648344.5179750.90570.3701380.185069
M5-47.4313553108066339.38632-0.13980.8895050.444753
M6234.187147811827348.3527580.67230.5050080.252504
M7590.986007695037348.3547761.69650.0970190.048509
M8311.521538341208353.3271560.88170.3828520.191426
M9430.915726239081364.9101921.18090.244140.12207
M10618.343590382069360.8072951.71380.0937710.046885
M11-185.133169059902344.065913-0.53810.59330.29665
t-9.782238446637267.018747-1.39370.1705610.08528


Multiple Linear Regression - Regression Statistics
Multiple R0.736405222894403
R-squared0.542292652306156
Adjusted R-squared0.393271655382578
F-TEST (value)3.63903519303565
F-TEST (DF numerator)14
F-TEST (DF denominator)43
p-value0.000545270742913884
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation483.846579610374
Sum Squared Residuals10066623.0418283


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
141384895.63805800023-757.638058000227
246345037.80863245882-403.808632458819
339964236.81918295556-240.819182955560
443084793.34489898984-485.344898989843
541434629.94317392009-486.943173920093
644294625.52635834461-196.526358344613
752195098.03539350911120.964606490892
849294720.50444354341208.495556456587
957554942.87537540988812.124624590116
1055925461.82443132216130.175568677837
1141634607.98889694576-444.988896945757
1249625149.68830620546-187.688306205456
1352084816.04197365145391.958026348548
1447555025.16721058526-270.167210585259
1544914635.87800230437-144.878002304375
1657325137.0910598859594.9089401141
1757314567.552610367051163.44738963295
1850404721.58749496428318.412505035723
1961025583.64200917292518.357990827083
2049045284.32895194692-380.328951946917
2153695096.612188991272.387811009003
2255785728.75433878107-150.754338781071
2346194478.29656710214140.703432897865
2447314862.28859966399-131.288599663992
2550114679.81245056072331.187549439278
2652995064.37785273168234.622147268322
2741464373.04619229394-227.046192293945
2846254871.13961062422-246.139610624224
2947364631.57279931116104.427200688837
3042194390.69114928687-171.691149286869
3151164915.39320365288200.606796347124
3242054664.01198324279-459.011983242786
3341214528.27118375710-407.271183757097
3451035070.522693615832.4773063841965
3543003957.34783367287342.65216632713
3645784112.81386433557465.18613566443
3738094233.8442198035-424.844219803498
3855264712.48058527808813.519414721915
3942474100.22274323747146.777256762526
4038304170.26632520708-340.266325207084
4143944540.65199835946-146.651998359458
4248264250.66622521567575.333774784325
4344094395.1263805866713.8736194133276
4445694342.4315148822226.568485117798
4541064603.18905324879-497.18905324879
4647944616.83175926685177.168240733150
4739143952.36670227924-38.3667022792384
4837933939.20922979498-146.209229794980
4944053945.6632979841459.336702015899
5040224396.16571894616-374.165718946159
5141003634.03387920865465.966120791354
5247884311.15810529295476.841894707051
5331633797.27941804223-634.279418042234
5435854110.52877218857-525.528772188566
5539034756.80301307843-853.803013078426
5641783773.72310638468404.276893615317
5738634043.05219859323-180.052198593231
5841874376.06677701411-189.066777014113


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
180.7211119754779360.5577760490441280.278888024522064
190.6155049319175050.7689901361649890.384495068082495
200.6311140430461270.7377719139077460.368885956953873
210.7956107756919230.4087784486161530.204389224308077
220.7425274849813390.5149450300373220.257472515018661
230.6616971898623160.6766056202753690.338302810137684
240.6490709637406190.7018580725187630.350929036259381
250.5782282749442560.8435434501114880.421771725055744
260.4880479478629060.9760958957258130.511952052137094
270.4221529386474640.8443058772949280.577847061352536
280.3366619774251420.6733239548502830.663338022574858
290.2761173738770170.5522347477540340.723882626122983
300.2055006300613310.4110012601226620.794499369938669
310.1640393401108480.3280786802216970.835960659889152
320.1569602196164690.3139204392329370.843039780383531
330.1290681921070190.2581363842140370.870931807892981
340.1231677381600730.2463354763201460.876832261839927
350.1146254339183260.2292508678366530.885374566081674
360.09120006910862440.1824001382172490.908799930891376
370.1126306870927820.2252613741855640.887369312907218
380.2951298423655640.5902596847311280.704870157634436
390.1986295377954860.3972590755909720.801370462204514
400.9239320166994680.1521359666010640.0760679833005322


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