Multiple Linear Regression - Estimated Regression Equation
Y[t] = -37.2940689141077 + 0.73903374269513X[t] + 0.15933358934725Y1[t] + 0.234922754766544Y2[t] + 25.8124488053722M1[t] + 18.8216956913314M2[t] + 10.7186918552078M3[t] + 22.8169458116256M4[t] + 10.4075301409941M5[t] + 18.6651780109597M6[t] + 26.9840623171739M7[t] + 14.8732723526244M8[t] + 12.0424536035340M9[t] + 29.6388908477154M10[t] -5.40627929365437M11[t] -0.111511471449605t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-37.29406891410777.498728-4.97341.2e-056e-06
X0.739033742695130.0751029.840400
Y10.159333589347250.0751922.1190.0400450.020022
Y20.2349227547665440.0883722.65830.0110620.005531
M125.81244880537225.4390574.74582.4e-051.2e-05
M218.82169569133146.6319152.8380.0069620.003481
M310.71869185520784.0424112.65160.0112540.005627
M422.81694581162563.7286296.119400
M510.40753014099414.2597192.44320.0188410.00942
M618.66517801095973.8899514.79832e-051e-05
M726.98406231717395.3303715.06239e-064e-06
M814.87327235262445.0692712.9340.0054020.002701
M912.04245360353403.4505273.490.0011490.000574
M1029.63889084771544.7125456.289400
M11-5.406279293654375.118222-1.05630.2968780.148439
t-0.1115114714496050.038-2.93450.0053950.002697


Multiple Linear Regression - Regression Statistics
Multiple R0.97835470633545
R-squared0.957177931408722
Adjusted R-squared0.941884335483265
F-TEST (value)62.5868458977316
F-TEST (DF numerator)15
F-TEST (DF denominator)42
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.06605318956999
Sum Squared Residuals694.377118697318


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1113.6111.3876179778082.21238202219182
2112.9110.1868308428542.71316915714603
3104106.657054276905-2.65705427690547
4109.9113.403064862006-3.50306486200567
59996.08795702816412.91204297183586
6106.3106.906049563541-0.606049563540803
7128.9126.6785514204582.22144857954247
8111.1113.216895915796-2.11689591579626
9102.9109.540275619302-6.6402756193022
10130128.5578614801461.44213851985418
118783.90909096701363.09090903298642
1287.583.02097094528054.4790290547195
13117.6119.422402764087-1.82240276408679
14103.4109.806251481246-6.40625148124578
15110.8113.258607255625-2.45860725562543
16112.6117.730520549539-5.13052054953865
17102.5104.581691117279-2.08169111727950
18112.4112.753434559988-0.353434559988104
19135.6137.104143488721-1.50414348872073
20105.1110.987157232133-5.88715723213283
21127.7120.2234095325457.47659046745484
22137135.9547630737481.04523692625173
239196.259750824066-5.25975082406591
2490.589.21176650177551.28823349822453
25122.4120.8691693177851.53083068221457
26123.3121.1192638439942.1807361560057
27124.3120.6973817298523.60261827014765
28120119.6857678781030.314232121897236
29118.1114.7848775268263.31512247317414
30119119.837040940191-0.83704094019072
31142.7141.9087376187770.791262381223005
32123.6119.6102606061093.98973939389073
33129.6125.4593342550594.14066574494139
34151.6144.6234248338346.97657516616645
35110.4108.2402483134562.15975168654358
3699.2102.413088805551-3.21308880555058
37130.5127.2558066500783.24419334992250
38136.2134.4892855268591.71071447314124
39129.7126.9018353407172.79816465928299
40128124.9655696502163.03443034978389
41121.6126.099973060017-4.49997306001733
42135.8134.1424858656051.65751413439484
43143.8144.187879302930-0.387879302929657
44147.5144.6316174947702.86838250522960
45136.2135.9475387116050.252461288395305
46156.6165.545154675918-8.94515467591782
47123.3123.2909098954640.00909010453591619
48104.5107.054173747393-2.55417374739345
49139.8144.965003290242-5.16500329024210
50136.5136.698368305047-0.198368305047200
51112.1113.385121396900-1.28512139689974
52118.5113.2150770601375.28492293986319
5394.494.04550126771320.354498732286814
54102.3102.1609890706750.139010929324792
55111.4112.520688169115-1.12068816911509
5699.298.05406875119121.14593124880876
5787.893.0294418814893-5.22944188148933
58115.8116.318795936355-0.518795936354544


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.1195946199447990.2391892398895980.880405380055201
200.1730436417027310.3460872834054610.82695635829727
210.7164517433445770.5670965133108460.283548256655423
220.7139729015127120.5720541969745760.286027098487288
230.7532405162702240.4935189674595510.246759483729776
240.6464945009815020.7070109980369970.353505499018498
250.6426185439352890.7147629121294220.357381456064711
260.5970153039846370.8059693920307260.402984696015363
270.66968919847020.66062160305960.3303108015298
280.8462185856599940.3075628286800130.153781414340006
290.7860719178420320.4278561643159350.213928082157968
300.8135223711078440.3729552577843120.186477628892156
310.7273207977871650.545358404425670.272679202212835
320.7934810370019640.4130379259960730.206518962998036
330.8256172330661760.3487655338676480.174382766933824
340.8380069281672710.3239861436654580.161993071832729
350.7465447983726330.5069104032547350.253455201627367
360.6911527981546310.6176944036907380.308847201845369
370.651102394331120.697795211337760.34889760566888
380.6469606542166480.7060786915667040.353039345783352
390.5384009542967480.9231980914065040.461599045703252


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