Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 604335.544025157 + 52211.4327044027X[t] -10737.0504941598M1[t] -31415.9620245583M2[t] -45812.6252770291M3[t] -40860.6218628332M4[t] -36479.4517819706M5[t] -38801.9483677747M6[t] -45494.7782869121M7[t] -50086.4415393831M8[t] -59034.9381251872M9[t] -54820.2680443246M10[t] -10852.1700808625M11[t] -1504.17008086253t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)604335.54402515713504.0655844.752100
X52211.432704402710825.3676414.82311e-055e-06
M1-10737.050494159814061.215256-0.76360.4481520.224076
M2-31415.962024558314623.044119-2.14840.0357990.017899
M3-45812.625277029114615.876218-3.13440.0026820.001341
M4-40860.621862833214610.815998-2.79660.0069610.003481
M5-36479.451781970614607.86565-2.49720.0153260.007663
M6-38801.948367774714607.026451-2.65640.0101430.005071
M7-45494.778286912114608.298766-3.11430.0028440.001422
M8-50086.441539383114611.682042-3.42780.0011150.000557
M9-59034.938125187214617.174815-4.03870.0001577.9e-05
M10-54820.268044324614624.774708-3.74850.0004070.000204
M11-10852.170080862514535.789514-0.74660.458280.22914
t-1504.17008086253175.624874-8.564700


Multiple Linear Regression - Regression Statistics
Multiple R0.815618618735924
R-squared0.665233731228697
Adjusted R-squared0.591471672007901
F-TEST (value)9.0186437072943
F-TEST (DF numerator)13
F-TEST (DF denominator)59
p-value8.28744184389052e-10
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation25174.8882440813
Sum Squared Residuals37392724888.0169


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1577992592094.323450134-14102.3234501342
2565464569911.241838874-4447.24183887437
3547344554010.408505541-6666.40850554064
4554788557458.241838874-2670.24183887389
5562325560335.2418388741989.75816112615
6560854556508.5751722074345.42482779281
7555332548311.5751722077020.42482779284
8543599542215.7418388741383.25816112601
9536662531763.0751722074898.92482779258
10542722534473.5751722078248.42482779282
11593530629148.93575921-35618.9357592094
12610763638496.935759209-27733.9357592094
13612613626255.715184187-13642.7151841870
14611324604072.6335729267251.3664270741
15594167588171.8002395935995.19976040731
16595454591619.6335729263834.36642707397
17590865594496.633572926-3631.63357292605
18589379590669.96690626-1290.96690625937
19584428582472.9669062591955.03309374061
20573100576377.133572926-3277.13357292601
21567456565924.4669062591531.53309374067
22569028568634.966906259393.03309374062
23620735611098.8947888599636.10521114107
24628884620446.8947888598437.1052111411
25628232608205.67421383720026.3257861634
26612117586022.59260257626094.4073974245
27595404570121.75926924225282.2407307577
28597141573569.59260257623571.4073974244
29593408576446.59260257616961.4073974244
30590072572619.92593590917452.0740640910
31579799564422.92593590915376.0740640910
32574205558327.09260257615877.9073974244
33572775547874.42593590924900.5740640911
34572942550584.92593590922357.0740640910
35619567593048.85381850926518.1461814915
36625809602396.85381850923412.1461814915
37619916590155.63324348629760.3667565138
38587625567972.55163222519652.4483677749
39565742552071.71829889213670.2817011081
40557274555519.5516322251754.44836777478
41560576558396.5516322252179.44836777476
42548854554569.884965559-5715.88496555857
43531673546372.884965559-14699.8849655586
44525919540277.051632225-14358.0516322252
45511038529824.384965559-18786.3849655585
46498662532534.884965559-33872.8849655586
47555362574998.812848158-19636.8128481581
48564591584346.812848158-19755.8128481581
49541657572105.592273136-30448.5922731358
50527070549922.510661875-22852.5106618747
51509846534021.677328541-24175.6773285415
52514258537469.510661875-23211.5106618748
53516922540346.510661875-23424.5106618748
54507561536519.843995208-28958.8439952082
55492622528322.843995208-35700.8439952082
56490243522227.010661875-31984.0106618748
57469357511774.343995208-42417.3439952081
58477580514484.843995208-36904.8439952081
59528379556948.771877808-28569.7718778077
60533590566296.771877808-32706.7718778077
61517945554055.551302785-36110.5513027854
62506174531872.469691524-25698.4696915243
63501866515971.636358191-14105.6363581911
64516141519419.469691524-3278.46969152441
65528222522296.4696915245925.53030847558
66532638518469.80302485814168.1969751422
67536322510272.80302485826049.1969751422
68536535504176.96969152432358.0303084756
69523597493724.30302485829872.6969751423
70536214496434.80302485839779.1969751423
71586570538898.73090745747671.2690925427
72596594548246.73090745748347.2690925427
73580523536005.51033243544517.4896675651


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.01494797364857230.02989594729714450.985052026351428
180.005136936216136920.01027387243227380.994863063783863
190.001443919838667290.002887839677334580.998556080161333
200.0003584122047073170.0007168244094146340.999641587795293
217.46764115827677e-050.0001493528231655350.999925323588417
222.16714531832214e-054.33429063664427e-050.999978328546817
233.69890578344136e-067.39781156688272e-060.999996301094217
248.56005445744122e-071.71201089148824e-060.999999143994554
251.89173715788026e-073.78347431576052e-070.999999810826284
261.33817885533315e-072.67635771066629e-070.999999866182114
274.48930169661696e-088.97860339323393e-080.999999955106983
281.73324390767128e-083.46648781534256e-080.99999998266756
291.13972219659738e-082.27944439319477e-080.999999988602778
307.25307987218253e-091.45061597443651e-080.99999999274692
318.11454723278488e-091.62290944655698e-080.999999991885453
322.75193190855175e-095.5038638171035e-090.999999997248068
338.62349769750184e-101.72469953950037e-090.99999999913765
343.45208927578017e-106.90417855156033e-100.999999999654791
351.17657425013385e-102.35314850026770e-100.999999999882343
364.65328715685841e-119.30657431371681e-110.999999999953467
375.77777599073358e-111.15555519814672e-100.999999999942222
389.47722661646543e-091.89544532329309e-080.999999990522773
394.06517749705112e-078.13035499410224e-070.99999959348225
401.72359442126052e-053.44718884252103e-050.999982764055787
410.0001122835358317380.0002245670716634760.999887716464168
420.0008260270315708980.001652054063141800.99917397296843
430.004819737409234620.009639474818469240.995180262590765
440.01127794638973770.02255589277947550.988722053610262
450.03674450595604680.07348901191209370.963255494043953
460.0829925839907470.1659851679814940.917007416009253
470.0938319083481930.1876638166963860.906168091651807
480.1261167434854490.2522334869708970.873883256514551
490.2071987275439390.4143974550878770.792801272456061
500.4302224595944510.8604449191889020.569777540405549
510.6491631897543250.701673620491350.350836810245675
520.8298822686270890.3402354627458230.170117731372911
530.9523938290758370.09521234184832660.0476061709241633
540.992576857738410.01484628452318080.00742314226159041
550.9919865153621860.01602696927562830.00801348463781416
560.9951238252881790.009752349423642870.00487617471182143


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level260.65NOK
5% type I error level310.775NOK
10% type I error level330.825NOK