Multiple Linear Regression - Estimated Regression Equation
Y[t] = -50.9640522907201 + 1.07016114979443X[t] + 0.173985757105798Y1[t] + 0.293977711131534Y2[t] + 1.59007716465838M1[t] + 4.34909964071228M2[t] -6.16808657058887M3[t] + 5.25575586956772M4[t] + 2.64205857405578M5[t] -3.92509865437882M6[t] -2.86912893355579M7[t] + 2.20031881493963M8[t] + 3.4871885785655M9[t] + 5.68632854743579M10[t] + 1.38569107000666M11[t] + 0.0128020945805415t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-50.96405229072019.03349-5.64171e-061e-06
X1.070161149794430.07956513.450200
Y10.1739857571057980.0615562.82650.0071770.003588
Y20.2939777111315340.0688684.26870.000115.5e-05
M11.590077164658382.0571630.77290.4438820.221941
M24.349099640712282.4661781.76350.0850910.042545
M3-6.168086570588872.035795-3.02980.0041760.002088
M45.255755869567722.6180432.00750.0511580.025579
M52.642058574055782.6556490.99490.3254910.162745
M6-3.925098654378821.846348-2.12590.0394360.019718
M7-2.869128933555791.846323-1.5540.1276960.063848
M82.200318814939631.9296781.14030.2606420.130321
M93.48718857856552.1218851.64340.1077590.053879
M105.686328547435792.2033472.58080.0134420.006721
M111.385691070006662.1984150.63030.5319040.265952
t0.01280209458054150.0320640.39930.6917170.345859


Multiple Linear Regression - Regression Statistics
Multiple R0.980850670429848
R-squared0.962068037682683
Adjusted R-squared0.948520908283641
F-TEST (value)71.0163761889459
F-TEST (DF numerator)15
F-TEST (DF denominator)42
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2.65910913178632
Sum Squared Residuals296.976177739476


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1119.93119.2164101116130.713589888387024
294.7697.5623320245071-2.80233202450712
395.2698.2415039618835-2.98150396188351
4117.96120.879510277436-2.91951027743645
5115.86118.308468249154-2.4484682491536
6111.44111.2130057093790.226994290621141
7108.16108.434036640471-0.274036640471373
8108.77104.1551036684784.61489633152204
9109.45105.9878694407403.46213055925976
10124.83117.9148663410046.91513365899579
11115.31114.4695305614030.840469438597184
12109.49110.931916971499-1.44191697149868
13124.24125.632077481162-1.39207748116161
1492.8593.943923747105-1.09392374710498
1598.4298.1526829709810.267317029019022
16120.88120.0582879417810.821712058218956
17111.72115.190392302949-3.47039230294921
18116.1116.748534360424-0.648534360424116
19109.37108.9304804843220.43951951567756
20111.65110.5978967625111.05210323748911
21114.29112.1350601056542.15493989434616
22133.68131.3149787662012.36502123379860
23114.27115.338443354064-1.06844335406398
24126.49126.1342012301630.355798769836524
25131129.1868364722061.81316352779402
26104105.087038863418-1.08703886341766
27108.88107.3703121439401.50968785606044
28128.48127.0219134148621.45808658513812
29132.44131.0850242381771.35497576182347
30128.04127.1290357013800.91096429862042
31116.35116.931665388839-0.581665388839237
32120.93122.967164401547-2.03716440154736
33118.59120.877978779315-2.28797877931461
34133.1138.476387610345-5.37638761034508
35121.05122.434131116665-1.38413111666460
36127.62126.6548460359740.965153964025679
37135.44134.3126533836391.12734661636065
38114.88113.9434997370530.936500262947035
39114.34114.681759607881-0.341759607880524
40128.85128.86260763621-0.0126076362099425
41138.9139.222093189837-0.32209318983747
42129.44128.9434450402860.496554959714038
43114.96117.087644298075-2.12764429807471
44127.98128.320275533755-0.340275533754762
45127.03129.875783106862-2.84578310686236
46128.75132.539545050612-3.78954505061198
47137.91136.2978949678691.61210503213140
48128.37128.2490357623640.120964237636472
49135.9138.16202255138-2.26202255138009
50122.19118.1432056279174.04679437208273
51113.08111.5337413153151.54625868468456
52136.2135.5476807297110.652319270289317
53138133.1140220198834.88597798011681
54115.24116.225979188531-0.985979188531487
55110.95108.4061731882922.54382681170776
5699.23102.519559633709-3.28955963370902
57102.39102.873308567429-0.483308567428939
58112.67112.784222231837-0.114222231837341


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.4517427237684340.9034854475368690.548257276231566
200.3871567936930910.7743135873861810.612843206306909
210.31715034372780.63430068745560.6828496562722
220.3768086832416540.7536173664833070.623191316758346
230.2851609558182190.5703219116364380.714839044181781
240.5962868790607390.8074262418785230.403713120939262
250.7628765604026850.4742468791946310.237123439597315
260.7007652017073460.5984695965853070.299234798292653
270.6907703627272570.6184592745454860.309229637272743
280.6205512915075810.7588974169848370.379448708492419
290.657466436138810.6850671277223790.342533563861189
300.5695940054232970.8608119891534050.430405994576703
310.5052275388004120.9895449223991770.494772461199588
320.5965537156743670.8068925686512650.403446284325633
330.6812065375167120.6375869249665770.318793462483288
340.8194171369109290.3611657261781410.180582863089071
350.719778776644510.5604424467109810.280221223355491
360.6386671517318450.722665696536310.361332848268155
370.6945000987686530.6109998024626930.305499901231347
380.5785466661331620.8429066677336760.421453333866838
390.4033528343136030.8067056686272050.596647165686397


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