Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 243.301929501305 -1.54574360309231X[t] + 0.889239136592848`Yt-1`[t] + 0.0310888319576515`Yt-2`[t] + 0.0174977223073751`Yt-3`[t] -0.347038931375699`Yt-4`[t] + 0.266291251496857`Yt-5`[t] -0.0304035045744285t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)243.30192950130535.2039916.911200
X-1.545743603092310.228481-6.765300
`Yt-1`0.8892391365928480.0995428.933300
`Yt-2`0.03108883195765150.1620160.19190.8484890.424245
`Yt-3`0.01749772230737510.1505170.11630.9078480.453924
`Yt-4`-0.3470389313756990.147972-2.34530.0223940.011197
`Yt-5`0.2662912514968570.0917542.90220.0052020.002601
t-0.03040350457442850.100142-0.30360.7624990.381249


Multiple Linear Regression - Regression Statistics
Multiple R0.955334021847317
R-squared0.91266309329897
Adjusted R-squared0.902301087419188
F-TEST (value)88.077839743329
F-TEST (DF numerator)7
F-TEST (DF denominator)59
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation12.6291749440012
Sum Squared Residuals9410.26752620514


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1507510.784212755440-3.78421275544049
2569544.15194132196824.8480586780318
3580593.919556662604-13.9195566626042
4578577.4530000737420.54699992625841
5565569.921477784468-4.92147778446847
6547558.79183774985-11.7918377498499
7555557.636372999469-2.63637299946930
8562570.338433337187-8.33843333718706
9561577.508466201906-16.508466201906
10555555.463167089655-0.463167089655524
11544557.767457322074-13.7674573220736
12537555.954039910277-18.9540399102772
13543529.82266621273613.1773337872642
14594573.63138956960620.3686104303935
15611606.7059218339454.29407816605457
16613596.24180483480116.7581951651985
17611601.3383269273879.66167307261248
18594593.6806051613790.319394838620695
19595589.7423563954915.25764360450893
20591604.690765073956-13.6907650739560
21589600.054226257468-11.0542262574675
22584589.903022497365-5.90302249736505
23573583.357177395735-10.3571773957347
24567582.27414569577-15.2741456957694
25569551.68500553647217.3149944635276
26621605.26622342388715.7337765761125
27629631.042413014094-2.04241301409448
28628611.88005407634916.1199459236511
29612621.111106581668-9.11110658166762
30595584.96567146059910.0343285394013
31597590.4214506472476.57854935275301
32593598.939374549215-5.93937454921535
33590597.775298408217-7.77529840821684
34580573.7498140943196.25018590568094
35574582.319738026282-8.31973802628186
36573564.2904152956998.709584704301
37573555.72021929331817.2797807066821
38620603.36096939250316.6390306074967
39626621.1859002520774.81409974792284
40620604.59726456724415.4027354327560
41588597.346296806551-9.34629680655128
42566558.0325414695797.9674585304215
43557564.621108509276-7.62110850927655
44561552.8406780433288.15932195667174
45549566.29200052395-17.2920005239500
46532533.803601007945-1.80360100794540
47526535.248943695753-9.24894369575297
48511520.413466041783-9.41346604178298
49499499.578738935411-0.578738935411133
50555529.19018079031825.8098192096819
51565557.7917192734687.20828072653168
52542558.96287361275-16.9628736127505
53527524.6379674687722.36203253122816
54510502.1655026164917.83449738350896
55514518.149564388598-4.14956438859846
56517514.9904928360272.00950716397332
57508513.28952440955-5.28952440954997
58493511.961749930953-18.9617499309533
59490480.8572690326489.14273096735224
60469490.234481895381-21.2344818953809
61478464.58549182771713.4145081722828
62528505.42214232314622.5778576768537
63534540.938965297302-6.93896529730173
64518528.167220262763-10.1672202627633
65506507.955260979404-1.95526097940416
66502507.101848283329-5.10184828332873
67516521.977080054333-5.97708005433252


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
110.5438577261866190.9122845476267620.456142273813381
120.5551265986115760.8897468027768490.444873401388424
130.7987173931393070.4025652137213850.201282606860692
140.8188064208663280.3623871582673430.181193579133671
150.7596773844960110.4806452310079780.240322615503989
160.7638879377423680.4722241245152640.236112062257632
170.6829543935813880.6340912128372240.317045606418612
180.609278228596360.781443542807280.39072177140364
190.532820070573270.934359858853460.46717992942673
200.5308207205447970.9383585589104050.469179279455203
210.526371699932830.947256600134340.47362830006717
220.4813141176984920.9626282353969840.518685882301508
230.5544818234784910.8910363530430180.445518176521509
240.7655542062137630.4688915875724740.234445793786237
250.7308206915978730.5383586168042550.269179308402127
260.666799626546760.666400746906480.33320037345324
270.638730060828240.7225398783435210.361269939171761
280.5809593363646870.8380813272706260.419040663635313
290.6505135297484570.6989729405030870.349486470251543
300.5800351206144130.8399297587711730.419964879385587
310.5088240748385790.9823518503228430.491175925161421
320.4772819163670580.9545638327341160.522718083632942
330.4974506437544830.9949012875089650.502549356245517
340.4225520810352710.8451041620705420.577447918964729
350.5772601763479320.8454796473041370.422739823652068
360.4998597411980090.9997194823960180.500140258801991
370.4498029541265820.8996059082531630.550197045873418
380.3725070216800550.745014043360110.627492978319945
390.3060047986223690.6120095972447380.693995201377631
400.4200637454274290.8401274908548580.579936254572571
410.4175193590628530.8350387181257060.582480640937147
420.4384003021930040.8768006043860070.561599697806996
430.3927838430412730.7855676860825460.607216156958727
440.4906103965052090.9812207930104180.509389603494791
450.5448748726668050.910250254666390.455125127333195
460.5399872362050050.920025527589990.460012763794995
470.545382572247310.909234855505380.45461742775269
480.560081105194050.87983778961190.43991889480595
490.4679555896675210.9359111793350420.532044410332479
500.4556205476110680.9112410952221360.544379452388932
510.3654291174660230.7308582349320450.634570882533977
520.3518797226747950.703759445349590.648120277325205
530.2531920847068220.5063841694136450.746807915293177
540.2312274575160120.4624549150320240.768772542483988
550.1918067532994840.3836135065989690.808193246700516
560.1325701365028910.2651402730057820.86742986349711


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