Multiple Linear Regression - Estimated Regression Equation
Y[t] = -94720.9605158426 + 0.592327661009512X[t] + 0.895766698514853Y1[t] -0.417564650909098Y2[t] + 0.270154944508241Y3[t] -0.157692651463375Y4[t] + 12851.7566275878M1[t] + 8051.82719716753M2[t] + 15042.7024308202M3[t] + 19434.5168649013M4[t] + 18108.0290237541M5[t] + 18650.3443112222M6[t] + 17673.7431743616M7[t] + 20418.5457150754M8[t] + 17570.7707595111M9[t] + 18101.5818362902M10[t] + 20103.1448944525M11[t] + 520.055780191044t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-94720.960515842631536.948962-3.00350.0044360.002218
X0.5923276610095120.1673473.53950.0009770.000489
Y10.8957666985148530.1617675.53742e-061e-06
Y2-0.4175646509090980.181553-2.30.0263680.013184
Y30.2701549445082410.1524071.77260.0833820.041691
Y4-0.1576926514633750.108262-1.45660.1524960.076248
M112851.75662758784884.9826352.63090.0117740.005887
M28051.827197167535756.9216311.39860.1690940.084547
M315042.70243082026456.1370522.330.0245690.012285
M419434.51686490135730.2152843.39160.0015010.00075
M518108.02902375415142.9771543.52090.0010320.000516
M618650.34431122225874.3016483.17490.002770.001385
M717673.74317436166624.661222.66790.010720.00536
M820418.54571507546768.6817443.01660.0042810.002141
M917570.77075951117007.1721362.50750.0160130.008007
M1018101.58183629026211.44472.91420.0056390.00282
M1120103.14489445253929.68525.11577e-063e-06
t520.055780191044154.6676023.36240.0016320.000816


Multiple Linear Regression - Regression Statistics
Multiple R0.985124369674081
R-squared0.970470023725756
Adjusted R-squared0.958795381942916
F-TEST (value)83.1263212848346
F-TEST (DF numerator)17
F-TEST (DF denominator)43
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3685.96446459631
Sum Squared Residuals584212363.473471


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1286602276438.64294577310163.3570542271
2283042279617.2524992393424.74750076138
3276687275247.4336216031439.56637839672
4277915278141.373382996-226.373382995589
5277128276504.908751473623.09124852682
6277103274328.7024902102774.29750979044
7275037273803.4081162361233.59188376398
8270150271006.610572395-856.610572394643
9267140263721.1272941473418.87270585261
10264993265765.043609807-772.043609807469
11287259284064.5854175783194.41458242155
12291186287781.4339074643404.56609253556
13292300294222.009188872-1922.00918887193
14288186288545.555114005-359.555114005374
15281477283530.202877907-2053.20287790750
16282656284162.447686412-1506.44768641232
17280190285175.999604018-4985.99960401816
18280408280268.246807905139.753192095442
19276836278443.978042471-1607.97804247134
20275216275212.0967682993.90323170146075
21274352273037.2828746591314.71712534145
22271311274891.478715301-3580.47871530065
23289802291840.020437621-2038.02043762125
24290726293262.414173577-2536.41417357664
25292300294632.52167068-2332.52167067987
26278506285895.448752782-7389.44875278206
27269826269906.153408989-80.1534089887796
28265861270414.91988997-4553.91988997006
29269034265782.9187696143251.08123038630
30264176267107.7318633-2931.73186329997
31255198256413.363304377-1215.36330437660
32253353252831.601455222521.39854477773
33246057246294.511344679-237.51134467947
34235372238919.264884460-3547.26488445952
35258556255685.950880832870.04911917025
36260993263674.977140295-2681.97714029476
37254663257977.865645282-3314.86564528209
38250643248699.2755596661943.72444033395
39243422246329.776260896-2907.77626089623
40247105244789.354116372315.64588363029
41248541250936.815124818-2395.81512481807
42245039246960.304400980-1921.30440098034
43237080240766.393450401-3686.3934504008
44237085236759.207346437325.792653562820
45225554231045.609529229-5491.6095292287
46226839224276.9485365372562.05146346283
47247934251615.493002461-3681.49300246100
48248333250126.367393348-1793.36739334811
49246969248753.536143747-1784.53614374741
50245098242717.4680743082380.53192569210
51246263242661.4338306043601.56616939579
52255765251793.9049242523971.09507574767
53264319260811.3577500773507.64224992311
54268347266408.0144376061938.98556239443
55273046267769.8570865155276.14291348477
56273963273957.4838576475.51614235262969
57267430266434.468957286995.53104271411
58271993266655.2642538955337.7357461048
59292710293054.950261510-344.950261509565
60295881292273.8073853163607.19261468396
61293299294108.424405646-809.424405645755


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.302992381396510.605984762793020.69700761860349
220.1886024943756570.3772049887513130.811397505624343
230.1273817064228380.2547634128456770.872618293577162
240.1454558939832020.2909117879664040.854544106016798
250.09886230134666040.1977246026933210.90113769865334
260.5604252273522940.8791495452954120.439574772647706
270.6840168403048940.6319663193902120.315983159695106
280.7630174410541940.4739651178916120.236982558945806
290.8050516043109140.3898967913781720.194948395689086
300.7171874157285890.5656251685428220.282812584271411
310.6351433241676740.7297133516646510.364856675832326
320.5943517433167170.8112965133665660.405648256683283
330.6706981947717540.6586036104564930.329301805228246
340.9089811779267820.1820376441464370.0910188220732183
350.9146956507684410.1706086984631180.085304349231559
360.919791650386780.160416699226440.08020834961322
370.870226710421630.2595465791567410.129773289578371
380.8165997347996730.3668005304006540.183400265200327
390.6859552949931270.6280894100137460.314044705006873
400.6757537803036320.6484924393927370.324246219696368


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 level00OK