Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 45157.3216699624 + 0.492045256054949X[t] + 0.469069737125908`yt-1`[t] -0.0789174470844457`yt-2`[t] + 0.0872661433584767`yt-3`[t] -0.289706583131103`yt-4`[t] + 3347.42238425707M1[t] + 4680.4007143094M2[t] -5912.44143343331M3[t] -20106.8179521148M4[t] -20373.1414736510M5[t] -17006.4450401302M6[t] -10613.8820516124M7[t] -2691.84006111352M8[t] -2069.86719893052M9[t] -1154.20523955606M10[t] -2543.26157898661M11[t] -311.187481241182t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)45157.321669962414651.8655693.0820.0033410.00167
X0.4920452560549490.0699077.038600
`yt-1`0.4690697371259080.1238883.78620.0004110.000205
`yt-2`-0.07891744708444570.137762-0.57290.5693120.284656
`yt-3`0.08726614335847670.1382140.63140.5306660.265333
`yt-4`-0.2897065831311030.10223-2.83390.0066160.003308
M13347.422384257071934.1511621.73070.0896740.044837
M24680.40071430941973.8849062.37120.0216260.010813
M3-5912.441433433314091.049188-1.44520.1546360.077318
M4-20106.81795211484438.569686-4.533.7e-051.8e-05
M5-20373.14147365104236.880926-4.80851.4e-057e-06
M6-17006.44504013023546.159356-4.79571.5e-057e-06
M7-10613.88205161241997.729216-5.3133e-061e-06
M8-2691.840061113522418.919532-1.11280.2711040.135552
M9-2069.867198930522472.791929-0.83710.4065440.203272
M10-1154.205239556062413.719748-0.47820.6346030.317301
M11-2543.261578986611988.365583-1.27910.2067760.103388
t-311.18748124118284.895304-3.66550.0005970.000299


Multiple Linear Regression - Regression Statistics
Multiple R0.99481067895626
R-squared0.989648286965417
Adjusted R-squared0.98612870453366
F-TEST (value)281.183437567921
F-TEST (DF numerator)17
F-TEST (DF denominator)50
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2933.95709978877
Sum Squared Residuals430405213.170048


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1318672322518.863375641-3846.86337564090
2317756319503.035591463-1747.03559146340
3337302335999.1346176191302.86538238138
4349420346388.2149765383031.78502346251
5336923342676.301539132-5753.30153913222
6330758332782.090399556-2024.09039955607
7321002322103.957926635-1101.95792663474
8320820319042.8905729571777.10942704312
9327032326499.566044411532.43395558866
10324047327538.857996403-3491.85799640324
11316735320813.810032402-4078.81003240201
12315710317926.674916245-2216.6749162452
13313427315662.944143400-2235.94414340046
14310527313579.779902458-3052.77990245839
15330962329448.8917121821513.10828781758
16339015337480.2462092521534.7537907476
17341332341076.919345131255.080654869102
18339092342239.48450244-3147.48450244010
19323308326199.72703026-2891.72703025979
20325849324493.5881866511355.41181334932
21330675328826.5559058381848.44409416168
22332225330055.2522922169.74770800022
23331735331445.822405934289.177594066029
24328047328489.820456986-442.820456985822
25326165325360.354884297804.645115702978
26327081325742.4232395471338.57676045265
27346764345360.2054351521403.79456484809
28344190345025.373348114-835.373348114505
29343333341221.4439751072111.55602489277
30345777343370.3032669612406.69673303912
31344094340140.1447720613953.85522793919
32348609348915.242056091-306.242056091246
33354846355346.157803148-500.157803147705
34356427356604.638622906-177.63862290585
35353467352553.656523993913.343476007163
36355996352112.1809529153883.81904708533
37352487350830.1424105791656.85758942143
38355178352298.4161313872879.58386861305
39374556374691.807854988-135.807854988002
40375021373137.4677808701883.53221912957
41375787371652.9235773124134.07642268766
42372720369778.1432782752941.85672172550
43364431359871.2156863514559.78431364924
44370490367430.9081455093059.09185449054
45376974374456.9183731072517.08162689259
46377632377066.062671388565.937328611743
47378205375375.8155370972829.18446290288
48370861370862.073411086-1.0734110864272
49369167365173.8861635253993.11383647512
50371551368821.813429172729.18657082995
51382842383362.683149536-520.683149536432
52381903384424.438554914-2521.43855491353
53384502384124.503335237377.496664763145
54392058388133.643212543924.35678745983
55384359385759.162811686-1400.16281168602
56388884390294.450617333-1410.45061733278
57386586390983.801873495-4397.80187349523
58387495386561.188417303933.811582697123
59385705385657.89550057447.1044994259362
60378670379893.250262768-1223.25026276788
61377367377738.809022558-371.809022558154
62376911379058.531705974-2147.53170597386
63389827393390.277230523-3563.27723052262
64387820390913.259130312-3093.25913031164
65387267388391.908228080-1124.90822808045
66380575384676.335340228-4101.33534022829
67372402375521.791773008-3119.79177300787
68376740381214.920421459-4474.92042145895


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.2134646330581150.426929266116230.786535366941885
220.1772989041433950.3545978082867890.822701095856605
230.326550724626970.653101449253940.67344927537303
240.2986866499104410.5973732998208820.701313350089559
250.3647814895800820.7295629791601640.635218510419918
260.3020136847212800.6040273694425590.697986315278720
270.9106133304373330.1787733391253340.0893866695626672
280.9371435482412730.1257129035174540.062856451758727
290.9055472483025360.1889055033949290.0944527516974643
300.8625600908960880.2748798182078250.137439909103912
310.7995053260161850.400989347967630.200494673983815
320.8592967011383530.2814065977232950.140703298861647
330.8221987697660590.3556024604678810.177801230233941
340.7488434350391510.5023131299216980.251156564960849
350.7747289575258670.4505420849482660.225271042474133
360.7591796199290410.4816407601419180.240820380070959
370.7493459682371980.5013080635256030.250654031762802
380.7287258192515680.5425483614968650.271274180748432
390.8398720815780540.3202558368438910.160127918421946
400.78656296265180.42687407469640.2134370373482
410.7016745376165680.5966509247668650.298325462383432
420.5925124093292910.8149751813414190.407487590670709
430.504055828130520.991888343738960.49594417186948
440.3968838997700710.7937677995401420.603116100229929
450.2985531476911870.5971062953823740.701446852308813
460.2656545041512180.5313090083024350.734345495848782
470.1612792524980870.3225585049961750.838720747501913


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