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 |