Multiple Linear Regression - Estimated Regression Equation
X_2t[t] = + 31.3471573638543 + 0.444702753166022X_1t[t] -0.362675102423084X_3t[t] -0.262539402740327X_4t[t] -0.207318027182089X_5t[t] -0.274389035067997X_6t[t] -0.327297113875413X_7t[t] -0.209605852221708X_8t[t] + 0.0459801204750859X_9t[t] + 0.887743425105732X_10t[t] -0.000478451727605654X_11t[t] -0.241762602800191X_12t[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)31.34715736385439.236363.39390.0011380.000569
X_1t0.4447027531660220.0534598.318500
X_3t-0.3626751024230840.058971-6.150100
X_4t-0.2625394027403270.059547-4.40893.7e-051.8e-05
X_5t-0.2073180271820890.056577-3.66440.0004780.000239
X_6t-0.2743890350679970.079743-3.44090.0009820.000491
X_7t-0.3272971138754130.136247-2.40220.0189520.009476
X_8t-0.2096058522217080.269963-0.77640.4401150.220057
X_9t0.04598012047508590.2977670.15440.8777260.438863
X_10t0.8877434251057320.3122652.84290.0058540.002927
X_11t-0.0004784517276056540.066048-0.00720.9942410.49712
X_12t-0.2417626028001910.158891-1.52160.1326240.066312


