Multiple Linear Regression - Estimated Regression Equation |
Yt[t] = + 365.825961771427 -2.39632617023328Xt[t] + e[t] |
Multiple Linear Regression - Ordinary Least Squares | |||||
Variable | Parameter | S.D. | T-STAT H0: parameter = 0 | 2-tail p-value | 1-tail p-value |
(Intercept) | 365.825961771427 | 194.027118 | 1.8854 | 0.064383 | 0.032191 |
Xt | -2.39632617023328 | 1.775122 | -1.35 | 0.182277 | 0.091139 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.174536352936849 |
R-squared | 0.0304629384964964 |
Adjusted R-squared | 0.0137467822636774 |
F-TEST (value) | 1.82236502651777 |
F-TEST (DF numerator) | 1 |
F-TEST (DF denominator) | 58 |
p-value | 0.18227704443092 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 25.4697443187088 |
Sum Squared Residuals | 37625.0567883032 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 151.7 | 113.732448662886 | 37.9675513371143 |
2 | 121.3 | 113.732448662885 | 7.56755133711472 |
3 | 133 | 112.773918194792 | 20.226081805208 |
4 | 119.6 | 112.773918194792 | 6.82608180520801 |
5 | 122.2 | 111.336122492652 | 10.863877507348 |
6 | 117.4 | 111.096489875629 | 6.30351012437133 |
7 | 106.7 | 110.856857258605 | -4.15685725860533 |
8 | 87.5 | 109.658694173489 | -22.1586941734887 |
9 | 81 | 108.939796322419 | -27.9397963224187 |
10 | 110.3 | 108.700163705395 | 1.5998362946046 |
11 | 87 | 108.700163705395 | -21.7001637053954 |
12 | 55.7 | 108.460531088372 | -52.760531088372 |
13 | 146 | 108.101082162837 | 37.8989178371629 |
14 | 137.5 | 107.334257788362 | 30.1657422116376 |
15 | 138.5 | 106.136094703246 | 32.3639052967542 |
16 | 135.6 | 106.112131441543 | 29.4878685584565 |
17 | 107.3 | 107.214441479851 | 0.0855585201492485 |
18 | 99 | 106.950845601125 | -7.95084560112509 |
19 | 91.4 | 106.687249722399 | -15.2872497223994 |
20 | 68.4 | 106.303837535162 | -37.9038375351621 |
21 | 82.6 | 105.489086637283 | -22.8890866372828 |
22 | 98.4 | 105.441160113878 | -7.04116011387813 |
23 | 71.3 | 104.530556169189 | -33.2305561691895 |
24 | 47.6 | 104.554519430892 | -56.9545194308918 |
25 | 130.8 | 104.554519430892 | 26.2454805691082 |
26 | 113.6 | 103.332393084073 | 10.2676069159272 |
27 | 125.7 | 102.829164588324 | 22.8708354116762 |
28 | 113.6 | 102.637458494705 | 10.9625415052948 |
29 | 97.1 | 103.068797205347 | -5.96879720534717 |
30 | 104.4 | 102.661421756408 | 1.73857824359247 |
31 | 91.8 | 102.349899354277 | -10.5498993542772 |
32 | 75.1 | 101.942523905338 | -26.8425239053375 |
33 | 89.2 | 101.870634120231 | -12.6706341202305 |
34 | 110.2 | 101.750817811719 | 8.44918218828114 |
35 | 78.4 | 102.254046307468 | -23.8540463074679 |
36 | 68.4 | 101.894597381933 | -33.4945973819329 |
37 | 122.8 | 101.894597381933 | 20.9054026180671 |
38 | 129.7 | 100.289058847877 | 29.4109411521234 |
39 | 159.1 | 99.9056466606392 | 59.1943533393607 |
40 | 139 | 99.8577201372346 | 39.1422798627654 |
41 | 102.2 | 102.877091111729 | -0.6770911117285 |
42 | 113.6 | 102.68538501811 | 10.9146149818901 |
43 | 81.5 | 102.182156522361 | -20.6821565223609 |
44 | 77.4 | 101.798744335124 | -24.3987443351235 |
45 | 87.6 | 101.726854550017 | -14.1268545500166 |
46 | 101.2 | 101.631001503207 | -0.431001503207203 |
47 | 87.2 | 101.367405624482 | -14.1674056244815 |
48 | 64.9 | 101.007956698947 | -36.1079566989465 |
49 | 133.1 | 100.696434296816 | 32.4035657031838 |
50 | 118 | 99.9535731840439 | 18.0464268159561 |
51 | 135.9 | 99.4024181648902 | 36.4975818351098 |
52 | 125.7 | 99.3784549031879 | 26.3215450968121 |
53 | 108 | 98.1802918180713 | 9.81970818192871 |
54 | 128.3 | 98.1563285563689 | 30.1436714436311 |
55 | 84.7 | 97.8448061542386 | -13.1448061542386 |
56 | 86.4 | 97.9885857244526 | -11.5885857244526 |
57 | 92.2 | 98.0844387712619 | -5.88443877126194 |
58 | 95.8 | 97.4134674435966 | -1.61346744359662 |
59 | 92.3 | 97.7729163691316 | -5.47291636913163 |
60 | 54.3 | 97.3415776584896 | -43.0415776584896 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
5 | 0.171100588575399 | 0.342201177150799 | 0.828899411424601 |
6 | 0.0734769637408666 | 0.146953927481733 | 0.926523036259133 |
7 | 0.034893599402264 | 0.0697871988045279 | 0.965106400597736 |
8 | 0.0207043254936356 | 0.0414086509872712 | 0.979295674506364 |
9 | 0.00893283742056577 | 0.0178656748411315 | 0.991067162579434 |
10 | 0.0178256647300436 | 0.0356513294600872 | 0.982174335269956 |
11 | 0.00814155488689378 | 0.0162831097737876 | 0.991858445113106 |
12 | 0.0284646369456159 | 0.0569292738912318 | 0.971535363054384 |
13 | 0.386808980071185 | 0.77361796014237 | 0.613191019928815 |
14 | 0.57822263548498 | 0.843554729030041 | 0.42177736451502 |
15 | 0.69538282693909 | 0.609234346121821 | 0.30461717306091 |
16 | 0.732788765873203 | 0.534422468253594 | 0.267211234126797 |
17 | 0.668857461697497 | 0.662285076605005 | 0.331142538302503 |
18 | 0.603762285896497 | 0.792475428207005 | 0.396237714103503 |
19 | 0.546885769378923 | 0.906228461242154 | 0.453114230621077 |
20 | 0.593274398282073 | 0.813451203435854 | 0.406725601717927 |
21 | 0.538659595603252 | 0.922680808793497 | 0.461340404396748 |
22 | 0.458786733157614 | 0.917573466315229 | 0.541213266842385 |
23 | 0.44434489542246 | 0.888689790844921 | 0.55565510457754 |
24 | 0.628596083418819 | 0.742807833162363 | 0.371403916581181 |
25 | 0.705638263394662 | 0.588723473210676 | 0.294361736605338 |
26 | 0.681884511935278 | 0.636230976129444 | 0.318115488064722 |
27 | 0.710055893833342 | 0.579888212333317 | 0.289944106166658 |
28 | 0.672036340915986 | 0.655927318168028 | 0.327963659084014 |
29 | 0.600194082004381 | 0.799611835991238 | 0.399805917995619 |
30 | 0.530671788602368 | 0.938656422795263 | 0.469328211397632 |
31 | 0.457995878858925 | 0.915991757717849 | 0.542004121141075 |
32 | 0.438387727190831 | 0.876775454381663 | 0.561612272809169 |
33 | 0.373645422674904 | 0.747290845349807 | 0.626354577325096 |
34 | 0.321875919367458 | 0.643751838734916 | 0.678124080632542 |
35 | 0.296991449989888 | 0.593982899979776 | 0.703008550010112 |
36 | 0.332040847216316 | 0.664081694432632 | 0.667959152783684 |
37 | 0.321647036767392 | 0.643294073534785 | 0.678352963232608 |
38 | 0.356066464908366 | 0.712132929816732 | 0.643933535091634 |
39 | 0.688376509419475 | 0.62324698116105 | 0.311623490580525 |
40 | 0.782321633474312 | 0.435356733051376 | 0.217678366525688 |
41 | 0.715754355383871 | 0.568491289232258 | 0.284245644616129 |
42 | 0.665456523628025 | 0.66908695274395 | 0.334543476371975 |
43 | 0.622454116164237 | 0.755091767671526 | 0.377545883835763 |
44 | 0.612826686231173 | 0.774346627537654 | 0.387173313768827 |
45 | 0.565619319934383 | 0.868761360131234 | 0.434380680065617 |
46 | 0.480480804118232 | 0.960961608236463 | 0.519519195881768 |
47 | 0.475408062274501 | 0.950816124549002 | 0.524591937725499 |
48 | 0.940428382975217 | 0.119143234049566 | 0.0595716170247829 |
49 | 0.925951592988209 | 0.148096814023582 | 0.0740484070117908 |
50 | 0.940842398052434 | 0.118315203895132 | 0.0591576019475662 |
51 | 0.90181314500878 | 0.19637370998244 | 0.0981868549912198 |
52 | 0.885004227995472 | 0.229991544009056 | 0.114995772004528 |
53 | 0.796074174790977 | 0.407851650418046 | 0.203925825209023 |
54 | 0.862796489493786 | 0.274407021012428 | 0.137203510506214 |
55 | 0.733258260294773 | 0.533483479410454 | 0.266741739705227 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 0 | 0 | OK |
5% type I error level | 4 | 0.0784313725490196 | NOK |
10% type I error level | 6 | 0.117647058823529 | NOK |