Multiple Linear Regression - Estimated Regression Equation
Y[t] = -99.7566815768365 + 0.382755975409948X[t] + 1.02354018150553`Y(t-1)`[t] + 0.104099099931590`Y(t-4)`[t] + 0.00510435475890887`Y(t-5)`[t] + 4.0412038052447M1[t] + 67.3233309731705M2[t] + 21.7024053188966M3[t] + 3.10372942599408M4[t] -8.80075905104333M5[t] -17.7562793542933M6[t] + 4.46357831698049M7[t] + 4.86982749424487M8[t] + 1.88816508082327M9[t] -4.80574981277827M10[t] -2.9185475181839M11[t] -0.470059344867009t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-99.756681576836541.611218-2.39740.0202910.010146
X0.3827559754099480.2400111.59470.1170720.058536
`Y(t-1)`1.023540181505530.07489613.666100
`Y(t-4)`0.1040990999315900.1740310.59820.552430.276215
`Y(t-5)`0.005104354758908870.1599460.03190.9746690.487334
M14.04120380524473.8732521.04340.3017990.1509
M267.32333097317055.60369312.014100
M321.70240531889666.5484583.31410.0017150.000858
M43.103729425994087.7258190.40170.6895910.344796
M5-8.800759051043337.69218-1.14410.2580230.129011
M6-17.75627935429339.010969-1.97050.0543290.027164
M74.463578316980494.0857681.09250.2798630.139931
M84.869827494244874.1340051.1780.2443760.122188
M91.888165080823274.2630690.44290.659740.32987
M10-4.805749812778275.161882-0.9310.3563230.178162
M11-2.91854751818393.500481-0.83380.4083840.204192
t-0.4700593448670090.172063-2.73190.0086790.004339


Multiple Linear Regression - Regression Statistics
Multiple R0.995733449711533
R-squared0.99148510287443
Adjusted R-squared0.988760335794248
F-TEST (value)363.878846777648
F-TEST (DF numerator)16
F-TEST (DF denominator)50
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation5.38069327362718
Sum Squared Residuals1447.59300524284


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1431440.995986249429-9.99598624942896
2484487.759982902138-3.75998290213822
3510500.5786366291429.42136337085846
4513509.7790932822833.22090671771729
5503503.134090215368-0.134090215368056
6471486.247271849365-15.2472718493649
7471473.780922453283-2.78092245328301
8476476.267280673961-0.267280673961445
9475476.86930629062-1.86930629062032
10470469.0888612818050.911138718195271
11461464.114971643031-3.11497164303055
12455457.451062109505-2.45106210950471
13456455.8358292883190.164170711680960
14517511.9883006983015.01169930169949
15525529.705664547819-4.70566454781862
16523523.819505405741-0.819505405740737
17519511.653059252047.34694074795991
18509500.3164281965188.68357180348152
19512509.262250186142.73774981386033
20519514.1685794684754.83142053152457
21517517.301931481317-0.301931481317353
22510510.24461865493-0.244618654929754
23509503.7247929527175.27520704728275
24501504.133070221441-3.13307022144072
25507501.7930637558475.20693624415297
26569563.462343079395.53765692061006
27580581.647909688873-1.64790968887270
28578580.61706320411-2.61706320411020
29565567.506431133992-2.5064311339919
30547546.2454961727450.754503827255213
31555550.3824461681554.61755383184498
32562557.6659463993444.33405360065648
33561560.7427452562440.257254743755970
34555556.624359239572-1.62435923957166
35544548.890166955041-4.89016695504074
36537538.744083804635-1.74408380463454
37543540.4406620335942.55933796640645
38594599.578128581498-5.57812858149836
39611608.1098827801922.89011721980806
40613612.2781674007390.721832599260754
41611601.0850913515659.91490864843475
42594592.5024733228781.49752667712190
43595598.00175661179-3.00175661178942
44591596.577167028587-5.57716702858733
45589589.330877821964-0.330877821964188
46584581.7081823957372.29181760426274
47573577.297713153688-4.29771315368823
48567566.277014201050.722985798949873
49569569.525846364973-0.525846364972995
50621621.223343153339-0.223343153338821
51629632.85062415551-3.85062415551058
52628627.9876974375220.0123025624782818
53612611.9730628849290.0269371150711113
54595592.7041945673732.29580543262719
55597595.6641152149371.33588478506305
56593596.321026429632-3.32102642963226
57590587.7551391498542.2448608501459
58580581.333978427957-1.33397842795659
59574566.9723552955237.02764470447678
60573566.394769663376.6052303366301
61573570.4086123078382.59138769216159
62620620.987901585334-0.987901585334136
63626628.107282198465-2.10728219846462
64620620.518473269605-0.518473269605384
65588602.648265162106-14.6482651621058
66566563.9841358911212.01586410887912
67557559.908509365696-2.90850936569592


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
200.9910310904189660.01793781916206890.00896890958103446
210.9804807394971570.03903852100568620.0195192605028431
220.9799651994315410.04006960113691740.0200348005684587
230.9631254015020.0737491969959990.0368745984979995
240.9472837471000460.1054325057999080.052716252899954
250.9137580355703760.1724839288592480.086241964429624
260.8902891255258150.2194217489483690.109710874474185
270.8726306864632130.2547386270735740.127369313536787
280.8655234996709820.2689530006580360.134476500329018
290.857405351799690.2851892964006190.142594648200310
300.7978452193166330.4043095613667350.202154780683367
310.741027383736710.5179452325265810.258972616263290
320.7158319032553220.5683361934893550.284168096744678
330.6308182684576850.7383634630846310.369181731542315
340.5428664062107820.9142671875784370.457133593789219
350.5341597905565870.9316804188868270.465840209443413
360.53219234960780.93561530078440.4678076503922
370.4328330403379260.8656660806758520.567166959662074
380.4626848751281740.9253697502563480.537315124871826
390.3693018317572890.7386036635145770.630698168242711
400.286974339700620.573948679401240.71302566029938
410.8020598014339820.3958803971320360.197940198566018
420.7217725221362850.5564549557274290.278227477863715
430.6093160343267970.7813679313464050.390683965673203
440.5428563236679310.9142873526641370.457143676332069
450.4349575796450480.8699151592900970.565042420354952
460.2987467103271820.5974934206543630.701253289672819
470.3335033294564930.6670066589129860.666496670543507


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level30.107142857142857NOK
10% type I error level40.142857142857143NOK