Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 545.06511627907 -18.2604651162791X[t] + 14.3869767441861M1[t] + 9.586976744186M2[t] -0.613023255814025M3[t] -5.61302325581399M4[t] -18.6130232558140M5[t] -15.2130232558140M6[t] + 40.4390697674418M7[t] + 44.5651162790698M8[t] + 29.3151162790697M9[t] + 10.3151162790697M10[t] -1.93488372093025M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)545.0651162790717.61363230.945600
X-18.260465116279110.62142-1.71920.0929390.04647
M114.386976744186123.3671230.61570.5414190.27071
M29.58697674418623.3671230.41030.6836890.341844
M3-0.61302325581402523.367123-0.02620.9791950.489597
M4-5.6130232558139923.367123-0.24020.8113360.405668
M5-18.613023255814023.367123-0.79650.4301940.215097
M6-15.213023255814023.367123-0.6510.5185640.259282
M740.439069767441823.4153521.7270.0915110.045755
M844.565116279069824.7675021.79930.0791530.039576
M929.315116279069724.7675021.18360.2432230.121611
M1010.315116279069724.7675020.41650.6791810.339591
M11-1.9348837209302524.767502-0.07810.9381020.469051


Multiple Linear Regression - Regression Statistics
Multiple R0.544603875494702
R-squared0.296593381203849
Adjusted R-squared0.095620061547806
F-TEST (value)1.47578485398686
F-TEST (DF numerator)12
F-TEST (DF denominator)42
p-value0.171893663081346
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation34.8246528364997
Sum Squared Residuals50935.7706976745


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1593559.45209302325533.5479069767446
2590554.65209302325635.3479069767441
3580544.45209302325635.5479069767442
4574539.45209302325634.5479069767442
5573526.45209302325646.5479069767442
6573529.85209302325643.1479069767442
7620585.50418604651234.4958139534884
8626589.6302325581436.3697674418606
9620574.3802325581445.6197674418605
10588555.3802325581432.6197674418605
11566543.1302325581422.8697674418605
12557545.0651162790711.9348837209302
13561559.4520930232561.54790697674409
14549554.652093023256-5.6520930232558
15532544.452093023256-12.4520930232558
16526539.452093023256-13.4520930232558
17511526.452093023256-15.4520930232558
18499529.852093023256-30.8520930232558
19555585.504186046512-30.5041860465116
20565589.63023255814-24.6302325581396
21542574.38023255814-32.3802325581395
22527555.38023255814-28.3802325581395
23510543.13023255814-33.1302325581395
24514545.06511627907-31.0651162790698
25517559.452093023256-42.4520930232559
26508554.652093023256-46.6520930232558
27493544.452093023256-51.4520930232558
28490539.452093023256-49.4520930232558
29469526.452093023256-57.4520930232558
30478529.852093023256-51.8520930232558
31528567.243720930232-39.2437209302325
32534571.36976744186-37.3697674418605
33518556.11976744186-38.1197674418605
34506537.11976744186-31.1197674418604
35502524.86976744186-22.8697674418605
36516526.804651162791-10.8046511627907
37528541.191627906977-13.1916279069768
38533536.391627906977-3.39162790697671
39536526.1916279069779.8083720930233
40537521.19162790697715.8083720930233
41524508.19162790697715.8083720930232
42536511.59162790697724.4083720930233
43587567.24372093023319.7562790697675
44597571.3697674418625.6302325581395
45581556.1197674418624.8802325581395
46564537.1197674418626.8802325581396
47558524.8697674418633.1302325581395
48575545.0651162790729.9348837209302
49580559.45209302325620.5479069767441
50575554.65209302325620.3479069767442
51563544.45209302325618.5479069767442
52552539.45209302325612.5479069767442
53537526.45209302325610.5479069767442
54545529.85209302325615.1479069767442
55601585.50418604651215.4958139534884


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.6475005801221470.7049988397557070.352499419877853
170.68474606727720.6305078654456010.315253932722800
180.7565722922498450.4868554155003110.243427707750155
190.7646850270481070.4706299459037860.235314972951893
200.749612736214910.5007745275701790.250387263785089
210.77415993673640.45168012652720.2258400632636
220.7475352164053380.5049295671893230.252464783594662
230.7130557359148820.5738885281702370.286944264085118
240.6643369440346760.6713261119306490.335663055965324
250.6708518531086150.6582962937827710.329148146891385
260.69402250189750.6119549962049990.305977498102499
270.7448019279552220.5103961440895560.255198072044778
280.7901737762075990.4196524475848030.209826223792401
290.8741610266318590.2516779467362820.125838973368141
300.939279449097270.1214411018054610.0607205509027304
310.9404119229427480.1191761541145050.0595880770572524
320.9528817924741810.09423641505163760.0471182075258188
330.970310314374670.05937937125066080.0296896856253304
340.9844867729288120.03102645414237500.0155132270711875
350.9963190823840440.007361835231911690.00368091761595584
360.9970967215017820.005806556996436940.00290327849821847
370.998269972093960.003460055812078250.00173002790603913
380.9995018089640030.0009963820719943510.000498191035997176
390.9998395683667110.0003208632665780670.000160431633289034


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level50.208333333333333NOK
5% type I error level60.25NOK
10% type I error level80.333333333333333NOK