Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 128.755416666667 + 12.9404166666667X[t] -5.35740277777782M1[t] -0.641638888888884M2[t] + 3.70612499999999M3[t] + 5.85188888888888M4[t] + 2.17165277777778M5[t] -1.76258333333333M6[t] -7.69481944444444M7[t] -3.91905555555555M8[t] -1.19529166666666M9[t] + 6.51447222222222M10[t] + 2.57223611111111M11[t] -0.0397638888888885t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)128.7554166666673.69111334.882500
X12.94041666666673.0340764.2659.8e-054.9e-05
M1-5.357402777777824.277103-1.25260.216690.108345
M2-0.6416388888888844.264529-0.15050.881060.44053
M33.706124999999994.2531210.87140.3880670.194033
M45.851888888888884.2428881.37920.1744950.087248
M52.171652777777784.2338380.51290.6104560.305228
M6-1.762583333333334.225979-0.41710.6785580.339279
M7-7.694819444444444.219318-1.82370.0746960.037348
M8-3.919055555555554.21386-0.930.3572060.178603
M9-1.195291666666664.20961-0.28390.7777280.388864
M106.514472222222224.2065711.54860.1283210.064161
M112.572236111111114.2047470.61170.5437180.271859
t-0.03976388888888850.071514-0.5560.5808850.290442


Multiple Linear Regression - Regression Statistics
Multiple R0.734406514839355
R-squared0.539352929038487
Adjusted R-squared0.40917006115806
F-TEST (value)4.14304076888121
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value0.000163786037073121
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.64732770487073
Sum Squared Residuals2032.60041833333


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1126.51123.3582500000003.1517499999998
2131.02128.034252.98575
3136.51132.342254.16775000000001
4138.04134.448253.59174999999999
5132.92130.728252.19175000000001
6129.61126.754252.85575000000003
7122.96120.782252.17775000000002
8124.04124.51825-0.478249999999984
9121.29127.20225-5.91224999999999
10124.56134.87225-10.3122500000000
11118.53130.89025-12.3602500000000
12113.14128.27825-15.13825
13114.15122.881083333333-8.73108333333327
14122.17127.557083333333-5.38708333333332
15129.23131.865083333333-2.63508333333333
16131.19133.971083333333-2.78108333333333
17129.12130.251083333333-1.13108333333333
18128.28126.2770833333332.00291666666667
19126.83120.3050833333336.52491666666667
20138.13124.04108333333314.0889166666667
21140.52126.72508333333313.7949166666667
22146.83134.39508333333312.4349166666667
23135.14130.4130833333334.72691666666666
24131.84127.8010833333334.03891666666667
25125.7122.4039166666673.29608333333338
26128.98127.0799166666671.90008333333333
27133.25131.3879166666671.86208333333334
28136.76133.4939166666673.26608333333333
29133.24129.7739166666673.46608333333334
30128.54125.7999166666672.74008333333332
31121.08119.8279166666671.25208333333333
32120.23123.563916666667-3.33391666666666
33119.08126.247916666667-7.16791666666667
34125.75133.917916666667-8.16791666666666
35126.89129.935916666667-3.04591666666666
36126.6127.323916666667-0.723916666666674
37121.89121.92675-0.0367499999999588
38123.44126.60275-3.16275
39126.46130.91075-4.45075000000001
40129.49133.01675-3.52674999999999
41127.78129.29675-1.51675000000001
42125.29125.32275-0.0327500000000041
43119.02119.35075-0.330750000000012
44119.96123.08675-3.12675000000001
45122.86125.77075-2.91075000000001
46131.89133.44075-1.55075000000002
47132.73129.458753.27124999999998
48135.01126.846758.16324999999999
49136.71134.392.32000000000005
50142.73139.0663.66399999999999
51144.43143.3741.05600000000000
52144.93145.48-0.549999999999996
53138.75141.76-3.01000000000001
54130.22137.786-7.56600000000001
55122.19131.814-9.62400000000001
56128.4135.55-7.15
57140.43138.2342.196
58153.5145.9047.596
59149.33141.9227.408
60142.97139.313.65999999999999


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.1169482663712620.2338965327425240.883051733628738
180.1259616924984770.2519233849969540.874038307501523
190.2562803763984460.5125607527968910.743719623601554
200.780925919878310.4381481602433790.219074080121689
210.9720913376438140.05581732471237180.0279086623561859
220.9969663423134640.006067315373071730.00303365768653586
230.9969022877560440.006195424487912480.00309771224395624
240.99675610211740.006487795765198670.00324389788259934
250.9933324252687040.01333514946259160.00666757473129582
260.9875845419743070.0248309160513850.0124154580256925
270.98059650923320.03880698153360110.0194034907668006
280.9734588048431950.05308239031361040.0265411951568052
290.9688041267513670.06239174649726520.0311958732486326
300.9747862527180180.05042749456396380.0252137472819819
310.9887385629569030.02252287408619350.0112614370430967
320.9954599348985560.00908013020288820.0045400651014441
330.9939811821853920.01203763562921580.00601881781460791
340.9910160890621220.01796782187575670.00898391093787835
350.9813353637683360.0373292724633280.018664636231664
360.9636170407206550.07276591855868910.0363829592793445
370.932938276000660.1341234479986800.0670617239993402
380.913249128487440.1735017430251190.0867508715125594
390.8844992055138130.2310015889723740.115500794486187
400.822477876966110.3550442460677810.177522123033891
410.7108150887443680.5783698225112630.289184911255632
420.6444833973209510.7110332053580980.355516602679049
430.6855097078130740.6289805843738520.314490292186926


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level40.148148148148148NOK
5% type I error level110.407407407407407NOK
10% type I error level160.592592592592593NOK