Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 105.384112125121 -0.0218733363637488X[t] + 0.244600489110058M1[t] + 0.230600085802714M2[t] + 0.225163812858891M3[t] + 0.152232065005675M4[t] + 0.0324264484251042M5[t] -0.0535068965189192M6[t] -0.121817038190091M7[t] -0.177502379497611M8[t] -0.126750254077858M9[t] -0.0234371924761798M10[t] + 0.0249370714892171M11[t] + 0.0801217433075963t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)105.3841121251210.428976245.664600
X-0.02187333636374880.005622-3.89090.000320.00016
M10.2446004891100580.2298631.06410.2928310.146416
M20.2306000858027140.2305161.00040.3223660.161183
M30.2251638128588910.2301180.97850.3329590.166479
M40.1522320650056750.2271470.67020.5060860.253043
M50.03242644842510420.2250450.14410.886060.44303
M6-0.05350689651891920.224536-0.23830.8127070.406353
M7-0.1218170381900910.224374-0.54290.5898070.294903
M8-0.1775023794976110.224306-0.79130.4328080.216404
M9-0.1267502540778580.224325-0.5650.5747980.287399
M10-0.02343719247617980.224171-0.10460.9171870.458593
M110.02493707148921710.2239770.11130.9118330.455916
t0.08012174330759630.00781710.249600


Multiple Linear Regression - Regression Statistics
Multiple R0.946332492074222
R-squared0.895545185555408
Adjusted R-squared0.866025346690632
F-TEST (value)30.3370621248209
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.354095200960798
Sum Squared Residuals5.76763692179953


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1103.63103.5149387202550.115061279744937
2103.64103.620432065710.0195679342899749
3103.66103.769486879711-0.109486879710544
4103.77103.820423547892-0.0504235478924228
5103.88103.8004256773470.0795743226531766
6103.91103.8646087520740.0453912479256085
7103.91103.933291028257-0.0232910282565623
8103.92103.999286769348-0.0792867693477565
9104.05104.169532643530-0.119532643529858
10104.23104.394526787530-0.164526787530249
11104.3104.501149458439-0.201149458439500
12104.31104.556334130258-0.246334130257874
13104.31104.856995692675-0.546995692675405
14104.34104.903431029948-0.563431029948282
15104.55104.925620493039-0.375620493039064
16104.65104.934997822130-0.284997822129811
17104.73104.893126615220-0.163126615220464
18104.75104.830444339038-0.0804443390382939
19104.75104.824757271584-0.0747572715837193
20104.76104.888565679039-0.128565679038538
21104.94105.008502879584-0.0685028795840206
22105.29105.1853756835840.104624316415838
23105.38105.2613756835840.118624316415831
24105.43105.3056236872210.124376312779338
25105.43105.545039907820-0.115039907819696
26105.42105.538979237820-0.118979237819582
27105.52105.587416704547-0.0674167045468627
28105.69105.6230420372740.0669579627258855
29105.72105.5461734921830.173826507817234
30105.74105.5425492241830.197450775817281
31105.74105.5499861585460.190013841453607
32105.74105.5525492241830.187450775817279
33105.95105.6484257547280.301574245271936
34106.17105.6984332078180.471566792181528
35106.34105.7766205414550.563379458545159
36106.37105.7727472050910.597252794908903
37106.37105.9290447475080.440955252492114
38106.36105.8683007365980.4916992634016
39106.44105.8926775333260.547322466674447
40106.29105.9414268678710.348573132128953
41106.23106.0001730082350.229826991765055
42106.23105.9834247384170.246575261583356
43106.23105.9208669964160.309133003583678
44106.23105.9409287311440.289071268856351
45106.34106.054303930780.285696069220001
46106.44106.1721187265980.267881273401967
47106.44106.2196833893250.220316610674844
48106.48106.2989287311440.181071268856347
49106.5106.3939809317420.106019068258051
50106.57106.3988569299240.171143070076289
51106.4106.3947983893780.00520161062202413
52106.37106.450109724833-0.0801097248326048
53106.25106.570101207015-0.320101207015001
54106.21106.618972946288-0.408972946287952
55106.21106.611098545197-0.401098545197003
56106.24106.508669596287-0.268669596287335
57106.19106.589234791378-0.399234791378059
58106.08106.759545594469-0.679545594469084
59106.13106.831170927196-0.701170927196333
60106.09106.746366246287-0.656366246286713


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.0009264875932503450.001852975186500690.99907351240675
180.0007189442033335760.001437888406667150.999281055796666
190.0002677225905810010.0005354451811620020.99973227740942
209.2853734916939e-050.0001857074698338780.999907146265083
214.0045636405382e-058.0091272810764e-050.999959954363595
227.96863741772666e-050.0001593727483545330.999920313625823
239.244198643709e-050.000184883972874180.999907558013563
240.0001048257458434880.0002096514916869760.999895174254157
256.00862444275754e-050.0001201724888551510.999939913755572
264.11709076914053e-058.23418153828106e-050.999958829092309
272.36608871637106e-054.73217743274212e-050.999976339112836
287.06042901135717e-061.41208580227143e-050.999992939570989
297.48143811504224e-061.49628762300845e-050.999992518561885
301.12455887008689e-052.24911774017378e-050.9999887544113
311.95369197468025e-053.9073839493605e-050.999980463080253
329.78413309471307e-050.0001956826618942610.999902158669053
330.0001903340827856050.0003806681655712090.999809665917214
340.000486227255105480.000972454510210960.999513772744895
350.0001998703904106950.0003997407808213890.99980012960959
367.96908023918756e-050.0001593816047837510.999920309197608
370.0001014296692030490.0002028593384060980.999898570330797
380.0009063731863339970.001812746372667990.999093626813666
390.001228974256817430.002457948513634860.998771025743183
400.1035685575496960.2071371150993920.896431442450304
410.3861615057437460.7723230114874910.613838494256254
420.4548783886472690.9097567772945380.545121611352731
430.4109189677356170.8218379354712340.589081032264383


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