Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 263.734200766228 + 0.000253339919810202X[t] + 1.23877863761127Y1[t] -0.317282826192632Y2[t] + 0.169813272838906Y3[t] -0.0593898141762464Y4[t] + 0.230078665812567Y5[t] -0.455301377384477Y6[t] + 0.133074244597905Y7[t] + 0.144344462501845Y8[t] + 0.0194396382456085Y9[t] -0.264854112662661Y10[t] + 0.55307300684554Y11[t] -0.525001084215331Y12[t] + 47.9017286725281M1[t] + 94.2651699586358M2[t] + 60.4857327806912M3[t] + 121.951904260527M4[t] + 40.5584718885717M5[t] + 228.392489428843M6[t] + 66.902963518707M7[t] -25.7832520296353M8[t] + 39.6934894694768M9[t] + 58.4457634559164M10[t] + 78.4448469281772M11[t] + 3.98110966935865t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)263.734200766228318.6720450.82760.4136660.206833
X0.0002533399198102020.0266480.00950.992470.496235
Y11.238778637611270.155157.984400
Y2-0.3172828261926320.242012-1.3110.1986360.099318
Y30.1698132728389060.2447080.69390.4924320.246216
Y4-0.05938981417624640.246685-0.24080.8111940.405597
Y50.2300786658125670.2434120.94520.3512140.175607
Y6-0.4553013773844770.245696-1.85310.0725620.036281
Y70.1330742445979050.2475210.53760.5943360.297168
Y80.1443444625018450.2421460.59610.5550530.277527
Y90.01943963824560850.2464110.07890.9375820.468791
Y10-0.2648541126626610.244295-1.08420.2859240.142962
Y110.553073006845540.2480932.22930.0325070.016254
Y12-0.5250010842153310.191239-2.74530.009590.004795
M147.9017286725281118.2618710.4050.687980.34399
M294.2651699586358121.0233410.77890.4414260.220713
M360.4857327806912123.4367820.490.6272710.313636
M4121.951904260527123.8014330.98510.3315530.165776
M540.5584718885717122.9926990.32980.7436020.371801
M6228.392489428843125.4224461.8210.0774190.03871
M766.902963518707120.6873840.55430.5829680.291484
M8-25.7832520296353113.91537-0.22630.8222950.411147
M939.6934894694768117.4518430.3380.7374750.368737
M1058.4457634559164121.2937470.48190.6329980.316499
M1178.4448469281772115.3955370.67980.5012390.25062
t3.981109669358656.6498760.59870.5533580.276679


Multiple Linear Regression - Regression Statistics
Multiple R0.988781225067778
R-squared0.977688311046536
Adjusted R-squared0.961282657404283
F-TEST (value)59.5945966168931
F-TEST (DF numerator)25
F-TEST (DF denominator)34
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation167.808885383951
Sum Squared Residuals957433.948469338


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
12849.272816.2750842820732.9949157179337
22921.442994.6896361064-73.2496361063972
32981.853024.85793243141-43.0079324314072
43080.583085.71836399457-5.13836399457217
53106.223152.44982234285-46.2298223428475
63119.313265.90736121444-146.597361214440
73061.263203.22651156427-141.966511564271
83097.313007.8695122921689.4404877078393
93161.693153.271570744548.41842925545732
103257.163241.0868300821216.0731699178766
113277.013346.56555055549-69.5555505554946
123295.323248.5803723467946.7396276532099
133363.993346.785898589417.2041014106021
143494.173436.7211932685657.4488067314444
153667.033553.93972106815113.090278931848
163813.063735.5124919722477.5475080277635
173917.963829.1968781233788.7631218766249
183895.514103.14352127401-207.633521274014
193801.063938.5486635358-137.488663535800
203570.123732.68652617856-162.566526178561
213701.613532.4409747153169.169025284701
223862.273733.35929508236128.910704917641
233970.13856.36344203787113.736557962129
244138.523921.27749320525217.242506794749
254199.754162.2580475705537.4919524294548
264290.894353.91182206719-63.021822067185
274443.914334.37922231134109.530777688664
284502.644482.342342982420.2976570176018
294356.984423.91805323185-66.9380532318512
304591.274435.50795617548155.762043824521
314696.964536.49989715262160.460102847375
324621.44655.78653367334-34.3865336733385
334562.844605.86279664817-43.0227966481657
344202.524489.22308052641-286.703080526411
354296.494238.7296780429157.7603219570854
364435.234220.70906782703214.520932172969
374105.184280.62612881557-175.446128815567
384116.684002.66949525508114.010504744920
393844.494054.47376382167-209.983763821667
403720.983710.5767065111210.4032934888799
413674.43697.39253654014-22.9925365401388
423857.623599.11699593431258.503004065688
433801.063774.6847838007926.3752161992075
443504.373569.97868720109-65.6086872010924
453032.63182.59820690516-149.998206905158
463047.032903.21761383401143.812386165994
472962.343170.51292384835-208.172923848345
482197.822540.18267213309-342.362672133095
492014.451926.6948407424287.7551592575769
501862.831898.01785330278-35.1878533027819
511905.411875.0393603674430.3706396325610
521810.991914.10009453967-103.110094539673
531670.071622.6727097617947.3972902382125
541864.441924.47416540175-60.0341654017546
552052.021959.4001439465192.6198560534883
562029.61856.47874065485173.121259345153
572070.832055.3964509868315.4335490131661
582293.412295.5031804751-2.09318047510133
592443.272337.03840551537106.231594484625
602513.172649.31039448783-136.140394487834


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
290.02413745384472780.04827490768945570.975862546155272
300.004407805056394650.00881561011278930.995592194943605
310.001220770326878330.002441540653756670.998779229673122


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level20.666666666666667NOK
5% type I error level31NOK
10% type I error level31NOK