Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 176.905248685416 + 3.04049881808095X[t] + 5.55389550870783M1[t] + 17.0753919629505M2[t] + 24.7482898354962M3[t] + 29.669786289739M4[t] + 35.4641806165276M5[t] + 38.9775773071543M6[t] + 47.2367697428724M7[t] + 45.180071397559M8[t] + 1.51650827343334M9[t] -8.72648463505236M10[t] -13.8292874716581M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)176.90524868541611.53630415.334700
X3.040498818080950.08724634.849600
M15.553895508707835.0354621.1030.2756620.137831
M217.07539196295055.059443.3750.0014880.000744
M324.74828983549625.080254.87151.3e-056e-06
M429.6697862897395.1254485.78871e-060
M535.46418061652765.2242956.788300
M638.97757730715435.2964157.359200
M747.23676974287245.4985918.590700
M845.1800713975595.4501198.289700
M91.516508273433345.0615160.29960.7657920.382896
M10-8.726484635052365.150959-1.69410.0968550.048427
M11-13.82928747165815.108937-2.70690.0094380.004719


Multiple Linear Regression - Regression Statistics
Multiple R0.985073814323171
R-squared0.970370419665202
Adjusted R-squared0.962805420430785
F-TEST (value)128.271053254117
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation7.94448891931475
Sum Squared Residuals2966.40049688840


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1594605.088479907375-11.0884799073753
2595604.447981089295-9.4479810892953
3591596.918384871436-5.91838487143616
4589592.718384871436-3.71838487143619
5584583.310285107820.689714892180035
6573571.6211877080421.37881229195811
7567564.6778860533552.32211394664476
8569565.6616865261233.33831347387716
9621631.456080852911-10.4560808529114
10629645.537078489073-16.5370784890733
11628640.434275652468-12.4342756524676
12612623.858574943316-11.8585749433162
13595599.007482271214-4.00748227121449
14597595.3264846350521.67351536494766
15593581.71589078103111.2841092189686
16590580.5563895991129.44361040088764
17580568.10779101741511.8922089825848
18574562.49969125379911.5003087462010
19573561.63738723527411.3626127647257
20573562.62118770804210.3788122919581
21620616.2535867625073.74641323749335
22626624.2535867625071.74641323749335
23620616.110285107823.88971489218002
24588584.3320903082643.6679096917362
25566556.4404988180819.55950118191883
26557546.67850354575710.3214964542429
27561557.3919002363843.60809976361619
28549544.0704037821414.92959621785904
29532531.6218052004440.378194799556179
30526526.013705436828-0.0137054368276273
31511512.989406145979-1.98940614597905
32499504.851710164504-5.85171016450381
33555555.443610400888-0.443610400887622
34565563.4436104008881.55638959911237
35542540.0978146557961.90218534420379
36527526.5626127647260.43738723527428
37510504.7520189107055.247981089295
38514513.2330165468670.766983453133338
39517520.905914419412-3.9059144194124
40508513.665415601331-5.66541560133144
41493501.216817019634-8.2168170196343
42490498.649216074099-8.64921607409907
43469479.543919147089-10.5439191470886
44478486.608717256018-8.6087172560181
45528531.11961985624-3.11961985624001
46534533.0386222200780.961377779921877
47518518.81432292923-0.814322929229542
48506508.31961985624-2.31961985624002
49502501.7115200926240.288479907375944
50516519.314014183029-3.31401418302857
51528533.067909691736-5.0679096917362
52533537.989406145979-4.98940614597904
53536540.743301654687-4.74330165468667
54537541.216199527232-4.21619952723238
55524525.151401418303-1.15140141830285
56536535.2566983453130.743301654686659
57587576.72710212745410.2728978725457
58597584.72710212745412.2728978725457
59581573.5433016546877.45669834531333
60564553.92710212745410.0728978725457


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.0008606974095109950.001721394819021990.99913930259049
170.03605285310486040.07210570620972090.96394714689514
180.01584058631071760.03168117262143530.984159413689282
190.05348527825213010.1069705565042600.94651472174787
200.05774616666128510.1154923333225700.942253833338715
210.03472210193322660.06944420386645320.965277898066773
220.04923817269622480.09847634539244970.950761827303775
230.1657108133033240.3314216266066480.834289186696676
240.8694870356717140.2610259286565720.130512964328286
250.9538015748006540.09239685039869230.0461984251993462
260.98836105555230.02327788889539790.0116389444476989
270.9948722686282260.01025546274354840.00512773137177421
280.9990834475552120.001833104889576130.000916552444788067
290.99988979388360.0002204122328014280.000110206116400714
300.999969358225586.12835488412234e-053.06417744206117e-05
310.9999778400339394.43199321225238e-052.21599660612619e-05
320.9999802759446663.94481106685859e-051.97240553342929e-05
330.9999678898469786.42203060430797e-053.21101530215398e-05
340.9999762341628664.75316742689485e-052.37658371344742e-05
350.9999162321557370.0001675356885254628.37678442627312e-05
360.999790541901540.0004189161969196730.000209458098459837
370.9996341981418870.0007316037162269910.000365801858113495
380.99956838731760.0008632253647994760.000431612682399738
390.9992304126673150.001539174665370520.00076958733268526
400.998853110598750.002293778802500470.00114688940125023
410.9986205517147810.002758896570438080.00137944828521904
420.99850152289220.002996954215597410.00149847710779870
430.9938473177494440.01230536450111170.00615268225055586
440.975878684702410.04824263059518160.0241213152975908


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level160.551724137931034NOK
5% type I error level210.724137931034483NOK
10% type I error level250.862068965517241NOK