Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 129.718988349067 + 0.0136271957734372X[t] + 1.19580953439251Y1[t] -0.238594808848829Y2[t] + 0.196588623192844Y3[t] -0.145134629903214Y4[t] + 0.185141696854423Y5[t] -0.287136374322501Y6[t] -0.0474422047632084Y7[t] + 0.214776602993101Y8[t] -0.136153330812813Y9[t] -97.833027155869M1[t] -45.5330062332913M2[t] -21.5011093797021M3[t] -32.1109665268857M4[t] -35.3444354143223M5[t] -68.1801106941438M6[t] + 91.203578826176M7[t] -75.5180147630598M8[t] -152.121790143776M9[t] -78.3595862713242M10[t] + 2.82383943069867M11[t] -3.29251587550166t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)129.718988349067320.6802860.40450.6881650.344083
X0.01362719577343720.0276980.4920.6256320.312816
Y11.195809534392510.1631697.328700
Y2-0.2385948088488290.254168-0.93870.3539570.176979
Y30.1965886231928440.2580080.76190.4509210.22546
Y4-0.1451346299032140.254971-0.56920.5726460.286323
Y50.1851416968544230.2508310.73810.4651010.232551
Y6-0.2871363743225010.252906-1.13530.263530.131765
Y7-0.04744220476320840.256306-0.18510.8541620.427081
Y80.2147766029931010.2583880.83120.4111830.205591
Y9-0.1361533308128130.187124-0.72760.4714310.235715
M1-97.833027155869124.418642-0.78630.4366870.218343
M2-45.5330062332913128.719832-0.35370.7255440.362772
M3-21.5011093797021127.642071-0.16840.8671480.433574
M4-32.1109665268857130.136862-0.24670.8064670.403234
M5-35.3444354143223127.303352-0.27760.7828350.391417
M6-68.1801106941438127.352612-0.53540.5956010.297801
M791.203578826176123.3837210.73920.4644580.232229
M8-75.5180147630598119.309677-0.6330.5306540.265327
M9-152.121790143776122.893405-1.23780.2235750.111787
M10-78.3595862713242126.196005-0.62090.5384490.269224
M112.82383943069867121.0913530.02330.981520.49076
t-3.292515875501666.159006-0.53460.5961350.298067


Multiple Linear Regression - Regression Statistics
Multiple R0.985935806623163
R-squared0.972069414781667
Adjusted R-squared0.955462039786983
F-TEST (value)58.5323938968557
F-TEST (DF numerator)22
F-TEST (DF denominator)37
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation179.230088334974
Sum Squared Residuals1188566.70888882


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
12756.762694.9972408116461.7627591883607
22849.272854.36269349885-5.09269349885296
32921.442984.53477025541-63.094770255414
42981.853022.15013511431-40.3001351143129
53080.583106.32647221096-25.7464722109604
63106.223143.7939178847-37.5739178846978
73119.313298.95101900772-179.641019007723
83061.263164.47722173451-103.217221734515
93097.312992.47239411682104.837605883177
103161.693122.4332460682139.2567539317895
113257.163238.8249584951818.3350415048225
123277.013348.8623081975-71.8523081974984
133295.323259.6042011713235.7157988286754
143363.993360.624320109853.36567989014842
153494.173462.7752896911331.3947103088707
163667.033577.3807540174289.649245982579
173813.063745.5854562998767.4745437001274
183917.963875.792147071842.1678529282009
193895.514170.2552809412-274.745280941203
203801.063920.92953489374-119.869534893738
213570.123737.48905010517-167.369050105171
223701.613515.30195230011186.308047699893
233862.273768.5550772003393.7149227996692
243970.13867.19548366755102.904516332445
254138.523917.31679772707221.203202272926
264199.754137.8969932197861.8530067802159
274290.894269.3185806288121.5714193711878
284443.914363.4486287993380.4613712006736
294502.644430.8835100844971.7564899155094
304356.984493.099148005-136.119148005004
314591.274449.1259214508142.1440785492
324696.964572.90360947257124.056390527433
334621.44545.4587070893975.941292910611
344562.844521.5995292048841.2404707951171
354202.524504.70165455865-302.181654558650
364296.494162.45531168665134.034688313352
374435.234219.15759654057216.072403459430
384105.184255.25033673187-150.070336731873
394116.684017.4417902386299.2382097613795
403844.494064.4403117008-219.950311700802
413720.983737.13634150576-16.1563415057587
423674.43661.1606001374513.2393998625486
433857.623559.07598778486298.544012215144
443801.063793.371705593687.68829440631748
453504.373600.58445965303-96.2144596530258
463032.63322.53367218556-289.933672185561
473047.032962.0219243196885.0080756803184
482962.343044.55733776145-82.2173377614527
492197.822732.57416374939-534.754163749392
502014.451924.5056564396489.9443435603621
511862.831951.93956918602-89.1095691860238
521905.411815.2701703681490.139829631862
531810.991908.31821989892-97.3282198989177
541670.071551.78418690105118.285813098952
551864.441850.7417908154213.6982091845815
562052.021960.6779283055091.3420716945026
572029.61946.7953890355982.804610964409
582070.832047.7016002412423.1283997587616
592293.412188.28638542616105.12361457384
602443.272526.13955868685-82.8695586868457


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
260.07250813830755980.1450162766151200.92749186169244
270.02115066867090990.04230133734181980.97884933132909
280.01102152658476320.02204305316952650.988978473415237
290.0102701724457030.0205403448914060.989729827554297
300.004219122526194490.008438245052388990.995780877473806
310.007030125799148030.01406025159829610.992969874200852
320.009504115939539770.01900823187907950.99049588406046
330.00347668807951370.00695337615902740.996523311920486
340.004119769332833980.008239538665667960.995880230667166


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