Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 74.8461699959766 + 2.19376705976759X[t] + 0.583817180808853Y1[t] -0.784569819676212Y2[t] -10.6853024858533M1[t] -16.6925710430407M2[t] -10.2731451518584M3[t] -12.6971781321019M4[t] + 2.54561934032703M5[t] + 54.8658399069361M6[t] -12.0357994812021M7[t] -66.5419062293564M8[t] -60.0192868381692M9[t] -40.3833766595293M10[t] -10.1516715402114M11[t] + 0.150462479682088t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)74.846169995976630.3514772.4660.0179370.008968
X2.193767059767590.3321966.603800
Y10.5838171808088530.1457154.00660.0002530.000127
Y2-0.7845698196762120.422976-1.85490.0708140.035407
M1-10.68530248585336.26046-1.70680.0954250.047713
M2-16.69257104304077.232645-2.30790.0261230.013061
M3-10.27314515185847.597654-1.35210.183740.09187
M4-12.69717813210197.727253-1.64320.1079960.053998
M52.545619340327039.1671880.27770.7826470.391324
M654.86583990693618.5829896.392400
M7-12.035799481202113.813277-0.87130.3886530.194326
M8-66.541906229356417.098992-3.89160.0003590.000179
M9-60.01928683816926.978926-8.600100
M10-40.38337665952935.812018-6.948300
M11-10.15167154021146.160731-1.64780.1070370.053518
t0.1504624796820880.1101291.36620.1793110.089656


Multiple Linear Regression - Regression Statistics
Multiple R0.987071748987967
R-squared0.974310637650165
Adjusted R-squared0.964912090449005
F-TEST (value)103.666089747359
F-TEST (DF numerator)15
F-TEST (DF denominator)41
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation7.7464999763229
Sum Squared Residuals2460.33873720999


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1589587.8170654058671.18293459413330
2584576.1819687045287.8180312954722
3573574.538236513318-1.53823651331768
4567560.7304542689036.26954573109736
5569562.6557390316596.34426096834063
6621617.7401351512463.25986484875400
7629635.055055854422-6.05505585442201
8628627.8234716464750.176528353525246
9612610.9225774554711.07742254452880
10595601.910903777899-6.91090377789872
11597601.014325886281-4.01432588628114
12593598.268430730348-5.26843073034825
13590581.3905538641848.60944613581628
14580572.7337940422897.26620595771116
15574569.8816172498554.11838275014532
16573556.75771340125416.2422865987457
17573566.7741880072676.22581199273327
18620623.208530391545-3.20853039154525
19626629.01160885468-3.01160885468073
20620614.4734046231545.52659537684597
21588597.34938828947-9.34938828946997
22566576.018933048368-10.0189330483677
23557564.372083023717-7.37208302371713
24561558.2424169425862.75758305741416
25549553.277257385341-4.27725738534084
26532542.085106410199-10.0851064101989
27526527.702016433075-1.70201643307534
28511513.629671597518-2.62967159751786
29499514.87107796446-15.8710779644599
30555556.550678638112-1.55067863811170
31565556.2924631504788.70753684952182
32542549.36232300526-7.36232300525979
33527524.3893099156492.61069008435057
34510506.2965649594023.7034350405978
35514512.8849902264181.11500977358164
36517518.12959348988-1.12959348987961
37508516.99115058403-8.9911505840297
38493504.895297629557-11.8952976295568
39490493.048229014536-3.04822901453604
40469480.768145961011-11.7681459610114
41478479.373469750845-1.37346975084486
42528527.7344328188050.265567181194724
43534536.917983647975-2.91798364797492
44518518.174557199987-0.174557199987186
45506499.0167162057976.98328379420343
46502488.77359821433113.2264017856686
47516505.72860086358310.2713991364166
48528524.3595588371863.6404411628137
49533529.5239727605793.47602723942096
50536529.1038332134286.89616678657241
51537534.8299007892162.17009921078374
52524532.114014771314-8.11401477131376
53536531.3255252457694.67447475423087
54587585.7662230002921.23377699970823
55597593.7228884924443.27711150755584
56581579.1662435251241.83375647487575
57564565.322008133613-1.32200813361284


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.02837689314585630.05675378629171250.971623106854144
200.04479218814964060.08958437629928130.95520781185036
210.3091700997836770.6183401995673540.690829900216323
220.2256282215910020.4512564431820040.774371778408998
230.2650940398741380.5301880797482750.734905960125862
240.3248048665142630.6496097330285260.675195133485737
250.3691145698779680.7382291397559360.630885430122032
260.3636318174499750.727263634899950.636368182550025
270.2835788747426930.5671577494853860.716421125257307
280.409088816124580.818177632249160.59091118387542
290.6477023369480230.7045953261039530.352297663051977
300.8290466261760740.3419067476478520.170953373823926
310.9194834470296950.1610331059406110.0805165529703053
320.874642267156270.2507154656874590.125357732843730
330.9672301694890980.06553966102180320.0327698305109016
340.963075906064350.07384818787129860.0369240939356493
350.9700800484628360.05983990307432760.0299199515371638
360.9678097794367420.06438044112651540.0321902205632577
370.9958887106446010.008222578710797320.00411128935539866
380.995445039697480.009109920605038540.00455496030251927


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