Multiple Linear Regression - Estimated Regression Equation
BESTC[t] = -0.75448327137553 + 0.307049523018442INDUSTR[t] + 0.694996652147111Y3[t] + 1.72757373099391M1[t] -0.579545947732459M2[t] + 2.03034588826871M3[t] -0.75591220373799M4[t] -3.99789829388022M5[t] -1.18967180175891M6[t] + 0.298094479651019M7[t] + 6.44444054242996M8[t] + 1.32753134816382M9[t] + 3.57349423814607M10[t] + 3.23498817808467M11[t] + 0.0472542409650887t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-0.754483271375538.666941-0.08710.9310430.465522
INDUSTR0.3070495230184420.0383778.000800
Y30.6949966521471110.0962517.220700
M11.727573730993910.86379120.0519960.025998
M2-0.5795459477324591.040881-0.55680.580630.290315
M32.030345888268711.0104332.00940.0509510.025476
M4-0.755912203737990.893009-0.84650.4020840.201042
M5-3.997898293880220.855833-4.67143.1e-051.5e-05
M6-1.189671801758910.871828-1.36460.1796550.089827
M70.2980944796510190.7347040.40570.6869970.343499
M86.444440542429960.9233446.979500
M91.327531348163820.7313091.81530.0766250.038313
M103.573494238146070.8201744.3578.3e-054.2e-05
M113.234988178084670.85783.77130.0005020.000251
t0.04725424096508870.0314331.50330.1402350.070117


Multiple Linear Regression - Regression Statistics
Multiple R0.98466733380303
R-squared0.969569758258765
Adjusted R-squared0.95942634434502
F-TEST (value)95.586137616345
F-TEST (DF numerator)14
F-TEST (DF denominator)42
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation1.0859361766499
Sum Squared Residuals49.5288099497942


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
198.399.3885169653282-1.08851696532819
296.3896.725080887137-0.345080887136932
3100.82102.631211223783-1.81121122378281
499.0699.2369923117442-0.176992311744223
594.0394.4008173674262-0.370817367426193
6102.07102.122970469553-0.0529704695527258
799.3198.99584222634230.314157773657726
898.64100.127656802392-1.48765680239229
9101.82102.088907690541-0.268907690540689
1099.1499.332028926774-0.192028926773886
1197.6397.7460956385892-0.116095638589223
12100.06100.299520570010-0.239520570009528
13101.32100.8258565602510.494143439748832
14101.49101.0476156924600.442384307540174
15105.43105.792768014068-0.362768014067527
16105.09103.8066401355241.2833598644761
1799.4899.40974476823250.0702552317675301
18108.53108.2889422070760.241057792924179
19104.34103.2624436935411.07755630645909
20106.1105.6492276356450.450772364354807
21107.35107.2070468595960.142953140404218
22103103.272093169448-0.272093169447541
23104.5104.1426255535260.357374446473547
24105.17104.0650989496251.10490105037461
25104.84104.904628241270-0.0646282412698626
26106.18106.419998536593-0.239998536593377
27108.86108.928693324461-0.068693324461323
28107.77106.3595049581351.41049504186485
29102.74102.7143457692520.0256542307478491
30112.63109.2440097159023.3859902840984
31106.26105.4464459944610.813554005538527
32108.86108.4819676132260.378032386774175
33111.38110.7771087864890.602891213510783
34106.85106.4324406775270.417559322473321
35107.86107.7025405355980.157459464401905
36107.94108.691889393735-0.751889393734923
37111.38111.2179114738020.162088526198271
38111.29111.962864077347-0.672864077347334
39113.72113.5395266513170.180473348682869
40111.88113.49836080668-1.61836080668003
41109.87109.4120455466600.457954453340149
42113.72114.416942428991-0.696942428991389
43111.71113.015101687116-1.30510168711614
44114.81114.0964594915210.713540508478675
45112.05112.685100122646-0.635100122645671
46111.54111.4934372262520.0465627737481058
47110.87111.268738272286-0.398738272286228
48110.87110.983491086630-0.113491086630163
49115.48114.9830867593490.496913240650947
50111.63110.8144408064630.815559193537468
51116.24114.1778007863712.06219921362879
52113.56114.458501787917-0.898501787916705
53106.01106.193046548429-0.183046548429334
54110.45113.327135178478-2.87713517847846
55107.77108.670166398539-0.9001663985392
56108.61108.664688457215-0.0546884572153699
57108.19108.0318365407290.158163459271359


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
180.01563202351338990.03126404702677980.98436797648661
190.003127300668048340.006254601336096690.996872699331952
200.01973792946901860.03947585893803720.980262070530981
210.007269611340143990.01453922268028800.992730388659856
220.007922794006554880.01584558801310980.992077205993445
230.002757479010820160.005514958021640320.99724252098918
240.001228550380293540.002457100760587090.998771449619706
250.003550539681264610.007101079362529230.996449460318735
260.004689183759738490.009378367519476980.995310816240262
270.003613163636918910.007226327273837830.996386836363081
280.001812044796571470.003624089593142940.998187955203429
290.001446932305353610.002893864610707230.998553067694646
300.1837092311371810.3674184622743620.81629076886282
310.2815657457938180.5631314915876360.718434254206182
320.1956944405677510.3913888811355020.80430555943225
330.1541804320586970.3083608641173940.845819567941303
340.1138406212128360.2276812424256720.886159378787164
350.1025722739794820.2051445479589650.897427726020518
360.1182359448535220.2364718897070440.881764055146478
370.07344270333092550.1468854066618510.926557296669074
380.0663568917294430.1327137834588860.933643108270557
390.0897395279302110.1794790558604220.910260472069789


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level80.363636363636364NOK
5% type I error level120.545454545454545NOK
10% type I error level120.545454545454545NOK