Multiple Linear Regression - Estimated Regression Equation
Gemiddelde_prijs_vliegticket_in$[t] = + 296.249069801245 + 0.408609281722776`Gemiddelde_olieprijs_in$`[t] + 3.66666666666665Q1[t] + 2.71400000000000Q2[t] -2.04466666666666Q3[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)296.2490698012455.71060351.87700
`Gemiddelde_olieprijs_in$`0.4086092817227760.0909174.49433.6e-051.8e-05
Q13.666666666666656.3341860.57890.5650410.28252
Q22.714000000000006.3341860.42850.6699830.334992
Q3-2.044666666666666.334186-0.32280.7480720.374036


Multiple Linear Regression - Regression Statistics
Multiple R0.527554415011112
R-squared0.278313660797717
Adjusted R-squared0.225827381583006
F-TEST (value)5.30259841165704
F-TEST (DF numerator)4
F-TEST (DF denominator)55
p-value0.00110098507590728
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation17.3468832420402
Sum Squared Residuals16550.2897017137


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1296.95306.943816113544-9.99381611354354
2296.84305.991149446877-9.15114944687654
3287.54301.23248278021-13.6924827802099
4287.81303.277149446877-15.4671494468765
5283.99308.345345949852-24.3553459498523
6275.79307.392679283186-31.6026792831856
7269.52302.634012616519-33.114012616519
8278.35304.678679283186-26.3286792831856
9283.43307.810067790795-24.3800677907955
10289.46306.857401124129-17.3974011241288
11282.3302.098734457462-19.7987344574621
12293.55304.143401124129-10.5934011241288
13304.78305.22357103749-0.443571037490312
14300.99304.270904370824-3.28090437082363
15315.29299.51223770415715.7777622958430
16316.21301.55690437082414.6530956291763
17331.79307.32382274554524.4661772544547
18329.38306.37115607887923.0088439211213
19317.27301.61248941221215.6575105877879
20317.98303.65715607887914.3228439211213
21340.28311.50798179038728.7720182096134
22339.21310.5553151237228.6546848762800
23336.71305.79664845705330.9133515429467
24340.11307.8413151237232.2686848762801
25347.72309.86537247786137.854627522139
26328.68308.91270581119419.7672941888056
27303.05304.154039144528-1.10403914452771
28299.83306.198705811194-6.3687058111944
29320.04310.1268824181649.91311758183642
30317.94309.1742157514978.76578424850305
31303.31304.41554908483-1.10554908483029
32308.85306.4602157514972.38978424850307
33319.19311.7000281527967.48997184720371
34314.52310.7473614861303.77263851387034
35312.39305.9886948194636.401305180537
36315.77308.0333614861307.73663851387033
37320.23315.393856059574.83614394042983
38309.45314.441189392904-4.99118939290356
39296.54309.682522726237-13.1425227262369
40297.28311.727189392904-14.4471893929036
41301.39321.99698205221-20.6069820522103
42306.68321.044315385544-14.3643153855436
43305.91316.285648718877-10.3756487188769
44314.76318.330315385544-3.57031538554362
45323.34326.446737130171-3.10673713017132
46341.58325.49407046350516.0859295364953
47330.12320.7354037968389.38459620316202
48318.16322.780070463505-4.62007046350463
49317.84329.257968988424-11.4179689884240
50325.39328.305302321757-2.91530232175736
51327.56323.5466356550914.01336434490932
52329.77325.5913023217574.17869767824263
53333.29340.674512319758-7.38451231975835
54346.1339.7218456530926.3781543469083
55358334.96317898642523.0368210135749
56344.82337.0078456530927.81215434690827
57313.3324.943054973431-11.6430549734315
58301.26323.990388306765-22.7303883067648
59306.38319.231721640098-12.8517216400982
60319.31321.276388306765-1.96638830676483


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
80.01670075625184660.03340151250369330.983299243748153
90.007498614394645020.01499722878929000.992501385605355
100.003266028046666450.00653205609333290.996733971953334
110.001830432904019870.003660865808039740.99816956709598
120.004942954357461760.009885908714923530.995057045642538
130.002811551444930260.005623102889860520.99718844855507
140.001588097064507560.003176194129015120.998411902935492
150.004354757309521970.008709514619043940.995645242690478
160.002328853284327360.004657706568654710.997671146715673
170.2611247397247680.5222494794495350.738875260275232
180.6192448660683450.761510267863310.380755133931655
190.7148681532612580.5702636934774830.285131846738742
200.744804581175280.5103908376494410.255195418824720
210.96580221945810.06839556108380020.0341977805419001
220.98534529180870.02930941638260090.0146547081913005
230.9926586930363740.01468261392725200.00734130696362602
240.9967743044529620.006451391094075930.00322569554703796
250.9997600340767260.0004799318465471080.000239965923273554
260.9998266022996230.0003467954007545950.000173397700377297
270.9996466687910350.000706662417930080.00035333120896504
280.9994106688355450.001178662328910930.000589331164455463
290.9993500304116270.001299939176746020.000649969588373012
300.9991188258988460.001762348202307800.000881174101153899
310.9983007400942330.003398519811533840.00169925990576692
320.9969984203991360.00600315920172720.0030015796008636
330.997601665282560.004796669434881280.00239833471744064
340.9970249115511980.005950176897603340.00297508844880167
350.9962659786234430.007468042753113430.00373402137655671
360.9970362798651910.005927440269617840.00296372013480892
370.9994246985018140.001150602996371100.000575301498185552
380.9993794357635570.00124112847288660.0006205642364433
390.998910945874280.002178108251440840.00108905412572042
400.998037169666540.003925660666918180.00196283033345909
410.9970560848573980.005887830285203490.00294391514260174
420.9945727611729570.01085447765408630.00542723882704314
430.9910679286009260.01786414279814760.00893207139907382
440.9820006160640140.03599876787197140.0179993839359857
450.9743087771615670.05138244567686560.0256912228384328
460.9966492100184090.00670157996318260.0033507899815913
470.9953233251729520.009353349654095640.00467667482704782
480.9877649495781530.02447010084369480.0122350504218474
490.9706605582520860.05867888349582840.0293394417479142
500.9496332491761210.1007335016477570.0503667508238785
510.8885103033141730.2229793933716530.111489696685827
520.7822195349097330.4355609301805350.217780465090267


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level270.6NOK
5% type I error level350.777777777777778NOK
10% type I error level380.844444444444444NOK