Warning: Trying to access array offset on value of type bool in /home/topgsnkq/timelyhomework.com/wp-content/themes/enfold/framework/php/function-set-avia-frontend.php on line 570
Using the following data, please complete the assignment:Security and Criminal Justice ScenarioTopic 2Predicting the Number of People Arrested for Drug PossessionScenario 2Review 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.YearPeople Arrested for Drug Possession20061,519,76020071,361,65820081,321,82420091,387,91520101,179,72820111,143,93120121,237,70820131,203,3232014982,1692015801,560The 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.