Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 4034.67414588099 -212.018661728933X[t] + 149.111280543151M1[t] -155.569382420216M2[t] + 125.531550666231M3[t] + 18.9031937939464M4[t] + 42.8421256459596M5[t] + 429.378880296264M6[t] -10.3214307325519M7[t] -131.409330864466M8[t] -134.291943506517M9[t] + 94.7117888392695M10[t] -220.682612642051M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)4034.67414588099453.0246018.906100
X-212.01866172893352.75716-4.01880.0001839.1e-05
M1149.111280543151167.7578150.88880.3780270.189013
M2-155.569382420216173.688078-0.89570.3743980.187199
M3125.531550666231173.0177480.72550.4712530.235626
M418.9031937939464170.090190.11110.911920.45596
M542.8421256459596168.1481780.25480.7998550.399927
M6429.378880296264167.6872872.56060.0132780.006639
M7-10.3214307325519167.70619-0.06150.9511530.475576
M8-131.409330864466177.088114-0.74210.4612690.230634
M9-134.291943506517178.337931-0.7530.4547090.227354
M1094.7117888392695176.6443350.53620.5940410.297021
M11-220.682612642051175.268148-1.25910.2134050.106702


Multiple Linear Regression - Regression Statistics
Multiple R0.64418846056054
R-squared0.414978772719358
Adjusted R-squared0.284974055545882
F-TEST (value)3.19202857974467
F-TEST (DF numerator)12
F-TEST (DF denominator)54
p-value0.0016767257417023
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation276.877096315935
Sum Squared Residuals4139690.02907454


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
123602466.43426641978-106.434266419778
222142310.16666666667-96.1666666666658
328252612.46946592601212.530534073993
423552421.03364436215-66.0336443621488
523332381.36697769548-48.3669776954822
630162767.90373234579248.096267654213
721552391.80901983565-236.809019835651
821722440.33604908688-268.336049086882
921502501.05903496351-351.059034963512
1025332666.45716879062-133.457168790618
1120582223.85157027194-165.851570271939
1221602359.72671822242-199.726718222416
1322602551.24173111135-291.241731111353
1424982500.98346222271-2.98346222270652
1526952866.89186000073-171.891860000726
1627992696.65790460976102.342095390238
1729472635.7893717702311.210628229798
1829302958.72052790183-28.7205279018265
1923182476.61648452722-158.616484527224
2025402376.73045056820163.269549431797
2125702416.25157027194153.748429728062
2226692645.2553026177323.7446973822750
2324502329.86090113641120.139098863595
2428422486.93791525978355.062084740224
2534402593.64546345714846.35453654286
2626782352.57039901245325.429600987547
2729812527.66200123443453.337998765567
2822602357.42804584347-97.4280458434689
2928442402.56884386838441.431156131625
3025462767.90373234579-221.903732345787
3124562328.20342131697127.796578683029
3222952228.3173873579566.6826126420505
3323792225.4347747159153.565225284101
3424792433.2366408887945.763359111208
3520572096.64037323458-39.6403732345787
3622802317.32298587663-37.3229858766295
3723512445.23240024689-94.232400246887
3822762182.9554696293193.044530370693
3925482400.45080419707147.549195802927
4023112251.41871497959.5812850209976
4122012254.15578065812-53.1557806581225
4227252619.49066913553105.509330864466
4324082179.79035810672228.209641893282
4421392101.1061903205937.8938096794103
4518982119.42544385143-221.425443851432
4625372327.22731002433209.772689975674
4720691969.4291761972299.570823802781
4820632190.11178883927-127.111788839270
4925242360.42493555531163.575064444686
5024372204.1573358022232.842664197800
5121892442.85453654286-253.85453654286
5227932315.02431349768477.975686502318
5320742275.35764683102-201.357646831016
5426222640.69253530843-18.6925353084269
5522782222.1940904525055.8059095474956
5621442143.509922666380.490077333623784
5724272161.82917619722265.170823802781
5821392284.82357767854-145.823577678539
5918281842.21797915986-14.2179791598589
6020722062.900591801919.09940819809035
6118002318.02120320953-518.021203209527
6217582310.16666666667-552.166666666667
6322462633.6713320989-387.6713320989
6419872463.43737670794-476.437376707936
6518682317.76137917680-449.761379176802
6625142598.28880296264-84.28880296264
6721212137.38662576093-16.3866257609312


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.2435857645292880.4871715290585760.756414235470712
170.2556020548782270.5112041097564550.744397945121773
180.2063557254460270.4127114508920540.793644274553973
190.1273338171437430.2546676342874850.872666182856257
200.1555391029040250.3110782058080510.844460897095975
210.2002474709691060.4004949419382130.799752529030894
220.1377893242948980.2755786485897960.862210675705102
230.1134574501623020.2269149003246040.886542549837698
240.1658873859118550.3317747718237100.834112614088145
250.7751845274000330.4496309451999350.224815472599967
260.7925698195314960.4148603609370090.207430180468504
270.8672373802985910.2655252394028170.132762619701409
280.8169034623344440.3661930753311130.183096537665556
290.911263527840830.177472944318340.08873647215917
300.8904231202521790.2191537594956420.109576879747821
310.8694689489530470.2610621020939070.130531051046953
320.823918966029470.352162067941060.17608103397053
330.7862892452978840.4274215094042320.213710754702116
340.7242284116339050.5515431767321890.275771588366095
350.6538830027265690.6922339945468630.346116997273431
360.6114797661467380.7770404677065240.388520233853262
370.577635232128510.844729535742980.42236476787149
380.4930460447986120.9860920895972250.506953955201388
390.4304617463977170.8609234927954330.569538253602283
400.3530465872117790.7060931744235570.646953412788221
410.3130726645836770.6261453291673540.686927335416323
420.2447453411117180.4894906822234370.755254658888282
430.2073728760988450.4147457521976890.792627123901155
440.1430581750885480.2861163501770950.856941824911452
450.1661107104535730.3322214209071460.833889289546427
460.1588513771012260.3177027542024520.841148622898774
470.1377959023440980.2755918046881960.862204097655902
480.09401739490738920.1880347898147780.905982605092611
490.2574369766066690.5148739532133380.74256302339333
500.3082640461015710.6165280922031420.691735953898429
510.4177554359771540.8355108719543070.582244564022846


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