Multiple Linear Regression - Estimated Regression Equation
Y[t] = -1581.71366541556 + 17.1393927894853X[t] -1.45486092444313M1[t] -0.824024568713355M2[t] + 5.5934443397917M3[t] + 41.7883174989466M4[t] + 8.69965578100341M5[t] + 10.2346763403491M6[t] + 4.92475170042933M7[t] + 7.20871783851072M8[t] + 11.3211930468029M9[t] + 30.1172787296379M10[t] -3.60510496166605M11[t] -1.50025676429478t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-1581.71366541556282.09094-5.60711e-061e-06
X17.13939278948532.8725225.966700
M1-1.4548609244431312.93169-0.11250.9109030.455452
M2-0.82402456871335513.566718-0.06070.9518250.475912
M35.593444339791713.560870.41250.6818710.340935
M441.788317498946614.6522082.8520.0064370.003218
M58.6996557810034113.5340180.64280.5234780.261739
M610.234676340349113.5146810.75730.452650.226325
M74.9247517004293313.5254630.36410.7174090.358705
M87.2087178385107213.5249810.5330.596550.298275
M911.321193046802913.5232370.83720.4067360.203368
M1030.117278729637913.8120412.18050.034260.01713
M11-3.6051049616660513.539742-0.26630.7912030.395601
t-1.500256764294780.612783-2.44830.0181420.009071


Multiple Linear Regression - Regression Statistics
Multiple R0.905968603940365
R-squared0.820779111325654
Adjusted R-squared0.771207376160409
F-TEST (value)16.5574012809846
F-TEST (DF numerator)13
F-TEST (DF denominator)47
p-value2.46247466861860e-13
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation21.3062643774529
Sum Squared Residuals21335.9743809301


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1108.5107.1606791457971.33932085420329
2112.3103.3775619630188.9224380369823
3116.6102.46738055880314.1326194411971
4115.5115.2235741831220.276425816878101
5120.1117.3129562703822.78704372961763
6132.9127.4599618112305.44003818877033
7128.1123.5634771812274.53652281877262
8129.3127.2608833292272.03911667077351
9132.5135.700495321649-3.20049532164891
10131135.514143594914-4.51414359491423
11124.9130.971016232494-6.071016232494
12120.8133.075864429865-12.2758644298653
13122127.207049966915-5.20704996691508
14122.1124.966478135191-2.86647813519102
15127.4131.254841702560-3.85484170256033
16135.2143.154065687405-7.95406568740485
17137.3147.642962765193-10.3429627651933
18135146.477969064980-11.4779690649804
19136149.437241550772-13.4372415507723
20138.4156.391132328774-17.9911323287736
21134.7160.374502195930-25.6745021959297
22138.4158.816999046036-20.4169990460363
23133.9153.588295972037-19.6882959720368
24133.6147.294841702560-13.6948417025603
25141.2139.1979061769772.00209382302308
26151.8142.0991521820999.7008478179014
27155.4149.2444853889426.1555146110581
28156.6154.1165583300982.48344166990224
29161.6160.6621825426240.937817457375732
30160.7160.5255524097810.174447590219479
31156162.627855256098-6.62785525609819
32159.5161.354837495146-1.85483749514650
33168.7165.3382073623033.36179263769735
34169.9163.6093102845146.29068971548574
35169.9155.98109221998713.9189077800132
36185.9154.65806185946131.2419381405390
37190.8160.10124663757130.698753362429
38195.8174.65727973954321.1427202604575
39211.9186.08746114375725.8125388562426
40227.1197.30110941702329.7988905829774
41251.3206.93182433165744.3681756683434
42256.7220.50670843040136.193291569599
43251.9217.46719343987334.4328065601268
44251.2234.36193203577616.8380679642241
45270.3250.00008899978220.2999110002179
46267.2249.81373727304717.3862627269528
47243234.3013985253578.69860147464335
48229.9234.520913515885-4.62091351588456
49187.2228.480705125039-41.2807051250392
50178.2215.09952798015-36.8995279801501
51175.2217.445831205937-42.2458312059375
52192.4217.004692382353-24.6046923823529
53187224.750074090143-37.7500740901435
54184214.329808283608-30.3298082836084
55194.1213.004232572029-18.904232572029
56212.7211.7312148110780.968785188922443
57217.5212.2867061203375.21329387966342
58200.5199.2458098014881.25419019851200
59205.9202.7581970501263.14180294987420
60196.5197.150318492229-0.65031849222889
61206.3193.85241294770112.4475870522989


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.002124620278085440.004249240556170880.997875379721915
180.0006927598577876160.001385519715575230.999307240142212
190.0001358207927183600.0002716415854367190.999864179207282
203.01176146051441e-056.02352292102883e-050.999969882385395
211.5122937970789e-053.0245875941578e-050.99998487706203
222.66196150550665e-065.32392301101329e-060.999997338038495
234.89844127617984e-079.79688255235967e-070.999999510155872
242.75890669522639e-075.51781339045279e-070.99999972410933
253.17759141901912e-076.35518283803824e-070.999999682240858
269.41698248552693e-071.88339649710539e-060.999999058301752
278.36624539081892e-071.67324907816378e-060.99999916337546
282.4593381047624e-074.9186762095248e-070.99999975406619
299.530040488934e-081.9060080977868e-070.999999904699595
302.24664589048073e-084.49329178096146e-080.999999977533541
317.9373040972106e-091.58746081944212e-080.999999992062696
323.40417084429783e-096.80834168859566e-090.99999999659583
332.60978357669981e-095.21956715339962e-090.999999997390216
342.88085556322412e-095.76171112644824e-090.999999997119144
359.18010066600592e-091.83602013320118e-080.9999999908199
369.74112769617927e-071.94822553923585e-060.99999902588723
370.0003740971177990970.0007481942355981940.9996259028822
380.005835047783954670.01167009556790930.994164952216045
390.02015647960839760.04031295921679520.979843520391602
400.04903226687032380.09806453374064770.950967733129676
410.07008434536754520.1401686907350900.929915654632455
420.07249868564995440.1449973712999090.927501314350046
430.09275583487389170.1855116697477830.907244165126108
440.09919956674854830.1983991334970970.900800433251452


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level210.75NOK
5% type I error level230.821428571428571NOK
10% type I error level240.857142857142857NOK