Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 571208.730769231 -9054.10512820517M1[t] -10516.4102564102M2[t] + 6712.33076923077M3[t] + 25958.8217948718M4[t] + 20013.3128205128M5[t] -32509.4461538462M6[t] -35521.2051282051M7[t] -18703.4641025641M8[t] -12776.4730769231M9[t] -1772.48205128206M10[t] + 4749.25897435897M11[t] -1017.24102564102t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)571208.73076923115015.83964238.040400
M1-9054.1051282051717171.425446-0.52730.6012360.300618
M2-10516.410256410218238.581782-0.57660.5677960.283898
M36712.3307692307718202.2974620.36880.7144640.357232
M425958.821794871818169.7711261.42870.1617150.080858
M520013.312820512818141.0229861.10320.2772570.138629
M6-32509.446153846218116.07103-1.79450.0811330.040567
M7-35521.205128205118094.930962-1.9630.0574030.028701
M8-18703.464102564118077.616156-1.03460.3077470.153873
M9-12776.473076923118064.137609-0.70730.4839440.241972
M10-1772.4820512820618054.503916-0.09820.9223390.461169
M114749.2589743589718048.7212310.26310.7939460.396973
t-1017.24102564102263.801412-3.85610.0004580.000229


Multiple Linear Regression - Regression Statistics
Multiple R0.726599513438472
R-squared0.527946852929025
Adjusted R-squared0.370595803905366
F-TEST (value)3.35521660773704
F-TEST (DF numerator)12
F-TEST (DF denominator)36
p-value0.00239913546443793
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation25522.0197830042
Sum Squared Residuals23449445776.9462


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1548604561137.384615385-12533.3846153848
2563668558657.8384615385010.16153846154
3586111574869.33846153811241.6615384615
4604378593098.58846153811279.4115384615
5600991586135.83846153814855.1615384615
6544686532595.83846153812090.1615384615
7537034528566.8384615388467.16153846156
8551531544367.3384615387163.66153846157
9563250549277.08846153813972.9115384616
10574761559263.83846153815497.1615384615
11580112564768.33846153815343.6615384615
12575093559001.83846153816091.1615384615
13557560548930.4923076928629.50769230773
14564478546450.94615384618027.0538461539
15580523562662.44615384617860.5538461539
16596594580891.69615384615702.3038461538
17586570573928.94615384612641.0538461538
18536214520388.94615384615825.0538461539
19523597516359.9461538467237.05384615385
20536535532160.4461538464374.55384615385
21536322537070.196153846-748.196153846149
22532638547056.946153846-14418.9461538462
23528222552561.446153846-24339.4461538461
24516141546794.946153846-30653.9461538462
25501866536723.6-34857.6000000000
26506174534244.053846154-28070.0538461538
27517945550455.553846154-32510.5538461538
28533590568684.803846154-35094.8038461539
29528379561722.053846154-33343.0538461538
30477580508182.053846154-30602.0538461539
31469357504153.053846154-34796.0538461539
32490243519953.553846154-29710.5538461538
33492622524863.303846154-32241.3038461539
34507561534850.053846154-27289.0538461539
35516922540354.553846154-23432.5538461538
36514258534588.053846154-20330.0538461538
37509846524516.707692308-14670.7076923076
38527070522037.1615384625032.83846153845
39541657538248.6615384623408.33846153845
40564591556477.9115384628113.08846153845
41555362549515.1615384625846.83846153845
42498662495975.1615384622686.83846153845
43511038491946.16153846219091.8384615384
44525919507746.66153846218172.3384615384
45531673512656.41153846219016.5884615385
46548854522643.16153846226210.8384615385
47560576528147.66153846232428.3384615385
48557274522381.16153846234892.8384615384
49565742512309.81538461553432.1846153846


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.01185198719542280.02370397439084560.988148012804577
170.008515607773984150.01703121554796830.991484392226016
180.003743691584898690.007487383169797370.996256308415101
190.00267653037106850.0053530607421370.997323469628931
200.003041839937640510.006083679875281010.99695816006236
210.02827973756370090.05655947512740170.9717202624363
220.3188299264128810.6376598528257630.681170073587119
230.7977578087637320.4044843824725370.202242191236268
240.976791438120950.04641712375809880.0232085618790494
250.9843846339812470.0312307320375060.015615366018753
260.9884215214935240.02315695701295240.0115784785064762
270.9910877022914410.01782459541711720.00891229770855862
280.9868709610144350.02625807797112980.0131290389855649
290.9850699113750320.02986017724993530.0149300886249677
300.9974785300658130.005042939868373590.00252146993418680
310.9910659503802540.01786809923949260.00893404961974631
320.9830746427595030.03385071448099490.0169253572404974
330.9577293868395060.08454122632098890.0422706131604944


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level40.222222222222222NOK
5% type I error level140.777777777777778NOK
10% type I error level160.888888888888889NOK