Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 79.3607618844651 + 12.4028527007149X[t] + 0.948720399414102Y1[t] + 0.0452222789877021Y2[t] -0.0408328304937311Y3[t] -0.0614850910601708Y4[t] -23.7371627758512M1[t] -27.9989333349529M2[t] -24.4920114941735M3[t] -6.19985693337634M4[t] -6.38345082070392M5[t] -13.9880587951269M6[t] -19.3849873747136M7[t] -15.2421114767019M8[t] -20.9699777464923M9[t] -8.16895780312471M10[t] + 41.071920254817M11[t] -0.36680636578864t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)79.360761884465128.7518882.76020.0084560.004228
X12.40285270071494.1545242.98540.0046590.002329
Y10.9487203994141020.1471186.448700
Y20.04522227898770210.2057770.21980.8270950.413548
Y3-0.04083283049373110.20551-0.19870.8434410.421721
Y4-0.06148509106017080.147137-0.41790.6781160.339058
M1-23.737162775851210.356885-2.29190.0268680.013434
M2-27.998933334952913.536032-2.06850.0446430.022321
M3-24.492011494173511.115007-2.20350.0329640.016482
M4-6.1998569333763410.779711-0.57510.5681930.284097
M5-6.383450820703928.57903-0.74410.4608770.230439
M6-13.98805879512698.328297-1.67960.1002910.050146
M7-19.38498737471369.408562-2.06040.0454480.022724
M8-15.24211147670199.985531-1.52640.1342280.067114
M9-20.96997774649239.375399-2.23670.0305450.015272
M10-8.1689578031247110.069057-0.81130.4216650.210833
M1141.0719202548178.56494.79542e-051e-05
t-0.366806365788640.120071-3.05490.0038570.001928


Multiple Linear Regression - Regression Statistics
Multiple R0.991204866841592
R-squared0.98248708805046
Adjusted R-squared0.97556337867506
F-TEST (value)141.901838274907
F-TEST (DF numerator)17
F-TEST (DF denominator)43
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.5733111803007
Sum Squared Residuals1857.96205454184


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1613606.597269646136.40273035387012
2611602.1835273613178.81647263868347
3594599.686748832992-5.68674883299231
4595600.266493470975-5.26649347097542
5591599.85473035335-8.85473035334952
6589588.9507849949830.0492150050170205
7584582.1131338523581.88686614764226
8573581.15700306045-8.15700306044966
9567564.7279006616052.27209933839482
10569571.299481108424-2.29948110842371
11621622.556246516211-1.55624651621067
12629631.462758207738-2.46275820773805
13628617.58735565414510.4126443458549
14612610.1255591939481.87444080605214
15595594.5170386202470.482961379753423
16597595.1395356634241.86046433657554
17593596.432607845305-3.43260784530546
18590586.4346760407693.565323959231
19580578.6074716682361.39252833176405
20574572.801031509211.19896849079054
21573560.93025254299112.0697474570093
22573572.7371956253470.262804374652884
23620622.425892932077-2.42589293207659
24626625.9867684607890.0132315392114816
25620609.76205391911510.2379460808845
26588597.793345238461-9.7933452384613
27566567.168277995484-1.16827799548417
28557562.650750912377-5.65075091237739
29561554.2425380489656.75746195103478
30549552.524849980308-3.52484998030826
31532537.277526835682-5.2775268356818
32526524.7727167275791.22728327242068
33511512.460996554409-1.46099655440884
34499511.825049677965-12.8250496779655
35555549.9263859233195.0736140766809
36565562.0547373258182.94526267418223
37542551.382690133458-9.38269013345761
38527523.8369493969933.16305060300701
39510507.8546530597482.14534694025179
40514509.2977244706564.7022755293444
41517513.8000766241953.19992337580525
42508510.472147082472-2.47214708247227
43493497.187510605381-4.18751060538104
44490485.9573347797814.04266522021862
45469476.521206962408-7.5212069624076
46478470.0624835922757.93751640772524
47528527.5701458777970.429854122203224
48534535.016384452334-1.01638445233443
49518532.192395795099-14.1923957950993
50506510.060618809281-4.06061880928134
51502497.7732814915294.22671850847127
52516511.6454954825674.35450451743287
53528525.6700471281852.32995287181495
54533530.6175419014672.38245809853252
55536529.8143570383436.18564296165652
56537535.311913922981.68808607701981
57524529.359643278588-5.35964327858768
58536529.0757899959896.92421000401108
59587588.521328750597-1.52132875059686
60597596.4793515533210.520648446678803
61581584.478234852053-3.47823485205266


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.3114618126124020.6229236252248030.688538187387598
220.1662125289295030.3324250578590070.833787471070497
230.08539045173692030.1707809034738410.91460954826308
240.03789656742094910.07579313484189810.96210343257905
250.09352743855327580.1870548771065520.906472561446724
260.718423788978110.5631524220437810.281576211021891
270.6152450256834280.7695099486331430.384754974316572
280.6328633990170750.734273201965850.367136600982925
290.5726496854434310.8547006291131380.427350314556569
300.5155105547721250.968978890455750.484489445227875
310.5128528733946080.9742942532107850.487147126605392
320.5071742754276380.9856514491447240.492825724572362
330.5673490857192580.8653018285614830.432650914280742
340.8997855044683280.2004289910633450.100214495531673
350.9359848009822080.1280303980355840.0640151990177919
360.9454792856207180.1090414287585640.054520714379282
370.9450387327905950.1099225344188090.0549612672094046
380.9232757107549930.1534485784900130.0767242892450066
390.8417618004078350.3164763991843310.158238199592165
400.7845296804507210.4309406390985570.215470319549279


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 level10.05OK