Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 17654549.7169412 -1839472.92735294X[t] -1571508.65347059M1[t] + 520775.106529412M2[t] + 1159579.77M3[t] + 727630.592M4[t] + 49483.014M5[t] + 209356.366000001M6[t] -334884.508M7[t] + 1756609.548M8[t] + 368185.735999999M9[t] + 379876.924000001M10[t] + 1535339.136M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)17654549.7169412791300.8104722.310800
X-1839472.92735294466278.474202-3.9450.0002650.000132
M1-1571508.653470591091529.923072-1.43970.1565720.078286
M2520775.1065294121091529.9230720.47710.6354980.317749
M31159579.771087538.9410691.06620.2917610.14588
M4727630.5921087538.9410690.66910.5067290.253365
M549483.0141087538.9410690.04550.9639020.481951
M6209356.3660000011087538.9410690.19250.8481760.424088
M7-334884.5081087538.941069-0.30790.7594970.379749
M81756609.5481087538.9410691.61520.1129580.056479
M9368185.7359999991087538.9410690.33850.7364570.368228
M10379876.9240000011087538.9410690.34930.7284250.364212
M111535339.1361087538.9410691.41180.1646080.082304


Multiple Linear Regression - Regression Statistics
Multiple R0.61198741386414
R-squared0.374528594728118
Adjusted R-squared0.214833767850191
F-TEST (value)2.34527693883543
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0.0187656331272622
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation1719550.04895249
Sum Squared Residuals138972061430068


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
114731798.3716083041.0634706-1351242.69347061
216471559.6218175324.8234706-1703765.20347059
315213975.9518814129.4869412-3600153.53694118
417637387.418382180.3089412-744792.908941177
517972385.8317704032.7309412268353.099058822
616896235.5517863906.0829412-967670.532941176
716697955.9417319665.2089412-621709.268941176
819691579.5219411159.2649412280420.255058822
915930700.7518022735.4529412-2092034.70294118
1017444615.9818034426.6409412-589810.660941177
1117699369.8819189888.8529412-1490518.97294118
1215189796.8117654549.7169412-2464752.90694118
1315672722.7516083041.0634706-410318.313470583
1417180794.318175324.8234706-994530.523470587
1517664893.4518814129.4869412-1149236.03694118
1617862884.9818382180.3089412-519295.328941175
1716162288.8817704032.7309412-1541743.85094118
1817463628.8217863906.0829412-400277.262941176
1916772112.1717319665.2089412-547553.038941176
2019106861.4819411159.2649412-304297.784941176
2116721314.2518022735.4529412-1301421.20294118
2218161267.8518034426.6409412126841.209058824
2318509941.219189888.8529412-679947.652941177
2417802737.9717654549.7169412148188.253058822
2516409869.7516083041.0634706326828.686529417
2617967742.0418175324.8234706-207582.783470589
2720286602.2718814129.48694121472472.78305882
2819537280.8118382180.30894121155100.50105882
2918021889.6217704032.7309412317856.889058825
3020194317.2317863906.08294122330411.14705882
3119049596.6217319665.20894121729931.41105882
3220244720.9419411159.2649412833561.675058825
3321473302.2418022735.45294123450566.78705882
3419673603.1918034426.64094121639176.54905882
3521053177.2919189888.85294121863288.43705882
3620159479.8417654549.71694122504930.12305882
3718203628.3116083041.06347062120587.24652941
3821289464.9418175324.82347063114140.11652941
3920432335.7116974656.55958823457679.15041176
4017180395.0716542707.3815882637687.688411765
4115816786.3215864559.8035882-47773.4835882354
4215071819.7516024433.1555882-952613.405588236
4314521120.6115480192.2815882-959071.671588236
4415668789.3917571686.3375882-1902896.94758824
4514346884.1116183262.5255882-1836378.41558824
4613881008.1316194953.7135882-2313945.58358823
4715465943.6917350415.9255882-1884472.23558824
4814238232.9215815076.7895882-1576843.86958824
4913557713.2114243568.1361176-685854.926117641
5016127590.2916335851.8961176-208261.606117648
5116793894.216974656.5595882-180762.359588236
5216014007.4316542707.3815882-528699.951588235
5316867867.1515864559.80358821003307.34641176
5416014583.2116024433.1555882-9849.94558823517
5515878594.8515480192.2815882398402.568411764
5618664899.1417571686.33758821093212.80241176
5717962530.0616183262.52558821779267.53441176
5817332692.216194953.71358821137738.48641176
5919542066.3517350415.92558822191650.42441177
6017203555.1915815076.78958821388478.40041177


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.3013310640699830.6026621281399650.698668935930017
170.289024244511730.578048489023460.71097575548827
180.1807710166152900.3615420332305800.81922898338471
190.1033254261119890.2066508522239780.896674573888011
200.05804496510917360.1160899302183470.941955034890826
210.04651924516738560.09303849033477120.953480754832614
220.02678034705748530.05356069411497070.973219652942515
230.01964071367320360.03928142734640720.980359286326796
240.04991969967222790.09983939934445570.950080300327772
250.04084394496375830.08168788992751650.959156055036242
260.04123227846148520.08246455692297040.958767721538515
270.2232018549789010.4464037099578010.7767981450211
280.2103557861295380.4207115722590770.789644213870462
290.2044752495914870.4089504991829730.795524750408513
300.2655866032324380.5311732064648750.734413396767562
310.2592067716906270.5184135433812530.740793228309373
320.2088919093619140.4177838187238280.791108090638086
330.4216823359482560.8433646718965120.578317664051744
340.3590935274406820.7181870548813630.640906472559318
350.3502777040973730.7005554081947470.649722295902627
360.3549603083616300.7099206167232590.64503969163837
370.3082602475537510.6165204951075010.69173975244625
380.3140989435673520.6281978871347040.685901056432648
390.3328938341816160.6657876683632330.667106165818384
400.2800174167676020.5600348335352040.719982583232398
410.2075957262093810.4151914524187620.792404273790619
420.1518355522308880.3036711044617760.848164447769112
430.09904816228543880.1980963245708780.900951837714561
440.0865989300687250.173197860137450.913401069931275


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level10.0344827586206897OK
10% type I error level60.206896551724138NOK