Multiple Linear Regression - Estimated Regression Equation
Y[t] = -73.1510170709155 + 1.59969233247625X[t] + 11.1606847397861M1[t] + 6.0224322816004M2[t] + 5.10915205278968M3[t] -0.50326670695449M4[t] -3.26028849504525M5[t] -0.0384486529738717M6[t] + 1.08645587982531M7[t] -1.87090434254156M8[t] -5.83979691027234M9[t] -8.29572307978729M10[t] -6.8884307248126M11[t] -0.601101440014372t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-73.151017070915510.228513-7.151700
X1.599692332476250.0722222.150200
M111.16068473978618.8920781.25510.2157720.107886
M26.02243228160048.8787780.67830.5009830.250491
M35.109152052789688.8684850.57610.5673540.283677
M4-0.503266706954498.877189-0.05670.9550360.477518
M5-3.260288495045258.892682-0.36660.7155790.35779
M6-0.03844865297387178.88698-0.00430.9965670.498283
M71.086455879825318.8616710.12260.9029570.451478
M8-1.870904342541568.876112-0.21080.833990.416995
M9-5.839796910272348.911837-0.65530.5155480.257774
M10-8.295723079787298.861467-0.93620.3540810.177041
M11-6.88843072481268.821069-0.78090.4388580.219429
t-0.6011014400143720.182858-3.28730.0019430.000971


Multiple Linear Regression - Regression Statistics
Multiple R0.98098756551415
R-squared0.96233660369338
Adjusted R-squared0.951692600389335
F-TEST (value)90.4111522896355
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation13.9379095736167
Sum Squared Residuals8936.20487098658


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1108.2110.975184302529-2.77518430252921
2108.8111.314661267739-2.51466126773874
3110.2116.678956628562-6.47895662856164
4109.5108.7057748630790.794225136920803
5109.5112.706236364365-3.20623636436480
6116135.803036622118-19.8030366221178
7111.2128.648316519017-17.4483165190166
8112.1127.009485655607-14.9094856556069
9114127.558507111786-13.5585071117857
10119.1122.101941003542-3.00194100354202
11114.1113.1500086903970.94999130960277
12115.1112.8785994120432.22140058795716
13115.4125.357813510786-9.95781351078607
14110.8119.778428845834-8.9784288458336
15116126.742416539133-10.7424165391326
16119.2133.006496532689-13.8064965326888
17126.5133.007727202784-6.50772720278385
18127.8131.949173240145-4.14917324014544
19131.3134.072668665406-2.7726686654065
20140.3134.3534686009685.94653139903174
21137.3123.86461296306113.4353870369390
22143126.72644698369416.2735530163062
23134.5120.33402240251114.165977597489
24139.9126.14144398756613.7585560124337
25159.3148.85868901415810.4413109858424
26170.4160.07607384020610.3239261597943
27175164.32058456829510.6794154317049
28175.8160.02669516750815.7733048324919
29180.9164.66703360178416.2329663982158
30180.3165.84804890461314.4519510953875
31169.6158.85329803475910.746701965241
32172.3160.89375953604511.4062404639554
33184.8171.04093498708113.7590650129191
34177.7169.9035381765237.79646182347684
35184.6170.70972909148313.8902709085165
36211.4202.5921356959028.80786430409833
37215.3220.990211424807-5.69021142480705
38215.9223.249319188988-7.34931918898821
39244.7247.489984073031-2.78998407303071
40259.3265.591787326911-6.29178732691112
41289300.946218544731-11.9462185447312
42310.9312.20529554216-1.30529554215997
43321305.05057543905915.9494245609412
44315.1300.37232914394414.7276708560559
45333.2326.3564586864956.84354131350461
46314.1318.340384846290-4.24038484628962
47284.7280.4340213153254.26597868467522
48273.9265.7653810446848.13461895531582
49216208.018101747727.98189825227993
50196.4187.8815168572348.51848314276628
51190.9181.568058190989.33194180902012
52206.4202.8692461098133.53075389018716
53196.3190.8727842863365.42721571366405
54199.5188.69444569096410.8055543090358
55198.9205.375141341759-6.47514134175912
56214.4231.570957063436-17.1709570634361
57214.2234.679486251577-20.4794862515770
58187.6204.427688989951-16.8276889899514
59180.6213.872218500284-33.2722185002835
60172.2205.122439859805-32.922439859805


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.01822145421837810.03644290843675620.981778545781622
180.02233837548027110.04467675096054210.977661624519729
190.03408568202404590.06817136404809180.965914317975954
200.08323689973652750.1664737994730550.916763100263473
210.05218375158714360.1043675031742870.947816248412856
220.03408755321314320.06817510642628640.965912446786857
230.01757535545679220.03515071091358440.982424644543208
240.01363258927554900.02726517855109790.986367410724451
250.054120613018160.108241226036320.94587938698184
260.07903828839897260.1580765767979450.920961711601027
270.06981400934992160.1396280186998430.930185990650078
280.05388654630292980.1077730926058600.94611345369707
290.03612430505406510.07224861010813030.963875694945935
300.02752209487479210.05504418974958420.972477905125208
310.01765910546355520.03531821092711030.982340894536445
320.00968699539414020.01937399078828040.99031300460586
330.004726932477569470.009453864955138950.99527306752243
340.003642720545898210.007285441091796420.996357279454102
350.001875618106964490.003751236213928980.998124381893035
360.0009370807004375720.001874161400875140.999062919299562
370.000992179236538930.001984358473077860.999007820763461
380.003354991580429320.006709983160858630.99664500841957
390.01179078931643190.02358157863286390.988209210683568
400.3353477739923060.6706955479846120.664652226007694
410.7642603164542620.4714793670914760.235739683545738
420.9936064853949360.01278702921012710.00639351460506355
430.98277555880130.0344488823974020.017224441198701


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level60.222222222222222NOK
5% type I error level150.555555555555556NOK
10% type I error level190.703703703703704NOK