Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 116.597165706393 + 21.2164030996859X[t] -16.3844866073163M1[t] -11.5185960744808M2[t] -11.6965980755825M3[t] -7.19841447468412M4[t] -23.5563893078486M5[t] -7.31310291507592M6[t] -12.7531787022404M7[t] -12.8490423714049M8[t] + 0.915369317430634M9[t] -13.0923114136710M10[t] -6.41047327089834M11[t] -0.250898186835515t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)116.5971657063938.69286913.41300
X21.21640309968594.7756294.44265.5e-052.8e-05
M1-16.38448660731638.017077-2.04370.0467340.023367
M2-11.51859607448087.996703-1.44040.1565210.078261
M3-11.69659807558257.767435-1.50590.1389420.069471
M4-7.198414474684127.660879-0.93960.3523140.176157
M5-23.55638930784867.65157-3.07860.0035010.00175
M6-7.313102915075927.727571-0.94640.3489070.174454
M7-12.75317870224047.716701-1.65270.1052080.052604
M8-12.84904237140497.707049-1.66720.1022740.051137
M90.9153693174306347.6986190.11890.9058720.452936
M10-13.09231141367107.623575-1.71730.0926430.046321
M11-6.410473270898347.685441-0.83410.4085320.204266
t-0.2508981868355150.097482-2.57380.0133460.006673


Multiple Linear Regression - Regression Statistics
Multiple R0.745176801073555
R-squared0.555288464858216
Adjusted R-squared0.429609117970321
F-TEST (value)4.4182952776921
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value8.43903345039143e-05
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation12.0499880817301
Sum Squared Residuals6679.3017874125


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
110099.9617809122410.038219087758995
295.84395716104.576773258241-8.7328160982408
3105.5073942125.364276169990-19.8568819699895
4118.1540031129.611561584052-11.4575584840524
5101.8612953113.002688564052-11.1413932640523
6109.8419174128.995076769990-19.1531593699895
7105.6348802123.304102795990-17.6692225959895
8112.927078122.957340939990-10.0302629399895
9133.0698623136.470854441990-3.40099214198950
10125.6756757122.2122755240523.46340017594767
11146.736359128.64321547999018.0931435200105
12142.5803162134.8027905640527.77752563594764
13106.1448241118.167405769900-12.0225816699005
14126.5170831122.7823981159013.73468498409947
15132.7893932122.35349792796310.4358952720367
16121.2391637126.600783342026-5.36161964202617
17114.5079041109.9919103220264.51599377797383
18146.1499235125.98429852796320.1656249720367
19146.1244263120.29332455396325.8311017460367
20128.5058644119.9465626979638.55930170203665
21155.5838858133.46007619996322.1238096000366
22125.0382458119.2014972820265.83674851797382
23136.8944416125.63243723796311.2620043620366
24142.2233554131.79201232202610.4313430779738
25117.7715451115.1566275278742.61491757212569
26120.627231119.7716198738740.855611126125644
27127.7664457119.3427196859378.42372601406283
28135.1096379123.590005111.5196328
29105.7113717106.98113208-1.26976038000000
30117.9245283122.973520285937-5.04899198593717
31120.754717117.2825463119373.47217068806282
32107.572667116.935784455937-9.36311745593718
33130.4436512130.449297957937-0.00564675793717828
34107.2157063116.19071904-8.97501274000001
35105.0739419122.621658995937-17.5477170959372
36130.1121877128.781234081.33095361999999
37109.6379398112.145849285848-2.50790948584814
38116.7261601116.760841631848-0.0346815318481742
3997.1188169395.11553834422512.00327858577489
40140.8975013120.57922685797420.3182744420262
41108.2865885103.9703538379744.31623466202616
4297.6542580398.7463389442251-1.09208091422512
43112.0346762114.271768069911-2.23709186991100
44123.0494646113.9250062139119.12445838608899
45112.4171341127.438519715911-15.021385615911
46116.4966854113.1799407979743.31674460202618
47104.6914839119.610880753911-14.919396853911
48122.2335543125.770455837974-3.53690153797383
4999.7960224487.91866794413611.8773544958639
5096.7108618192.53366029013614.17720151986388
51112.3151453113.321163201885-1.00601790188483
52102.5497195117.568448615948-15.0187291159477
53104.5385008100.9595755959483.57892520405234
54122.0805711116.9519638018855.12860729811517
5580.6476287690.044586728199-9.39695796819894
5691.4074451889.6978248721991.70962030780106
5799.51555329103.211338374199-3.69578508419894
58106.527282110.169162555948-3.64188055594766
5998.4956654895.3836994121993.11196606780106
60106.7567568122.759677595948-16.0029207959476


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.6045528594629690.7908942810740620.395447140537031
180.6820955066164780.6358089867670440.317904493383522
190.7672621593614260.4654756812771480.232737840638574
200.677624931803060.6447501363938790.322375068196940
210.6637238935252960.6725522129494080.336276106474704
220.7386173536319460.5227652927361080.261382646368054
230.8888238482794420.2223523034411170.111176151720558
240.8948577162362570.2102845675274860.105142283763743
250.8522700794340660.2954598411318680.147729920565934
260.8132449665654680.3735100668690650.186755033434533
270.7756068395281130.4487863209437750.224393160471887
280.7070739978439510.5858520043120990.292926002156049
290.7146004133423650.570799173315270.285399586657635
300.7518159894392430.4963680211215150.248184010560757
310.7394620047629850.5210759904740290.260537995237015
320.7899180832662020.4201638334675950.210081916733798
330.790607364997410.4187852700051780.209392635002589
340.8095862448611730.3808275102776540.190413755138827
350.8970847601277890.2058304797444230.102915239872211
360.8518783210992080.2962433578015830.148121678900792
370.8160655960720080.3678688078559830.183934403927992
380.7308460787217460.5383078425565090.269153921278254
390.6292170366283410.7415659267433180.370782963371659
400.8877880097385380.2244239805229250.112211990261462
410.7966864135221340.4066271729557310.203313586477866
420.8067028047696190.3865943904607630.193297195230382
430.7692246584961670.4615506830076650.230775341503833


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