Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 252.997616013072 -17.3371732026144X[t] + 12.3202303921566M1[t] -2.30092156862746M2[t] + 5.73164379084967M3[t] + 36.4988480392157M4[t] + 0.193256535947739M5[t] -11.2332565359477M6[t] + 11.2462826797386M7[t] + 5.85884803921567M8[t] + 13.2911830065359M9[t] + 77.7374656862745M10[t] + 0.846513071895421M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)252.99761601307227.8606259.080800
X-17.33717320261443.333326-5.20124e-062e-06
M112.320230392156610.4326191.18090.2435710.121785
M2-2.3009215686274610.461335-0.21990.8268660.413433
M35.7316437908496710.5333110.54410.5889140.294457
M436.498848039215710.4785273.48320.0010820.000541
M50.19325653594773910.4309140.01850.9852970.492648
M6-11.233256535947710.430914-1.07690.2870130.143506
M711.246282679738610.4360261.07760.2866940.143347
M85.8588480392156710.4785270.55910.5787280.289364
M913.291183006535910.5964131.25430.2159320.107966
M1077.737465686274510.6601837.292300
M110.84651307189542110.4315540.08110.9356680.467834


Multiple Linear Regression - Regression Statistics
Multiple R0.885262235683724
R-squared0.783689225927746
Adjusted R-squared0.728460943185894
F-TEST (value)14.18999807745
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value8.0138118363493e-12
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation16.4923870073344
Sum Squared Residuals12783.9449723856


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1104.1104.0821356209160.0178643790841724
290.299.8632875816993-9.6632875816993
399.2116.564439542484-17.3644395424836
4116.5145.597926470588-29.0979264705882
598.4105.824900326797-7.42490032679736
690.692.6646699346405-2.06466993464051
7130.5116.87792647058813.6220735294117
8107.4116.691643790850-9.29164379084967
9106125.857696078431-19.8576960784313
10196.5193.7714133986932.72858660130724
11107.8104.7444395424843.05556045751636
1290.5102.164209150327-11.6642091503267
13123.8114.4844395424839.31556045751657
14114.7103.33072222222211.3692777777778
15115.3113.0970049019612.20299509803925
16197142.13049183006554.8695081699347
1788.4102.357465686274-13.9574656862745
1893.890.9309526143792.86904738562093
19111.3115.144209150327-3.84420915032678
20105.9111.490491830065-5.59049183006532
21123.6122.3902614379081.20973856209155
22171192.037696078431-21.0376960784314
2397111.679308823529-14.6793088235294
2499.2112.566513071895-13.3665130718954
25126.6124.8867434640521.71325653594792
26103.4111.999308823529-8.59930882352942
27121.3121.765591503268-0.465591503267971
28129.6152.532795751634-22.932795751634
29110.8114.493486928105-3.69348692810458
3098.9103.066973856209-4.16697385620915
31122.8127.280230392157-4.48023039215686
32120.9120.1590784313730.740921568627468
33133.1132.7925653594770.307434640522879
34203.1205.907434640523-2.80743464052288
35110.2123.815330065359-13.6153300653595
36119.5126.436251633987-6.93625163398695
37135.1143.957633986928-8.85763398692795
38113.9129.336482026144-15.4364820261438
39137.4137.3690473856210.0309526143790445
40157.1164.668816993464-7.5688169934641
41126.4126.629508169935-0.229508169934665
42112.2118.670429738562-6.47042973856214
43128.8146.351120915033-17.5511209150327
44136.8147.898555555556-11.0985555555556
45156.5160.532042483660-4.03204248366019
46215.2218.043455882353-2.843455882353
47146.7120.34789542483726.3521045751634
48130.8116.03394771241814.7660522875817
49133.1135.289047385621-2.18904738562073
50153.4131.07019934640522.3298006535947
51159.9144.30391666666715.5960833333333
52174.6169.8699689542484.73003104575157
53145119.69463888888925.3053611111111
54112.9103.0669738562099.83302614379085
55137.8125.54651307189512.2534869281046
56150.6125.36023039215725.2397696078431
57162.1139.72743464052322.3725653594771
58226.4202.4423.96
59112.3113.413026143791-1.11302614379084
60126.3109.09907843137317.2009215686275


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.9971112999026970.005777400194605910.00288870009730295
170.9941387670303920.01172246593921670.00586123296960834
180.9860347336804140.02793053263917140.0139652663195857
190.9758759135367220.0482481729265560.024124086463278
200.95633645326050.08732709347900170.0436635467395008
210.9340487888469490.1319024223061020.065951211153051
220.944736871798160.1105262564036800.0552631282018399
230.9284266042081340.1431467915837320.0715733957918659
240.9158040048619580.1683919902760830.0841959951380417
250.8733327774547050.253334445090590.126667222545295
260.8385778430764290.3228443138471430.161422156923571
270.8048826899700420.3902346200599160.195117310029958
280.8727848352038340.2544303295923320.127215164796166
290.8704525160002650.2590949679994710.129547483999735
300.8252055723302240.3495888553395510.174794427669776
310.7632801015714420.4734397968571150.236719898428558
320.752422223023680.4951555539526390.247577776976319
330.7964662310852010.4070675378295970.203533768914799
340.782546554393610.4349068912127810.217453445606391
350.7542241496420980.4915517007158050.245775850357902
360.681675225659870.636649548680260.31832477434013
370.5814806950945370.8370386098109260.418519304905463
380.7648441375753930.4703117248492140.235155862424607
390.7974201327101720.4051597345796560.202579867289828
400.7860291006482420.4279417987035160.213970899351758
410.7626353934211140.4747292131577720.237364606578886
420.6406514876470360.7186970247059290.359348512352964
430.4982882622742470.9965765245484940.501711737725753
440.3636110943566320.7272221887132630.636388905643368


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level10.0344827586206897NOK
5% type I error level40.137931034482759NOK
10% type I error level50.172413793103448NOK