Quantitative Reasoning I Project: Creating Visuals from Data

User Generated

yhi123

Mathematics

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
  1. 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.
  2. 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.
  3. 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

Health Services and Nursing Scenario Topic 1 Scenario 1 Predicting the Number of Babies Born Review the data involving the number of babies born in Humboldt County from 2006-2015. Predict the n be born in 2018. Year Babies Born in Humboldt County 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 275 280 320 366 358 336 375 390 455 487 ing Scenario nty from 2006-2015. Predict the number of babies who will Security and Criminal Justice Scenario Topic 2 Scenario 2 Year 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Predicting the Number of People Arrested for Drug Possession Review the data involving the number of people arrested for drug possession from 2006-2015. Predict the people who will be arrested for drug possession in 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 Scenario n from 2006-2015. Predict the number of Humanities and Sciences Scenario Topic 3 Scenario 3 Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Predicting Student Smartphone Usage Review the data involving the average number of hours students spent on their smartphones from 2002number of hours students will spend on their smartphones in 2018. Average Number of Hours Students Spend on their Smartphones 0.1 0.75 1 1.5 1.75 5.5 6 9.3 9.5 8.9 9 11 12.5 10.6 Scenario n their smartphones from 2002-2015. Predict the Social Sciences Scenario Topic 4 Scenario 4 Hours of Sleep 4 4.25 4.5 4.75 5 5.25 5.5 5.75 6 6.25 6.5 6.75 7 7.25 7.5 7.75 8 8.25 8.5 8.75 9 9.25 9.5 9.75 10 Predicting Test Performance Based on Sleep Review the data involving the number of hours students sleep and their average score on a test they take Predict the optimal hours of sleep students need the night before a test to achieve the highest score on t Average Score on Test 55 40 53 59 60 63 66 75 70 72 80 77 85 90 100 95 88 85 74 88 90 87 86 95 82 rio average score on a test they take the next day. o achieve the highest score on the test. Business Scenario Topic 5 Scenario 5 Month 1 2 3 4 5 6 7 8 9 10 11 Predicting Fuji Apple Purchases Review the monthly data involving Fuji apples purchased at a large grocery store. Predict how many Fu have available for the customers in December (month 12)? Fuji Apples Purchased 5,325 5,648 5,873 9,842 8,234 9,421 10,123 9,784 10,443 9,564 10,147 Hint: When determining the solution to this question remember that am up around holidays. Seasonality is a characteristic of a time series in wh and predictable changes that recur every calendar year. Any predictable series that recurs or repeats over a one-year period can be said to be se rio ry store. Predict how many Fuji apples will need to be in stock to his question remember that amounts needed in a store will go acteristic of a time series in which the data experiences regular calendar year. Any predictable change or pattern in a time ear period can be said to be seasonal. Education Scenario Topic 6 Elementary Education: Math Skills Scenario 6 Review the data involving elementary students in Apache County who passed the AZ Merit Test fr pass the AZ Merit test in 2018. Fiscal Year Students in Apache County who Pass the AZ Merit Test 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 12 7 14 18 25 37 33 39 45 42 cenario passed the AZ Merit Test from 2006-2015. Predict the number of students who will
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags