Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 51.8113889492929 + 18.2085406063896X[t] + 0.271210793016475Y1[t] + 0.178741922485548Y2[t] + 2.56273080422700M1[t] + 5.67578036676462M2[t] -13.7940300961573M3[t] + 4.70725653390193M4[t] -1.077914935995M5[t] -1.85769590905666M6[t] + 12.8906641756498M7[t] -4.24578668033340M8[t] + 2.00799178358461M9[t] + 10.0895616108159M10[t] -12.0140621863243M11[t] -0.123585395824864t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)51.811388949292920.1630072.56960.013820.00691
X18.20854060638965.1382223.54370.0009830.000491
Y10.2712107930164750.1286452.10820.0410190.02051
Y20.1787419224855480.1275571.40130.1684790.084239
M12.562730804227008.4230750.30430.7624390.381219
M25.675780366764628.3476170.67990.5002810.25014
M3-13.79403009615738.455493-1.63140.1102890.055145
M44.707256533901937.6337750.61660.5408030.270402
M5-1.0779149359958.610897-0.12520.9009780.450489
M6-1.857695909056667.854358-0.23650.8141810.40709
M712.89066417564988.0791681.59550.1180890.059044
M8-4.245786680333408.741576-0.48570.6297040.314852
M92.007991783584617.7178540.26020.7960.398
M1010.08956161081598.255591.22210.2284660.114233
M11-12.01406218632438.902205-1.34960.1843870.092193
t-0.1235853958248640.113949-1.08460.2843010.142151


Multiple Linear Regression - Regression Statistics
Multiple R0.795209101442698
R-squared0.632357515017304
Adjusted R-squared0.501056627523484
F-TEST (value)4.81609475067004
F-TEST (DF numerator)15
F-TEST (DF denominator)42
p-value2.73510789530196e-05
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation11.1876886667339
Sum Squared Residuals5256.90386355821


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1105.5073942116.327182839840-10.8197886398403
2118.1540031121.194616342282-3.04061324228207
3101.8612953106.758378626621-4.89708332662111
4109.8419174122.977800845741-13.1358834457407
5105.6348802116.321284913857-10.6864047138574
6112.927078115.703396386494-2.77631838649371
7133.0698623131.553919906451.51594239354994
8125.6756757121.0602456121224.61543008787832
9146.736359128.78541545871117.9509435412892
10142.5803162141.1336333812781.4466828187219
11106.1448241121.543687546616-15.3988634466159
12126.5170831122.8096065507253.70747654927534
13132.7893932124.2613785733938.5280146266072
14121.2391637132.593337675405-11.3541739754053
15114.5079041110.9885196801413.51938441985927
16146.1499235125.4761204342820.6738030657199
17146.1244263126.94586246102219.1785638389783
18128.5058644131.691336355184-3.18547195518444
19155.5838858141.53320948081114.0506763191888
20125.0382458128.467849260778-3.42960346077757
21136.8944416131.1537126834165.74072891658421
22142.2233554136.8674389627475.35591643725269
23117.7715451118.204687938054-0.433142838053818
24120.627231124.416070163774-3.78883916377362
25127.7664457123.2591448284474.50730087155322
26135.1096379128.6952718632426.41436603675772
27105.7113717112.369505944845-6.65813424484494
28117.9245283124.086616380677-6.1620880806768
29120.754717116.2354967833454.5192202166545
30107.572667118.282711226473-10.7100442264733
31130.4436512129.8382450505070.605406149493046
32107.2157063116.424881601348-9.20917530134752
33105.0739419120.343408998013-15.2694670980133
34130.1121877123.5687162812276.54347141877314
35109.6379398107.7493265010541.88861329894587
36116.7261601118.562350472136-1.83619037213637
3797.11881693101.055750691696-3.93693376169571
38140.8975013118.20299449813922.6945068018607
39108.2865885106.9781961315581.30839236844158
4097.65425803106.128011446106-8.47375341610594
41112.0346762109.7152551605112.31942103948877
42123.0494646110.81157021870912.2378943812905
43112.4171341130.994057994316-18.5769238943156
44116.4966854112.8192234103773.67746198962318
45104.6914839118.155391627623-13.4639077276226
46122.2335543123.640864840735-1.40731054073518
4799.7960224485.852629454276113.9433929857239
4896.7108618194.79330882336541.91755298663464
49112.3151453110.5937383966241.72140690337555
50102.5497195117.263805120931-14.7140856209310
51104.538500897.81106001683486.7274407831652
52122.0805711114.9826492231977.09792187680345
5380.6476287695.9784291412642-15.3308003812642
5491.4074451886.9735049931394.43394018686092
5599.5155532997.1106542579162.40489903208389
56106.527282102.1813953153764.34588668462361
5798.4956654893.45396311223755.0417023677625
58106.7567568118.695516934013-11.9387601340126


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.6300202100573010.7399595798853980.369979789942699
200.820924964061380.3581500718772410.179075035938621
210.894986902180120.2100261956397590.105013097819880
220.8853891540149370.2292216919701260.114610845985063
230.8162879039877910.3674241920244180.183712096012209
240.8443285171882510.3113429656234980.155671482811749
250.7878200170913170.4243599658173660.212179982908683
260.7325943535648060.5348112928703880.267405646435194
270.7456289207671980.5087421584656040.254371079232802
280.7213633532486390.5572732935027220.278636646751361
290.6309558511038790.7380882977922420.369044148896121
300.6182693152112050.763461369577590.381730684788795
310.5429377735235490.9141244529529020.457062226476451
320.5096742840047050.980651431990590.490325715995295
330.6343799533418720.7312400933162550.365620046658128
340.5984900663030610.8030198673938770.401509933696939
350.6001133275141850.799773344971630.399886672485815
360.4796999371700520.9593998743401030.520300062829948
370.3601280602572870.7202561205145750.639871939742713
380.7385026652686150.5229946694627710.261497334731385
390.6065959528628640.7868080942742710.393404047137136


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