Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 701.25 + 79.75X[t] -21.4833333333334M1[t] -41.5666666666667M2[t] + 42.75M3[t] -42.1333333333332M4[t] -23.0166666666668M5[t] + 107.7M6[t] -267.183333333333M7[t] -344.066666666667M8[t] + 122.25M9[t] + 69.3666666666667M10[t] -29.9166666666666M11[t] -0.716666666666665t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)701.2529.97656823.393300
X79.7524.6405873.23650.0022460.001123
M1-21.483333333333434.735557-0.61850.5393080.269654
M2-41.566666666666734.633443-1.20020.2362110.118105
M342.7534.5407941.23770.222120.11106
M4-42.133333333333234.457687-1.22280.227650.113825
M5-23.016666666666834.38419-0.66940.5065890.253294
M6107.734.3203663.13810.0029660.001483
M7-267.18333333333334.266268-7.797300
M8-344.06666666666734.221942-10.05400
M9122.2534.1874273.57590.0008340.000417
M1069.366666666666734.1627512.03050.0481130.024056
M11-29.916666666666634.147938-0.87610.3855330.192767
t-0.7166666666666650.580784-1.2340.2234840.111742


Multiple Linear Regression - Regression Statistics
Multiple R0.944260037716194
R-squared0.891627018827788
Adjusted R-squared0.860999871974771
F-TEST (value)29.1123108236891
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation53.9848207329173
Sum Squared Residuals134060.6


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1627679.05-52.0500000000007
2696658.2537.7499999999999
3825741.8583.15
4677656.2520.7500000000000
5656674.65-18.6499999999999
6785804.65-19.6500000000000
7412429.050000000000-17.0499999999995
8352351.450.550000000000007
9839817.0521.9499999999998
10729763.45-34.4500000000000
11696663.4532.5500000000002
12641692.65-51.65
13695670.4524.5500000000002
14638649.65-11.6500000000000
15762733.2528.75
16635647.65-12.65
17721666.0554.95
18854796.0557.95
19418420.45-2.45000000000004
20367342.8524.1500000000001
21824808.4515.5500000000001
22687754.85-67.85
23601654.85-53.85
24676684.05-8.04999999999999
25740661.8578.1500000000001
26691641.0549.95
27683724.65-41.65
28594639.05-45.05
29729657.4571.55
30731787.45-56.45
31386411.85-25.8500000000001
32331334.25-3.24999999999997
33707799.85-92.85
34715746.25-31.25
35657646.2510.7500000000000
36653675.45-22.45
37642653.25-11.2499999999998
38643632.4510.5500000000000
39718716.051.94999999999998
40654630.4523.5500000000000
41632648.85-16.8500000000001
42731778.85-47.85
43392403.25-11.2500000000001
44344325.6518.35
45792791.250.750000000000033
46852737.65114.35
47649637.6511.3500000000000
48629666.85-37.85
49685724.4-39.3999999999998
50617703.6-86.6
51715787.2-72.2
52715701.613.4000000000000
53629720-91
5491685066
55531474.456.5999999999999
56357396.8-39.8000000000001
57917862.454.6000000000001
58828808.819.2000000000000
59708708.8-0.80000000000003
60858738120


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.5122434206494320.9755131587011350.487756579350568
180.468460251112110.936920502224220.53153974888789
190.3165741250002370.6331482500004740.683425874999763
200.2091491957687660.4182983915375320.790850804231234
210.1381554843320080.2763109686640170.861844515667992
220.1052414559257400.2104829118514800.89475854407426
230.1311134770265550.262226954053110.868886522973445
240.08998322281215160.1799664456243030.910016777187848
250.1362812116628210.2725624233256420.863718788337179
260.1237354400269210.2474708800538420.876264559973079
270.2116234864064810.4232469728129620.788376513593519
280.1747624697048260.3495249394096520.825237530295174
290.3193744171998620.6387488343997230.680625582800138
300.3079593779193390.6159187558386780.692040622080661
310.2262129643706060.4524259287412120.773787035629394
320.1913726093903580.3827452187807170.808627390609642
330.2452171180387970.4904342360775950.754782881961203
340.2048831363614490.4097662727228980.795116863638551
350.1622254416094830.3244508832189650.837774558390517
360.106272125620930.212544251241860.89372787437907
370.06758219229519260.1351643845903850.932417807704807
380.06458895897741430.1291779179548290.935411041022586
390.05558600745472070.1111720149094410.94441399254528
400.03535283875004090.07070567750008190.96464716124996
410.03961026127277510.07922052254555030.960389738727225
420.03634207437783480.07268414875566950.963657925622165
430.02024666191724060.04049332383448120.97975333808276


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level10.0370370370370370OK
10% type I error level40.148148148148148NOK