Multiple Linear Regression - Estimated Regression Equation
Y_t[t] = + 20.9911446404945 + 0.485054135605806X_1t[t] -0.380396689533934X_2t[t] -0.84860944516033X_4t[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)20.99114464049451.8891311.111500
X_1t0.4850541356058060.04156711.669100
X_2t-0.3803966895339340.028708-13.250500
X_4t-0.848609445160330.198261-4.28035.3e-052.6e-05


Multiple Linear Regression - Regression Statistics
Multiple R0.911697011378877
R-squared0.831191440557176
Adjusted R-squared0.824698803655529
F-TEST (value)128.020626002714
F-TEST (DF numerator)3
F-TEST (DF denominator)78
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4.06295238811674
Sum Squared Residuals1287.59140443207


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1-3-6.688689590993693.68868959099369
2-4-4.335334767677020.335334767677024
3-7-3.97177945812249-3.02822054187751
4-7-5.92789621192582-1.07210378807418
5-7-4.02136242946141-2.97863757053859
6-3-2.01472153571987-0.985278464280133
70-0.1577707245943670.157770724594367
8-5-2.51206671651035-2.48793328348965
9-3-1.6793574827301-1.3206425172699
1030.9001536127097082.09984638729029
112-1.833597900140883.83359790014088
12-7-5.50926642763832-1.49073357236168
13-1-0.399827208097607-0.600172791902393
140-1.699808028904921.69980802890492
15-30.553439683134595-3.5534396831346
1643.204866633286780.795133366713215
1721.055335198719810.944664801280188
1831.435731888253751.56426811174625
190-1.938255346212751.93825534621275
20-10-3.20094424086584-6.79905575913416
21-10-6.49166574403461-3.50833425596539
22-9-5.0533447171966-3.9466552828034
23-22-13.6041366911215-8.39586330887854
24-16-14.9714830318464-1.02851696815359
25-18-17.4304364698343-0.569563530165736
26-14-16.54814426471512.54814426471511
27-12-18.08657240283036.08657240283026
28-17-22.71095748676525.71095748676517
29-23-21.3445523146395-1.65544768536046
30-28-23.4772423692271-4.5227576307729
31-31-27.4960156601042-3.50398433989575
32-21-26.04085325328685.04085325328682
33-19-23.75753194748394.7575319474839
34-22-24.83323883336672.83323883336671
35-22-22.32470242403990.324702424039949
36-25-23.5378083473541-1.46219165264587
37-16-18.76828351559792.76828351559791
38-22-19.170071919906-2.829928080094
39-21-14.5839199307246-6.41608006927536
40-10-14.46242110467344.46242110467336
41-7-10.54924642846743.54924642846742
42-5-10.67435442071415.67435442071411
43-4-4.39098354121210.390983541212099
447-1.893797008470698.89379700847069
4561.755929469457874.24407053054213
4634.42325663099014-1.42325663099014
47105.172700133472664.82729986652734
4806.65605379685484-6.65605379685484
49-21.98208574158102-3.98208574158102
50-13.23248359104944-4.23248359104944
512-0.5546419243104872.55464192431049
5283.970577216946614.02942278305339
53-6-1.98841261635376-4.01158738364624
54-4-0.742565101680088-3.25743489831991
5542.222834186687721.77716581331228
5676.400398229770380.599601770229623
5732.123668244009910.876331755990091
583-2.533458431284495.53345843128449
5980.1889432049807477.81105679501925
603-1.095137404446494.09513740444649
61-3-1.63071567999052-1.36928432000948
6240.8664708527508873.13352914724911
63-5-6.278741685695451.27874168569545
64-1-2.244068183438221.24406818343822
655-0.1823528149637145.18235281496371
660-1.400009073072631.40000907307263
67-6-3.26830976078348-2.73169023921652
68-13-10.6487792409424-2.35122075905755
69-15-5.75414641693954-9.24585358306046
70-8-10.15237522875132.15237522875129
71-20-16.1441066534112-3.85589334658884
72-10-15.22452252213785.22452252213778
73-22-16.9554241724173-5.04457582758274
74-25-19.1927716730767-5.80722832692331
75-10-14.65165232043954.65165232043951
76-8-13.28336481111525.28336481111522
77-9-8.24584144628689-0.754158553713111
78-5-5.891545454370910.891545454370909
79-7-2.09986960421625-4.90013039578375
80-11-5.04293600921058-5.95706399078942
81-11-6.22235917256594-4.77764082743406
82-16-11.6243790155481-4.37562098445188


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
70.2242256431559230.4484512863118450.775774356844077
80.1068252114898460.2136504229796920.893174788510154
90.05357118659768390.1071423731953680.946428813402316
100.04827882776441660.09655765552883320.951721172235583
110.02524495074282860.05048990148565730.974755049257171
120.02695216594143380.05390433188286750.973047834058566
130.02011345151640770.04022690303281530.979886548483592
140.009689072290389970.01937814458077990.99031092770961
150.01459201487693350.0291840297538670.985407985123066
160.007129509860950980.0142590197219020.992870490139049
170.003471573903954510.006943147807909010.996528426096046
180.001848468973411920.003696937946823840.998151531026588
190.000896348226053670.001792696452107340.999103651773946
200.009469418441673210.01893883688334640.990530581558327
210.00589953672584370.01179907345168740.994100463274156
220.003774715075626020.007549430151252040.996225284924374
230.00345267585612510.00690535171225020.996547324143875
240.01416565195320840.02833130390641680.985834348046792
250.02126218809390660.04252437618781320.978737811906093
260.03582489579576630.07164979159153250.964175104204234
270.09892914658286520.197858293165730.901070853417135
280.1205999962483530.2411999924967060.879400003751647
290.09301978400845520.186039568016910.906980215991545
300.09782799891686850.1956559978337370.902172001083131
310.07798319713118830.1559663942623770.922016802868812
320.1233669259723420.2467338519446850.876633074027658
330.1293756701285990.2587513402571980.870624329871401
340.119698955052020.239397910104040.88030104494798
350.09085530550531360.1817106110106270.909144694494686
360.06836712146837930.1367342429367590.931632878531621
370.06459382250841590.1291876450168320.935406177491584
380.05357193748380710.1071438749676140.946428062516193
390.05807837274814590.1161567454962920.941921627251854
400.08817372236643050.1763474447328610.911826277633569
410.1161565228836170.2323130457672340.883843477116383
420.1486300135659230.2972600271318460.851369986434077
430.1224856223658130.2449712447316260.877514377634187
440.3427621802063640.6855243604127280.657237819793636
450.3714916248650720.7429832497301440.628508375134928
460.3428007077959820.6856014155919640.657199292204018
470.4469254017838250.893850803567650.553074598216175
480.5193482214523210.9613035570953590.480651778547679
490.4994536258136150.9989072516272290.500546374186385
500.4660211309565460.9320422619130920.533978869043454
510.4642838361031630.9285676722063260.535716163896837
520.4896988885627520.9793977771255040.510301111437248
530.445756595753620.8915131915072390.55424340424638
540.390381954181430.7807639083628590.60961804581857
550.37581306233170.75162612466340.6241869376683
560.3507285371407580.7014570742815150.649271462859242
570.2960830531722660.5921661063445320.703916946827734
580.2990738280107720.5981476560215450.700926171989227
590.4266646017428660.8533292034857330.573335398257134
600.4718511598879910.9437023197759830.528148840112008
610.4026775755891980.8053551511783960.597322424410802
620.4099528097206590.8199056194413180.590047190279341
630.3533319863074850.706663972614970.646668013692515
640.2954580244954410.5909160489908820.704541975504559
650.2521296202395630.5042592404791270.747870379760437
660.2017398911032710.4034797822065410.798260108896729
670.2117434839158920.4234869678317850.788256516084108
680.4297580571948020.8595161143896030.570241942805198
690.5128209760134510.9743580479730980.487179023986549
700.569271718069010.8614565638619790.43072828193099
710.469532512291520.9390650245830410.53046748770848
720.6516636551347210.6966726897305580.348336344865279
730.8794792311527510.2410415376944980.120520768847249
740.800286401920710.3994271961585810.19971359807929
750.716518786281780.566962427436440.28348121371822


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level50.072463768115942NOK
5% type I error level130.188405797101449NOK
10% type I error level170.246376811594203NOK