Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 2433.44637791450 -315.074157998355X[t] -0.00125846806695553Y1[t] + 0.177146531235082Y2[t] + 250.885789760826M1[t] + 140.710806349446M2[t] + 315.354276985791M3[t] + 212.856988453909M4[t] + 147.800396561370M5[t] + 450.964210878744M6[t] + 22.4825935448227M7[t] -94.9584839475962M8[t] + 0.239158080932078M9[t] + 206.346376078827M10[t] -162.905871133591M11[t] + 10.3153346404841t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)2433.44637791450751.6240493.23760.0022660.001133
X-315.074157998355148.716908-2.11860.0396770.019839
Y1-0.001258468066955530.162594-0.00770.9938590.496929
Y20.1771465312350820.1635191.08330.2844280.142214
M1250.885789760826167.3646031.4990.1408470.070424
M2140.710806349446177.562390.79250.4322520.216126
M3315.354276985791167.4281431.88350.0661020.033051
M4212.856988453909181.4177171.17330.246850.123425
M5147.800396561370174.406910.84740.4012320.200616
M6450.964210878744168.3351872.6790.0102770.005138
M722.4825935448227191.0253090.11770.9068340.453417
M8-94.9584839475962168.855391-0.56240.5766580.288329
M90.239158080932078161.0319480.00150.9988220.499411
M10206.346376078827163.505711.2620.2134460.106723
M11-162.905871133591170.220741-0.9570.3436670.171834
t10.31533464048416.7053111.53840.1309580.065479


Multiple Linear Regression - Regression Statistics
Multiple R0.737666102933429
R-squared0.544151279416992
Adjusted R-squared0.392201705889323
F-TEST (value)3.58113067897427
F-TEST (DF numerator)15
F-TEST (DF denominator)45
p-value0.000455865512472009
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation248.415794172444
Sum Squared Residuals2776968.30574466


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
123602370.94408274775-10.9440827477537
222142363.26073922011-149.260739220114
328252564.87790823958260.122091760418
423552446.06363679895-91.0636367989512
523332500.150390123-167.150390123001
630162730.39835569784285.601644302156
721552307.47531562750-152.475315627505
821722322.42419461478-150.424194614779
921502275.39261393325-125.392613933248
1025332494.854343900138.1456560999033
1120582131.53821437135-73.5382143713462
1221602373.20431394026-213.204313940262
1322602550.13247226208-290.132472262079
1424982468.2159228704729.7840771295347
1526952670.5898658708724.4101341291327
1627992620.32086820423178.679131795772
1729472600.34659692652346.653403073479
1829302932.06273185892-2.06273185891864
1923182540.13552974541-222.135529745412
2025402430.76847831946109.231521680542
2125702427.58839796174142.411602038264
2226692683.29972649229-14.2997264922944
2324502329.55262151878120.447378481216
2428422520.58693839180321.413061608205
2534402742.49965297038697.500347029623
2626782711.32888053959-33.3288805395925
2729813003.18026416202-22.1802641620213
2822602709.46576446555-449.465764465548
2928442696.70429533406147.295704665936
3025462881.72584992033-335.725849920326
3124562504.37333335246-48.3733333524587
3222952328.81747841858-33.8174784185778
3323792418.58988063521-39.5898806352127
3424792562.27574830735-83.2757483073498
3520572183.43514017265-126.435140172648
3622802318.18872415478-38.1887241547824
3723512482.29818293607-131.298182936073
3822762368.29025253813-92.290252538125
3925482540.71491399787.28508600220146
4023112390.79428482979-79.7942848297873
4122012349.87698362572-148.876983625724
4227252621.51083616823103.489163831767
4324082135.9378740721272.062125927901
4421392090.5284321647448.471567835263
4518982140.22448634224-242.224486342240
4625372262.03678918277274.963210817235
4720691828.09598568856240.904014311445
4820632115.10278797718-52.1027879771833
4925242293.40688656888230.593113431123
5024372191.90420483170245.095795168296
5121892458.63704772973-269.637047729731
5227932351.35544570149441.644554298514
5320742251.92173399069-177.921733990689
5426222673.30222635468-51.3022263546779
5522782127.07794720253150.922052797475
5621442117.4614164824526.5385835175518
5724272162.20462112756264.795378872436
5821392354.53339211749-215.533392117494
5918281989.37803824867-161.378038248667
6020722089.91723553598-17.9172355359773
6118002295.71872251484-495.718722514840


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.6230565131339480.7538869737321040.376943486866052
200.4589302827253120.9178605654506230.541069717274688
210.3631061151458560.7262122302917120.636893884854144
220.2368168975226280.4736337950452560.763183102477372
230.1791782639238440.3583565278476870.820821736076156
240.2207658734128460.4415317468256930.779234126587154
250.7451587058117950.509682588376410.254841294188205
260.7565776842681150.486844631463770.243422315731885
270.7900147840245430.4199704319509150.209985215975457
280.7182559128002680.5634881743994640.281744087199732
290.8226196671306480.3547606657387040.177380332869352
300.7986680782016810.4026638435966380.201331921798319
310.8485195457418910.3029609085162170.151480454258109
320.7855748928764110.4288502142471770.214425107123588
330.7114969125608330.5770061748783330.288503087439167
340.6183588906315370.7632822187369260.381641109368463
350.5117213930435470.9765572139129060.488278606956453
360.4287260708123790.8574521416247570.571273929187621
370.3921997729519120.7843995459038250.607800227048088
380.2994102272084710.5988204544169410.70058977279153
390.2787902077780670.5575804155561340.721209792221933
400.2302576768550560.4605153537101120.769742323144944
410.1366036716746120.2732073433492240.863396328325388
420.07747478996929880.1549495799385980.922525210030701


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