Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 39.038520381192 + 0.637407184691893X[t] -0.272539382924652M1[t] -0.00150391792607000M2[t] + 0.304227031804597M3[t] + 0.470522460723327M4[t] + 0.608184536264328M5[t] + 0.540258492164768M6[t] + 0.694706519912123M7[t] + 0.735689325948949M8[t] + 0.888275102075635M9[t] + 0.522867621037696M10[t] + 0.269330499234351M11[t] + 0.0686660801794755t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)39.03852038119223.2713991.67750.1002220.050111
X0.6374071846918930.2185352.91670.0054530.002727
M1-0.2725393829246520.387002-0.70420.4848380.242419
M2-0.001503917926070000.393409-0.00380.9969660.498483
M30.3042270318045970.379540.80160.4269250.213462
M40.4705224607233270.3763341.25030.2175210.108761
M50.6081845362643280.3710081.63930.1079780.053989
M60.5402584921647680.3701731.45950.151230.075615
M70.6947065199121230.3692841.88120.0662790.03314
M80.7356893259489490.368331.99740.051720.02586
M90.8882751020756350.371382.39180.0209090.010455
M100.5228676210376960.3679041.42120.1620.081
M110.2693304992343510.3679350.7320.4678780.233939
t0.06866608017947550.0405551.69310.0971910.048596


Multiple Linear Regression - Regression Statistics
Multiple R0.987885678348134
R-squared0.975918113485352
Adjusted R-squared0.969112362948604
F-TEST (value)143.39610425269
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.581204328880177
Sum Squared Residuals15.5387297078166


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1107.11107.394163863906-0.284163863906472
2107.57107.823102414942-0.253102414941710
3107.81108.178377229311-0.368377229311087
4108.75108.4133387384090.336661261590705
5109.43108.6515372533640.778462746635643
6109.62109.0538438158000.566156184199835
7109.54109.2132172052580.326782794742190
8109.53109.3292401633210.200759836678962
9109.84109.5823623788620.257637621138211
10109.67109.2983691216970.371630878302837
11109.79109.1326202956140.657379704385954
12109.56108.9319558765590.628044123440825
13110.22109.1169009564761.10309904352394
14110.4109.8709171717040.529082828296159
15110.69110.2325660579200.457433942079853
16110.72110.4930238544060.226976145593968
17110.89110.7057260819730.184273918026572
18110.58110.700092046206-0.120092046206423
19110.94111.108054237694-0.168054237693908
20110.91111.141214261747-0.231214261747181
21111.22111.336969830666-0.116969830665660
22111.09111.250572800756-0.160572800755516
23111111.256923914539-0.256923914539225
24111.06111.120000213954-0.0600002139535328
25111.55111.802122897930-0.252122897930094
26112.32112.2756799518930.0443200481065509
27112.64112.5353436885590.104656311440953
28112.36112.916908850136-0.556908850136393
29112.04113.129611077704-1.08961107770377
30112.37113.136725185631-0.766725185630614
31112.59113.455450371261-0.865450371261225
32112.89113.603343688559-0.713343688559044
33113.22113.799099257478-0.579099257477537
34112.85114.012283604373-1.16228360437259
35113.06113.852908850136-0.792908850136393
36112.99113.671366646622-0.681366646622274
37113.32113.818067295458-0.498067295457647
38113.74114.304372493115-0.564372493114832
39113.91114.653273235637-0.743273235637301
40114.52114.875486601042-0.355486601041673
41114.96115.132807331537-0.172807331537501
42114.91115.190914014240-0.280914014239678
43115.3115.420402194013-0.120402194013431
44115.44115.523677008383-0.0836770083828088
45115.52115.757677008383-0.237677008382816
46116.08115.8178836309520.262116369048187
47115.94115.6521348048690.287865195131308
48115.56115.4642185295080.0957814704923437
49115.88115.948744986230-0.0687449862297302
50116.66116.4159279683460.244072031653832
51117.41116.8604397885720.549560211427583
52117.68117.3312419560070.348758043993392
53117.85117.5503182554210.29968174457906
54118.21117.6084249381230.60157506187688
55118.92118.0928759917740.827124008226373
56119.03118.202524877990.827475122010071
57119.17118.4938915246120.676108475387803
58118.95118.2608908422230.689109157777082
59118.92118.8154121348420.104587865158356
60118.9118.8824587333570.0175412666426384


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.6337142976002880.7325714047994240.366285702399712
180.905257160215460.1894856795690790.0947428397845394
190.8907535821829280.2184928356341430.109246417817072
200.8539053204082130.2921893591835750.146094679591787
210.8132805535974380.3734388928051230.186719446402562
220.7962387457698390.4075225084603230.203761254230161
230.8292094602702610.3415810794594770.170790539729739
240.8689097498229720.2621805003540550.131090250177028
250.8764191127618680.2471617744762630.123580887238132
260.9501177588105630.09976448237887320.0498822411894366
270.9963125013552670.00737499728946650.00368749864473325
280.9983125560752170.003374887849566790.00168744392478340
290.9987430152339920.002513969532015780.00125698476600789
300.9981038638079950.003792272384010880.00189613619200544
310.9961720865087820.007655826982436050.00382791349121802
320.9919563015930360.01608739681392800.00804369840696402
330.9900209387066140.01995812258677140.00997906129338571
340.9848041720780430.03039165584391320.0151958279219566
350.9714505438452480.05709891230950350.0285494561547517
360.9668817306799480.0662365386401050.0331182693200525
370.974985845499750.05002830900049850.0250141545002493
380.9624023908073370.07519521838532610.0375976091926631
390.939090753580290.1218184928394210.0609092464197106
400.888159661614680.2236806767706390.111840338385320
410.878829637651850.2423407246962990.121170362348150
420.7800280431832410.4399439136335180.219971956816759
430.6932134239593280.6135731520813440.306786576040672


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level50.185185185185185NOK
5% type I error level80.296296296296296NOK
10% type I error level130.481481481481481NOK