Multiple Linear Regression - Estimated Regression Equation
QBEFRU[t] = -77762.8038393112 + 43308.2898165855PBEPIL[t] -13371.5549986481PBEFRU[t] -71801.4106895052PBEREG[t] -25052.210867151PCHEXO[t] + 79708.4302130641PAMMOORA[t] + 1884.30016541286PAMMOAPP[t] -4757.99338540753PAMMOGRA[t] -107690.203091025PSOCOLA[t] + 260892.453821228PSOLEM[t] -92735.8580943806PSTILL[t] + 0.0390542002511986BUDBEER[t] + 0.00893580719412229BUDCHIL[t] -0.0140084185334704BUDAMB[t] + 0.00419180585976342`BUDSISSS\r`[t] + 2224.18026740329Q1[t] + 1808.5633525552Q2[t] + 2022.30010055336Q3[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-77762.8038393112110800.077985-0.70180.4842410.242121
PBEPIL43308.289816585559771.6200730.72460.4702310.235116
PBEFRU-13371.554998648118882.596805-0.70810.4803280.240164
PBEREG-71801.410689505212493.244337-5.747200
PCHEXO-25052.21086715115294.6052-1.6380.1042330.052117
PAMMOORA79708.430213064129458.323592.70580.007880.00394
PAMMOAPP1884.300165412866128.144870.30750.7590470.379523
PAMMOGRA-4757.993385407533568.908872-1.33320.1851790.092589
PSOCOLA-107690.20309102557580.799211-1.87020.0640610.03203
PSOLEM260892.45382122880705.2231053.23270.0016110.000806
PSTILL-92735.858094380647177.427055-1.96570.051810.025905
BUDBEER0.03905420025119860.00178621.870200
BUDCHIL0.008935807194122290.0111310.80280.4238190.211909
BUDAMB-0.01400841853347040.006249-2.24170.0269510.013476
`BUDSISSS\r`0.004191805859763420.0011353.69210.0003450.000173
Q12224.180267403292564.5497590.86730.3876430.193822
Q21808.56335255522608.0072530.69350.4894530.244727
Q32022.300100553362578.5653780.78430.4345350.217268


Multiple Linear Regression - Regression Statistics
Multiple R0.978990451586407
R-squared0.958422304297357
Adjusted R-squared0.952111404056777
F-TEST (value)151.867763355631
F-TEST (DF numerator)17
F-TEST (DF denominator)112
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation10119.4549718129
Sum Squared Residuals11469177319.7734


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1178421174252.5764413524168.42355864765
2139871146326.357230263-6455.35723026324
3118159117605.037680353553.962319646565
4109763112449.081990878-2686.08199087846
597415101653.009022982-4238.00902298225
6119190120275.410975313-1085.41097531269
797903106507.621150224-8604.62115022355
896953101053.073909253-4100.07390925259
98788893659.4976417386-5771.49764173862
108463786991.0364956655-2354.03649566549
119054991119.6688360451-570.668836045131
129568095673.65839458256.34160541749409
1399371127630.376605148-28259.3766051476
147998494128.0875274437-14144.0875274437
158675276725.031775716410026.9682242836
168573375384.061737897510348.9382621025
178490672221.916750531712684.0832494683
187835669511.46637032418844.53362967595
19108895123602.102781653-14707.1027816529
2010176894101.73335188627666.26664811379
217328547644.632822459625640.3671775404
226572451185.843452989914538.1565470101
236745756599.468630978110857.5313690219
246720362648.36421985434554.63578014569
256927359120.136741751610152.8632582484
268080783534.8887210426-2727.88872104259
277512978478.6435434903-3349.64354349031
287499183267.6490473722-8276.64904737224
296815766916.28593510441240.71406489561
307385885029.3319896892-11171.3319896892
317134972752.450009957-1403.45000995695
328563483095.78296417592538.21703582406
339162488879.70362343182744.29637656821
34116014118074.910089184-2060.91008918371
35120033129778.236111574-9745.23611157394
3610865194641.316351706614009.6836482934
37105378118143.125319222-12765.1253192218
38138939145695.730863025-6756.73086302471
39132974127893.4151912955080.58480870503
40135277147227.403882359-11950.4038823594
41152741141469.96037452511271.0396254754
42158417153698.7855688864718.21443111414
43157460151187.5944569186272.40554308191
44193997181566.67999709312430.320002907
45154089152692.5628813591396.43711864106
46147570149942.965528782-2372.96552878168
47162924177938.137402041-15014.1374020405
48153629152440.3391186671188.66088133288
49155907150483.514111355423.48588865042
50197675196408.4661346851266.5338653154
51250708240506.82158011310201.1784198869
52266652248437.12187964118214.8781203594
53209842213000.915126675-3158.91512667521
54165826163113.6097349852712.39026501531
55137152141279.70892976-4127.70892975958
56150581155660.473530942-5079.47353094177
57145973148121.870456837-2148.87045683697
58126532114341.92721209212190.0727879081
59115437101182.1156956714254.8843043304
60119526116939.4159717652586.58402823465
61110856113361.963557992-2505.96355799232
629724397484.0373703408-241.037370340758
63103876104437.390727651-561.390727650967
64116370123790.786885116-7420.78688511552
65109616107112.1252150332503.87478496683
669836594151.28841983394213.71158016605
679044085823.77303614934616.22696385073
688889982026.8035844376872.19641556298
699235890303.66373233362054.33626766642
708839483922.55778077224471.44221922775
7198219107973.621212342-9754.62121234163
72113546118961.412749289-5415.41274928863
73107168108848.706519286-1680.7065192858
747754064660.342389667412879.6576103326
757494471247.10694092563696.89305907438
767564175679.4366843709-38.4366843709458
777591080189.963968932-4279.963968932
7887384100885.41892478-13501.4189247804
798461586733.4703155061-2118.47031550612
808042087148.4902119244-6728.49021192437
818078493498.5853520564-12714.5853520564
827993388900.4914115843-8967.49141158425
838211893466.1322593413-11348.1322593413
8491420104223.788601321-12803.7886013211
85112426128929.455503187-16503.4555031868
86114528117049.700792609-2521.70079260946
87131025124100.8624445346924.13755546634
88116460127356.447435406-10896.4474354065
89111258124375.409256979-13117.4092569792
90155318153079.2611889042238.73881109569
91155078166970.128304246-11892.1283042463
92134794148310.763909865-13516.7639098653
93139985150146.960651852-10161.960651852
94198778212034.08828941-13256.0882894099
95172436171601.498863907834.501136092926
96169585164280.5919932225304.40800677783
97203702204147.117789087-445.117789086595
98282392275030.8110074277361.18899257318
99220658210523.09640679210134.9035932079
100194472189228.2822840585243.71771594188
101269246260275.0901703818970.90982961866
102215340188185.25469567827154.7453043222
103218319207426.65830034510892.3416996553
104195724201283.540272683-5559.54027268276
105174614166956.5765278477657.423472153
106172085164724.7328797797360.26712022059
107152347148366.3866751423980.61332485836
108189615186392.3259474313222.67405256864
109173804165365.6001806758438.39981932471
110145683141858.6964062073824.30359379344
111133550134032.668039587-482.668039586615
112121156123122.596478158-1966.59647815834
113112040109601.9464337872438.05356621251
114120767128990.8956592-8223.89565919975
115127019116316.52685040610702.4731495935
116136295139682.580235073-3387.58023507308
117113425118244.442397444-4819.44239744417
118107815119221.176684486-11406.1766844858
119100298110761.549833771-10463.5498337714
1209704880614.250755035416433.7492449646
1219875099751.7602932835-1001.76029328348
12298235121390.161926378-23155.1619263779
123101254112919.499788694-11665.4997886939
124139589152655.266632129-13066.2666321287
125134921125932.3192554058988.68074459526
1268035561104.004831242119250.9951687579
1278039673616.57622487486779.42377512523
1288218379911.4789924072271.52100759298
1297970971910.22933997177798.77066002829
1309078193404.2614473332-2623.26144733324


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.2094308151037280.4188616302074550.790569184896272
220.2617745215878830.5235490431757660.738225478412117
230.1577396325761470.3154792651522940.842260367423853
240.531829080378250.9363418392435010.46817091962175
250.4274888770480390.8549777540960770.572511122951961
260.3195769463585660.6391538927171310.680423053641434
270.2418178863804840.4836357727609670.758182113619516
280.1819050984908180.3638101969816370.818094901509182
290.1300304119851190.2600608239702370.869969588014881
300.09424821056606250.1884964211321250.905751789433938
310.06153789253770140.1230757850754030.938462107462299
320.04813325811543670.09626651623087340.951866741884563
330.03796085483747350.07592170967494710.962039145162526
340.03227765253145270.06455530506290550.967722347468547
350.04020102503827170.08040205007654330.959798974961728
360.02898691785606670.05797383571213340.971013082143933
370.1088975077690040.2177950155380080.891102492230996
380.105084631459220.210169262918440.89491536854078
390.08633553120566360.1726710624113270.913664468794336
400.09068341136033870.1813668227206770.909316588639661
410.2258555294413550.4517110588827110.774144470558645
420.2249559130288140.4499118260576270.775044086971187
430.2455159642709130.4910319285418260.754484035729087
440.3300603291093490.6601206582186990.669939670890651
450.2835893109584550.567178621916910.716410689041545
460.2354675994378150.470935198875630.764532400562185
470.25024956952640.5004991390528010.7497504304736
480.2039325767263030.4078651534526060.796067423273697
490.1662467555855110.3324935111710220.833753244414489
500.1447604682970240.2895209365940490.855239531702976
510.2037038078811860.4074076157623710.796296192118814
520.2835938798057330.5671877596114650.716406120194267
530.2791227242119750.5582454484239490.720877275788025
540.246194355524850.49238871104970.75380564447515
550.2082196651028780.4164393302057560.791780334897122
560.1889702617524670.3779405235049330.811029738247533
570.1607301620300440.3214603240600880.839269837969956
580.1723649036116150.344729807223230.827635096388385
590.1814507153113970.3629014306227940.818549284688603
600.1827989589386210.3655979178772420.817201041061379
610.1563039416645370.3126078833290750.843696058335463
620.1518923793800730.3037847587601460.848107620619927
630.1208271226396710.2416542452793410.879172877360329
640.1132258198720950.226451639744190.886774180127905
650.1150116401331150.230023280266230.884988359866885
660.09809279060199940.1961855812039990.901907209398001
670.08473977604606960.1694795520921390.91526022395393
680.08980080852790280.1796016170558060.910199191472097
690.09758515041708780.1951703008341760.902414849582912
700.1009719238290860.2019438476581710.899028076170915
710.1376104345012740.2752208690025480.862389565498726
720.1286385272899960.2572770545799910.871361472710005
730.12550071585790.2510014317157990.8744992841421
740.36500005457370.73000010914740.6349999454263
750.3471092919601030.6942185839202050.652890708039897
760.3245380448510190.6490760897020370.675461955148981
770.3025751159844750.6051502319689510.697424884015525
780.3858425818946470.7716851637892950.614157418105353
790.3506303072328310.7012606144656610.649369692767169
800.3246416205014650.6492832410029310.675358379498535
810.3232114362122570.6464228724245130.676788563787743
820.3247756456193360.6495512912386710.675224354380664
830.3340327791913140.6680655583826280.665967220808686
840.3807233970711820.7614467941423650.619276602928818
850.4438154185735850.887630837147170.556184581426415
860.3834157920132350.7668315840264690.616584207986765
870.3594270836785670.7188541673571340.640572916321433
880.3514403690199480.7028807380398960.648559630980052
890.6354530542661420.7290938914677150.364546945733858
900.5926497542480820.8147004915038360.407350245751918
910.5959691937645610.8080616124708780.404030806235439
920.5952183466436550.809563306712690.404781653356345
930.5244493968987120.9511012062025770.475550603101288
940.5030565217773420.9938869564453170.496943478222658
950.5329603535993060.9340792928013880.467039646400694
960.4660705285461870.9321410570923730.533929471453813
970.5465039944188780.9069920111622440.453496005581122
980.5061554573315720.9876890853368560.493844542668428
990.5521965073768570.8956069852462860.447803492623143
1000.4974151264635070.9948302529270140.502584873536493
1010.5130467948572880.9739064102854240.486953205142712
1020.4937645181424730.9875290362849450.506235481857527
1030.7284213034969430.5431573930061150.271578696503057
1040.6327105367294230.7345789265411540.367289463270577
1050.635412431158230.7291751376835410.36458756884177
1060.7431637593214620.5136724813570770.256836240678538
1070.7325564889315270.5348870221369460.267443511068473
1080.5947831047682860.8104337904634290.405216895231714
1090.4588534696468090.9177069392936180.541146530353191


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level00OK
10% type I error level50.0561797752808989OK