Multiple Linear Regression - Estimated Regression Equation
Gasverbruik[t] = + 184.187780754098 + 0.411924978271191`verbruik-1`[t] -35.9914829823636M1[t] -81.5347368847649M2[t] -110.464288803697M3[t] -152.701279577718M4[t] -158.942776182526M5[t] -152.417963785236M6[t] -154.263242501735M7[t] -149.200362839029M8[t] -131.896899673988M9[t] -83.2310550224989M10[t] -18.2122278589104M11[t] -0.16013532449131t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)184.18778075409821.7505848.468200
`verbruik-1`0.4119249782711910.0941834.37363.2e-051.6e-05
M1-35.99148298236369.138069-3.93860.000168e-05
M2-81.53473688476498.36703-9.744800
M3-110.4642888036977.4212-14.88500
M4-152.7012795777189.279407-16.455900
M5-158.94277618252613.716955-11.587300
M6-152.41796378523616.352712-9.320700
M7-154.26324250173516.91922-9.117600
M8-149.20036283902917.310186-8.619200
M9-131.89689967398817.039827-7.740500
M10-83.231055022498915.563314-5.34791e-060
M11-18.212227858910411.241353-1.62010.1086690.054335
t-0.160135324491310.056166-2.85110.005390.002695


Multiple Linear Regression - Regression Statistics
Multiple R0.985212262026276
R-squared0.970643201246931
Adjusted R-squared0.966449372853635
F-TEST (value)231.445617278627
F-TEST (DF numerator)13
F-TEST (DF denominator)91
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation15.1539145582881
Sum Squared Residuals20897.3425060305


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1262272.437505885142-10.4375058851424
2218210.2571175274027.74288247259787
3175163.04273124004611.9572687599538
4100102.932831075873-2.93283107587304
57765.636825776234611.3631742237654
64362.5272283487959-19.5272283487959
74746.51636504658470.483634953415271
84953.0668092978842-4.06680929788419
96971.0339870949765-2.03398709497652
10152127.77819598739824.2218040126022
11205226.826661023004-21.8266610230038
12246266.710777405796-20.710777405796
13294247.4480832080646.5519167919401
14242221.51709293818520.4829070618155
15181171.0073068246599.99269317534088
16107103.4827570516043.51724294839555
175666.5986767302372-10.5986767302372
184951.9551799112051-2.95517991120505
194747.0662910223162-0.0662910223161652
204751.1451854039885-4.14518540398852
217168.28851324453842.7114867554616
22151126.68042205004424.3195779499556
23244224.49311215083719.5068878491631
24280280.854227664477-0.85422766447677
25230259.531908575385-29.5319085753847
26185193.232270434933-8.23227043493258
27148145.6059591693062.39404083069449
289887.967608874759410.0323911252406
296160.96972803190070.0302719680992663
304652.0931809086653-6.09318090866532
314543.90889219360691.09110780639309
325548.39971155355046.6002884464496
334869.6622891768122-21.6622891768122
34115115.284523655911-0.284523655911313
35185207.742189039178-22.7421890391783
36276254.62903005258121.3709699474192
37220255.962584768404-35.9625847684042
38181187.191396758325-6.19139675832495
39151142.0366353623258.96336463767498
408387.2817599156773-4.28175991567729
415552.86922946393712.13077053606286
424947.70000714514241.29999285485757
434243.2230432345247-1.22304323452473
444645.24231272484110.757687275158901
457464.03334047847589.96665952152422
46103124.072949197067-21.0729491970665
47200200.877465406028-0.87746540602828
48237258.886280832753-21.8862808327529
49247237.9758867219329.02411327806793
50215196.39174727775118.6082527222486
51182154.1204607296527.8795392703502
528098.1298103481885-18.1298103481885
534649.7118306352278-3.71183063522784
546542.07105844680622.928941553194
554047.8922189929681-7.8922189929681
564442.4968388744031.50316112559697
576361.28786662803771.71213337196234
5885117.620150542188-32.6201505421878
59185191.541191903251-6.54119190325113
60247250.785782264789-3.78578226478933
61231240.173512610748-9.17351261074826
62167187.879323731517-20.8793237315166
63117132.426437878737-15.4264378787369
647969.43306286666539.56693713333467
654547.3782817630609-2.37828176306093
664039.73750957463910.262490425360907
673835.67247064229262.32752935770742
684139.75136502396491.24863497603506
696958.130467799328410.8695322006716
70152118.17007651791933.8299234820809
71232217.21854155352514.7814584464748
72282268.2246323496413.7753676503604
73255252.6692629563442.33073704365577
74161195.84389931613-34.8438993161295
75107128.033264115214-21.033264115214
765363.3921891900577-10.3921891900577
774034.74660843411435.25339156588574
783935.75626078938743.2437392106126
793433.33892177012570.661078229874314
803536.1820412169844-1.18204121698443
815653.73729403580552.2627059641945
8297110.893427906498-13.8934279064979
83210192.64104385471417.358956145286
84260257.2406589337782.75934106622232
85257241.68528954048215.3147104595177
86210194.74612537877615.2538746212238
87125146.295964156607-21.2959641566067
888068.885214905043411.1147850949566
894243.9469589535407-1.94695895354069
903534.65848685203410.34151314796591
913129.76959796314521.2304020368548
923233.0246423882751-1.02464238827513
935050.5798952070962-0.579895207096223
9492106.500254142975-14.5002541429751
95189188.6597950694620.340204930537643
96256246.6686104961879.33138950381306
97250238.11596573350211.8840342664982
98198189.9410266369828.05897336301789
99136139.431240523457-3.43124052345669
1007371.49476577213081.50523422786915
1013939.1418602117467-0.141860211746665
1023231.50108802332480.498911976675229
1033026.61219913443593.3878008655641
1043130.69109351610820.308906483891757
1054548.2463463349293-3.24634633492931


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.66837133591740.6632573281652010.3316286640826
180.5289681128354950.942063774329010.471031887164505
190.3969046251485910.7938092502971820.603095374851409
200.2964668839410040.5929337678820070.703533116058996
210.2006160594375060.4012321188750120.799383940562494
220.1578668356459520.3157336712919040.842133164354048
230.3365762537592080.6731525075184160.663423746240792
240.435902833194820.8718056663896410.56409716680518
250.9311221961127720.1377556077744560.0688778038872282
260.966081713039140.06783657392172010.03391828696086
270.9541304349953910.09173913000921850.0458695650046093
280.9390873267287740.1218253465424510.0609126732712257
290.9114552470692650.1770895058614710.0885447529307355
300.8803054960700110.2393890078599790.119694503929989
310.8385381498468190.3229237003063630.161461850153181
320.8042678590533410.3914642818933180.195732140946659
330.8188196059196440.3623607881607110.181180394080356
340.8320095019711430.3359809960577130.167990498028857
350.8535215241732650.2929569516534690.146478475826735
360.906978437759760.1860431244804810.0930215622402405
370.9700848661926530.05983026761469360.0299151338073468
380.9596580042071030.08068399158579490.0403419957928974
390.9536664585070310.09266708298593760.0463335414929688
400.9351583451598220.1296833096803560.0648416548401781
410.9144470158544870.1711059682910250.0855529841455126
420.9012749723072690.1974500553854610.0987250276927307
430.8708927764459610.2582144471080780.129107223554039
440.8363417112508740.3273165774982520.163658288749126
450.8337448445477660.3325103109044680.166255155452234
460.8636545763761250.2726908472477510.136345423623875
470.8300198054889540.3399603890220930.169980194511046
480.8524105556091060.2951788887817890.147589444390895
490.8376028807321270.3247942385357470.162397119267873
500.8851395054250690.2297209891498620.114860494574931
510.9680283513439040.06394329731219280.0319716486560964
520.9772964446992150.04540711060157060.0227035553007853
530.9670969839995770.06580603200084640.0329030160004232
540.9850539156926810.02989216861463730.0149460843073187
550.9805604809493780.03887903810124430.0194395190506221
560.9721328928590980.05573421428180440.0278671071409022
570.9605844240212250.07883115195755040.0394155759787752
580.9902791469690830.01944170606183410.00972085303091704
590.9863030000513730.02739399989725320.0136969999486266
600.9797803651775720.04043926964485690.0202196348224284
610.9763160705267440.04736785894651260.0236839294732563
620.9776912636817450.04461747263651010.022308736318255
630.9749644976126710.05007100477465890.0250355023873294
640.9685536915547510.06289261689049840.0314463084452492
650.9549051515026940.09018969699461190.045094848497306
660.9360181242055490.1279637515889020.0639818757944509
670.9121817148580550.175636570283890.0878182851419448
680.8807647357414620.2384705285170770.119235264258538
690.8654961774955160.2690076450089670.134503822504484
700.9936017271539290.01279654569214170.00639827284607083
710.9914506510169090.01709869796618140.0085493489830907
720.9899118987810.02017620243799940.0100881012189997
730.9841715988881130.0316568022237750.0158284011118875
740.999979812482944.03750341204672e-052.01875170602336e-05
750.9999650798233456.98403533093946e-053.49201766546973e-05
760.9999985080102022.98397959700604e-061.49198979850302e-06
770.9999970723414435.85531711417261e-062.92765855708631e-06
780.9999897552525542.04894948924662e-051.02447474462331e-05
790.9999678485664146.43028671727647e-053.21514335863823e-05
800.9999093646783130.0001812706433746529.06353216873259e-05
810.9996993355499720.0006013289000567250.000300664450028362
820.9990957508408170.001808498318366170.000904249159183086
830.9997946340035020.0004107319929969850.000205365996498492
840.9994751874732010.001049625053597580.000524812526798791
850.9984336790254070.003132641949186110.00156632097459305
860.999542192380.0009156152400004410.00045780762000022
870.9999260925812890.0001478148374223337.39074187111666e-05
880.9992194457919270.001561108416145450.000780554208072726


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level150.208333333333333NOK
5% type I error level270.375NOK
10% type I error level390.541666666666667NOK