Description
The purpose of this assignment is to have you practice creating visuals using the data from the topic you chose in Week 2. Creating charts and trendlines are important skills used in many careers.
Watch How to Create Trendlines and Scatterplots in Excel®.
Watch Week 4 Lynda.com® Video: Data-Analysis Fundamentals with Excel.
Create at least two visuals using your data from the data you chose in Week 2.
The Topic I choose is: TOPIC 2: SECURITY AND CRIMINAL JUSTICE- Create one scatter plot of the data, and apply a linear model (also known as a regression) in Excel®. Include the equation, R2 value, and prediction value on the visual.
- Create one scatter plot of the data, and apply an exponential model in Excel®. Include the equation, R2 value, and prediction value on the visual.
- Determine whether the linear or the exponential model is a better representation of your data to base your prediction on. 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.
- Title each chart so that it aligns with the data and selected model.
- Create descriptive labels for both the x- and y axes.
- Resize the chart as needed so it can be viewed easily.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Security and Criminal Justice Scenario
Year
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
People Arrested
for Drug
Possession
1.519.760
1.361.658
1.321.824
1.387.915
1.179.728
1.143.931
1.237.708
1.203.323
982.169
801.560
873986,0667
819544,76
744217,9929
Scatter plot representing year against th...