Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 2718.53693396615 -143.325735825476X[t] + 149.357889865432M1[t] + 79.583054198158M2[t] + 308.876265971366M3[t] + 174.909067479149M4[t] + 155.408839553913M5[t] + 443.408839553913M6[t] + 8.6416410616967M7[t] -52.0585868635391M8[t] -25.2585868635390M9[t] + 169.654305814339M10[t] -198.166286791274M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)2718.53693396615165.41818416.434300
X-143.32573582547638.433263-3.72920.0005070.000254
M1149.357889865432158.8812560.94010.3518940.175947
M279.583054198158166.5383840.47790.6349150.317457
M3308.876265971366166.4824611.85530.0696990.034849
M4174.909067479149166.2643211.0520.298070.149035
M5155.408839553913166.1840780.93520.3543860.177193
M6443.408839553913166.1840782.66820.010370.005185
M78.6416410616967166.0278350.0520.9587050.479353
M8-52.0585868635391165.974178-0.31370.7551420.377571
M9-25.2585868635390165.974178-0.15220.879680.43984
M10169.654305814339165.8931181.02270.3115890.155795
M11-198.166286791274165.831295-1.1950.2379630.118982


Multiple Linear Regression - Regression Statistics
Multiple R0.677027504049389
R-squared0.458366241239345
Adjusted R-squared0.322957801549182
F-TEST (value)3.38506404983442
F-TEST (DF numerator)12
F-TEST (DF denominator)48
p-value0.00125516766011968
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation262.184694437486
Sum Squared Residuals3299559.07186933


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
123602581.24335218062-221.243352180622
222142511.46851651335-297.468516513352
328252740.7617282865684.23827171344
423552606.79452979434-251.794529794343
523332587.29430186911-254.294301869108
630162875.29430186911140.705698130893
721552440.52710337689-285.527103376891
821722379.82687545165-207.826875451655
921502406.62687545165-256.626875451655
1025332601.53976812953-68.5397681295326
1120582233.71917552392-175.71917552392
1221602431.88546231519-271.885462315194
1322602581.24335218063-321.243352180626
1424982511.46851651335-13.4685165133519
1526952740.76172828656-45.7617282865597
1627992606.79452979434192.205470205657
1729472587.29430186911359.705698130893
1829302875.2943018691154.7056981308925
1923182440.52710337689-122.527103376891
2025402379.82687545165160.173124548345
2125702406.62687545165163.373124548345
2226692601.5397681295367.4602318704673
2324502233.71917552392216.280824476080
2428422431.88546231519410.114537684806
2534402581.24335218063858.756647819374
2626782511.46851651335166.531483486648
2729812740.76172828656240.238271713440
2822602576.69612527099-316.696125270993
2928442551.46286791274292.537132087262
3025462839.46286791274-293.462867912738
3124562376.0305222554379.9694777445737
3222952308.16400753892-13.1640075389167
3323792334.9640075389244.0359924610832
3424792509.81129720123-30.8112972012277
3520572126.22487365481-69.2248736548125
3622802298.5925279975-18.5925279975007
3723512437.91761635515-86.9176163551494
3822762343.77740559754-67.7774055975444
3925482561.60455850471-13.6045585047140
4023112407.57175699693-96.5717569969307
4122012372.30569813089-171.305698130893
4227252660.3056981308964.6943018691073
4324082204.03963926485203.960360735145
4421392129.006837757079.9931622429289
4518982155.80683775707-257.806837757071
4625372329.22087006113207.779129938873
4720691947.06770387297121.932296127033
4820632145.23399066424-82.2339906642408
4925242294.59188052967229.408119470327
5024372224.8170448624212.182955137601
5121892454.11025663561-265.110256635607
5227932320.14305814339472.85694185661
5320742300.64283021815-226.642830218154
5426222588.6428302181533.3571697818456
5522782153.87563172594124.124368274062
5621442093.175403800750.824596199298
5724272119.9754038007307.024596199298
5821392314.88829647858-175.888296478580
5918281921.26907142438-93.2690714243812
6020722109.40255670787-37.4025567078717
6118002258.76044657330-458.760446573304


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.4730084511424250.946016902284850.526991548857575
170.6966472341740360.6067055316519290.303352765825964
180.5614869300910360.8770261398179280.438513069908964
190.4732864221098780.9465728442197550.526713577890122
200.4502559961552340.9005119923104670.549744003844766
210.4509111060483820.9018222120967640.549088893951618
220.3502024866834070.7004049733668140.649797513316593
230.3362427303674310.6724854607348620.663757269632569
240.4963160872842580.9926321745685160.503683912715742
250.974835691618690.05032861676262090.0251643083813104
260.9643673210881650.07126535782366990.0356326789118350
270.9644166770229260.07116664595414870.0355833229770743
280.9666047634030130.06679047319397350.0333952365969867
290.9835554425860860.03288911482782720.0164445574139136
300.9813320007884030.0373359984231940.018667999211597
310.9728522527366740.05429549452665240.0271477472633262
320.9529034539574140.09419309208517210.0470965460425861
330.9233720048977640.1532559902044720.076627995102236
340.8801643269576260.2396713460847490.119835673042374
350.823195374355890.3536092512882190.176804625644109
360.7513490771680620.4973018456638760.248650922831938
370.670534397524960.6589312049500790.329465602475039
380.5965321939668510.8069356120662980.403467806033149
390.5342106023518740.9315787952962530.465789397648126
400.6144907328383020.7710185343233970.385509267161698
410.5046028561831960.9907942876336080.495397143816804
420.3908428719977750.781685743995550.609157128002225
430.2927953258390240.5855906516780470.707204674160976
440.1890239606713030.3780479213426060.810976039328697
450.5154442562872560.9691114874254880.484555743712744


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level20.0666666666666667NOK
10% type I error level80.266666666666667NOK