In: Statistics and Probability
Predict the number of people arrested for drug possession in 2016 and 2017 from the data Year # of People Arrested 2006 1,519,760 2007 1,361,658 2008 1,321,824 2009 1,387,915 2010 1,179,728 2011 1,143,931 2012 1,237,708 2013 1,203,323 2014 982,169 2015 801,560 2016 2017 2018
data
| year | people |
| 2006 | 1519760 |
| 2007 | 1361658 |
| 2008 | 1321824 |
| 2009 | 1387915 |
| 2010 | 1179728 |
| 2011 | 1143931 |
| 2012 | 123708 |
| 2013 | 1203323 |
| 2014 | 982169 |
| 2015 | 801560 |
in excel
data -> data analysis -> regression
| SUMMARY OUTPUT | |||||
| Regression Statistics | |||||
| Multiple R | 0.618659074 | ||||
| R Square | 0.38273905 | ||||
| Adjusted R Square | 0.305581431 | ||||
| Standard Error | 334685.1721 | ||||
| Observations | 10 | ||||
| ANOVA | |||||
| df | SS | MS | F | Significance F | |
| Regression | 1 | 5.55644E+11 | 5.55644E+11 | 4.96048291 | 0.05654219 |
| Residual | 8 | 8.96113E+11 | 1.12014E+11 | ||
| Total | 9 | 1.45176E+12 | |||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | |
| Intercept | 166099369.9 | 74082225.11 | 2.242094776 | 0.055244584 | -4734547.532 |
| year | -82067.55152 | 36847.62473 | -2.227214159 | 0.05654219 | -167038.3265 |
y^ = 166099369.9 -82067.55152 * year
| 2016 | 651186.0357 |
| 2017 | 569118.4842 |
| 2018 | 487050.9326 |