Multiple Linear Regression - Estimated Regression Equation
y[t] = + 81.0978124999999 -5.16078124999995x[t] + 16.3589279513888M1[t] + 15.9374317956349M2[t] + 24.1445070684524M3[t] + 15.8372966269841M4[t] + 12.5300861855159M5[t] + 21.3800186011905M6[t] + 6.18709387400795M7[t] -11.3772594246032M8[t] + 26.3012444196429M9[t] + 27.6858494543651M10[t] + 22.1929247271826M11[t] + 0.0929247271825398t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)81.09781249999992.44663433.146700
x-5.160781249999952.000773-2.57940.0120980.006049
M116.35892795138882.8013085.839700
M215.93743179563492.7994885.69300
M324.14450706845242.7980018.629200
M415.83729662698412.7968465.662600
M512.53008618551592.7960244.48143e-051.5e-05
M621.38001860119052.7955357.647900
M76.187093874007952.795382.21330.0302850.015142
M8-11.37725942460322.795558-4.06980.0001276.3e-05
M926.30124441964292.796079.406500
M1027.68584945436512.9012859.542600
M1122.19292472718262.9008037.650600
t0.09292472718253980.0305373.0430.0033440.001672


Multiple Linear Regression - Regression Statistics
Multiple R0.924878815061786
R-squared0.855400822550093
Adjusted R-squared0.827344265731454
F-TEST (value)30.4884461796049
F-TEST (DF numerator)13
F-TEST (DF denominator)67
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation5.02406007724201
Sum Squared Residuals1691.15903720238


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1101.597.54966517857183.95033482142816
299.297.221093751.97890625
3107.8105.521093752.27890625000002
492.397.3068080357142-5.00680803571423
599.294.09252232142865.10747767857144
6101.6103.035379464286-1.43537946428569
78787.9353794642857-0.935379464285681
871.470.46395089285710.936049107142891
9104.7108.235379464286-3.5353794642857
10115.1109.7129092261905.38709077380959
11102.5104.312909226190-1.81290922619042
1275.382.2129092261904-6.91290922619044
1396.793.50398065476183.19601934523818
1494.693.17540922619051.42459077380952
1598.6101.475409226190-2.87540922619048
1699.593.26112351190486.23887648809523
179290.0468377976191.95316220238095
1893.698.9896949404762-5.38969494047620
1989.383.88969494047625.41030505952381
2066.966.41826636904760.481733630952386
21108.8104.1896949404764.61030505952381
22113.2105.6672247023817.53277529761904
23105.5100.2672247023815.23277529761904
2477.878.167224702381-0.367224702380958
25102.194.61907738095237.48092261904768
269794.2905059523812.70949404761905
2795.5102.590505952381-7.09050595238095
2899.394.37622023809524.92377976190475
2986.491.1619345238095-4.76193452380952
3092.4100.104791666667-7.70479166666666
3185.785.00479166666670.695208333333334
3261.967.5333630952381-5.6333630952381
33104.9105.304791666667-0.404791666666663
34107.9106.7823214285711.11767857142857
3595.6101.382321428571-5.78232142857144
3679.879.28232142857140.517678571428565
3794.895.7341741071428-0.934174107142794
3893.795.4056026785714-1.70560267857143
39108.1103.7056026785714.39439732142857
4096.995.49131696428571.40868303571428
4188.892.27703125-3.47703125000001
42106.7101.2198883928575.48011160714286
4386.886.11988839285710.680111607142851
4469.868.64845982142861.15154017857142
45110.9106.4198883928574.48011160714286
46105.4107.897418154762-2.49741815476191
4799.2102.497418154762-3.29741815476191
4884.480.39741815476194.00258184523809
4987.296.8492708333333-9.64927083333327
5091.996.520699404762-4.6206994047619
5197.9104.820699404762-6.9206994047619
5294.596.6064136904762-2.1064136904762
538593.3921279761905-8.39212797619048
54100.3102.334985119048-2.03498511904762
5578.787.2349851190476-8.53498511904762
5665.869.763556547619-3.96355654761906
57104.8107.534985119048-2.73498511904763
5896109.012514880952-13.0125148809524
59103.3103.612514880952-0.312514880952395
6082.981.51251488095241.38748511904762
6191.497.9643675595238-6.56436755952374
6294.597.6357961309524-3.13579613095239
63109.3105.9357961309523.36420386904761
6492.197.7215104166667-5.62151041666668
6599.394.5072247023814.79277529761904
66109.6103.4500818452386.1499181547619
6787.588.3500818452381-0.850081845238102
6873.170.87865327380952.22134672619046
69110.7108.6500818452382.0499181547619
70111.6110.1276116071431.47238839285712
71110.7104.7276116071435.97238839285714
728482.6276116071431.37238839285713
73101.699.07946428571422.52053571428577
74102.198.75089285714293.34910714285713
75113.9107.0508928571436.84910714285714
769998.83660714285710.163392857142846
77100.495.62232142857144.77767857142857
78109.5104.5651785714294.93482142857142
799389.46517857142863.53482142857142
8076.871.993754.80624999999999
81105.3109.765178571429-4.46517857142858


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.5849335650081260.8301328699837480.415066434991874
180.4666889791106950.933377958221390.533311020889305
190.4326265916110280.8652531832220570.567373408388972
200.3040448384791120.6080896769582230.695955161520888
210.3147141987355960.6294283974711920.685285801264404
220.2629408997764320.5258817995528640.737059100223568
230.2479395492393350.495879098478670.752060450760665
240.1993377462531990.3986754925063980.800662253746801
250.1934208741804430.3868417483608860.806579125819557
260.1554977443508370.3109954887016740.844502255649163
270.2185223912689970.4370447825379950.781477608731003
280.2318594870855950.463718974171190.768140512914405
290.2845677454270510.5691354908541020.715432254572949
300.2793132511629010.5586265023258030.720686748837099
310.2249031344308640.4498062688617280.775096865569136
320.2055296557405510.4110593114811030.794470344259449
330.1554831197890800.3109662395781590.84451688021092
340.1551749491963300.3103498983926610.84482505080367
350.1469598561181070.2939197122362140.853040143881893
360.1543009899609440.3086019799218870.845699010039056
370.1317150257885070.2634300515770140.868284974211493
380.09799652784855960.1959930556971190.90200347215144
390.2177265908752050.4354531817504100.782273409124795
400.2165761888212090.4331523776424180.783423811178791
410.1653643386664890.3307286773329790.83463566133351
420.3429119303233340.6858238606466670.657088069676666
430.3408155441699740.6816310883399470.659184455830026
440.3287643484482330.6575286968964670.671235651551767
450.5529336053139160.8941327893721680.447066394686084
460.6656762277915060.6686475444169880.334323772208494
470.5906644632878050.8186710734243890.409335536712195
480.7252672962236770.5494654075526470.274732703776323
490.7657255973319160.4685488053361680.234274402668084
500.708787965704350.5824240685912980.291212034295649
510.7036808476132570.5926383047734860.296319152386743
520.737319304715020.5253613905699590.262680695284979
530.7779876353759330.4440247292481330.222012364624067
540.7195005940054950.5609988119890090.280499405994505
550.7123232774511980.5753534450976050.287676722548802
560.6404200412749180.7191599174501640.359579958725082
570.5825117072419710.8349765855160570.417488292758029
580.851759541324530.2964809173509410.148240458675470
590.8181761489121180.3636477021757640.181823851087882
600.7592054946046140.4815890107907710.240794505395386
610.7918666264948760.4162667470102490.208133373505124
620.7648588283881110.4702823432237780.235141171611889
630.687557830976350.6248843380473010.312442169023650
640.6565699478660970.6868601042678070.343430052133903


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