Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 100.335200181349 -2.32705377694079X[t] + 0.149120980679454M1[t] + 1.09636674339122M2[t] + 0.95194583943642M3[t] + 0.702524935481617M4[t] + 0.419770698193481M5[t] + 0.143683127572011M6[t] + 0.132595556950542M7[t] + 0.809350282485877M8[t] + 0.691596045197743M9[t] + 0.462175141242941M10[t] + 0.239420903954802M11[t] + 0.281087570621469t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)100.3352001813491.03061597.354700
X-2.327053776940790.902121-2.57950.012450.006225
M10.1491209806794541.2497860.11930.9054360.452718
M21.096366743391221.2484780.87820.3834790.191739
M30.951945839436421.2474590.76310.4484920.224246
M40.7025249354816171.246730.56350.5752710.287635
M50.4197706981934811.2462930.33680.7374720.368736
M60.1436831275720111.2461470.11530.9086040.454302
M70.1325955569505421.2462930.10640.9156390.457819
M80.8093502824858771.2446560.65030.5180920.259046
M90.6915960451977431.2436340.55610.5802760.290138
M100.4621751412429411.2429040.37190.7113590.355679
M110.2394209039548021.2424650.19270.8478680.423934
t0.2810875706214690.01906114.746900


Multiple Linear Regression - Regression Statistics
Multiple R0.93492067185643
R-squared0.874076662664479
Adjusted R-squared0.845852466365138
F-TEST (value)30.9690541191741
F-TEST (DF numerator)13
F-TEST (DF denominator)58
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2.15175963867601
Sum Squared Residuals268.544033472836


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1103.52100.7654087326492.7545912673507
2103.5101.9937420659831.50625793401684
3103.52102.1304087326501.38959126735019
4103.53102.1620753993161.36792460068352
5103.53102.1604087326501.36959126735019
6103.53102.1654087326501.36459126735020
7103.52102.4354087326501.08459126735019
8103.54103.3932510288070.146748971193397
9103.59103.556584362140.0334156378600615
10103.59103.608251028807-0.0182510288066067
11103.59103.66658436214-0.0765843621399367
12103.59103.708251028807-0.118251028806602
13103.63104.138459580108-0.508459580107533
14103.74105.366792913441-1.62679291344077
15103.7105.503459580107-1.80345958010743
16103.72105.535126246774-1.8151262467741
17103.81105.533459580107-1.72345958010743
18103.8105.538459580107-1.73845958010743
19104.22105.808459580107-1.58845958010743
20106.91104.4392480993232.47075190067656
21107.06104.6025814326572.45741856734324
22107.17104.6542480993232.51575190067657
23107.25104.7125814326572.53741856734324
24107.28104.7542480993232.52575190067657
25107.24105.1844566506242.05554334937564
26107.23106.4127899839580.817210016042422
27107.34106.5494566506240.790543349375747
28107.34106.5811233172910.758876682709082
29107.3106.5794566506240.720543349375744
30107.24106.5844566506240.655543349375742
31107.3106.8544566506240.445543349375744
32107.32107.812298946781-0.492298946781062
33107.28107.975632280114-0.695632280114389
34107.33108.027298946781-0.697298946781059
35107.33108.085632280114-0.755632280114389
36107.33108.127298946781-0.797298946781055
37107.28108.557507498082-1.27750749808197
38107.28109.785840831415-2.50584083141520
39107.29109.922507498082-2.63250749808187
40107.29109.954174164749-2.66417416474854
41107.23109.952507498082-2.72250749808187
42107.24109.957507498082-2.71750749808188
43107.24110.227507498082-2.98750749808188
44107.2111.185349794239-3.98534979423868
45107.23111.348683127572-4.11868312757201
46107.2111.400349794239-4.20034979423868
47107.21111.458683127572-4.24868312757202
48107.24111.500349794239-4.26034979423868
49107.21111.930558345540-4.72055834553961
50113.89113.1588916788730.731108321127171
51114.05113.2955583455400.754441654460494
52114.05113.3272250122060.722774987793827
53114.05113.3255583455400.724441654460494
54114.05113.3305583455400.719441654460497
55115.12113.6005583455391.51944165446050
56115.68114.5584006416961.12159935830370
57116.05114.7217339750301.32826602497036
58116.18114.7734006416961.40659935830370
59116.35114.8317339750301.51826602497036
60116.44114.8734006416961.56659935830370
61117115.3036091929971.69639080700277
62117.61116.5319425263301.07805747366955
63118.17116.6686091929971.50139080700287
64118.33116.7002758596641.62972414033621
65118.33116.6986091929971.63139080700287
66118.42116.7036091929971.71639080700288
67118.5116.9736091929971.52639080700288
68118.67117.9314514891540.738548510846074
69119.09118.0947848224870.995215177512742
70119.14118.1464514891540.993548510846073
71119.23118.2047848224871.02521517751275
72119.33118.2464514891541.08354851084607


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
171.54955075409298e-053.09910150818596e-050.999984504492459
184.27673861299270e-078.55347722598539e-070.999999572326139
192.94340827849628e-065.88681655699257e-060.999997056591722
201.78954359541076e-073.57908719082152e-070.99999982104564
211.15789556670435e-082.31579113340871e-080.999999988421044
229.59869217606954e-101.91973843521391e-090.99999999904013
231.04205943435395e-102.08411886870791e-100.999999999895794
241.28638055784226e-112.57276111568452e-110.999999999987136
251.31242701928871e-122.62485403857742e-120.999999999998687
269.7874818907804e-141.95749637815608e-130.999999999999902
277.03301506835766e-151.40660301367153e-140.999999999999993
285.00242106693344e-161.00048421338669e-151
294.05395777031992e-178.10791554063984e-171
304.52501780906316e-189.05003561812632e-181
311.90904042905979e-183.81808085811959e-181
322.19960918995568e-194.39921837991137e-191
332.76567829207708e-205.53135658415417e-201
344.57596443666624e-219.15192887333249e-211
351.33891726382325e-212.6778345276465e-211
368.23991845632549e-221.64798369126510e-211
379.59646329539283e-221.91929265907857e-211
381.65864520190152e-223.31729040380303e-221
392.70303962986345e-235.4060792597269e-231
403.90707311348483e-247.81414622696966e-241
411.06546983322795e-242.13093966645590e-241
421.53972633725262e-253.07945267450524e-251
431.43311665075113e-252.86623330150225e-251
442.06171215882732e-264.12342431765465e-261
455.37940717330637e-271.07588143466127e-261
464.79289350038597e-279.58578700077195e-271
471.93496730183953e-263.86993460367906e-261
483.33130939550566e-246.66261879101131e-241
491.99361679206807e-093.98723358413615e-090.999999998006383
500.96861415088270.06277169823460150.0313858491173008
510.9915089205677880.01698215886442480.00849107943221239
520.9949996916125530.01000061677489370.00500030838744685
530.9965050829572630.006989834085474040.00349491704273702
540.9998838401363670.0002323197272650390.000116159863632519
550.999960439109977.91217800613651e-053.95608900306826e-05


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level360.923076923076923NOK
5% type I error level380.974358974358974NOK
10% type I error level391NOK