Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 218.876252554515 -5.76855040693692X[t] + 72.7832532666989M1[t] + 87.6197783160123M2[t] + 64.8766418472774M3[t] + 44.7775949908746M4[t] + 20.7449417198273M5[t] + 55.9833505094106M6[t] + 47.7881528843493M7[t] + 25.6494118095783M8[t] + 17.0532314389814M9[t] -8.40513845351738M10[t] + 3.01280616186310M11[t] -0.540019448542279t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)218.87625255451528.6189037.64800
X-5.768550406936921.185888-4.86435e-062e-06
M172.783253266698934.7361432.09530.038890.019445
M287.619778316012334.7503632.52140.0134090.006705
M364.876641847277434.669351.87130.0644820.032241
M444.777594990874634.7608251.28820.200920.10046
M520.744941719827334.651180.59870.5508580.275429
M655.983350509410634.7648241.61030.1107490.055374
M747.788152884349334.6728691.37830.1714660.085733
M825.649411809578334.8488260.7360.4635910.231796
M917.053231438981434.9343860.48820.6266050.313302
M10-8.4051384535173834.790986-0.24160.8096360.404818
M113.0128061618631035.6303590.08460.9327970.466399
t-0.5400194485422790.248155-2.17610.0321060.016053


Multiple Linear Regression - Regression Statistics
Multiple R0.557723806345547
R-squared0.311055844164565
Adjusted R-squared0.213705039535645
F-TEST (value)3.19520568268790
F-TEST (DF numerator)13
F-TEST (DF denominator)92
p-value0.000544869943113202
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation71.1801908095377
Sum Squared Residuals466128.999858761


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1235.1285.350935965737-50.2509359657371
2280.7299.647441566506-18.9474415665060
3264.6270.595735242292-5.99573524229156
4240.7261.493769751221-20.7937697512207
5201.4231.152546624694-29.7525466246944
6240.8271.619486372672-30.819486372672
7241.1268.652819706005-27.5528197060054
8223.8257.511159996566-33.711159996566
9206.1248.374960177427-42.2749601774268
10174.7222.376570836386-47.6765708363858
11203.3239.023046410161-35.7230464101609
12220.5258.544422427503-38.0444224275032
13299.5336.556206652597-37.0562066525968
14347.4373.926913881116-26.5269138811156
15338.3379.486509998523-41.1865099985229
16327.7318.4675908450199.23240915498054
17351.6282.35781731155669.242182688444
18396.6322.82475705953473.775242940466
19438.8331.395191206741107.404808793259
20395.6297.17932986955498.420670130446
21363.5253.431827608793110.068172391207
22378.8285.11894233712193.6810576628785
23357244.079913841527112.920086158473
24369240.527088231122128.472911768878
25464.8295.464670828468169.335329171532
26479.1298.224075615365180.875924384635
27431.3286.478020511962144.821979488038
28366.5271.60750461395494.8924953860464
29326.3258.57193270823867.7280672917621
30355.1258.65901960765796.4409803923426
31331.6272.99800416180258.6019958381985
32261.3238.78214282461422.5178571753857
33249229.64594300547519.3540569945248
34205.5226.721755292182-21.2217552921819
35235.6243.368230865957-7.76823086595698
36240.9234.0468548486156.85314515138534
37264.9306.290088666771-41.3900886667714
38253.8303.280943046732-49.4809430467316
39232.3274.229236722517-41.9292367225174
40193.8270.895821638383-77.0958216383833
41177280.934451360415-103.934451360415
42213.2315.632840701456-102.432840701456
43207.2306.897623627853-99.6976236278526
44180.6278.450312697602-97.8503126976024
45188.6292.388314506211-103.788314506211
46175.4231.778622723548-56.3786227235483
47199248.425098297323-49.4250982973235
48179.6221.798071059170-42.1980710591704
49225.8270.967103249579-45.1671032495794
50234291.032159257287-57.0321592572873
51200.2285.054654560821-84.8546545608209
52183.6258.647037848939-75.047037848939
53178.2245.611465943223-67.4114659432232
54203.2257.235653656517-54.0356536565166
55208.5248.500436582913-40.000436582913
56191.8225.821676059600-34.0216760595996
57172.8216.685476240461-43.8854762404605
58148167.612885271672-19.6128852716718
59159.4184.259360845447-24.8593608454469
60154.5232.623488897474-78.1234888974739
61213.2264.486869867072-51.2868698670721
62196.4267.246274653969-70.8462746539692
63182.8255.500219550566-72.7002195505658
64176.4217.55550202481-41.1555020248101
65153.6192.982829305220-39.3828293052205
66173.2233.449769053198-60.2497690531985
67171236.251652793469-65.2516527934687
68151.2219.341442677092-68.1414426770923
69161.9210.205242857953-48.3052428579532
70157.2178.438303109975-21.2383031099752
71201.7229.696081125372-27.9960811253719
72236.4203.06905388721933.3309461127812
73356.1286.84938851924969.2506114807507
74398.3283.840242899210114.459757100790
75403.7260.557086981932143.142913018068
76384.6262.992222304735121.607777695265
77365.8249.956650399019115.843349600981
78368.1296.19214055393471.9078594460658
79367.9298.99402429420468.9059757057955
80347264.77816295701782.2218370429828
81343.3244.10486232400499.1951376759957
82292.9264.25487623845928.6451237615414
83311.5303.9755534399817.52444656001858
84300.9317.728379050387-16.8283790503868
85366.9361.1288608338595.77113916614109
86356.9398.499568062378-41.5995680623776
87329.7375.2164121451-45.5164121451003
88316.2343.040245026282-26.8402450262815
89269301.161921085881-32.1619210858812
90289.3330.091760019985-40.7917600199853
91266.2315.587992539445-49.3879925394448
92253.6258.29792957451-4.69792957450991
93233.8249.161729755371-15.3617297553708
94228.4228.931890821267-0.531890821266662
95253.6228.27271517423125.327284825769
96260.1253.562641598516.53735840148978
97306.6325.805875416667-19.2058754166669
98309.2340.102381017438-30.902381017438
99309.5305.2821242862874.21787571371313
100271255.80030594665715.1996940533427
101279.9260.07038526175219.8296147382477
102317.9271.69457297504646.2054270249543
103298.4251.42225508756846.9777449124317
104246.7211.43784334344435.2621566565559
105227.3202.30164352430524.9983564756950
106209.1164.7661533693944.3338466306099


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.05490044081529140.1098008816305830.945099559184709
180.03631098611308860.07262197222617730.963689013886911
190.06395575944865780.1279115188973160.936044240551342
200.03291521565622010.06583043131244020.96708478434378
210.01613758396538020.03227516793076040.98386241603462
220.02187102734648340.04374205469296680.978128972653517
230.01187053397838350.0237410679567670.988129466021616
240.007400716412949050.01480143282589810.99259928358705
250.006808390835812130.01361678167162430.993191609164188
260.01030279681794520.02060559363589030.989697203182055
270.01834228854543500.03668457709086990.981657711454565
280.04981627664068570.09963255328137140.950183723359314
290.1408939914093970.2817879828187940.859106008590603
300.2656356864656020.5312713729312030.734364313534398
310.5041060415324740.9917879169350520.495893958467526
320.7177826856884920.5644346286230160.282217314311508
330.83053787865840.3389242426831980.169462121341599
340.906043581395810.1879128372083770.0939564186041887
350.9439361286511750.1121277426976490.0560638713488247
360.9637445790179650.07251084196407060.0362554209820353
370.9837322203722010.03253555925559790.0162677796277990
380.992715447031130.01456910593774190.00728455296887096
390.9942298845485120.01154023090297620.00577011545148811
400.9961239120897960.007752175820407150.00387608791020357
410.9981396754634630.003720649073073690.00186032453653684
420.9988970528349930.002205894330015040.00110294716500752
430.999142949822670.001714100354662150.000857050177331075
440.9991184723520520.001763055295896140.000881527647948072
450.9990224522090160.001955095581967900.000977547790983951
460.9984599434924540.003080113015091790.00154005650754589
470.997623907994640.00475218401071950.00237609200535975
480.9964759978649280.0070480042701430.0035240021350715
490.9944968839571060.01100623208578740.00550311604289372
500.9918996372567190.01620072548656290.00810036274328144
510.9897385822027520.0205228355944960.010261417797248
520.9863939632161540.02721207356769230.0136060367838462
530.981339964809880.03732007038024110.0186600351901205
540.9733585080716650.05328298385666990.0266414919283350
550.961654465587970.07669106882405830.0383455344120292
560.9460907524510170.1078184950979660.0539092475489831
570.926835131571890.1463297368562200.0731648684281102
580.9020282672965470.1959434654069050.0979717327034525
590.8707964194914570.2584071610170870.129203580508543
600.8533626479000620.2932747041998770.146637352099938
610.8267677313015620.3464645373968750.173232268698438
620.8150624088278850.3698751823442290.184937591172115
630.8262041179472160.3475917641055670.173795882052784
640.825083518859130.3498329622817380.174916481140869
650.836304688242850.3273906235142990.163695311757149
660.8729229098690410.2541541802619180.127077090130959
670.9190501037796850.1618997924406300.0809498962203148
680.9678133214017070.06437335719658620.0321866785982931
690.9907839839765960.01843203204680910.00921601602340454
700.9986078536443440.002784292711311790.00139214635565590
710.9998963475794250.000207304841149840.00010365242057492
720.9999964639380587.07212388487722e-063.53606194243861e-06
730.9999989290407712.14191845724132e-061.07095922862066e-06
740.9999990444998151.91100036922173e-069.55500184610863e-07
750.9999989831623472.03367530644486e-061.01683765322243e-06
760.9999979317161074.13656778587572e-062.06828389293786e-06
770.9999952805231649.43895367233078e-064.71947683616539e-06
780.9999921382425281.57235149438238e-057.8617574719119e-06
790.9999761546390544.76907218924849e-052.38453609462424e-05
800.9999341564087770.0001316871824458546.58435912229268e-05
810.9999180069508270.0001639860983452718.19930491726355e-05
820.9998995257272780.0002009485454449220.000100474272722461
830.9997804112494240.0004391775011530560.000219588750576528
840.9994010656294270.001197868741146850.000598934370573425
850.999622138325650.000755723348700440.00037786167435022
860.9995501957057110.0008996085885770750.000449804294288537
870.9979636255677450.004072748864509360.00203637443225468
880.9964216497436540.007156700512692020.00357835025634601
890.9840548262718620.03189034745627610.0159451737281380


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level280.383561643835616NOK
5% type I error level450.616438356164384NOK
10% type I error level520.712328767123288NOK