Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 62.0612446771867 + 11.2313886269777X[t] + 0.903839553931842Y1[t] + 0.138496282550783Y2[t] -0.0268436559582434Y3[t] -0.106380515370436Y4[t] -0.304423604736795M1[t] -8.57352205803797M2[t] -15.1525310336085M3[t] -10.9992974103655M4[t] -16.0366466935367M5[t] -3.40079273180213M6[t] + 46.5949436809979M7[t] + 7.48450705642377M8[t] -22.312510614135M9[t] -29.1933619104057M10[t] -19.6969423104956M11[t] -0.303391881932367t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)62.061244677186729.0901642.13340.0392380.019619
X11.23138862697774.1187962.72690.0095320.004766
Y10.9038395539318420.1538655.87421e-060
Y20.1384962825507830.2113390.65530.5161050.258052
Y3-0.02684365595824340.204305-0.13140.8961420.448071
Y4-0.1063805153704360.15215-0.69920.4885880.244294
M1-0.3044236047367955.151245-0.05910.9531770.476588
M2-8.573522058037976.08372-1.40930.1666840.083342
M3-15.15253103360856.209176-2.44030.0193190.009659
M4-10.99929741036555.5677-1.97560.0553120.027656
M5-16.03664669353675.11864-3.1330.0032780.001639
M6-3.400792731802135.061933-0.67180.5056480.252824
M746.59494368099795.514568.449400
M87.4845070564237711.600720.64520.5225910.261295
M9-22.31251061413512.101186-1.84380.0728160.036408
M10-29.193361910405711.412181-2.55810.0145240.007262
M11-19.69694231049565.519844-3.56840.0009710.000485
t-0.3033918819323670.132367-2.29210.0273840.013692


Multiple Linear Regression - Regression Statistics
Multiple R0.9916496435823
R-squared0.983369015616902
Adjusted R-squared0.97611961216786
F-TEST (value)135.648267133865
F-TEST (DF numerator)17
F-TEST (DF denominator)39
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.43186455317889
Sum Squared Residuals1613.38638358712


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1591599.892025902565-8.89202590256489
2589588.5117768161860.488223183814306
3584581.0493368259552.95066317404505
4573580.103982340967-7.10398234096754
5567564.6077340432582.39226595674198
6569570.340679001943-1.34067900194263
7621621.836907737762-0.836907737762074
8629631.030976205637-2.03097620563719
9628615.94768555754812.0523144424523
10612607.358941945254.64105805475053
11595596.205504470838-1.20550447083832
12597597.193641494743-0.193641494742516
13593596.574947323276-3.57494732327611
14590586.8225217346343.17747826536618
15580578.4293985345131.57060146548678
16574572.7199694819451.28003051805481
17573561.07728119709911.9227188029008
18573572.2625041333590.737495866641411
19620623.041219471129-3.04121947112932
20626626.7729767476-0.772976747600198
21620608.71131031395711.2886896860426
22588595.67335567743-7.67335567743049
23566569.951593816125-3.95159381612462
24557564.551571860089-7.55157186008916
25561554.2595622548036.74043774519735
26549552.050700515275-3.05070051527468
27532537.458174382567-5.45817438256663
28526525.1308383309280.869161669072479
29511511.909224848887-0.90922484888677
30499511.586024260142-12.5860242601420
31555550.3243806026134.67561939738731
32565560.9045496572764.09545034272385
33542549.516159069003-7.51615906900278
34527522.7018904266594.29810957334124
35510508.9261649166641.07383508333602
36514510.4305976234593.56940237654056
37517513.9331102420483.06688975795195
38508510.67817358066-2.67817358065981
39493497.777799722887-4.77779972288714
40490486.3175285829073.68247141709336
41469476.110275875259-7.11027587525868
42478470.4066979525477.59330204745259
43528527.0014152336660.998584766333523
44534534.908889287943-0.908889287943508
45518530.380117732715-12.3801177327152
46506507.265811950661-1.26581195066128
47502497.9167367963734.08326320362692
48516511.8241890217094.17581097829111
49528525.3403542773082.65964572269169
50533530.9368273532462.063172646754
51536530.2852905340785.71470946592194
52537535.7276812632531.27231873674689
53524530.295484035497-6.29548403549729
54536530.4040946520095.59590534799061
55587588.79607695483-1.79607695482944
56597597.382608101543-0.382608101542956
57581584.444727326777-3.44472732677695


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.2725494316154570.5450988632309140.727450568384543
220.471180997967070.942361995934140.52881900203293
230.4745966070270940.9491932140541880.525403392972906
240.4516105184212780.9032210368425560.548389481578722
250.5896890352905530.8206219294188930.410310964709447
260.49923970879810.99847941759620.5007602912019
270.4192931617931910.8385863235863810.580706838206809
280.5057533119208150.988493376158370.494246688079185
290.5317710303906870.9364579392186260.468228969609313
300.8531044448094170.2937911103811670.146895555190583
310.9205608257712620.1588783484574760.079439174228738
320.938080886289920.123838227420160.06191911371008
330.9270515127779790.1458969744440420.0729484872220211
340.922190853664220.1556182926715590.0778091463357793
350.8383455407821730.3233089184356540.161654459217827
360.7986237834455740.4027524331088530.201376216554426


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