Multiple Linear Regression - Estimated Regression Equation
Import[t] = + 159.23583988678 -0.527705277557674Wisselkoers[t] -1.42952943199583M1[t] -9.62959659104806M2[t] -1.74482004101209M3[t] + 4.7166932453793M4[t] + 2.2752518187206M5[t] -4.09312791143662M6[t] -8.21383428477751M7[t] -12.0086173119050M8[t] + 4.34543457019099M9[t] -8.35340229011195M10[t] -1.39536111330011M11[t] + 0.355466572662176t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)159.2358398867833.8162364.70892.3e-051.2e-05
Wisselkoers-0.5277052775576740.333419-1.58270.120340.06017
M1-1.429529431995838.631223-0.16560.8691790.43459
M2-9.629596591048068.641211-1.11440.2709050.135452
M3-1.744820041012098.624537-0.20230.8405670.420284
M44.71669324537938.59310.54890.5857330.292867
M52.27525181872068.5863520.2650.7922050.396103
M6-4.093127911436628.597037-0.47610.636250.318125
M7-8.213834284777518.569283-0.95850.3428110.171406
M8-12.00861731190508.564508-1.40210.1675870.083793
M94.345434570190998.565540.50730.6143570.307178
M10-8.353402290111958.55609-0.97630.3340170.167009
M11-1.395361113300118.555046-0.16310.8711510.435576
t0.3554665726621760.1314292.70460.0095550.004777


Multiple Linear Regression - Regression Statistics
Multiple R0.660933492374028
R-squared0.436833081341729
Adjusted R-squared0.277677213025261
F-TEST (value)2.74468724252834
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value0.00585073172241857
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation13.5244071167880
Sum Squared Residuals8413.84104158875


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1100105.391249271679-5.39124927167932
296.2106436398.695851017067-2.48520738706693
396.31280765108.926888594905-12.6140809449054
4107.1793443117.287464338132-10.1081200381317
5114.9066592114.1421652978160.764493902184287
692.56060184107.732730917186-15.1721290771860
7114.9995356104.66930144694810.3302341530519
8107.1236185100.2371345259916.88648397400883
9117.7765394115.9887479651271.78779143487328
10107.3650971101.4367221882195.92837491178112
11106.2970187108.186589513849-1.88957081384937
12114.5072908111.0486437859353.45864701406529
1398.0031578109.820485682116-11.8173278821162
14103.0649206100.9206873272102.14423327279016
15100.2879168108.118305243798-7.83038844379835
16104.6066685115.258240363324-10.6515718633235
17111.1544534114.282138098695-3.12768469869481
18104.9874617107.532920511491-2.54545881149098
19109.9284852104.1360908152365.79239438476421
20111.5352466101.7939453848999.74130121510055
21132.4974459120.55667009296211.9407758070384
22100.3436426107.734315059994-7.39067245999414
23123.0983561115.184445325887.91391077411996
24114.2379493117.439209578262-3.20126027826215
25104.569518116.032971539605-11.4634535396049
26109.0833101107.7223456838041.36096441619577
27106.9843039117.034292193461-10.0499882934606
28133.6769759125.1089858031018.56799009689892
29124.8537197122.2196524926282.63406720737165
30122.5132349116.4912674930726.02196740692788
31116.8013374113.3516930589393.44964434106131
32116.0118882110.8994243181925.11246388180813
33129.7575926127.5912766250622.16631597493833
34125.1973623114.92076020522410.2766020947764
35143.7912139123.27463649778920.5165774022106
36127.9465032124.7010904778793.24541272212068
37130.2962757124.5603031882295.7359725117707
38108.4424631117.795207462249-9.35274436224869
39129.3675118127.4459055990941.92160620090552
40143.6797622133.9192982036489.76046399635223
41131.8844618132.278329774848-0.393867974848265
42117.6186496126.354521062442-8.73587146244193
43118.9560695124.782656158174-5.82658665817375
44104.8202842121.933866189015-17.1135819890153
45134.624315138.132936099242-3.50862109924163
46140.401226125.77886296704014.6223630329598
47143.8005015133.66284547779310.1376560222074
48153.4317823133.24312241769820.1886598823023
49153.2924677130.35640951837022.9360581816297
50127.3149438118.9821897396708.3327540603297
51153.5525216124.97967011874128.5728514812588
52136.9276493134.4964114917962.43123780820405
53131.7730101131.6500185360130.122991563987134
54144.3391845123.90769255580920.4314919441911
55107.4208229121.166509120704-13.7456862207037
56113.6249652118.251632281902-4.62666708190224
57124.2221603136.608422417608-12.3862621176083
58102.0618557125.498523279523-23.4366675795232
5996.36853348133.047106864689-36.6785733846885
60111.6838488135.375308140226-23.6914593402261


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.02104763023309900.04209526046619810.978952369766901
180.02286118392396280.04572236784792550.977138816076037
190.01035575615109180.02071151230218360.989644243848908
200.00317834995449570.00635669990899140.996821650045504
210.002192195270249110.004384390540498210.99780780472975
220.002459213092348620.004918426184697250.997540786907651
230.001938977648182600.003877955296365200.998061022351817
240.0008549469233542620.001709893846708520.999145053076646
250.0004892203747221750.000978440749444350.999510779625278
260.0001680363218923310.0003360726437846610.999831963678108
270.0001285921261570.0002571842523140.999871407873843
280.0006589424635775540.001317884927155110.999341057536422
290.0002654801681570790.0005309603363141570.999734519831843
300.0002570995521788880.0005141991043577770.999742900447821
310.0001484105764085770.0002968211528171540.999851589423591
326.57310452964148e-050.0001314620905928300.999934268954704
333.1334055849358e-056.2668111698716e-050.99996866594415
341.68022111593111e-053.36044223186222e-050.99998319778884
352.41866322675995e-054.8373264535199e-050.999975813367732
368.37845168406375e-061.67569033681275e-050.999991621548316
374.75287384330502e-059.50574768661004e-050.999952471261567
380.001248200200344000.002496400400687990.998751799799656
390.001867082883733850.00373416576746770.998132917116266
400.002611703281894490.005223406563788980.997388296718106
410.004033663909226930.008067327818453850.995966336090773
420.1092078571531010.2184157143062020.890792142846899
430.1063380769257750.2126761538515510.893661923074225


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level220.814814814814815NOK
5% type I error level250.925925925925926NOK
10% type I error level250.925925925925926NOK