Multiple Linear Regression - Estimated Regression Equation
Y[t] = -61.2630376829935 + 1.40627113005073X[t] + 13.2467444431871M1[t] + 7.91357507008057M2[t] + 7.41658892601371M3[t] + 2.76204361780485M4[t] + 0.583789724495387M5[t] + 3.66873901237363M6[t] + 4.0687525356061M7[t] + 1.47739688535246M8[t] -1.83149088257830M9[t] -5.53454530820887M10[t] -5.8656710635106M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-61.263037682993510.518752-5.824200
X1.406271130050730.04603830.545700
M113.24674444318719.7508641.35850.1807840.090392
M27.913575070080579.7406560.81240.4206430.210321
M37.416588926013719.7192640.76310.4492280.224614
M42.762043617804859.6981310.28480.7770470.388524
M50.5837897244953879.6915560.06020.9522220.476111
M63.668739012373639.6911990.37860.7067160.353358
M74.06875253560619.6911710.41980.6765150.338257
M81.477396885352469.6937740.15240.8795180.439759
M9-1.831490882578309.705371-0.18870.8511330.425567
M10-5.534545308208879.698271-0.57070.570940.28547
M11-5.86567106351069.69169-0.60520.547940.27397


Multiple Linear Regression - Regression Statistics
Multiple R0.976467560440171
R-squared0.95348889659198
Adjusted R-squared0.941613721253761
F-TEST (value)80.2926162718081
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation15.3230850012099
Sum Squared Residuals11035.4558958523


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1108.2104.5641243706983.63587562930221
2108.8104.5747852917844.22521470821608
3110.2110.1247650069350.0752349930646857
4109.5103.9233214556715.57667854432937
5109.5108.2139147605951.28608523940550
6116129.299134513122-13.2991345131221
7111.2122.949046612111-11.7490466121111
8112.1122.045216317918-9.94521631791834
9114123.23639616615-9.23639616614988
10119.1117.4239350454431.67606495455677
11114.1108.5145553968325.58544460316795
12115.1108.6145148271356.48548517286534
13115.4123.548784626383-8.1487846263826
14110.8118.356242366281-7.55624236628117
15116125.312493211483-9.31249321148318
16119.2131.62686271767-12.4268627176700
17126.5132.401778197467-5.9017781974671
18127.8132.252303886229-4.45230388622864
19131.3134.058588539512-2.75858853951184
20140.3134.842283601385.45771639862005
21137.3126.33019265226110.9698073477385
22143127.83034140781915.1696585921814
23134.5121.17099556728913.3290044327114
24139.9126.61478529178413.2852147082160
25159.3150.5491903233578.7508096766434
26170.4160.12249492878810.2775050712121
27175164.68808485290410.3119151470964
28175.8161.72106490075614.0789350992444
29180.9166.57416665770014.3258333423002
30180.3168.39347192853211.9065280714676
31169.6162.1840111405267.41598885947356
32172.3164.5146044454507.78539555454966
33184.8174.14341107398610.6565889260137
34177.7172.1278820044175.57211799558337
35184.6171.79675624911512.8032437508851
36211.4200.16276539343711.2372346065628
37215.3220.300238373873-5.00023837387282
38215.9221.99842465102-6.09842465101997
39244.7244.142403700770.557596299230145
40259.3260.863179569332-1.56317956933206
41289292.71668702325-3.71668702325026
42310.9303.3955004134027.50449958659752
43321297.04541251239123.9545874876086
44315.1293.46966707110221.6303329288978
45333.2317.02055788714016.1794421128595
46314.1308.9580629583535.14193704164743
47284.7274.59517585582310.1048241441768
48273.9262.03869511566911.8613048843307
49216215.237662305690.76233769430982
50196.4197.248052762127-0.84805276212709
51190.9192.532253227908-1.63225322790804
52206.4212.065571356572-5.66557135657176
53196.3202.293453360988-5.99345336098833
54199.5201.159589258714-1.6595892587144
55198.9215.762941195459-16.8629411954592
56214.4239.328228564149-24.9282285641491
57214.2242.769442220462-28.5694422204619
58187.6215.159778583969-27.5597785839689
59180.6222.422516930941-41.8225169309412
60172.2215.069239371975-42.8692393719749


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.0004073579925106030.0008147159850212060.99959264200749
170.00131836942862680.00263673885725360.998681630571373
180.001987210387282260.003974420774564530.998012789612718
190.003852511878288310.007705023756576610.996147488121712
200.01041306416261560.02082612832523110.989586935837384
210.01601007811387210.03202015622774420.983989921886128
220.01426646714539030.02853293429078060.98573353285461
230.008845689908621770.01769137981724350.991154310091378
240.005447875190506260.01089575038101250.994552124809494
250.004098423682028860.008196847364057720.995901576317971
260.002332965230589130.004665930461178260.99766703476941
270.001262182361056660.002524364722113320.998737817638943
280.0007932850396781120.001586570079356220.999206714960322
290.0004605103893834220.0009210207787668430.999539489610617
300.0003034989396123870.0006069978792247750.999696501060388
310.0001342534992378710.0002685069984757420.999865746500762
326.08751260054167e-050.0001217502520108330.999939124873995
334.55975484705643e-059.11950969411286e-050.99995440245153
349.9320347869373e-050.0001986406957387460.99990067965213
350.0005566841357365190.001113368271473040.999443315864263
360.002829434377358380.005658868754716760.997170565622642
370.003554564832782490.007109129665564980.996445435167218
380.003737798455968370.007475596911936730.996262201544032
390.002482009183848850.00496401836769770.99751799081615
400.001650447024359180.003300894048718360.99834955297564
410.004907339242830780.009814678485661560.99509266075717
420.06106370328146550.1221274065629310.938936296718534
430.05552313317710370.1110462663542070.944476866822896
440.03913798865661490.07827597731322970.960862011343385


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level210.724137931034483NOK
5% type I error level260.896551724137931NOK
10% type I error level270.93103448275862NOK