Multiple Linear Regression - Estimated Regression Equation
X_1[t] = -0.293680794030562 + 0.978370136065127X_2[t] -1.1065710161433X_3[t] -0.93424923909017X_4[t] + 3.97683039702274Y_1[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-0.2936807940305620.579935-0.50640.6140020.307001
X_20.9783701360651270.01867652.387800
X_3-1.10657101614330.11765-9.405600
X_4-0.934249239090170.044671-20.913800
Y_13.976830397022740.0718655.34100


Multiple Linear Regression - Regression Statistics
Multiple R0.993907933164318
R-squared0.987852979606966
Adjusted R-squared0.987230055484246
F-TEST (value)1585.83195541369
F-TEST (DF numerator)4
F-TEST (DF denominator)78
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation1.33580309255728
Sum Squared Residuals139.180852362675


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
10-0.4876206569010710.487620656901071
2-2-2.87574510253380.875745102533799
3-4-2.93909495529603-1.06090504470397
4-6-6.612742058894470.612742058894466
5-2-1.85741588034041-0.142584119659593
610.1860650111860490.813934988813951
777.11723477219144-0.117234772191438
823.15963333095597-1.15963333095597
921.528307657144710.471692342855292
101312.38918456909040.610815430909555
1178.32561355267151-1.32561355267151
12-1-2.878405738826771.87840573882677
1311.98555065120375-0.98555065120375
1402.33019420531001-2.33019420531001
150-1.751446305156931.75144630515693
1654.914998073998710.0850019260012877
1735.30792433592663-2.30792433592663
1867.17642281410697-1.17642281410697
1978.23887293327531-1.23887293327531
20-6-3.45594662797754-2.54405337202246
21-8-7.6960012322963-0.303998767703699
22-5-5.458308971636460.45830897163646
23-14-15.41399039652641.41399039652642
24-13-12.5245020598597-0.47549794014029
25-15-14.3941599997793-0.605840000220685
26-14-13.7619345923742-0.238065407625838
27-10-10.50707257126020.507072571260207
28-14-15.61236357650651.6123635765065
29-18-16.5865719017249-1.41342809827507
30-22-19.3961420661351-2.60385793386488
31-24-23.4762814020483-0.523718597951658
32-17-15.8657629875554-1.13423701244459
33-16-13.8181202851823-2.18187971481773
34-17-17.73391975292130.73391975292131
35-22-22.97981814689340.979818146893363
36-25-25.1541605547910.154160554790966
37-18-20.21136653035072.2113665303507
38-23-22.4905190516925-0.509480948307489
39-20-20.12578537269380.12578537269377
40-9-8.56066786607281-0.439332133927195
41-4-6.821871442524362.82187144252436
4201.3523938363959-1.3523938363959
4333.60399378025705-0.603993780257049
441415.6238862270144-1.62388622701444
451312.58130506908190.418694930918129
461213.3432325311189-1.34323253111891
471617.4950453414878-1.49504534148775
4877.39193408073237-0.391934080732367
4922.50158457496044-0.501584574960441
501-0.3245539089440371.32455390894404
5174.652536216224082.34746378377592
52109.728773469435990.271226530564007
5333.8174341051777-0.817434105177705
5423.68773205054582-1.68773205054582
551210.61323882615081.38676117384921
561413.67921075071730.320789249282671
571111.8906304447935-0.890630444793508
581311.87256095074551.12743904925449
591715.21416359125571.78583640874434
601412.49549585708841.50450414291163
6175.625015312552221.37498468744778
621613.42824392162482.57175607837518
6354.489390544374540.510609455625463
6455.64424426833949-0.644244268339493
651513.2283695670911.77163043290898
6698.383642132847770.616357867152227
6745.27204813675257-1.27204813675257
68-9-10.32245794403731.32245794403735
69-14-14.80065223209410.800652232094088
70-4-3.10317203454825-0.896827965451745
71-19-20.72855991584671.72855991584667
72-10-9.76253117764228-0.237468822357722
73-22-21.3624790801759-0.637520919824097
74-25-25.02746084926650.0274608492665128
75-8-8.146272648771580.146272648771585
76-8-7.21202340968141-0.787976590318586
77-8-9.972151404530681.97215140453068
78-2-0.293260157323618-1.70673984267638
79-6-6.816629093830890.81662909383089
80-10-11.63796576144021.63796576144017
81-11-11.63946693599390.639466935993882
82-14-13.1384299188803-0.861570081119718
83-25-22.5403029340679-2.45969706593212


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
80.3629936388243430.7259872776486850.637006361175657
90.209759630101370.419519260202740.79024036989863
100.120869346363220.241738692726440.87913065363678
110.107960464499080.215920928998160.89203953550092
120.2288120549551380.4576241099102750.771187945044862
130.1507734871903750.3015469743807490.849226512809625
140.3064610813859590.6129221627719180.693538918614041
150.4283697785092190.8567395570184370.571630221490781
160.3686806944504970.7373613889009940.631319305549503
170.4680142351745390.9360284703490780.531985764825461
180.3948752996355670.7897505992711330.605124700364433
190.3273727252468980.6547454504937970.672627274753102
200.378922493329070.757844986658140.62107750667093
210.3843060120522980.7686120241045970.615693987947701
220.336602955666780.673205911333560.66339704433322
230.3435847544419490.6871695088838990.656415245558051
240.2952516355684640.5905032711369280.704748364431536
250.2373872972017810.4747745944035620.762612702798219
260.1877974428391380.3755948856782770.812202557160862
270.1734680150997540.3469360301995080.826531984900246
280.2035031590143810.4070063180287610.796496840985619
290.2487245132155540.4974490264311080.751275486784446
300.3842861107086020.7685722214172030.615713889291398
310.3384904000720960.6769808001441910.661509599927904
320.310772220734980.621544441469960.68922777926502
330.4753192793173530.9506385586347060.524680720682647
340.5695810923030660.8608378153938670.430418907696934
350.5156463155518260.9687073688963490.484353684448174
360.4493492264750080.8986984529500160.550650773524992
370.4917993677900180.9835987355800370.508200632209982
380.4808356749085160.9616713498170320.519164325091484
390.4217315246986140.8434630493972280.578268475301386
400.3594518822781720.7189037645563440.640548117721828
410.6073058922505130.7853882154989740.392694107749487
420.5948614220894210.8102771558211570.405138577910579
430.5303389963876710.9393220072246580.469661003612329
440.5050875629873510.9898248740252990.494912437012649
450.4793676324113730.9587352648227450.520632367588627
460.4536904318962920.9073808637925830.546309568103708
470.4701864261758840.9403728523517690.529813573824116
480.4097700144413060.8195400288826120.590229985558694
490.3556200241598320.7112400483196640.644379975840168
500.3769794207188140.7539588414376280.623020579281186
510.5905799536063030.8188400927873940.409420046393697
520.5447109819768790.9105780360462430.455289018023121
530.4762241336470990.9524482672941970.523775866352901
540.5242095296184670.9515809407630670.475790470381533
550.5668090126301320.8663819747397360.433190987369868
560.5096580610124040.9806838779751920.490341938987596
570.4843939045544660.9687878091089330.515606095445534
580.4469101242274820.8938202484549640.553089875772518
590.4819580168489080.9639160336978150.518041983151092
600.4798593210643290.9597186421286580.520140678935671
610.4650699613224890.9301399226449780.534930038677511
620.6267455534674520.7465088930650960.373254446532548
630.5495067356630870.9009865286738260.450493264336913
640.4910780819148080.9821561638296150.508921918085192
650.5172520527974380.9654958944051240.482747947202562
660.4820481361348530.9640962722697060.517951863865147
670.5137315688186740.9725368623626530.486268431181326
680.4369392832195690.8738785664391380.563060716780431
690.3454770645454860.6909541290909720.654522935454514
700.3439279493346520.6878558986693050.656072050665347
710.3471398050265510.6942796100531030.652860194973449
720.2957558296764480.5915116593528960.704244170323552
730.4706867603982420.9413735207964840.529313239601758
740.332643612248440.6652872244968790.66735638775156
750.215981451220740.4319629024414810.78401854877926


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 level00OK