Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 1677.68894339794 + 0.586252193687844X[t] + 273.970572539457M1[t] -629.564052274936M2[t] + 82.4442739799037M3[t] -175.120587025784M4[t] -456.435752915417M5[t] -281.343885814236M6[t] -737.70923779068M7[t] -147.638849728842M8[t] -3.03609424816335M9[t] -187.498457097383M10[t] + 5.70781212665605M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)1677.68894339794309.748015.41632e-061e-06
X0.5862521936878440.05458910.739300
M1273.970572539457180.4569731.51820.1355220.067761
M2-629.564052274936188.524052-3.33940.001630.000815
M382.4442739799037187.1950710.44040.6616110.330805
M4-175.120587025784187.007064-0.93640.3537350.176868
M5-456.435752915417186.972198-2.44120.0183770.009188
M6-281.343885814236188.6593-1.49130.1424310.071216
M7-737.70923779068187.021625-3.94450.000260.00013
M8-147.638849728842190.777478-0.77390.4427970.221398
M9-3.03609424816335187.003763-0.01620.9871140.493557
M10-187.498457097383188.136532-0.99660.3239520.161976
M115.70781212665605187.5830980.03040.9758520.487926


Multiple Linear Regression - Regression Statistics
Multiple R0.889456603915496
R-squared0.791133050248887
Adjusted R-squared0.738916312811109
F-TEST (value)15.1509475518574
F-TEST (DF numerator)12
F-TEST (DF denominator)48
p-value1.84519066692701e-12
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation295.615397185516
Sum Squared Residuals4194646.22655121


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
13956.24283.59486676954-327.394866769543
23142.73383.40187945917-240.701879459166
33884.34194.77995254410-310.479952544095
43892.24015.30388373763-123.103883737629
536133770.33635385664-157.336353856642
63730.53711.6308461151118.8691538848887
73481.33382.7167210464098.5832789535953
83649.54002.80322142506-353.30322142506
94215.24329.32003260708-114.120032607077
104066.63971.3270204262695.2729795737447
114196.84304.47168828358-107.671688283582
124536.64680.00367771213-143.403677712131
134441.64396.8001653706644.7998346293384
143548.33626.81379027836-78.5137902783593
154735.94393.22632010743342.673679892569
164130.63995.19543349414135.404566505865
174356.24095.00281872097261.19718127903
184159.64178.22896707127-18.6289670712657
1939883675.96006832906312.039931670936
204167.83998.4063299724169.393670027599
214902.24766.312417782135.887582218004
223909.43891.0690951103918.3309048896106
234697.64386.07799364493311.52200635507
244308.94443.68541843656-134.785418436562
254420.44405.4180726178714.9819273821264
263544.23577.62723122795-33.4272312279492
2744334352.8921691817180.1078308182923
284479.74468.535454677711.1645453222989
294533.24178.07475456654355.125245433462
304237.53997.3115400992240.188459900802
314207.43825.86475425505381.535245744953
3243944141.68636610971252.313633890290
335148.44640.32682135848508.073178641522
344202.24285.96857277852-83.7685727785211
354682.54715.37585083939-32.8758508393926
364884.34602.67701336471281.622986635295
375288.95001.40205272094287.497947279064
384505.23884.64750506227620.552494937727
394611.54618.99203989662-7.49203989661987
4051044947.09312038509156.906879614912
414586.64573.3846087702513.2153912297498
424529.34197.92704077918331.372959220822
434504.14572.33967247778-68.2396724777777
444604.94241.70099035286363.199009647144
454795.44928.23527367858-132.835273678579
465391.15240.79752063791150.302479362087
475213.95116.899978296297.000021703803
4854155396.7556097148918.2443902851101
495990.35830.01090327933160.289096720666
504241.84509.70959397225-267.909593972253
515677.65782.40951827015-104.809518270146
525164.25344.57210770545-180.372107705446
533962.34434.5014640856-472.2014640856
5440114582.80160593525-571.801605935248
553310.34034.21878389171-723.918783891706
563837.34268.90309213997-431.603092139972
574145.34542.30545457387-397.00545457387
583796.73976.83779104692-180.137791046921
593849.64117.5744889359-267.974488935898
6042854306.67828077171-21.6782807717122
614189.64369.77393924165-180.173939241652


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.2707228890295740.5414457780591480.729277110970426
170.1516220120655590.3032440241311180.84837798793444
180.2479213035828300.4958426071656600.75207869641717
190.1571511537719920.3143023075439850.842848846228008
200.2037456149724830.4074912299449670.796254385027517
210.1272065906665210.2544131813330420.872793409333479
220.07333457498523770.1466691499704750.926665425014762
230.06868112620799240.1373622524159850.931318873792008
240.04418413432756340.08836826865512680.955815865672437
250.02523043225350840.05046086450701690.974769567746492
260.01395942649103800.02791885298207590.986040573508962
270.006840004630853060.01368000926170610.993159995369147
280.005034147001697220.01006829400339440.994965852998303
290.004094405601217350.00818881120243470.995905594398783
300.002892719858702170.005785439717404330.997107280141298
310.003420684969373660.006841369938747330.996579315030626
320.002744920793085030.005489841586170070.997255079206915
330.01091709027481890.02183418054963770.989082909725181
340.009654924888148030.01930984977629610.990345075111852
350.007391865181836250.01478373036367250.992608134818164
360.008200962842888920.01640192568577780.99179903715711
370.005079878201338060.01015975640267610.994920121798662
380.03604540578719030.07209081157438050.96395459421281
390.02705164211750590.05410328423501170.972948357882494
400.02465437065473900.04930874130947810.97534562934526
410.02837154833081670.05674309666163340.971628451669183
420.1768896018220020.3537792036440040.823110398177998
430.316415736116040.632831472232080.68358426388396
440.9372265823066780.1255468353866440.0627734176933219
450.9131863035310240.1736273929379520.086813696468976


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level40.133333333333333NOK
5% type I error level130.433333333333333NOK
10% type I error level180.6NOK