Multiple Linear Regression - Estimated Regression Equation
Gemiddelde_prijs_vliegticket_in$[t] = + 292.821678002806 + 0.157012705702092`Gemiddelde_olieprijs_in$`[t] + 4.90706693997384Q1[t] + 3.5409335155381Q2[t] -1.63119990889761Q3[t] + 0.413466757769053t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)292.8216780028066.01805548.657200
`Gemiddelde_olieprijs_in$`0.1570127057020920.1800530.8720.387050.193525
Q14.907066939973846.2915330.77990.4388270.219413
Q23.54093351553816.2653090.56520.5743020.287151
Q3-1.631199908897616.249521-0.2610.7950760.397538
t0.4134667577690530.2566311.61110.1129810.056491


Multiple Linear Regression - Regression Statistics
Multiple R0.558044424545972
R-squared0.311413579766845
Adjusted R-squared0.247655577893405
F-TEST (value)4.88430582227156
F-TEST (DF numerator)5
F-TEST (DF denominator)54
p-value0.000929059806845878
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation17.1005825241527
Sum Squared Residuals15791.2158239292


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1296.95300.842830238625-3.89283023862503
2296.84299.890163571959-3.05016357195858
3287.54295.131496905292-7.59149690529192
4287.81297.176163571959-9.36616357195859
5283.99303.03525085026-19.0452508502597
6275.79302.082584183593-26.292584183593
7269.52297.323917516926-27.8039175169263
8278.35299.368584183593-21.0185841835930
9283.43304.483431236866-21.0534312368661
10289.46303.530764570199-14.0707645701995
11282.3298.772097903533-16.4720979035328
12293.55300.816764570199-7.26676457019944
13304.78305.143407840848-0.363407840848122
14300.99304.190741174181-3.2007411741814
15315.29299.43207450751515.8579254924853
16316.21301.47674117418114.7332588258186
17331.79307.60432017923324.1856798207670
18329.38306.65165351256622.7283464874336
19317.27301.892986845915.3770131541003
20317.98303.93765351256614.0423464874336
21340.28310.86599731669929.4140026833013
22339.21309.91333065003229.296669349968
23336.71305.15466398336531.5553360166346
24340.11307.19933065003232.910669349968
25347.72311.88867327085335.8313267291475
26328.68310.93600660418617.7439933958142
27303.05306.177339937519-3.12733993751914
28299.83308.222006604186-8.39200660418582
29320.04313.6430284335786.39697156642198
30317.94312.6903617669115.24963823308864
31303.31307.931695100245-4.62169510024469
32308.85309.976361766911-1.12636176691133
33319.19315.9013943816073.28860561839269
34314.52314.948727714941-0.428727714940638
35312.39310.1900610482742.19993895172603
36315.77312.2347277149413.53527228505936
37320.23318.974656272231.25534372776959
38309.45318.021989605564-8.57198960556375
39296.54313.263322938897-16.7233229388971
40297.28315.307989605564-18.0279896055638
41301.39323.165848627452-21.7758486274525
42306.68322.213181960786-15.5331819607858
43305.91317.454515294119-11.5445152941191
44314.76319.499181960786-4.73918196078577
45323.34326.529584023624-3.18958402362447
46341.58325.57691735695816.0030826430422
47330.12320.8182506902919.3017493097089
48318.16322.862917356958-4.70291735695774
49317.84329.263698469931-11.4236984699311
50325.39328.311031803264-2.92103180326438
51327.56323.5523651365984.00763486340230
52329.77325.5970318032644.17296819673562
53333.29335.304500498324-2.0145004983237
54346.1334.35183383165711.748166168343
55358329.59316716499028.4068328350096
56344.82331.63783383165713.1821661683430
57313.3330.913378359869-17.6133783598694
58301.26329.960711693203-28.7007116932027
59306.38325.202045026536-18.8220450265360
60319.31327.246711693203-7.93671169320268


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
90.01998978123685230.03997956247370460.980010218763148
100.01623481203617320.03246962407234630.983765187963827
110.01004845278934420.02009690557868840.989951547210656
120.01663011683332040.03326023366664080.98336988316668
130.02753437114436890.05506874228873770.972465628855631
140.02503592259293280.05007184518586550.974964077407067
150.059867492989420.119734985978840.94013250701058
160.04071018098173690.08142036196347390.959289819018263
170.5113543042182230.9772913915635540.488645695781777
180.6639433787214380.6721132425571240.336056621278562
190.6211316214447770.7577367571104460.378868378555223
200.5471648044341640.9056703911316720.452835195565836
210.6733174330524860.6533651338950280.326682566947514
220.6575501075066340.6848997849867320.342449892493366
230.637099433776410.725801132447180.36290056622359
240.6286640767612270.7426718464775460.371335923238773
250.7927225600694430.4145548798611140.207277439930557
260.829799522439680.340400955120640.17020047756032
270.933613257600290.1327734847994200.0663867423997101
280.9809423087876350.03811538242473070.0190576912123654
290.9875929503677270.02481409926454500.0124070496322725
300.9880016169829930.02399676603401410.0119983830170071
310.9885609154583660.02287816908326740.0114390845416337
320.9860235914875860.02795281702482860.0139764085124143
330.990402398031530.0191952039369390.0095976019684695
340.9896411011286030.02071779774279430.0103588988713972
350.9869802917219880.02603941655602470.0130197082780124
360.9882996728263360.02340065434732790.0117003271736640
370.9966777735816930.006644452836614560.00332222641830728
380.9959298965066460.008140206986708480.00407010349335424
390.9938912497249340.01221750055013180.00610875027506588
400.9906868927316590.01862621453668280.00931310726834142
410.9855737504500290.02885249909994220.0144262495499711
420.9812209264074780.0375581471850430.0187790735925215
430.9861660922593550.02766781548128920.0138339077406446
440.9789901408655290.04201971826894210.0210098591344710
450.9621571504323970.07568569913520670.0378428495676033
460.989807638073810.02038472385238150.0101923619261907
470.9818411857989310.03631762840213780.0181588142010689
480.9664865508816420.06702689823671520.0335134491183576
490.9267888926000380.1464222147999230.0732111073999615
500.8537224116604070.2925551766791850.146277588339593
510.7211130723524480.5577738552951050.278886927647552


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level20.0465116279069767NOK
5% type I error level230.534883720930233NOK
10% type I error level280.651162790697674NOK