Multiple Linear Regression - Estimated Regression Equation
Time[t] = + 263753.723122278 -6604.16576146174Q1[t] + 14990.6169155053Q2[t] -13539.9412186187Q3[t] + 22773.0122341406Q4[t] -17536.7923706245Q5[t] -24895.40338031Q6[t] -11074.3302189309Q7[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)263753.72312227841573.1711296.344300
Q1-6604.1657614617410865.326787-0.60780.5442980.272149
Q214990.616915505313670.0543151.09660.2747110.137356
Q3-13539.941218618713415.546393-1.00930.3145980.157299
Q422773.01223414069254.1527982.46080.0150870.007543
Q5-17536.79237062457882.295556-2.22480.0277040.013852
Q6-24895.403380318721.573526-2.85450.0049710.002486
Q7-11074.33021893097356.954514-1.50530.1345190.06726


Multiple Linear Regression - Regression Statistics
Multiple R0.378825756788856
R-squared0.143508954006649
Adjusted R-squared0.100376311402668
F-TEST (value)3.32715422340948
F-TEST (DF numerator)7
F-TEST (DF denominator)139
p-value0.00262972525295913
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation80784.7735227698
Sum Squared Residuals907138969004.403


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1210907105191.33501746105715.66498254
2176508248600.070208891-72092.0702088908
3385534158697.860987325226836.139012675
4149061127339.99545532221721.0045446784
5165446172320.532004885-6874.53200488489
6237213140879.9366739496333.0633260597
7133131135502.013200656-2371.01320065601
8324799178075.912561359146723.087438641
9230964187533.30705232443430.6929476765
10236785117965.220830032118819.779169968
11215147153180.50918104961966.4908189514
12344297221499.54588347122797.45411653
13174724178075.912561359-3351.91256135859
14174415177474.02206946-3059.02206946004
15225548162637.90367201462910.0963279865
16223632172237.80220594451394.1977940561
17124817142106.178962118-17289.1789621178
18210767169147.72947671141619.270523289
19170266164879.1911962585386.80880374163
20294424199255.59673242395168.4032675768
21325107141019.365006933184087.634993067
227176134556.902855239-127380.902855239
23106408131054.65597488-24646.6559748796
2496560176517.95064422-79957.9506442198
25265769263753.7231222782015.27687772161
26149112141019.3650069338092.6349930674
27175824250639.731556119-74815.7315561191
28152871198726.53364933-45855.5336493298
29111665135643.716810424-23978.7168104242
30362301191308.000072396170992.999927604
31183167180233.6698534652933.33014653492
32329267242940.06603642586326.9339635752
33218946186224.33496520532721.665034795
34244052158416.72904456585635.2709554352
35341570167084.312141369174485.687858631
36103597109661.499474929-6064.49947492902
37256462197215.93538519559246.0646148051
38196553151812.56328310344740.436716897
39143246139640.567962433605.4320375701
40187681197215.935385195-9534.93538519487
4173566163652.948908081-90086.9489080809
42167488146999.17897211520488.8210278846
43143756111040.29651943232715.7034805683
44243199185387.1599180457811.8400819598
45152299169772.191206256-17473.191206256
46346485135322.958261286211162.041738714
47193339237443.010191019-44104.0101910189
48122774129462.386601491-6688.38660149097
49130585136268.068606703-5683.06860670306
50112611153804.860977328-41193.8609773275
51286468178158.6423603108309.3576397
52148446184019.214020095-35573.2140200947
53182079128437.66055706453641.3394429361
54140344135643.7168104244700.28318957585
55220516172237.80220594448278.1977940561
56243060210081.99581102132978.0041889789
57162765181470.873221466-18705.8732214658
58232138134556.90285523997581.097144761
59265318243446.58014431621871.4198556844
6085574141080.504161269-55506.5041612694
61225060196319.78652720328740.2134727971
62232317172036.17602892760280.8239710726
63164709149405.81616097615303.1838390238
64220801133660.75399724787140.2460027529
6599466150915.46566869-51449.4656686899
6692661175147.839402764-82486.8394027645
67133328127964.3472516015363.65274839949
6861361183394.862223816-122033.862223816
69100750148238.547683626-47488.5476836258
7010201093350.9493924828659.05060751798
71101523112127.110474617-10604.1104746169
72243511153180.50918104990330.4908189514
7322938172933.273643341-149995.273643341
74152474135643.71681042416830.2831895758
7599923123340.86902654-23417.86902654
76132487158215.102867548-25728.1028675483
77317394122728.127388084194665.872611916
7822648143484.97600662-120836.97600662
7946698149828.651713505-103130.651713505
80131698140879.93667394-9181.9366739403
81244749178782.99415657865966.0058434215
82128423187640.593272576-59217.5932725757
8397839145101.111301389-47262.111301389
84272458128566.237743499143891.762256501
85172494208820.27744364-36326.2774436404
86108043142330.612370827-34287.6123708269
87328107172177.879638696155929.120361304
88351067161527.333728714189539.666271286
89229242157412.64488832171829.3551116794
90120445117965.2208300322479.77916996843
91324598174725.003850236149872.996149764
92131069147342.398825634-16273.3988256339
93204271154923.16796725349347.8320327473
94116048146255.584870449-30207.5848704488
95250047200848.92479549949198.0752045008
96195838159253.9040917336584.0959082704
97173260155927.25212349717332.7478765031
98254488196201.00008239458286.9999176064
9992499147623.530768394-55124.5307683943
100224330135643.71681042488686.2831895759
101135781207959.604664852-72178.6046648517
10274408169772.191206256-95364.191206256
10381240192263.012807949-111023.012807949
104181633122103.77559180559529.2244081946
105271856124569.386591493147286.613408507
10695227153263.23897999-58036.2389799896
10798146199007.66559209-100861.66559209
10859194119957.518524256-60763.5185242561
109139942175621.152708228-35679.1527082279
110118612162413.58019657-43801.5801965705
11172880142188.908761059-69308.9087610588
11265475123624.276246076-58149.2762460763
113135131187592.280863151-52461.2808631506
114108446167084.312141369-58638.3121413687
115181528151812.56328310329715.436716897
116134019178075.912561359-44056.9125613586
117121848174373.09819367-52525.09819367
11881872144735.084216178-62863.0842161779
11958981122103.775591805-63122.7755918055
1205351598113.8559505348-44598.8559505348
12156375139640.56796243-83265.5679624299
12276302141785.42041298-65483.4204129797
123104011189999.027985277-85988.0279852775
12498104126089.887245764-27985.8872457641
12563123142106.178962118-78983.1789621178
1267491495958.264001938-21044.264001938
12731774133802.457607015-102028.457607015
12881437129332.293149546-47895.2931495461
12965745141161.068616701-75416.0686167007
13056653118388.05638256-61735.0563825601
131158399145631.2330741712767.7669258301
13273624164535.97134274-90911.9713427399
13351567140477.743009595-88910.7430095947
134102538153461.641123809-50923.641123809
13586678152235.398835632-65557.3988356316
136150580136268.06860670314311.9313932969
13799611158556.157377557-58945.1573775571
1389937396876.00350453412496.99649546587
13986230157037.822066796-70807.8220667959
14030837116890.01703267-86053.0170326697
14131706147200.695215866-115494.695215866
14254157138390.459752872-84233.4597528724
14364175149547.519770744-85372.5197707443
14459382124652.116390434-65270.1163904343
145119308111502.7586783387805.24132166203
14684105164476.997531913-80371.9975319127
14764187156151.685532206-91964.685532206


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
110.4767035145243980.9534070290487960.523296485475602
120.8053874356963570.3892251286072860.194612564303643
130.8198371437138670.3603257125722660.180162856286133
140.7856502923158420.4286994153683160.214349707684158
150.6982676535589540.6034646928820920.301732346441046
160.6068247090413720.7863505819172550.393175290958628
170.700006787596170.599986424807660.29999321240383
180.6155867954066260.7688264091867480.384413204593374
190.5754574421261540.8490851157476910.424542557873846
200.5221840403500370.9556319192999260.477815959649963
210.492936605250540.9858732105010790.50706339474946
220.8351607641658910.3296784716682180.164839235834109
230.8100635427894190.3798729144211620.189936457210581
240.8580146438410570.2839707123178860.141985356158943
250.823448094309010.353103811381980.17655190569099
260.8174045870523320.3651908258953370.182595412947668
270.8137899368998690.3724201262002610.186210063100131
280.8139830194912380.3720339610175240.186016980508762
290.7846771720644140.4306456558711720.215322827935586
300.8651181389401450.269763722119710.134881861059855
310.8422305280911160.3155389438177670.157769471908884
320.8633245337833570.2733509324332860.136675466216643
330.8355710201350610.3288579597298780.164428979864939
340.8186888222038620.3626223555922770.181311177796139
350.893296806333630.213406387332740.10670319366637
360.8751542944322190.2496914111355630.124845705567781
370.8592698920891060.2814602158217880.140730107910894
380.8307715660382450.338456867923510.169228433961755
390.8182159116141920.3635681767716160.181784088385808
400.7817356667448590.4365286665102810.218264333255141
410.8036230867204680.3927538265590640.196376913279532
420.7678375214663990.4643249570672030.232162478533601
430.7264141356929460.5471717286141090.273585864307054
440.693532452294890.6129350954102210.30646754770511
450.6560193637362090.6879612725275820.343980636263791
460.849281135212890.3014377295742210.15071886478711
470.8359664812170860.3280670375658280.164033518782914
480.8082793822360060.3834412355279880.191720617763994
490.788818918170130.422362163659740.21118108182987
500.7827375420884590.4345249158230820.217262457911541
510.8043247554793340.3913504890413330.195675244520666
520.7791951760919660.4416096478160670.220804823908034
530.755790237312330.4884195253753390.24420976268767
540.7211606685910640.5576786628178730.278839331408936
550.6943670570835760.6112658858328470.305632942916424
560.65990289284490.68019421431020.3400971071551
570.624562033921060.7508759321578810.37543796607894
580.6309534573918810.7380930852162380.369046542608119
590.5959244912495290.8081510175009420.404075508750471
600.5728312791917370.8543374416165260.427168720808263
610.5371195917782970.9257608164434060.462880408221703
620.5137197922706910.9725604154586190.486280207729309
630.4715256913687190.9430513827374370.528474308631281
640.4652276941730360.9304553883460710.534772305826964
650.4546261870024680.9092523740049360.545373812997532
660.4969193583989770.9938387167979540.503080641601023
670.4519508244176890.9039016488353780.548049175582311
680.5242733143238020.9514533713523970.475726685676198
690.4907058683975080.9814117367950170.509294131602491
700.4532241227034390.9064482454068790.546775877296561
710.411018309127890.822036618255780.58898169087211
720.4292491137864640.8584982275729280.570750886213536
730.5429632145553470.9140735708893050.457036785444653
740.5040425768388270.9919148463223470.495957423161173
750.4629773394083320.9259546788166650.537022660591668
760.4236340957501250.8472681915002510.576365904249875
770.6650575798975880.6698848402048250.334942420102412
780.7157846542047050.5684306915905890.284215345795295
790.761527414570990.4769451708580210.23847258542901
800.7264502509083530.5470994981832950.273549749091647
810.7329325563993410.5341348872013180.267067443600659
820.7054239246355080.5891521507289850.294576075364492
830.6768667825936350.646266434812730.323133217406365
840.8039551224795830.3920897550408340.196044877520417
850.7935048655360520.4129902689278960.206495134463948
860.7745596096546490.4508807806907010.225440390345351
870.890909315806240.218181368387520.10909068419376
880.9875618782842750.02487624343144970.0124381217157249
890.9895656783303630.02086864333927330.0104343216696366
900.9853321456122490.02933570877550240.0146678543877512
910.9980037881931690.003992423613662060.00199621180683103
920.9971231987485370.005753602502926890.00287680125146345
930.9986930991659590.002613801668081540.00130690083404077
940.9981787978334210.003642404333158240.00182120216657912
950.9986131123972340.002773775205531930.00138688760276596
960.9985030474712720.002993905057455490.00149695252872774
970.9986604300790140.002679139841972450.00133956992098622
980.9998449361961030.0003101276077935090.000155063803896754
990.9997974373539260.0004051252921480820.000202562646074041
1000.9999244858001410.0001510283997183667.55141998591829e-05
1010.9999045286175050.0001909427649896429.54713824948208e-05
1020.9998977349630070.0002045300739856550.000102265036992828
1030.9998530850090460.0002938299819072410.00014691499095362
1040.9999346827273330.0001306345453338926.53172726669462e-05
1050.9999999846014463.0797107732755e-081.53985538663775e-08
1060.9999999662771996.74456028605152e-083.37228014302576e-08
1070.9999999457663111.08467377461122e-075.42336887305609e-08
1080.999999886767812.2646437916068e-071.1323218958034e-07
1090.9999997177234385.64553123400755e-072.82276561700378e-07
1100.999999537488169.25023680218919e-074.6251184010946e-07
1110.9999990554568441.8890863115007e-069.4454315575035e-07
1120.9999981278281523.74434369697354e-061.87217184848677e-06
1130.9999977754341954.44913161028628e-062.22456580514314e-06
1140.999995277130279.44573946027425e-064.72286973013713e-06
1150.9999980231876093.95362478255802e-061.97681239127901e-06
1160.99999648774537.02450939895812e-063.51225469947906e-06
1170.9999972919684615.41606307808756e-062.70803153904378e-06
1180.999993560641121.28787177600588e-056.43935888002939e-06
1190.9999856462877082.87074245840311e-051.43537122920156e-05
1200.9999728105008985.43789982036134e-052.71894991018067e-05
1210.9999425594099220.0001148811801551765.74405900775881e-05
1220.9998687465525110.0002625068949770240.000131253447488512
1230.9997178243300310.0005643513399385330.000282175669969266
1240.9993658441528150.001268311694369660.000634155847184831
1250.9988355311369670.002328937726065320.00116446886303266
1260.997431793230340.005136413539319160.00256820676965958
1270.9973565986974430.005286802605113510.00264340130255675
1280.9949980043974240.01000399120515150.00500199560257575
1290.989882064225780.02023587154844030.0101179357742202
1300.9800282744242360.03994345115152760.0199717255757638
1310.9821728515384060.03565429692318910.0178271484615945
1320.9699753194942790.06004936101144260.0300246805057213
1330.9505613347903970.09887733041920590.049438665209603
1340.8991990016492230.2016019967015540.100800998350777
1350.8075763721072870.3848472557854250.192423627892712
1360.9314913245917850.137017350816430.068508675408215


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level370.293650793650794NOK
5% type I error level440.349206349206349NOK
10% type I error level460.365079365079365NOK