Multiple Linear Regression - Regression Statistics
Multiple R0.957117519497325
R-squared0.916073946128713
Adjusted R-squared0.902885566234654
F-TEST (value)69.460688385338
F-TEST (DF numerator)11
F-TEST (DF denominator)70
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3.0240654350445
Sum Squared Residuals640.148022880163


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1-3-4.948080824862691.94808082486269
2-4-2.14131446342658-1.85868553657342
3-7-6.51154590698915-0.488454093010852
4-7-4.20445493251037-2.79554506748963
5-7-4.77415776825536-2.22584223174464
6-3-2.18641994553898-0.813580054461025
70-1.785002514532881.78500251453288
8-5-1.86842044012433-3.13157955987567
9-3-3.074347839297240.0743478392972435
1030.5645050954734012.4354949045266
112-0.6321293835925982.6321293835926
12-7-11.16633881956514.16633881956507
13-11.69080317608383-2.69080317608383
1401.94923548223378-1.94923548223378
15-3-0.948930336808768-2.05106966319123
1647.10114994268736-3.10114994268736
1722.58329321015519-0.583293210155192
1831.216724995316021.78327500468398
190-3.042778546509543.04277854650954
20-10-7.42122418583962-2.57877581416038
21-10-8.49030488148799-1.50969511851201
22-9-7.54308200443584-1.45691799556416
23-22-18.1955557988583-3.80444420114172
24-16-16.8238278019670.823827801967045
25-18-21.3775528464663.37755284646597
26-14-14.25830255654950.258302556549502
27-12-16.14764545194594.14764545194594
28-17-18.55711694425321.55711694425317
29-23-20.6407854145687-2.35921458543134
30-28-24.2630396191683-3.73696038083171
31-31-28.0235085879537-2.97649141204635
32-21-21.10205923830680.102059238306841
33-19-17.4096709779125-1.59032902208746
34-22-25.00197514079293.0019751407929
35-22-23.85708985032631.85708985032628
36-25-22.0598870066226-2.94011299337739
37-16-18.44567096446922.44567096446921
38-22-17.8341257308486-4.16587426915142
39-21-16.7685618316674-4.23143816833263
40-10-11.03067034213971.0306703421397
41-7-6.4366553049305-0.563344695069504
42-5-8.407805071086953.40780507108696
43-4-5.614794602376211.61479460237621
4472.145913408503894.85408659149611
4561.429939119348044.57006088065196
4632.629808788949980.370191211050021
47107.872586947469232.12741305253077
4805.80434527654845-5.80434527654845
49-2-0.288555804068115-1.71144419593188
50-11.20563724070957-2.20563724070957
5120.9001083282061551.09989167179384
5286.08435902035221.9156409796478
53-6-4.3397445194819-1.6602554805181
54-4-1.01767324966563-2.98232675033437
5544.81947387797566-0.819473877975659
5673.393245630895693.60675436910431
5732.096957997214040.903042002785955
583-0.08091675718073613.08091675718074
5983.014237658243754.98576234175625
6030.5513004289544822.44869957104552
61-3-2.56320995451276-0.436790045487237
6243.36304972945520.6369502705448
63-5-8.213138547015623.21313854701562
64-11.21843408563981-2.21843408563981
6555.34078981836698-0.340789818366985
660-2.705016671474662.70501667147466
67-6-3.85489205975439-2.14510794024561
68-13-9.50176898800993-3.49823101199007
69-15-9.3952163369065-5.6047836630935
70-8-7.28536732264578-0.714632677354223
71-20-20.48962068631580.489620686315809
72-10-19.33642144412019.33642144412008
73-22-23.23990157421881.23990157421877
74-25-24.4844514739612-0.515548526038803
75-10-11.83868810136321.83868810136319
76-8-11.84174625378513.84174625378515
77-9-6.64717552975094-2.35282447024906
78-5-2.76587485556428-2.23412514443572
79-7-3.20421652514465-3.79578347485535
80-11-9.4522647182309-1.5477352817691
81-11-9.42543491839396-1.57456508160604
82-16-17.00976909023061.0097690902306


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
150.07411431615227090.1482286323045420.925885683847729
160.02536208276093270.05072416552186540.974637917239067
170.008773900770656630.01754780154131330.991226099229343
180.02540408715178310.05080817430356620.974595912848217
190.05535210261350380.1107042052270080.944647897386496
200.10005045801980.2001009160395990.8999495419802
210.05861570845728170.1172314169145630.941384291542718
220.03360300935835970.06720601871671940.96639699064164
230.02111454341707260.04222908683414520.978885456582927
240.01643071254088220.03286142508176440.983569287459118
250.02806333137487810.05612666274975620.971936668625122
260.01558909592475630.03117819184951270.984410904075244
270.01334874259238540.02669748518477090.986651257407615
280.009296013188278760.01859202637655750.990703986811721
290.01613996660029630.03227993320059250.983860033399704
300.01007450917346420.02014901834692830.989925490826536
310.007815615022830060.01563123004566010.99218438497717
320.004700378484466640.009400756968933270.995299621515533
330.01166318830007580.02332637660015150.988336811699924
340.01170531806747450.0234106361349490.988294681932525
350.0092407040585130.0184814081170260.990759295941487
360.007749412787456220.01549882557491240.992250587212544
370.007246685001114860.01449337000222970.992753314998885
380.005410781940706770.01082156388141350.994589218059293
390.005704008205154420.01140801641030880.994295991794846
400.03252940268012240.06505880536024470.967470597319878
410.02971386264151490.05942772528302980.970286137358485
420.04058839074683610.08117678149367210.959411609253164
430.03482045359859920.06964090719719840.965179546401401
440.07474391143897060.1494878228779410.925256088561029
450.09301864802941680.1860372960588340.906981351970583
460.07443044301069780.1488608860213960.925569556989302
470.09385995574456320.1877199114891260.906140044255437
480.1399536625810180.2799073251620360.860046337418982
490.1073206659215140.2146413318430280.892679334078486
500.08626952436685770.1725390487337150.913730475633142
510.1009007663948630.2018015327897270.899099233605137
520.09497516430162680.1899503286032540.905024835698373
530.06693115093946320.1338623018789260.933068849060537
540.05422099663559150.1084419932711830.945779003364408
550.03553661767557160.07107323535114320.964463382324428
560.06452257541498180.1290451508299640.935477424585018
570.07815322946276250.1563064589255250.921846770537238
580.1216775614360780.2433551228721560.878322438563922
590.3148139566615770.6296279133231530.685186043338423
600.4563504022707690.9127008045415380.543649597729231
610.4974880195793180.9949760391586360.502511980420682
620.3941762704787480.7883525409574970.605823729521252
630.3966888381181270.7933776762362550.603311161881873
640.3187588451359750.637517690271950.681241154864025
650.2197087954918740.4394175909837480.780291204508126
660.1449922133042090.2899844266084170.855007786695791
670.08688470895951740.1737694179190350.913115291040483


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level10.0188679245283019NOK
5% type I error level170.320754716981132NOK
10% type I error level260.490566037735849NOK