Multiple Linear Regression - Estimated Regression Equation
Y_t[t] = + 25.8050372634699 + 0.428060309492314X_1t[t] -0.450777521641689X_2t[t] -0.0776137468286691X_3t[t] -0.816444705642473X_4t[t] + 0.00518584246664621X_5t[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)25.80503726346994.0645816.348800
X_1t0.4280603094923140.0596897.171500
X_2t-0.4507775216416890.064245-7.016600
X_3t-0.07761374682866910.062086-1.25010.21510.10755
X_4t-0.8164447056424730.204637-3.98970.0001517.6e-05
X_5t0.005185842466646210.0809310.06410.9490770.474539


Multiple Linear Regression - Regression Statistics
Multiple R0.913826048354758
R-squared0.835078046651673
Adjusted R-squared0.824227918141914
F-TEST (value)76.9648069975043
F-TEST (DF numerator)5
F-TEST (DF denominator)76
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.06840558070266
Sum Squared Residuals1257.94622165103


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1-3-6.599547208029443.59954720802944
2-4-4.042385541311720.042385541311725
3-7-4.18692568802895-2.81307431197105
4-7-5.77560591157472-1.22439408842528
5-7-4.3950629527413-2.6049370472587
6-3-1.87936678170078-1.12063321829922
70-0.7845748344083680.784574834408368
8-5-2.36867028107771-2.63132971892229
9-3-1.992704158679-1.007295841321
1031.083399587470011.91660041252999
112-2.017710875117984.01771087511798
12-7-6.91676631850706-0.0832336814929382
13-1-0.63648578144448-0.36351421855552
140-1.373321653919511.37332165391951
15-30.431395802096771-3.43139580209677
1643.214751867847120.785248132152878
1721.211734744699730.788265255300269
1831.667698108808071.33230189119193
190-2.06724767715962.0672476771596
20-10-3.08155910621677-6.91844089378323
21-10-6.0593856352502-3.9406143647498
22-9-4.53232868741676-4.46767131258324
23-22-13.3483955350016-8.65160446499836
24-16-14.4227893412048-1.57721065879525
25-18-16.8742196881066-1.1257803118934
26-14-15.52417662747111.52417662747114
27-12-17.26038155820535.26038155820532
28-17-22.1604934539655.16049345396497
29-23-20.8787992110669-2.1212007889331
30-28-22.3383570905218-5.66164290947817
31-31-26.4443318401902-4.55566815980979
32-21-25.48097758396124.48097758396124
33-19-23.01455405543494.01455405543492
34-22-25.1879200098533.18792000985297
35-22-23.70293028560211.70293028560211
36-25-25.26449854836710.264498548367052
37-16-19.4566396472963.456639647296
38-22-19.7121897772169-2.2878102227831
39-21-14.7568573620567-6.24314263794334
40-10-14.72755313364784.7275531336478
41-7-10.80538479144063.80538479144063
42-5-10.3496276229895.34962762298898
43-4-3.59062077548652-0.409379224513484
447-1.235897687718438.23589768771843
4562.822501180849613.17749881915039
4635.31669705358583-2.31669705358583
47105.370111345222434.62988865477757
4806.93873033374168-6.93873033374168
49-22.23410743481298-4.23410743481298
50-12.95416054332851-3.95416054332851
512-1.154837347948943.15483734794894
5283.515168676672224.48483132332778
53-6-2.06519411818378-3.93480588181622
54-4-0.171539167740823-3.82846083225918
5542.621279008390071.37872099160993
5676.246415079570190.753584920429807
5732.261874855927480.738125144072518
583-2.328670383014265.32867038301426
5980.1312113560797387.86878864392026
603-0.5687721946948073.56877219469481
61-3-1.11158397629969-1.88841602370031
6241.165525364639732.83447463536027
63-5-6.326099051294611.3260990512946
64-1-2.524668131869271.52466813186927
655-0.6847655487958955.6847655487959
660-1.528216655843151.52821665584315
67-6-3.32611965588727-2.67388034411273
68-13-10.4591317048472-2.54086829515285
69-15-5.17945787658978-9.82054212341022
70-8-9.560627692918111.56062769291811
71-20-16.1456716845769-3.85432831542307
72-10-15.10421923532355.10421923532349
73-22-17.0947361380775-4.9052638619225
74-25-19.6750396379465-5.32496036205349
75-10-14.93205428452944.93205428452936
76-8-14.02364806545916.02364806545906
77-9-8.58907072826565-0.410929271734354
78-5-6.601349020053031.60134902005303
79-7-3.14841206506453-3.85158793493547
80-11-6.63865552952591-4.36134447047409
81-11-6.99403092817307-4.00596907182693
82-16-13.0029468014317-2.99705319856833


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
90.2028754612663840.4057509225327690.797124538733616
100.09717027781360470.1943405556272090.902829722186395
110.04608492002809740.09216984005619470.953915079971903
120.01819306563624080.03638613127248170.981806934363759
130.01774716824188440.03549433648376870.982252831758116
140.008908199001472950.01781639800294590.991091800998527
150.02011777509385740.04023555018771480.979882224906143
160.009478354528368630.01895670905673730.990521645471631
170.004370182015541070.008740364031082130.995629817984459
180.002117632753827050.004235265507654090.997882367246173
190.0009061939040116830.001812387808023370.999093806095988
200.0179954122119960.03599082442399210.982004587788004
210.01231563019321440.02463126038642870.987684369806786
220.008934557162968620.01786911432593720.991065442837031
230.008891602261929110.01778320452385820.991108397738071
240.0250404994770240.0500809989540480.974959500522976
250.03104389399615060.06208778799230110.968956106003849
260.04319380512377050.08638761024754090.95680619487623
270.08990974184170710.1798194836834140.910090258158293
280.1126542170731440.2253084341462890.887345782926856
290.08088564329185780.1617712865837160.919114356708142
300.0752523490025860.1505046980051720.924747650997414
310.07381254711130360.1476250942226070.926187452888696
320.171426434124230.342852868248460.82857356587577
330.1902386330039910.3804772660079810.809761366996009
340.1754022099946590.3508044199893180.824597790005341
350.1345219266337260.2690438532674520.865478073366274
360.1015809881886620.2031619763773230.898419011811338
370.09101750653139680.1820350130627940.908982493468603
380.07816106282172950.1563221256434590.92183893717827
390.08547540500926680.1709508100185340.914524594990733
400.1246008274584630.2492016549169260.875399172541537
410.1567450708457340.3134901416914670.843254929154266
420.1837849874299250.3675699748598490.816215012570075
430.1464800989603810.2929601979207610.853519901039619
440.332924365995090.6658487319901790.66707563400491
450.3363936109792710.6727872219585430.663606389020729
460.3125626091111120.6251252182222240.687437390888888
470.4161607731704250.832321546340850.583839226829575
480.4844765710374210.9689531420748410.515523428962579
490.4666879071844940.9333758143689880.533312092815506
500.4247395151129360.8494790302258720.575260484887064
510.424085810711470.8481716214229390.57591418928853
520.4762805897818190.9525611795636380.523719410218181
530.4281785055680470.8563570111360930.571821494431953
540.3733082032386380.7466164064772760.626691796761362
550.3434236234455460.6868472468910920.656576376554454
560.3354401418617220.6708802837234440.664559858138278
570.2930190484208690.5860380968417390.706980951579131
580.313540885755990.627081771511980.68645911424401
590.4557719700197670.9115439400395330.544228029980233
600.503407433301050.9931851333978990.49659256669895
610.4292284895451520.8584569790903040.570771510454848
620.4386498116490920.8772996232981840.561350188350908
630.4178419343591650.8356838687183310.582158065640835
640.3448296584599650.689659316919930.655170341540035
650.3583071016091350.716614203218270.641692898390865
660.3407087142648410.6814174285296820.659291285735159
670.2658559436484650.5317118872969290.734144056351535
680.3447453447391160.6894906894782320.655254655260884
690.6576315077738550.6847369844522890.342368492226145
700.5755620893680950.8488758212638090.424437910631904
710.4752256323381870.9504512646763740.524774367661813
720.5589858702480480.8820282595039040.441014129751952
730.8534444259152250.293111148169550.146555574084775


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level30.0461538461538462NOK
5% type I error level120.184615384615385NOK
10% type I error level160.246153846153846NOK