Multiple Linear Regression - Estimated Regression Equation
cultuurbestedingen[t] = + 100.676931818182 -0.0904886363636757M1[t] -0.0355909090909093M2[t] -0.298693181818184M3[t] -0.109795454545457M4[t] -0.394897727272728M5[t] -0.384000000000005M6[t] -0.543102272727275M7[t] -0.488204545454551M8[t] + 0.514693181818181M9[t] + 0.391590909090904M10[t] + 0.139602272727273M11[t] + 0.327102272727273t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)100.6769318181820.337006298.739200
M1-0.09048863636367570.40885-0.22130.8258410.41292
M2-0.03559090909090930.408592-0.08710.9309740.465487
M3-0.2986931818181840.408392-0.73140.4683340.234167
M4-0.1097954545454570.408249-0.26890.7892030.394602
M5-0.3948977272727280.408163-0.96750.3384660.169233
M6-0.3840000000000050.408135-0.94090.3517970.175899
M7-0.5431022727272750.408163-1.33060.1900240.095012
M8-0.4882045454545510.408249-1.19580.2380190.119009
M90.5146931818181810.4083921.26030.2140610.10703
M100.3915909090909040.4085920.95840.3429870.171494
M110.1396022727272730.4302390.32450.7470810.373541
t0.3271022727272730.00483467.66500


Multiple Linear Regression - Regression Statistics
Multiple R0.995287469888219
R-squared0.990597147716492
Adjusted R-squared0.98808972044089
F-TEST (value)395.065155968917
F-TEST (DF numerator)12
F-TEST (DF denominator)45
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.608411215437963
Sum Squared Residuals16.6573893181815


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1101.76100.9135454545460.8464545454544
2102.37101.2955454545451.07445454545456
3102.38101.3595454545451.02045454545455
4102.86101.8755454545450.984454545454554
5102.87101.9175454545450.952454545454556
6102.92102.2555454545450.664454545454556
7102.95102.4235454545450.526454545454552
8103.02102.8055454545450.214454545454550
9104.08104.135545454545-0.0555454545454519
10104.16104.339545454545-0.179545454545448
11104.24104.414659090909-0.174659090909094
12104.33104.602159090909-0.272159090909090
13104.73104.838772727273-0.108772727272686
14104.86105.220772727273-0.360772727272726
15105.03105.284772727273-0.254772727272721
16105.62105.800772727273-0.180772727272719
17105.63105.842772727273-0.212772727272730
18105.63106.180772727273-0.550772727272726
19105.94106.348772727273-0.408772727272727
20106.61106.730772727273-0.120772727272722
21107.69108.060772727273-0.370772727272728
22107.78108.264772727273-0.484772727272721
23107.93108.339886363636-0.409886363636357
24108.48108.527386363636-0.0473863636363603
25108.14108.764-0.623999999999961
26108.48109.146-0.665999999999997
27108.48109.21-0.729999999999996
28108.89109.726-0.836
29108.93109.768-0.837999999999994
30109.21110.106-0.896000000000003
31109.47110.274-0.804000000000001
32109.8110.656-0.856
33111.73111.986-0.255999999999998
34111.85112.19-0.340000000000003
35112.12112.265113636364-0.145113636363636
36112.15112.452613636364-0.302613636363634
37112.17112.689227272727-0.519227272727236
38112.67113.071227272727-0.401227272727275
39112.8113.135227272727-0.335227272727279
40113.44113.651227272727-0.211227272727276
41113.53113.693227272727-0.163227272727276
42114.53114.0312272727270.498772727272728
43114.51114.1992272727270.31077272727273
44115.05114.5812272727270.468772727272723
45116.67115.9112272727270.758772727272726
46117.07116.1152272727270.954772727272719
47116.92116.1903409090910.729659090909087
48117116.3778409090910.622159090909084
49117.02116.6144545454550.405545454545484
50117.35116.9964545454550.353545454545441
51117.36117.0604545454550.299545454545449
52117.82117.5764545454550.243545454545441
53117.88117.6184545454550.261545454545443
54118.24117.9564545454550.283545454545445
55118.5118.1244545454550.375545454545446
56118.8118.5064545454550.293545454545448
57119.76119.836454545455-0.0764545454545479
58120.09120.0404545454550.0495454545454534


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.05770632094513370.1154126418902670.942293679054866
170.0197393027209290.0394786054418580.98026069727907
180.005350631464762950.01070126292952590.994649368535237
190.004268996061025860.008537992122051720.995731003938974
200.1013772482251390.2027544964502780.898622751774861
210.1934964689507040.3869929379014090.806503531049296
220.235644735312610.471289470625220.76435526468739
230.2600273828887290.5200547657774590.73997261711127
240.4596184475720130.9192368951440270.540381552427987
250.3642040979940800.7284081959881610.63579590200592
260.2727598284990190.5455196569980370.727240171500981
270.1929158901286450.385831780257290.807084109871355
280.1332821016137120.2665642032274240.866717898386288
290.0875443865868330.1750887731736660.912455613413167
300.07358455869272030.1471691173854410.92641544130728
310.06127173599399660.1225434719879930.938728264006003
320.06184627745478460.1236925549095690.938153722545215
330.1248868540578390.2497737081156770.875113145942161
340.1916970332066580.3833940664133150.808302966793342
350.2932364281306200.5864728562612390.70676357186938
360.3470767144996570.6941534289993140.652923285500343
370.4150232060290500.8300464120580990.58497679397095
380.4817163292919940.9634326585839870.518283670708006
390.5544444437309490.8911111125381020.445555556269051
400.6125931549972510.7748136900054970.387406845002749
410.7433545096738950.513290980652210.256645490326105
420.6981786964600790.6036426070798420.301821303539921


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level10.037037037037037NOK
5% type I error level30.111111111111111NOK
10% type I error level30.111111111111111NOK