Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 36.0412849947343 -1.07737500078825X[t] + 0.346066086990625Y1[t] + 0.308973906895185Y2[t] + 0.239167122050576Y3[t] + 0.549191143048674M1[t] -20.4478997908501M2[t] -35.6144987271497M3[t] -35.2010923362867M4[t] -21.6096098638476M5[t] -8.96826790774917M6[t] -16.9676387368805M7[t] -21.7652635983034M8[t] -5.96576558472508M9[t] -44.2213929649418M10[t] -30.1782647969586M11[t] -0.097245795559272t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)36.041284994734310.589283.40360.001450.000725
X-1.077375000788252.990699-0.36020.720430.360215
Y10.3460660869906250.147222.35070.0233950.011698
Y20.3089739068951850.1475922.09340.0422450.021122
Y30.2391671220505760.1431921.67030.1021330.051067
M10.5491911430486749.212530.05960.952740.47637
M2-20.44789979085019.710246-2.10580.0410980.020549
M3-35.61449872714976.993079-5.09287e-064e-06
M4-35.20109233628675.966444-5.89981e-060
M5-21.60960986384765.739037-3.76545e-040.00025
M6-8.968267907749176.305878-1.42220.162180.08109
M7-16.96763873688057.694286-2.20520.0328350.016417
M8-21.76526359830347.564488-2.87730.0062210.003111
M9-5.965765584725086.261504-0.95280.3460330.173016
M10-44.22139296494187.385429-5.987700
M11-30.17826479695868.339904-3.61850.0007750.000387
t-0.0972457955592720.084068-1.15670.2537630.126881


Multiple Linear Regression - Regression Statistics
Multiple R0.936965555361769
R-squared0.877904451934389
Adjusted R-squared0.83247355032858
F-TEST (value)19.3239495784548
F-TEST (DF numerator)16
F-TEST (DF denominator)43
p-value1.32116539930394e-14
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation7.76399012700786
Sum Squared Residuals2592.02033576785


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1112.3125.016844688237-12.7168446882366
2117.3112.5478594836364.75214051636404
3111.1102.3793823327768.72061766722434
4102.2100.9228838251661.27711617483445
5104.3110.617329715332-6.31732971533162
6122.9120.7328357312592.16716426874133
7107.6117.593306142823-9.9933061428234
8121.3113.6527899794417.64721002055865
9131.5133.817355283876-2.31735528387632
108999.5680417524949-10.5680417524949
11104.4105.234238850241-0.834238850241086
12128.9129.952789193167-1.05278919316651
13135.9133.4769491509632.42305084903736
14133.3126.0581094289507.24189057105015
15121.3117.9169047094213.38309529057920
16120.5114.9511099572645.54889004273647
17120.4123.838972364477-3.43897236447719
18137.9133.2312773261944.66872267380579
19126.1130.968586135510-4.86858613550955
20133.2127.3732623104995.82673768950126
21151.1146.0721162806735.02788371932692
22105113.285368760788-8.28536876078828
23119118.5063240229270.493675977072679
24140.4143.469662619033-3.06966261903265
25156.6143.55007759733413.0499224026658
26137.1138.022392793389-0.922392793389313
27122.7126.133813068798-3.4338130687976
28125.8119.3161382041996.4838617958005
29139.3124.77019661147314.5298033885266
30134.9139.499997500233-4.59999750023276
31149.2134.79325591422514.4067440857748
32132.3136.716401258553-4.41640125855294
33149149.936128138009-0.936128138009019
34117.2115.5609894337711.63901056622894
35119.6119.619910122388-0.0199101223879989
36152144.7002084315437.29979156845746
37149.4149.500717892868-0.100717892868304
38127.3138.09136501356-10.7913650135600
39114.1122.125142355720-8.02514235571955
40102.1110.423072743032-8.32307274303189
41107.7110.40046740769-2.70046740769009
42104.4118.017840761567-13.6178407615669
43102.1107.639454463813-5.53945446381335
4496102.268353797482-6.26835379748189
45109.3114.359711396232-5.05971139623226
469078.174691964654611.8253080353454
4783.988.091932375357-4.19193237535695
48112113.279674566309-1.27967456630904
49114.3116.955410670598-2.65541067059826
50103.6103.880273280465-0.280273280464863
5191.792.3447575332864-0.644757533286418
5280.885.7867952703395-4.98679527033952
5387.289.2730339010277-2.0730339010277
54109.297.818048680747511.3819513192525
55102.796.70539734362855.9946026563715
5695.197.889192654025-2.78919265402508
57117.5114.2146889012093.28531109879068
5885.179.71090808829115.38909191170884
5992.187.54759462908664.55240537091336
60113.5115.397665189949-1.89766518994922


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
200.01900270952325910.03800541904651810.98099729047674
210.006158854359268840.01231770871853770.993841145640731
220.001550487300261500.003100974600522990.998449512699739
230.0002936208132473820.0005872416264947640.999706379186753
240.0003660514622552770.0007321029245105550.999633948537745
259.60663313403503e-050.0001921326626807010.99990393366866
260.0006931192757236650.001386238551447330.999306880724276
270.02853937530390880.05707875060781750.97146062469609
280.09653451418013750.1930690283602750.903465485819863
290.1090355179101720.2180710358203450.890964482089828
300.1457163968466310.2914327936932620.854283603153369
310.3726082773956240.7452165547912480.627391722604376
320.288487684939920.576975369879840.71151231506008
330.2931174773437830.5862349546875660.706882522656217
340.2040931359386710.4081862718773420.795906864061329
350.1581167125266630.3162334250533260.841883287473337
360.2598746004695560.5197492009391110.740125399530444
370.3437804629842370.6875609259684740.656219537015763
380.4612945751054820.9225891502109650.538705424894518
390.4425424514065790.8850849028131570.557457548593421
400.3866125355375600.7732250710751210.61338746446244


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