Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 302.521504071985 -1.72123794877019X[t] + 0.866754928207082`Y(t-1)`[t] + 0.134467604277825`Y(t-2)`[t] -0.125706630975887`Y(t-3)`[t] -0.380598880377657`Y(t-4)`[t] + 0.226892520847359`Y(t-5) `[t] + 0.764686012256499t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)302.52150407198546.1855926.550100
X-1.721237948770190.223008-7.718300
`Y(t-1)`0.8667549282070820.0945699.165300
`Y(t-2)`0.1344676042778250.148310.90670.3682720.184136
`Y(t-3)`-0.1257066309758870.137991-0.9110.3660130.183006
`Y(t-4)`-0.3805988803776570.141786-2.68430.0094190.004709
`Y(t-5) `0.2268925208473590.0941622.40960.0191080.009554
t0.7646860122564990.2262213.38030.0012890.000645


Multiple Linear Regression - Regression Statistics
Multiple R0.975983400744419
R-squared0.95254359852864
Adjusted R-squared0.94691317801509
F-TEST (value)169.178056281247
F-TEST (DF numerator)7
F-TEST (DF denominator)59
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation11.6937803278994
Sum Squared Residuals8067.9254030729


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1431432.531768903009-1.53176890300867
2484475.0040754267748.99592457322623
3510497.51370528301612.4862947169842
4513519.255266091415-6.2552660914153
5503505.310271144082-2.31027114408167
6471485.457024453743-14.4570244537435
7471478.859849748493-7.85984974849263
8476471.869238916284.13076108372011
9475485.649101921996-10.6491019219959
10470479.089354298221-9.08935429822093
11461472.488294294603-11.4882942946028
12455464.895921904341-9.89592190434128
13456456.746122086669-0.746122086669211
14517492.56536860329224.4346313967077
15525538.882188457978-13.8821884579780
16523529.424970078703-6.42497007870345
17519510.3107722657878.68922773421258
18509502.1057047682586.89429523174182
19512521.408045175023-9.40804517502284
20519517.2127994572011.78720054279898
21517527.462344748823-10.4623447488234
22510515.4976941924-5.4976941924004
23509510.282834693893-1.28283469389343
24501515.425085774191-14.4250857741912
25507501.3347337079025.66526629209798
26569537.99349113107331.0065088689265
27580588.798697728164-8.79869772816376
28578575.2457029717152.75429702828488
29565560.59312610244.40687389759962
30547548.750731569233-1.75073156923332
31555545.2240164013949.77598359860627
32562558.4917549628553.50824503714482
33561569.885833964901-8.88583396490128
34555546.5971265111798.40287348882148
35544550.886144412758-6.88614441275765
36537550.053183942416-13.0531839424165
37543521.89719683954921.1028031604509
38594571.67032366374122.3296763362587
39611604.9718588976876.02814110231254
40613596.96594464137616.0340553586235
41611598.00791488012912.9920851198708
42594588.137748615895.86225138411006
43595582.70743725708512.2925627429148
44591597.448982921819-6.4489829218187
45589595.995503021163-6.99550302116352
46584585.232604104466-1.23260410446644
47573580.929987158916-7.92998715891604
48567581.578550603035-14.5785506030352
49569548.95016464066920.0498353593306
50621610.27438949401810.7256105059823
51629634.711310205572-5.71131020557207
52628618.8170492534479.18295074655298
53612623.696460501156-11.6964605011559
54595585.1240002206379.8759997793629
55597589.0697441239527.93025587604845
56593599.169121093612-6.16912109361154
57590601.809320380471-11.8093203804712
58580576.5500369201073.44996307989297
59574589.602548388001-15.6025483880012
60573570.3399401156842.66005988431582
61573562.83254008234910.1674599176508
62620617.6024576215072.39754237849277
63626633.254306937835-7.25430693783494
64620619.9450410082710.0549589917285095
65588607.254794387329-19.2547943873291
66566567.030586523259-1.03058652325947
67557572.31978940308-15.3197894030801


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
110.02400893627303820.04801787254607640.975991063726962
120.01292730523091990.02585461046183980.98707269476908
130.03034711663314730.06069423326629470.969652883366853
140.1882908419187540.3765816838375080.811709158081246
150.4436669576886950.8873339153773890.556333042311305
160.414477892045950.82895578409190.58552210795405
170.4168283622367450.833656724473490.583171637763255
180.4703833219044050.940766643808810.529616678095595
190.4031433874431850.806286774886370.596856612556815
200.3441765949115460.6883531898230910.655823405088454
210.2986894616759880.5973789233519750.701310538324012
220.2445422760841630.4890845521683260.755457723915837
230.18857627804830.37715255609660.8114237219517
240.2703511061038840.5407022122077680.729648893896116
250.2691571716056720.5383143432113440.730842828394328
260.524103423151130.951793153697740.47589657684887
270.5298441425750760.9403117148498470.470155857424924
280.5656264772351410.8687470455297180.434373522764859
290.4883637638781240.9767275277562490.511636236121876
300.4662255460731780.9324510921463550.533774453926823
310.4474019260005950.894803852001190.552598073999405
320.3781630124759630.7563260249519250.621836987524037
330.4101651900006710.8203303800013420.589834809999329
340.3773318307140360.7546636614280710.622668169285964
350.4560528848593460.9121057697186920.543947115140654
360.8192920361507360.3614159276985270.180707963849264
370.8492605432826840.3014789134346310.150739456717316
380.8296962326423170.3406075347153660.170303767357683
390.7876822948731810.4246354102536380.212317705126819
400.7818289980718120.4363420038563750.218171001928188
410.7494797734571890.5010404530856210.250520226542811
420.6965797807933190.6068404384133620.303420219206681
430.678123486407340.6437530271853220.321876513592661
440.6263351880775810.7473296238448380.373664811922419
450.6024549825865370.7950900348269260.397545017413463
460.521180115665420.957639768669160.47881988433458
470.5962119252977380.8075761494045230.403788074702262
480.9070819071631060.1858361856737880.092918092836894
490.865589755151990.2688204896960190.134410244848010
500.8047833534097840.3904332931804310.195216646590216
510.7849857329299320.4300285341401350.215014267070068
520.6877314132207970.6245371735584050.312268586779202
530.6298764586366390.7402470827267230.370123541363361
540.4983816234107480.9967632468214950.501618376589252
550.6166097896313740.7667804207372520.383390210368626
560.5584455137907780.8831089724184440.441554486209222


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