Some help with a math project.
Using the following data, please complete the assignment:
Security and Criminal Justice Scenario | |||||||||
| Topic 2 | Predicting the Number of People Arrested for Drug Possession | ||||||||
| Scenario 2 | Review the data involving the number of people arrested for drug possession from 2006-2015. Predict the number of people who will be arrested for drug possession in 2018. | ||||||||
| Year | People Arrested for Drug Possession | ||||||||
| 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 | ||||||||
The purpose of this assignment is to have you practice creating visuals using the data from the topic you chose in Week 3. Creating charts and trendlines is an important skill used in many careers.
Watch How to Create Trendlines and Scatterplots in Excel®.
Watch Week 4 Lynda.com® Video: Adding Trendlines to Charts.
Create at least two visuals using your data.
- Create a scatter plot of the data, and apply a linear model (also known as a regression) in Excel®.
- Create a scatter plot of the data, and apply an exponential model in Excel®.
- Include the equation and R2 value on the visuals.
- Determine whether the linear or the exponential model is a better representation of your data to make your prediction. Explain why the model you chose is a better representation of your data.
Hints for Making an Effective Chart:
- Decide why you are making a chart from this data.
- Rename the chart title to something appropriate for the data.
- Put in a descriptive x-axis label.
- Put in a descriptive y-axis label.
- Resize the chart as needed so it is easily viewable.
9 years ago
10
Answer(1)![blurred-text]()
![]()
Purchase the answer to view it

NOT RATED
- graphical_statistics.docx
Bids(1)
other Questions(10)