Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 47.8128014249776 -0.324121971901887X[t] + 1.04159402162681Y1[t] -0.0115728999770883Y2[t] + 0.120744435018517Y3[t] -0.187044380770622Y4[t] -2.37853399760623M1[t] + 12.7571732943496M2[t] + 54.6403772282848M3[t] + 12.2017243573166M4[t] -1.85566430621556M5[t] -14.7445527046213M6[t] -8.75987229083388M7[t] + 11.4755668209098M8[t] + 10.6272966968030M9[t] + 3.67932141273498M10[t] -1.60302960241247M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)47.812801424977626.1658661.82730.0735090.036755
X-0.3241219719018870.188693-1.71770.0919140.045957
Y11.041594021626810.1451487.176100
Y2-0.01157289997708830.20495-0.05650.9551910.477595
Y30.1207444350185170.2111350.57190.5699130.284957
Y4-0.1870443807706220.142708-1.31070.1958370.097919
M1-2.378533997606234.191388-0.56750.5728770.286439
M212.75717329434964.4150462.88950.0056530.002827
M354.64037722828485.5025449.9300
M412.20172435731669.8961351.2330.2232370.111618
M5-1.8556643062155610.661253-0.17410.862510.431255
M6-14.74455270462138.80015-1.67550.099960.04998
M7-8.759872290833884.229563-2.07110.0434270.021714
M811.47556682090984.7966492.39240.020460.01023
M910.62729669680305.582331.90370.0625940.031297
M103.679321412734985.438170.67660.5017340.250867
M11-1.603029602412474.650111-0.34470.7317150.365858


Multiple Linear Regression - Regression Statistics
Multiple R0.99011755108764
R-squared0.980332764971788
Adjusted R-squared0.97416265202176
F-TEST (value)158.884087359767
F-TEST (DF numerator)16
F-TEST (DF denominator)51
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.54603616320942
Sum Squared Residuals2185.38006195232


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1501503.25591928815-2.25591928814988
2507507.524944403306-0.524944403306282
3569562.4813476167176.51865238328289
4580582.962870657616-2.96287065761648
5578575.4162908488282.58370915117167
6565566.064969447332-1.06496944733168
7547552.509508389265-5.50950838926462
8555552.3987331051472.60126689485288
9562559.4793580093662.52064199063367
10561559.372303049941.62769695005948
11555552.2113870884862.78861291151368
12544550.101676784718-6.10167678471817
13537536.6876616941270.312338305872941
14543539.5843828984763.41561710152369
15594595.371166087077-1.37116608707733
16611604.1499015266836.85009847331661
17613603.6358604935789.36413950642165
18611598.90078423336412.0992157666365
19594597.366903400128-3.36690340012829
20595597.725604876481-2.72560487648112
21591599.768944245347-8.76894424534657
22589586.5430947775482.45690522245175
23584579.6720728744384.32792712556199
24573576.03608779444-3.03608779443951
25567564.2879459798082.71205402019188
26569567.950630472151.04936952785008
27621622.289518040613-1.28951804061298
28629630.526624888503-1.52662488850253
29628619.8918182455548.10818175444596
30612614.13946488001-2.13946488001017
31595593.7699078093061.23009219069397
32597596.9731082892060.0268917107939254
33593597.729501435714-4.72950143571398
34590586.9810516099663.01894839003347
35580577.2444482888372.75555171116333
36574572.4061950574451.59380494255507
37573561.29784800637811.7021519936217
38573573.291714200758-0.291714200757703
39620625.7968298118-5.79682981180021
40626628.420376031179-2.42037603117879
41620615.6207253810584.379274618942
42588601.536816546666-13.5368165466659
43566567.360145480997-1.3601454809966
44557566.737045515213-9.73704551521297
45561552.7309894723848.26901052761555
46549553.609474369201-4.60947436920137
47532534.434333335735-2.43433333573538
48526524.7518655803811.24813441961923
49511513.086205699233-2.08620569923344
50499510.298753662557-11.2987536625574
51555550.3175234055934.68247659440668
52565561.8658832335453.13411676645457
53542556.242872512116-14.2428725121159
54527525.0790060249781.92099397502165
55510509.3884217851740.611578214825827
56514511.7536124420812.24638755791865
57517514.2912068371892.70879316281134
58508510.494076193343-2.49407619334333
59493500.437758412504-7.43775841250361
60490483.7041747830176.29582521698337
61469479.384419332303-10.3844193323032
62478470.3495743627527.65042563724764
63528530.743615038199-2.74361503819905
64534537.074343662473-3.07434366247339
65518528.192432518865-10.1924325188653
66506503.278958867652.72104113234962
67502493.605113135138.39488686486972
68516508.4118957718717.58810422812863


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
200.6269465987346330.7461068025307330.373053401265367
210.512338341192570.975323317614860.48766165880743
220.3662022911983210.7324045823966410.63379770880168
230.2558783743532270.5117567487064550.744121625646773
240.171581021645550.34316204329110.82841897835445
250.1140315060079240.2280630120158470.885968493992076
260.07530690877665670.1506138175533130.924693091223343
270.04203965720601570.08407931441203130.957960342793984
280.02652410066658300.05304820133316610.973475899333417
290.02244750417172740.04489500834345470.977552495828273
300.01742668155267960.03485336310535920.98257331844732
310.009575633120489260.01915126624097850.99042436687951
320.004799697320538650.00959939464107730.995200302679461
330.0058105015185470.0116210030370940.994189498481453
340.002984428163553330.005968856327106670.997015571836447
350.002578843799981930.005157687599963850.997421156200018
360.001686936248095910.003373872496191810.998313063751904
370.006250806326951030.01250161265390210.99374919367305
380.005921289211534520.01184257842306900.994078710788465
390.003724761418825940.007449522837651880.996275238581174
400.002153020226676560.004306040453353120.997846979773323
410.06941484991494730.1388296998298950.930585150085053
420.2619169192943900.5238338385887790.73808308070561
430.1836802945847350.3673605891694710.816319705415265
440.2336931740842840.4673863481685670.766306825915716
450.1671860009511170.3343720019022330.832813999048883
460.1195765156942940.2391530313885880.880423484305706
470.1586496879636860.3172993759273720.841350312036314
480.1712774097344880.3425548194689760.828722590265512


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level60.206896551724138NOK
5% type I error level120.413793103448276NOK
10% type I error level140.482758620689655NOK