Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 71.5670283035868 + 0.600308352328144X[t] -9.06114044400578M1[t] -10.8421961581726M2[t] -2.76076096387848M3[t] -10.0107189858019M4[t] -10.5541324307141M5[t] -4.46488841486347M6[t] -6.61278423001557M7[t] -5.74956059221821M8[t] -3.03290485901032M9[t] -4.19653415055227M10[t] -4.83803581103003M11[t] + 0.243875973404465t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)71.56702830358687.8707869.092700
X0.6003083523281440.0995956.027500
M1-9.061140444005782.371891-3.82020.000390.000195
M2-10.84219615817262.463892-4.40046.2e-053.1e-05
M3-2.760760963878482.655728-1.03950.3038680.151934
M4-10.01071898580192.48833-4.02310.0002070.000104
M5-10.55413243071412.467976-4.27649.2e-054.6e-05
M6-4.464888414863472.739256-1.630.1097940.054897
M7-6.612784230015572.788529-2.37140.0218690.010935
M8-5.749560592218212.652871-2.16730.0353120.017656
M9-3.032904859010322.821722-1.07480.2879330.143966
M10-4.196534150552272.79126-1.50350.1394120.069706
M11-4.838035811030032.516816-1.92230.0606430.030322
t0.2438759734044650.0343017.109900


Multiple Linear Regression - Regression Statistics
Multiple R0.920674569568137
R-squared0.847641663049474
Adjusted R-squared0.805499995382308
F-TEST (value)20.1140987049710
F-TEST (DF numerator)13
F-TEST (DF denominator)47
p-value6.4392935428259e-15
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3.86504183797615
Sum Squared Residuals702.111775237386


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1100.6105.791872694913-5.19187269491314
2104.3107.736481397654-3.43648139765421
3120.4123.445585298989-3.04558529898893
4107.5110.736573903353-3.23657390335264
5102.9109.476543068120-6.57654306811981
6125.6124.874319177530.725680822470073
7107.5101.2391369815036.26086301849652
8108.8104.1471616496904.65283835031027
9128.4125.3570672670783.04293273292234
10121.1121.0155563406700.0844436593302421
11119.5115.8754946702043.62450532979587
12128.7120.8973756194067.80262438059418
13108.7106.6773359778512.02266402214880
14105.5106.100649600814-0.600649600813876
15119.8121.509599325985-1.70959932598456
16111.3110.5414821521000.758517847900137
17110.6107.1203412484863.47965875151426
18120.1121.917809005568-1.81780900556770
1997.5102.184631099674-4.68463109967418
20107.7106.7134883191460.986511680853573
21127.3127.623239760370-0.32323976037029
22117.2118.959508697200-1.75950869719973
23119.8123.54444233445-3.74444233445004
24116.2124.003979805958-7.80397980595782
25111110.1441251758000.855874824199886
26112.4112.3888880547050.0111119452949567
27130.6126.8373444161513.76265558384929
28109.1111.727099611202-2.62709961120183
29118.8116.0499364526212.75006354737925
30123.9125.624721544448-1.72472154444785
31101.6103.850495240639-2.25049524063866
32112.8110.3603700227942.43962997720622
33128126.0474387987631.95256120123722
34129.6126.9286105376102.67138946239027
35125.8122.2087647137743.5912352862262
36119.5122.488209679583-2.98820967958314
37115.7113.6709452089822.02905479101817
38113.6111.5934879511242.00651204887586
39129.7124.8413276079134.85867239208649
40112110.9917303428541.00826965714629
41116.8112.4330870930984.36691290690245
42127124.8893522761002.11064772390024
43112.1109.1782403308052.92175966919518
44114.2114.547529243536-0.347529243536449
45121.1126.212532058907-5.1125320589069
46131.6133.817157343829-2.21715734382905
47125125.075245559395-0.0752455593945539
48120.4122.353148763563-1.95314876356317
49117.7117.1377344069310.56226559306927
50117.5115.4804929957032.01950700429726
51120.6124.466143350962-3.86614335096229
52127.5123.4031139904924.09688600950804
53112.3116.320092137676-4.02009213767615
54124.5123.7937979963550.706202003645235
55115.2117.447496347379-2.24749634737886
56104.7112.431450764834-7.73145076483362
57130.9130.4597221148820.440277885117625
58129.2127.9791670806921.22083291930827
59113.5116.896052722177-3.39605272217747
60125.6120.657286131494.94271386850995
61107.6107.877986535523-0.277986535522993


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.4145625598924970.8291251197849940.585437440107503
180.4542691347847510.9085382695695030.545730865215249
190.9015320729095450.196935854180910.098467927090455
200.8423868428287690.3152263143424620.157613157171231
210.75763466900690.48473066198620.2423653309931
220.702849033554070.5943019328918590.297150966445929
230.6228752417092680.7542495165814630.377124758290732
240.8656585837529030.2686828324941940.134341416247097
250.8822525987412110.2354948025175770.117747401258789
260.8838384070868670.2323231858262660.116161592913133
270.8917175379446310.2165649241107380.108282462055369
280.8862723152612580.2274553694774830.113727684738742
290.8686891709538140.2626216580923720.131310829046186
300.84681757220010.3063648555998010.153182427799900
310.8264315002195750.3471369995608500.173568499780425
320.787089711558950.4258205768820990.212910288441049
330.7181315557351920.5637368885296150.281868444264808
340.6551923365455110.6896153269089770.344807663454488
350.6111960078966440.7776079842067110.388803992103356
360.623916101257770.752167797484460.37608389874223
370.5254859545659340.9490280908681310.474514045434066
380.4264634303038530.8529268606077060.573536569696147
390.4687111980532770.9374223961065540.531288801946723
400.4124086066730240.8248172133460470.587591393326976
410.446920043668870.893840087337740.55307995633113
420.3213496964633590.6426993929267170.678650303536641
430.3825020175873020.7650040351746050.617497982412698
440.809181447994840.381637104010320.19081855200516


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