Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 632.244505651929 + 6.14920105647311X[t] + 70.0919714626187M1[t] -21.2602057945611M2[t] + 119.638415891786M3[t] -509.343601576689M4[t] -182.313541791994M5[t] -130.214920105647M6[t] -247.918507903497M7[t] -199.249726428445M8[t] -400.681743896919M9[t] + 547.587836521659M10[t] -2.53068226740704M11[t] -10.9671835879982t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)632.2445056519291461.4201210.43260.6676120.333806
X6.149201056473114.3346531.41860.1637570.081878
M170.0919714626187111.3402530.62950.5325820.266291
M2-21.2602057945611111.468448-0.19070.8497030.424852
M3119.638415891786111.2867231.0750.2887960.144398
M4-509.343601576689111.407597-4.57194.6e-052.3e-05
M5-182.313541791994110.911423-1.64380.1080610.05403
M6-130.214920105647110.898206-1.17420.2472650.123632
M7-247.918507903497117.494905-2.110.0411580.020579
M8-199.249726428445117.252797-1.69930.0970250.048513
M9-400.681743896919117.329468-3.4150.0014750.000738
M10547.587836521659116.9576974.68193.2e-051.6e-05
M11-2.53068226740704116.90892-0.02160.9828370.491419
t-10.96718358799826.5271-1.68030.1007030.050351


Multiple Linear Regression - Regression Statistics
Multiple R0.878170238609815
R-squared0.77118296798002
Adjusted R-squared0.696817432573527
F-TEST (value)10.3701662842151
F-TEST (DF numerator)13
F-TEST (DF denominator)40
p-value4.5114849633876e-09
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation165.316021337892
Sum Squared Residuals1093175.47643962


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
123542720.60564216268-366.60564216268
226972624.4354823739772.5645176260287
326512760.51612152879-109.516121528793
420672132.86532258527-65.8653225852655
526412448.92819878196192.071801218038
625392490.0596368803148.9403631196892
722942392.13487077683-98.1348707768288
827122466.73167500272245.268324997279
923142260.4816750027253.5183249972787
1030923234.67927817214-142.679278172141
1126772692.04117896450-15.0411789644958
1228132702.05228081332110.947719186676
1326682779.62467185736-111.624671857363
1429392689.60371312513249.396286874868
1526172825.68435227995-208.684352279953
1622312191.8843522799539.1156477200466
1724812514.09642953312-33.0964295331232
1824212579.82467185736-158.824671857364
1924082457.30310152799-49.3031015279895
2025602495.0046994150464.9953005849567
2121002288.75469941504-188.754699415043
2233153232.206297302182.793702697903
2328012671.12059492503129.879405074968
2424032668.83329466091-265.833294660914
2530242734.10728359201289.892716407992
2625072631.78792274683-124.78792274683
2729802767.86856190165212.131438098349
2822112127.9193608451883.0806391548213
2924712450.1314380983520.8685619016516
3025942491.26287619670102.737123803303
3124522368.7413058673283.2586941326776
3222322412.59210481085-180.592104810849
3323732206.34210481085166.657895189151
3431273168.24130586732-41.2413058673222
3528022637.90160877262164.098391227377
3626412635.614308508515.38569149149479
3727872700.888297439686.1117025604014
3826192604.7181376508914.2818623491061
3928062740.7987768057265.2012231942845
4021932106.9987768057286.0012231942845
4123232423.06165300241-100.061653002412
4225292470.3422921572358.6577078427661
4324122347.8207218278664.1792781721407
4422622391.67152077139-129.671520771386
4521542185.42152077139-31.4215207713861
4632303128.87311865844101.126881341560
4722952573.93661733785-278.936617337848
4827152565.50011601726149.499883982743
4927332630.77410494835102.225895051649
5023172528.45474410317-211.454744103173
5127302689.1321874838940.8678125161131
5219132055.33218748389-142.332187483887
5323902469.78228058415-79.7822805841535
5424842535.51052290839-51.5105229083943


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.487267219643240.974534439286480.51273278035676
180.487685564908620.975371129817240.51231443509138
190.3535186134167890.7070372268335780.646481386583211
200.5839489037006510.8321021925986990.416051096299349
210.6445590939269640.7108818121460730.355440906073036
220.6514226632090630.6971546735818740.348577336790937
230.5555471571760500.88890568564790.44445284282395
240.9232061284582560.1535877430834890.0767938715417443
250.9763518961001620.0472962077996750.0236481038998375
260.9862800745700880.02743985085982370.0137199254299119
270.9822939243052010.03541215138959780.0177060756947989
280.9647625984694040.07047480306119290.0352374015305964
290.9403821748539490.1192356502921020.0596178251460512
300.8963749880593730.2072500238812530.103625011940627
310.8327776371893250.3344447256213500.167222362810675
320.8439059807742980.3121880384514040.156094019225702
330.7829498861257180.4341002277485630.217050113874282
340.7668269998918480.4663460002163040.233173000108152
350.8891629395204210.2216741209591570.110837060479579
360.9188902150883240.1622195698233510.0811097849116756
370.9033474451049340.1933051097901330.0966525548950663


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level30.142857142857143NOK
10% type I error level40.190476190476190NOK