Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 183.652974945091 -0.383983963036890X[t] -34.9039253829419M1[t] -43.9415014112019M2[t] -34.8759253829419M3[t] -18.8397134824402M4[t] -43.1400229154509M5[t] -79.8253983109354M6[t] + 21.4276619130444M7[t] + 9.20993699214136M8[t] + 29.9799198151845M9[t] + 11.5351919396662M10[t] -9.17372492090307M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)183.65297494509115.56819711.796700
X-0.3839839630368900.186769-2.05590.0453670.022683
M1-34.90392538294198.173825-4.27029.4e-054.7e-05
M2-43.94150141120198.316968-5.28343e-062e-06
M3-34.87592538294198.173825-4.26689.5e-054.8e-05
M4-18.83971348244027.987562-2.35860.0225520.011276
M5-43.14002291545097.887285-5.46962e-061e-06
M6-79.82539831093547.90807-10.094200
M721.42766191304447.9556612.69340.0097740.004887
M89.209936992141367.9497511.15850.2525050.126253
M929.97991981518457.8993193.79530.0004220.000211
M1011.53519193966627.8577881.4680.1487670.074383
M11-9.173724920903077.844008-1.16950.2480910.124046


Multiple Linear Regression - Regression Statistics
Multiple R0.945413171743223
R-squared0.893806065305581
Adjusted R-squared0.866692720277218
F-TEST (value)32.9655401932369
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation12.4023356200969
Sum Squared Residuals7229.44265517568


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1100110.350653258460-10.3506532584602
294.9798.728865158962-3.75886515896208
3107.5108.531690396253-1.03169039625281
4124.27127.893203416654-3.62320341665409
5107.06106.5457306593970.514269340602919
679.7169.86035526391249.84964473608757
7163.41170.003701834716-6.59370183471576
8144.83157.417352309297-12.5873523092973
9166.82178.555959736856-11.7359597368558
10154.26161.589570119030-7.3295701190295
11132.6141.617902467491-9.01790246749109
12157.51150.4230027838797.08699721612125
13104.02111.456527072006-7.4365270720065
14106.03101.6817018347164.34829816528426
15113.23111.1159024674912.11409753250891
16117.64129.367701834716-11.7277018347158
17113.34106.5457306593976.79426934060295
1866.6269.4917306593971-2.87173065939706
19185.99170.37616627886215.6138337211385
20174.57158.15844135795816.4115586420415
21208.19179.66567339003228.5243266099676
22163.81161.9581947235451.85180527645510
23162.46141.24927786297621.2107221370243
24148.16150.423002783879-2.26300278387875
25113.41112.5662407251830.843759274816883
26105.63102.7914154878922.83858451210764
27111.79112.594240725183-0.804240725183107
28132.36130.4774154878921.88258451210765
29110.75107.2829798684283.46702013157213
3067.3770.5976044729433-3.22760447294327
31178.29171.4820400924086.80795990759222
32156.38159.264315171505-2.88431517150469
33189.71180.0342979945489.67570200545222
34152.8161.220945514514-8.42094551451407
35150.8141.9865270720068.81347292799352
36160.4153.0072148551177.392785144883
37127.25117.7346648676609.51533513234035
38108.47109.806802492576-1.33680249257633
39117.09120.346876938898-3.25687693889792
40147.25135.64583963036911.6041603696311
41116.19111.3455301973584.84446980264183
4275.8374.29153019735821.53846980264179
43181.94175.9132150258546.0267849741465
44179.12164.80136391849714.3186360815034
45183.15187.418309603747-4.26830960374717
46197.9170.08329538140527.8167046185945
47155.42150.4802523343824.93974766561748
48162.54158.1756389975944.36436100240643
49125.9118.4719140766907.42808592330952
50105.5107.591215025853-2.09121502585348
51121.11118.1312894721752.97871052782493
52137.51135.6458396303691.86416036963108
5397.2112.820028615420-15.6200286154198
5469.7475.028779406389-5.28877940638904
55152.58174.434876768161-21.8548767681614
56146.59161.848527242743-15.2585272427430
57161.16183.355759274817-22.1957592748169
58152.84166.757994261506-13.9179942615060
59121.95147.896040263144-25.9460402631442
60140.12156.701140579532-16.5811405795319


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.04620491571281310.09240983142562630.953795084287187
170.02053001399761600.04106002799523210.979469986002384
180.02446555830610090.04893111661220180.975534441693899
190.08542950010727180.1708590002145440.914570499892728
200.2140753847126020.4281507694252040.785924615287398
210.553263979115640.893472041768720.44673602088436
220.4505477613361540.9010955226723090.549452238663846
230.6395886250681070.7208227498637860.360411374931893
240.5519563644593960.8960872710812070.448043635540604
250.4545376914400050.9090753828800110.545462308559995
260.3733692300833080.7467384601666160.626630769916692
270.3034683274465820.6069366548931640.696531672553418
280.2264782210733790.4529564421467580.773521778926621
290.1662094878017530.3324189756035060.833790512198247
300.1216794661417740.2433589322835470.878320533858226
310.09236862187230350.1847372437446070.907631378127697
320.06274747294036940.1254949458807390.93725252705963
330.06834089256453530.1366817851290710.931659107435465
340.04425392372583650.0885078474516730.955746076274164
350.08438384287300880.1687676857460180.915616157126991
360.230365774548690.460731549097380.76963422545131
370.1660854369979130.3321708739958270.833914563002087
380.1787055516806120.3574111033612230.821294448319388
390.2364103689844280.4728207379688560.763589631015572
400.1937338458203960.3874676916407930.806266154179604
410.5199658091108130.9600683817783740.480034190889187
420.5020955926325180.9958088147349640.497904407367482
430.4972301561020680.9944603122041350.502769843897932
440.346143274254650.69228654850930.65385672574535


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