Multiple Linear Regression - Estimated Regression Equation
Y[t] = -8.2638347760359 -293.374157093177X[t] + 1.02469638380372Y1[t] -0.211002410605720Y2[t] + 0.316813468663976Y3[t] -0.0490383619885906Y4[t] -99.3752633320272M1[t] -2.92769282470823M2[t] -229.805644167399M3[t] + 73.407137286512M4[t] -312.343953515152M5[t] -434.547944602932M6[t] -401.501954448354M7[t] -270.918868937814M8[t] + 2.58702742390048M9[t] -299.756615294635M10[t] -158.836682680342M11[t] -20.2906549503601t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-8.2638347760359458.159706-0.0180.9856950.492847
X-293.374157093177402.161209-0.72950.4697490.234874
Y11.024696383803720.1519176.745100
Y2-0.2110024106057200.218097-0.96750.3388460.169423
Y30.3168134686639760.2512231.26110.2142380.107119
Y4-0.04903836198859060.196424-0.24970.8040710.402036
M1-99.3752633320272319.651277-0.31090.7574250.378712
M2-2.92769282470823323.522995-0.0090.9928230.496411
M3-229.805644167399316.481369-0.72610.4717880.235894
M473.407137286512316.181020.23220.8175350.408768
M5-312.343953515152313.758726-0.99550.3251990.162599
M6-434.547944602932318.304515-1.36520.179460.08973
M7-401.501954448354308.731621-1.30050.2005250.100262
M8-270.918868937814309.463729-0.87540.386310.193155
M92.58702742390048306.9753320.00840.9933160.496658
M10-299.756615294635296.032723-1.01260.3170590.15853
M11-158.836682680342293.554017-0.54110.591310.295655
t-20.290654950360116.467423-1.23220.2247390.11237


Multiple Linear Regression - Regression Statistics
Multiple R0.987348952648184
R-squared0.974857954295467
Adjusted R-squared0.964681411986489
F-TEST (value)95.7946151744927
F-TEST (DF numerator)17
F-TEST (DF denominator)42
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation449.915088892889
Sum Squared Residuals8501790.66296685


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
16802.966700.75768514592102.202314854076
27132.687274.53056299462-141.85056299462
37073.297276.99511397056-203.70511397056
47264.57570.83267050452-306.332670504523
57105.337455.48765278204-350.157652782038
67218.717074.56183178311144.148168216890
77225.727300.57278834085-74.8527883408454
87354.257334.3210622339319.9289377660697
97745.467761.48715011208-16.0271501120761
108070.267809.26507784895260.994922151053
118366.338220.5457641291145.784235870896
128667.518711.57776365675-44.0677636567545
138854.348921.77513556884-67.4351355688379
149218.19203.6976741790614.4023258209366
159332.99370.75013674324-37.8501367432404
169358.319738.97405771229-380.664057712288
179248.669440.82900052606-192.169000526059
189401.29199.146816396202.053183603996
199652.049393.76637859102258.273621408980
209957.389692.9226807336264.457319266406
2110110.6310259.7946542013-149.164654201287
2210169.2610101.756780037967.503219962108
2310343.7810334.56292905969.21707094044965
2410750.2110673.146188980377.0638110196967
2511337.510944.1831259614393.316874038635
2611786.9611588.7914384078198.168561592226
2712083.0411798.4675861894284.572413810645
2812007.7412456.0753950873-448.335395087311
2911745.9312023.9956599162-278.065659916154
3011051.5111700.8750847756-649.365084775614
3111445.911018.9279658516426.972034148441
3211924.8811600.6223516197324.257648380264
3312247.6312054.2665508692193.363449130801
3412690.9112120.2883596795570.621640320473
3512910.712759.4510979690151.248902031035
3613202.1213108.445147707993.6748522921336
3713654.6713365.6299728241289.040027175923
3813862.8213891.9176215480-29.0976215480415
3913523.9313844.0980660807-320.168066080698
4014211.1713864.9238591026346.246140897404
4114510.3514278.3534758705231.996524129522
4214289.2314179.8459458306109.384054169398
4314111.8214137.2382141421-25.4182141420642
4413086.5914173.4792419466-1086.88924194661
4513351.5413328.853856125722.6861438742812
4613747.6913448.6763518982299.013648101837
4712855.6113603.2272366380-747.61723663798
4812926.9312878.288837727048.6411622730297
4912121.9512839.0740804998-717.124080499796
5011731.6511773.2727028705-41.6227028705009
5111639.5111362.3590970161277.150902983853
5212163.7811374.6940175933789.085982406717
5312029.5311441.1342109053588.39578909473
5411234.1811040.4003212147193.779678785330
559852.1310437.1046530745-584.974653074511
569709.049230.79466346613478.245336533875
579332.759383.60778869172-50.8577886917192
587108.68306.73343053547-1198.13343053547
596691.496250.1229722044441.3670277956
606143.056318.3620619281-175.312061928106


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.02655528780038750.05311057560077500.973444712199612
220.009086186613488830.01817237322697770.990913813386511
230.002932079078774540.005864158157549080.997067920921225
240.0006587985841906080.001317597168381220.99934120141581
250.0001622363507420730.0003244727014841460.999837763649258
263.60728114571536e-057.21456229143072e-050.999963927188543
275.74045473760715e-050.0001148090947521430.999942595452624
282.44794183670405e-054.89588367340811e-050.999975520581633
291.13724702369786e-052.27449404739573e-050.999988627529763
300.0006483215269029010.001296643053805800.999351678473097
310.0002960903574757580.0005921807149515170.999703909642524
320.0001116665022994380.0002233330045988770.9998883334977
336.97681770834204e-050.0001395363541668410.999930231822917
342.29928147778418e-054.59856295556837e-050.999977007185222
355.75027431962601e-061.15005486392520e-050.99999424972568
361.3024290361657e-062.6048580723314e-060.999998697570964
377.3079956699905e-061.4615991339981e-050.99999269200433
386.57844337229648e-061.31568867445930e-050.999993421556628
395.19287966714735e-050.0001038575933429470.999948071203329


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level170.894736842105263NOK
5% type I error level180.947368421052632NOK
10% type I error level191NOK