Multiple Linear Regression - Estimated Regression Equation |
Crimerate[t] = + 1171.26771409283 + 21.0103219132378Funding[t] -23.9108325876178`25+HSgraduate`[t] -7.09689304546211`Dropouts16-19`[t] -6.5648075481889`CollegeStudents18-24`[t] + 26.2734721567441`25+CollegeGrads`[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) | 1171.26771409283 | 920.597682 | 1.2723 | 0.209953 | 0.104976 |
Funding | 21.0103219132378 | 5.998317 | 3.5027 | 0.00107 | 0.000535 |
`25+HSgraduate` | -23.9108325876178 | 12.75304 | -1.8749 | 0.067452 | 0.033726 |
`Dropouts16-19` | -7.09689304546211 | 19.593344 | -0.3622 | 0.71893 | 0.359465 |
`CollegeStudents18-24` | -6.5648075481889 | 8.609098 | -0.7625 | 0.449805 | 0.224902 |
`25+CollegeGrads` | 26.2734721567441 | 26.805098 | 0.9802 | 0.332363 | 0.166181 |
Multiple Linear Regression - Regression Statistics | |
Multiple R | 0.579348289671035 |
R-squared | 0.335644440744753 |
Adjusted R-squared | 0.260149490829384 |
F-TEST (value) | 4.44591911274881 |
F-TEST (DF numerator) | 5 |
F-TEST (DF denominator) | 44 |
p-value | 0.00230284525919422 |
Multiple Linear Regression - Residual Statistics | |
Residual Standard Deviation | 493.499245200084 |
Sum Squared Residuals | 10715826.2205743 |
Multiple Linear Regression - Actuals, Interpolation, and Residuals | |||
Time or Index | Actuals | Interpolation Forecast | Residuals Prediction Error |
1 | 184 | 486.173564779561 | -302.173564779561 |
2 | 213 | 234.588019757143 | -21.5880197571431 |
3 | 347 | 882.692340932702 | -535.692340932702 |
4 | 565 | 381.928538455668 | 183.071461544332 |
5 | 327 | 1233.6912114265 | -906.6912114265 |
6 | 260 | 197.842242411182 | 62.1577575888176 |
7 | 325 | 384.792555677241 | -59.7925556772414 |
8 | 102 | 395.070689581261 | -293.070689581261 |
9 | 38 | 379.275080281733 | -341.275080281733 |
10 | 226 | 193.943949767472 | 32.0560502325284 |
11 | 137 | 478.319707106806 | -341.319707106806 |
12 | 369 | 276.767176143313 | 92.2328238566865 |
13 | 109 | 526.118676681298 | -417.118676681298 |
14 | 809 | 340.984083670878 | 468.015916329122 |
15 | 29 | 221.450466286834 | -192.450466286834 |
16 | 245 | -1.72265818704375 | 246.722658187044 |
17 | 118 | 289.984810479114 | -171.984810479114 |
18 | 148 | 573.123768047641 | -425.123768047641 |
19 | 387 | 501.25137365263 | -114.251373652630 |
20 | 98 | 274.906802450486 | -176.906802450486 |
21 | 608 | 661.21078729651 | -53.2107872965103 |
22 | 218 | 680.392852924894 | -462.392852924894 |
23 | 254 | 681.119553819291 | -427.119553819291 |
24 | 697 | 927.236434037029 | -230.236434037029 |
25 | 827 | 449.494173739568 | 377.505826260432 |
26 | 693 | 558.873532082838 | 134.126467917162 |
27 | 448 | 452.560297901019 | -4.56029790101876 |
28 | 942 | 685.885479953707 | 256.114520046293 |
29 | 1017 | 616.340886194525 | 400.659113805475 |
30 | 216 | 830.926630529115 | -614.926630529115 |
31 | 673 | 805.407970233716 | -132.407970233716 |
32 | 989 | 826.63003914729 | 162.369960852710 |
33 | 630 | 594.258010800883 | 35.7419891991172 |
34 | 404 | 611.815708970498 | -207.815708970498 |
35 | 692 | 808.334367958195 | -116.334367958195 |
36 | 1517 | 996.151048091574 | 520.848951908426 |
37 | 879 | 543.4426706521 | 335.557329347899 |
38 | 631 | 768.310110581841 | -137.310110581841 |
39 | 1375 | 437.565952802613 | 937.434047197387 |
40 | 1139 | 556.164664247423 | 582.835335752577 |
41 | 3545 | 1615.48767768257 | 1929.51232231743 |
42 | 706 | 590.101757443888 | 115.898242556112 |
43 | 451 | 690.578793672533 | -239.578793672533 |
44 | 433 | 906.76346524697 | -473.76346524697 |
45 | 601 | 47.7261768099338 | 553.273823190066 |
46 | 1024 | 1297.36953071117 | -273.369530711173 |
47 | 457 | 914.684446098964 | -457.684446098964 |
48 | 1441 | 591.065645557543 | 849.934354442457 |
49 | 1022 | 1338.30595895475 | -316.305958954752 |
50 | 1244 | 1073.61297645462 | 170.387023545379 |
Goldfeld-Quandt test for Heteroskedasticity | |||
p-values | Alternative Hypothesis | ||
breakpoint index | greater | 2-sided | less |
9 | 0.0148708488024318 | 0.0297416976048637 | 0.985129151197568 |
10 | 0.0103049347191107 | 0.0206098694382213 | 0.98969506528089 |
11 | 0.00263411226467303 | 0.00526822452934606 | 0.997365887735327 |
12 | 0.00120938099638855 | 0.00241876199277709 | 0.998790619003611 |
13 | 0.000360336764615707 | 0.000720673529231414 | 0.999639663235384 |
14 | 0.00776592716627426 | 0.0155318543325485 | 0.992234072833726 |
15 | 0.00429833189186616 | 0.00859666378373231 | 0.995701668108134 |
16 | 0.00172336613530696 | 0.00344673227061393 | 0.998276633864693 |
17 | 0.000861641086505882 | 0.00172328217301176 | 0.999138358913494 |
18 | 0.000495780867374771 | 0.000991561734749542 | 0.999504219132625 |
19 | 0.000179094345671992 | 0.000358188691343984 | 0.999820905654328 |
20 | 9.36609231010158e-05 | 0.000187321846202032 | 0.999906339076899 |
21 | 6.8632824701065e-05 | 0.00013726564940213 | 0.9999313671753 |
22 | 4.05731542604472e-05 | 8.11463085208944e-05 | 0.99995942684574 |
23 | 2.26132406784822e-05 | 4.52264813569645e-05 | 0.999977386759322 |
24 | 1.28592512865821e-05 | 2.57185025731641e-05 | 0.999987140748713 |
25 | 5.41325695651078e-05 | 0.000108265139130216 | 0.999945867430435 |
26 | 0.000143836801387097 | 0.000287673602774194 | 0.999856163198613 |
27 | 5.50283007853729e-05 | 0.000110056601570746 | 0.999944971699215 |
28 | 0.000127948348802981 | 0.000255896697605962 | 0.999872051651197 |
29 | 0.000150364213064534 | 0.000300728426129068 | 0.999849635786936 |
30 | 0.000202462996224516 | 0.000404925992449033 | 0.999797537003775 |
31 | 8.36988531055383e-05 | 0.000167397706211077 | 0.999916301146894 |
32 | 0.000148311466881279 | 0.000296622933762557 | 0.999851688533119 |
33 | 5.72101955597952e-05 | 0.000114420391119590 | 0.99994278980444 |
34 | 2.52450014706135e-05 | 5.04900029412271e-05 | 0.99997475499853 |
35 | 1.21530895831621e-05 | 2.43061791663242e-05 | 0.999987846910417 |
36 | 4.12944674743667e-05 | 8.25889349487334e-05 | 0.999958705532526 |
37 | 1.72170431611879e-05 | 3.44340863223757e-05 | 0.999982782956839 |
38 | 1.42908300143164e-05 | 2.85816600286328e-05 | 0.999985709169986 |
39 | 2.47357962928637e-05 | 4.94715925857275e-05 | 0.999975264203707 |
40 | 1.31996869004974e-05 | 2.63993738009949e-05 | 0.9999868003131 |
41 | 0.495822757989960 | 0.991645515979921 | 0.504177242010040 |
Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity | |||
Description | # significant tests | % significant tests | OK/NOK |
1% type I error level | 29 | 0.878787878787879 | NOK |
5% type I error level | 32 | 0.96969696969697 | NOK |
10% type I error level | 32 | 0.96969696969697 | NOK |