Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 239.710507892753 -1.50323568329146X[t] + 0.913782838019183`Yt-1`[t] -0.311051463965936`Yt-4`[t] + 0.253189547911919`Yt-5`[t] -0.0368144501848631t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)239.71050789275332.7217817.325700
X-1.503235683291460.187441-8.019800
`Yt-1`0.9137828380191830.05281517.301700
`Yt-4`-0.3110514639659360.086816-3.58290.0006750.000338
`Yt-5`0.2531895479119190.0821493.08210.0030840.001542
t-0.03681445018486310.096896-0.37990.7053110.352655


Multiple Linear Regression - Regression Statistics
Multiple R0.955223117147497
R-squared0.912451203532981
Adjusted R-squared0.905275072675029
F-TEST (value)127.15085909029
F-TEST (DF numerator)5
F-TEST (DF denominator)61
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation12.4354714485818
Sum Squared Residuals9433.09795905813


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1507510.98253488212-3.98253488211976
2569543.80472879627125.1952712037293
3580595.203085723629-15.2030857236291
4578577.5387145579710.461285442029296
5565568.926361466403-3.92636146640275
6547558.93670409467-11.9367040946702
7555557.283485088649-2.28348508864914
8562570.669945527505-8.66994552750537
9561577.710753080934-16.7107530809343
10555555.466817793586-0.466817793586271
11544557.633192437401-13.6331924374006
12537555.660719162641-18.6607191626415
13543530.26550357959112.7344964204087
14594573.402161792420.5978382075997
15611607.7402854744083.25971452559218
16613596.62407717033716.3759228296627
17611600.4884883735210.5115116264807
18594593.900329245570.0996707544298384
19595589.4114406767175.58855932328347
20591604.493178234162-13.4931782341618
21589599.975508067377-10.9755080673770
22584589.664149719786-5.66414971978602
23573583.29929509929-10.2992950992905
24567581.77347254614-14.7734725461401
25569552.11218200811916.8878179918807
26621604.55858900659716.4414109934032
27629631.946212384762-2.94621238476152
28628611.99425993789416.0057400621059
29612619.876042922314-7.87604292231431
30595585.1910225518729.8089774481275
31597590.0683765764486.9316234235517
32593599.156373404425-6.15637340442491
33590597.632560816111-7.63256081611087
34580573.8433518599856.15664814001493
35574581.990271899887-7.99027189988747
36573564.3915770869948.60842291300633
37573556.2961682875716.7038317124301
38620602.50478178541917.4952182145808
39626622.0513152091113.94868479088863
40620604.79284169246815.2071583075318
41588596.464640004661-8.4646400046608
42566557.9790043913128.02099560868765
43557564.257836420647-7.25783642064696
44561553.3694797663917.63052023360927
45549566.474571206025-17.4745712060251
46532533.919747649244-1.91974764924447
47526534.669011252166-8.66901125216623
48511520.816233800263-9.81623380026258
49499499.942490641026-0.942490641026338
50555528.31980382438826.6801961756118
51565559.429057278065.5709427219395
52542559.199849708766-17.1998497087659
53527523.1987710684673.8012289315332
54510502.6775022089117.32249779108894
55514518.167514143585-4.16751414358458
56517515.3872883845941.61271161540645
57508513.777439871069-5.77743987106908
58493511.516318597328-18.5163185973281
59490480.9500657818039.04993421819686
60469490.578039220301-21.5780392203006
61478464.6888143447613.3111856552399
62528505.1775015625322.8224984374703
63534542.252844590015-8.25284459001547
64518527.91623265154-9.9162326515398
65506506.796008362825-0.796008362824866
66502507.022674226971-5.02267422697108
67516521.790399021296-5.79039902129627


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
90.7121088969721230.5757822060557530.287891103027877
100.5614255916319160.8771488167361670.438574408368084
110.5906024732968870.8187950534062260.409397526703113
120.6010955909050310.7978088181899390.398904409094969
130.6663693383882660.6672613232234670.333630661611734
140.7390506369153970.5218987261692070.260949363084603
150.6567724578596180.6864550842807640.343227542140382
160.6903235030573090.6193529938853820.309676496942691
170.6152095343699390.7695809312601220.384790465630061
180.5395641085533640.9208717828932730.460435891446636
190.4880227435778160.9760454871556320.511977256422184
200.4900966075614690.9801932151229380.509903392438531
210.4745519511600050.949103902320010.525448048839995
220.4389700630531940.8779401261063890.561029936946806
230.5206113506031480.9587772987937050.479388649396852
240.7336935514352430.5326128971295150.266306448564757
250.6917392730744550.616521453851090.308260726925545
260.6317468157892380.7365063684215240.368253184210762
270.6182500314725680.7634999370548630.381749968527432
280.5731597865776760.8536804268446480.426840213422324
290.6649573786601580.6700852426796850.335042621339842
300.6033825899712940.7932348200574130.396617410028706
310.5335333628824480.9329332742351040.466466637117552
320.5072593346882830.9854813306234330.492740665311717
330.5228464992123140.9543070015753720.477153500787686
340.4550523247612540.9101046495225070.544947675238746
350.6094042290569740.7811915418860520.390595770943026
360.5369466721063360.9261066557873280.463053327893664
370.4875439974634890.9750879949269770.512456002536511
380.4146573388788490.8293146777576990.585342661121151
390.355902517207890.711805034415780.64409748279211
400.4387868507985750.877573701597150.561213149201425
410.4757331606093890.9514663212187770.524266839390611
420.4741273014565350.948254602913070.525872698543465
430.4408484259284760.8816968518569530.559151574071524
440.5448856389401990.9102287221196020.455114361059801
450.5908909641854920.8182180716290170.409109035814508
460.5942644819903120.8114710360193750.405735518009688
470.5875839600365250.824832079926950.412416039963475
480.5979907665226930.8040184669546150.402009233477307
490.5207979162196470.9584041675607070.479202083780354
500.5042836366890720.9914327266218560.495716363310928
510.4711165358164560.9422330716329110.528883464183544
520.4601880546657370.9203761093314750.539811945334263
530.3815258925994450.763051785198890.618474107400555
540.3793516444496450.7587032888992890.620648355550355
550.2934817550925370.5869635101850750.706518244907463
560.3046919263140940.6093838526281890.695308073685906
570.3924698661294720.7849397322589440.607530133870528
580.2735379916192870.5470759832385750.726462008380713


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