Multiple Linear Regression - Estimated Regression Equation
Y[t] = -28.8691767006593 + 0.722631087194356X[t] + 0.68166492131029Y1[t] + 0.0357487587076676Y2[t] -0.136738073603211Y3[t] -0.0259058241864742Y4[t] -4.2607956589844M1[t] -2.90302129402693M2[t] -6.12901499458149M3[t] -3.79239104204496M4[t] -4.25182903906736M5[t] -13.9408302154570M6[t] -11.8293883425912M7[t] -0.0234283729133178M8[t] -2.79353232120853M9[t] -2.46252649385462M10[t] + 5.15904113856754M11[t] -0.3517093324785t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-28.869176700659311.622676-2.48390.0175220.008761
X0.7226310871943560.1417295.09871e-055e-06
Y10.681664921310290.1619334.20950.0001517.5e-05
Y20.03574875870766760.1987510.17990.8582120.429106
Y3-0.1367380736032110.201583-0.67830.5016790.250839
Y4-0.02590582418647420.132452-0.19560.8459760.422988
M1-4.26079565898446.930106-0.61480.5423350.271168
M2-2.903021294026937.122116-0.40760.685850.342925
M3-6.129014994581497.187253-0.85280.3991350.199567
M4-3.792391042044967.243078-0.52360.6036050.301803
M5-4.251829039067367.064731-0.60180.5508560.275428
M6-13.94083021545706.960589-2.00280.0523680.026184
M7-11.82938834259127.515352-1.5740.1237710.061885
M8-0.02342837291331787.466075-0.00310.9975130.498756
M9-2.793532321208537.628985-0.36620.7162660.358133
M10-2.462526493854627.717026-0.31910.7513960.375698
M115.159041138567547.6512880.67430.5042210.25211
t-0.35170933247850.176384-1.9940.0533650.026682


Multiple Linear Regression - Regression Statistics
Multiple R0.990946497626736
R-squared0.981974961158695
Adjusted R-squared0.973911127992848
F-TEST (value)121.775208013687
F-TEST (DF numerator)17
F-TEST (DF denominator)38
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation10.1208126903771
Sum Squared Residuals3892.3722815205


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1109.5114.208021387977-4.70802138797678
2116124.231763407891-8.23176340789096
3111.2121.675701642503-10.4757016425032
4112.1121.506282953435-9.40628295343544
5114122.560662011918-8.56066201191806
6119.1113.2512970016685.84870299833185
7114.1114.148677340249-0.0486773402491406
8115.1119.131017001195-4.03101700119537
9115.4116.632696911496-1.23269691149615
10110.8117.476075414857-6.67607541485681
11116125.443735513845-9.44373551384466
12119.2128.882793577405-9.68279357740541
13126.5128.776258553842-2.27625855384229
14127.8132.618950847725-4.81895084772499
15131.3130.3387371168560.961262883144313
16140.3135.4091803823864.89081961761399
17137.3137.81753096529-0.517530965289984
18143128.21503871442514.7849612855745
19134.5129.1798620907025.32013790929774
20139.9135.0040012983714.89599870162908
21159.3140.04962085935619.2503791406442
22170.4162.1207600766978.27923992330312
23175179.733910744141-4.73391074414088
24175.8175.830177358901-0.0301773589012391
25180.9173.5202384243007.37976157569961
26180.3176.4644757969083.83552420309158
27169.6169.0351691205440.564830879455514
28172.3165.5159397978126.78406020218753
29184.8172.76090518067612.0390948193237
30177.7173.6833260233974.01667397660301
31184.6170.95809662639413.6419033736063
32211.4196.64494478357614.7550552164243
33215.3216.226327676505-0.926327676504908
34215.9222.675778177690-6.77577817768954
35244.7238.2850855337566.4149144662443
36259.3262.184172001775-2.88417200177477
37289285.8581358638373.14186413616275
38310.9307.5801887929293.31981120707104
39321313.7815928404997.21840715950129
40315.1318.489033401315-3.38903340131464
41333.2324.0554124741949.14458752580584
42314.1321.953370901288-7.85337090128819
43284.7294.39778947713-9.69778947712996
44273.9273.3397081247260.560291875273653
45216233.091354552643-17.0913545526431
46196.4191.2273863307575.17261366924323
47190.9183.1372682082597.76273179174125
48206.4193.80285706191912.5971429380814
49196.3199.837345770043-3.53734577004328
50199.5193.6046211545475.89537884545333
51198.9197.1687992795981.73120072040208
52214.4213.2795634650511.12043653494857
53214.2226.305489367921-12.1054893679215
54187.6204.396967359221-16.7969673592212
55180.6189.815574465525-9.21557446552495
56172.2188.380328792132-16.1803287921317


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.2479425647432330.4958851294864660.752057435256767
220.1540354396091450.3080708792182900.845964560390855
230.1280760905211940.2561521810423870.871923909478806
240.06071249890876060.1214249978175210.93928750109124
250.05360446035325640.1072089207065130.946395539646744
260.03692833761778030.07385667523556050.96307166238222
270.08132111393939450.1626422278787890.918678886060605
280.1000833600596580.2001667201193160.899916639940342
290.1253499074377590.2506998148755180.874650092562241
300.7371002263789760.5257995472420480.262899773621024
310.6779627275523540.6440745448952920.322037272447646
320.6070998314812620.7858003370374750.392900168518738
330.6381702250388370.7236595499223260.361829774961163
340.7389991898895920.5220016202208160.261000810110408
350.7656950373123880.4686099253752250.234304962687612


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.0666666666666667OK