Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 103.383194533056 + 25.3980395469445X[t] -11.9519519732223M1[t] -7.33695962722222M2[t] -8.60218710461113M3[t] -5.19122898000001M4[t] -21.800102M5[t] -4.97138650461111M6[t] -10.6623604786111M7[t] -11.0091223346111M8[t] + 2.50439116738889M9[t] -12.59051504M10[t] -5.32324779461111M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)103.3831945330567.42266513.92800
X25.39803954694454.7518745.34483e-061e-06
M1-11.95195197322238.285176-1.44260.1557730.077886
M2-7.336959627222228.285176-0.88560.3803670.190184
M3-8.602187104611138.120006-1.05940.294840.14742
M4-5.191228980000018.064198-0.64370.5228740.261437
M5-21.8001028.064198-2.70330.0095250.004763
M6-4.971386504611118.120006-0.61220.543330.271665
M7-10.66236047861118.120006-1.31310.1955250.097763
M8-11.00912233461118.120006-1.35580.1816410.090821
M92.504391167388898.1200060.30840.7591240.379562
M10-12.590515048.064198-1.56130.1251650.062583
M11-5.323247794611118.120006-0.65560.5152960.257648


Multiple Linear Regression - Regression Statistics
Multiple R0.700889678005733
R-squared0.49124634073498
Adjusted R-squared0.361351789433272
F-TEST (value)3.78188565888308
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0.000490109125249605
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation12.7506163904545
Sum Squared Residuals7641.17626181678


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
110091.43124255983358.5687574401665
295.8439571696.0462349058333-0.202277745833311
3105.5073942120.179046975389-14.6716527753889
4118.1540031123.5900051-5.436002
5101.8612953106.98113208-5.11983677999997
6109.8419174123.809847575389-13.9679301753889
7105.6348802118.118873601389-12.4839934013889
8112.927078117.772111745389-4.84503374538888
9133.0698623131.2856252473891.78423705261114
10125.6756757116.190719049.48495666000002
11146.736359123.45798628538923.2783727146111
12142.5803162128.7812340813.7990821200000
13106.1448241116.829282106778-10.6844580067777
14126.5170831121.4442744527785.07280864722221
15132.7893932120.17904697538912.6103462246111
16121.2391637123.5900051-2.35084139999999
17114.5079041106.981132087.52677202
18146.1499235123.80984757538922.3400759246111
19146.1244263118.11887360138928.0055526986111
20128.5058644117.77211174538910.7337526546111
21155.5838858131.28562524738924.2982605526111
22125.0382458116.190719048.84752676
23136.8944416123.45798628538913.4364553146111
24142.2233554128.7812340813.44212132
25117.7715451116.8292821067780.942262993222257
26120.627231121.444274452778-0.817043452777788
27127.7664457120.1790469753897.58739872461112
28135.1096379123.590005111.5196328
29105.7113717106.98113208-1.26976038000000
30117.9245283123.809847575389-5.88531927538889
31120.754717118.1188736013892.6358433986111
32107.572667117.772111745389-10.1994447453889
33130.4436512131.285625247389-0.841974047388886
34107.2157063116.19071904-8.97501274000001
35105.0739419123.457986285389-18.3840443853889
36130.1121877128.781234081.33095361999999
37109.6379398116.829282106778-7.19134230677774
38116.7261601121.444274452778-4.71811435277778
3997.1188169394.78100742844442.33780950155557
40140.8975013123.590005117.3074962
41108.2865885106.981132081.30545641999999
4297.6542580398.4118080284444-0.757549998444434
43112.0346762118.118873601389-6.08419740138889
44123.0494646117.7721117453895.2773528546111
45112.4171341131.285625247389-18.8684911473889
46116.4966854116.190719040.305966360000001
47104.6914839123.457986285389-18.7665023853889
48122.2335543128.78123408-6.54767978000001
4999.7960224491.43124255983338.36477988016673
5096.7108618196.04623490583330.664626904166679
51112.3151453120.179046975389-7.86390167538889
52102.5497195123.5900051-21.0402856
53104.5385008106.98113208-2.44263128000001
54122.0805711123.809847575389-1.72927647538890
5580.6476287692.7208340544444-12.0732052944444
5691.4074451892.3740721984444-0.966627018444427
5799.51555329105.887585700444-6.37203241044442
58106.527282116.19071904-9.66343704
5998.4956654898.05994673844440.435718741555576
60106.7567568128.78123408-22.02447728


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.5949498499276880.8101003001446230.405050150072312
170.4924963570679710.9849927141359430.507503642932029
180.776662625331380.446674749337240.22333737466862
190.9443016375592770.1113967248814460.055698362440723
200.9272173965280940.1455652069438120.0727826034719059
210.9670817917404850.06583641651903010.0329182082595150
220.9530875727620440.0938248544759130.0469124272379565
230.9680444880997130.06391102380057380.0319555119002869
240.973794438439200.05241112312159850.0262055615607992
250.9556953489436480.08860930211270340.0443046510563517
260.9276312381818180.1447375236363640.0723687618181819
270.913302139144120.1733957217117600.0866978608558802
280.9135785706725580.1728428586548850.0864214293274425
290.8680539968283660.2638920063432680.131946003171634
300.8211161951837940.3577676096324120.178883804816206
310.8022444693403470.3955110613193050.197755530659653
320.7727111257443750.4545777485112510.227288874255625
330.7793190979262390.4413618041475220.220680902073761
340.7455667400586420.5088665198827150.254433259941358
350.810264369767230.3794712604655390.189735630232769
360.8084650555232250.3830698889535510.191534944476775
370.7480630108519040.5038739782961920.251936989148096
380.6502232677933760.6995534644132480.349776732206624
390.54832296446950.9033540710610.4516770355305
400.9115536203552870.1768927592894270.0884463796447134
410.8451931066635520.3096137866728960.154806893336448
420.7463710621841990.5072578756316010.253628937815801
430.6990430947939050.6019138104121910.300956905206095
440.7558520979406650.488295804118670.244147902059335


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 level50.172413793103448NOK