Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 1.54167091765125 + 0.98059228033681X[t] + 0.387904499998967M1[t] -0.390548095699390M2[t] -0.792460059946535M3[t] -1.03691565041127M4[t] + 0.366721482980735M5[t] -1.14491108900953M6[t] -0.737442655419468M7[t] -0.821530714152305M8[t] -0.660810912706852M9[t] -0.358194409032587M10[t] -0.471564152213164M11[t] -0.0264160821289604t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)1.541670917651251.2334141.24990.2163480.108174
X0.980592280336810.05747117.062400
M10.3879044999989670.2763791.40350.1657920.082896
M2-0.3905480956993900.266241-1.46690.1478060.073903
M3-0.7924600599465350.278754-2.84290.0061630.003082
M4-1.036915650411270.276503-3.75010.000410.000205
M50.3667214829807350.2963091.23760.220840.11042
M6-1.144911089009530.265079-4.31916.2e-053.1e-05
M7-0.7374426554194680.284798-2.58930.0121370.006069
M8-0.8215307141523050.266386-3.0840.0031260.001563
M9-0.6608109127068520.267358-2.47160.0164070.008203
M10-0.3581944090325870.291004-1.23090.2233320.111666
M11-0.4715641522131640.264668-1.78170.0800310.040015
t-0.02641608212896040.006086-4.34065.8e-052.9e-05


Multiple Linear Regression - Regression Statistics
Multiple R0.98920334433598
R-squared0.978523256445487
Adjusted R-squared0.97370950357982
F-TEST (value)203.276587675413
F-TEST (DF numerator)13
F-TEST (DF denominator)58
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.458137829416737
Sum Squared Residuals12.1736357030754


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11817.9848727330450.0151272669550136
219.618.55283324768921.04716675231082
323.322.53717046282870.762829537171278
423.722.75659493040340.943405069596563
520.319.72115072015080.578849279849173
622.822.20353041541250.596469584587477
724.324.05547118737880.244528812621157
821.521.39542711764130.104572882358660
923.523.19673771353040.303262286469589
1022.221.90399048653680.296009513463182
1120.921.5680862051599-0.668086205159919
1222.221.71905659114310.480943408856922
1319.519.13876816800270.361231831997348
1421.121.07955787511840.0204421248815975
152222.1221182492475-0.122118249247516
1619.219.4978251038455-0.297825103845481
1717.818.8158023664012-1.01580236640122
1819.219.14087904492190.0591209550780661
1919.920.6986421327872-0.79864213278721
2019.619.6075457115886-0.0075457115885984
2118.118.5651386945009-0.465138694500919
2220.421.1947605888546-0.794760588854571
2318.118.7015532907367-0.601553290736686
2418.619.4408790449219-0.84087904492193
2517.618.2334198142530-0.633419814253042
2619.420.0761502933351-0.676150293335115
2719.319.5497630189253-0.249763018925326
2818.618.8866544341969-0.286654434196911
2916.917.0279209603485-0.127920960348478
3016.416.8627014987008-0.462701498700789
311919.4010568669029-0.401056866902873
3218.718.8983158139064-0.19831581390635
3317.116.87531651648190.224683483518142
3421.520.97582683134070.524173168659272
3517.817.60008648091970.199913519080287
3618.117.75105686690290.348943133097128
371918.60284142494130.397158575058714
3818.918.87662425548450.0233757445155378
3916.817.0754670166368-0.275467016636818
4018.118.2754837645483-0.175483764548342
4115.715.63227646643050.0677235335695386
4215.115.2709385487154-0.170938548715409
4318.317.90735314495120.392646855048824
4416.516.42401981161780.075980188382158
4516.917.1466788991364-0.246678899136424
4618.418.6976492851196-0.297649285119583
4716.416.10638275896800.293617241031981
4815.715.9631754608501-0.263175460850134
4916.917.0110784749559-0.111078474955908
5016.616.8926243933644-0.292624393364354
5116.716.9545924871567-0.254592487156657
5216.616.58566158652930.0143384134707157
5314.414.13857274447880.261427255521237
5414.514.5617086510332-0.0617086510331594
5517.516.90394556316790.596054436832118
5614.314.3419607214641-0.0419607214640582
5715.415.4568567211174-0.0568567211173608
5817.217.2039455631679-0.00394556316788222
5914.614.51461980898260.0853801910173616
6014.214.2733532828311-0.0733532828310736
6114.914.9290193848021-0.0290193848021241
6214.114.2222099350085-0.122209935008487
6315.615.46088876520500.13911123479504
6414.614.7977801804765-0.197780180476546
6511.911.66427674219030.235723257809746
6613.513.46024184121620.0397581587838143
6714.214.233531104812-0.033531104812014
6813.713.63273082378180.0672691762181886
6914.414.15927145523300.240728544766973
7015.315.02382724498040.276172755019582
7114.313.60927145523300.690728544766975
7214.514.15247875335090.347521246649088


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.9694197962846420.0611604074307160.030580203715358
180.9730641476632130.05387170467357420.0269358523367871
190.9596795757175580.08064084856488370.0403204242824419
200.9741411723513660.05171765529726730.0258588276486336
210.954011021961950.09197795607609790.0459889780380489
220.9506729279411680.09865414411766360.0493270720588318
230.9817316971908420.03653660561831580.0182683028091579
240.9921834509509550.01563309809808930.00781654904904467
250.9900595514964190.01988089700716300.00994044850358148
260.9892215679564660.0215568640870670.0107784320435335
270.9882518962564240.02349620748715140.0117481037435757
280.984188974857960.03162205028408070.0158110251420403
290.9949509070635930.01009818587281320.00504909293640658
300.9918822732419950.01623545351600910.00811772675800454
310.9978598307456270.004280338508746240.00214016925437312
320.998069912151240.003860175697518570.00193008784875928
330.9997442013651750.0005115972696497260.000255798634824863
340.9999779508837564.40982324873151e-052.20491162436576e-05
350.9999897732031582.04535936849318e-051.02267968424659e-05
360.999997369216995.2615660195967e-062.63078300979835e-06
370.9999995787420398.42515922650204e-074.21257961325102e-07
380.9999991133948341.77321033240766e-068.8660516620383e-07
390.9999978229901964.35401960696193e-062.17700980348097e-06
400.9999931153791341.37692417315975e-056.88462086579875e-06
410.9999844523755073.10952489858162e-051.55476244929081e-05
420.9999690714146846.18571706325659e-053.09285853162829e-05
430.9999762268224884.75463550246575e-052.37731775123287e-05
440.9999632579380997.34841238029508e-053.67420619014754e-05
450.9998919742186340.0002160515627314300.000108025781365715
460.999817839012380.0003643219752423930.000182160987621196
470.9996877926927820.0006244146144369920.000312207307218496
480.9990630049267870.001873990146425390.000936995073212693
490.997361370597350.005277258805298840.00263862940264942
500.9958504060085420.008299187982916190.00414959399145809
510.9922943941481830.01541121170363490.00770560585181744
520.984352217703680.03129556459263840.0156477822963192
530.9645828580532980.07083428389340420.0354171419467021
540.917349684389050.1653006312219010.0826503156109505
550.9690297322794130.06194053544117460.0309702677205873


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level200.512820512820513NOK
5% type I error level300.769230769230769NOK
10% type I error level380.974358974358974NOK