Wells 1613 Mini Project 2 Name:
Directions: For this second project, I want you to create a linear model using Desmos or Excel and use your skills with linear equations to answer some questions. You will submit your work through Blackboard.
The CDC publishes public health data of many kinds, including data on the cause of death of people in the United States. One thing that they have noted in publications (like ‘Deaths from older adult falls’) is that death from falling is getting more and more common. Here we examine the raw data from their website: wonder.cdc.gov
Year Falling deaths per 100,000 people 1999 4.7 2000 4.7 2001 5.3 2002 5.7 2003 5.9 2004 6.4 2005 6.7 2006 7 2007 7.5 2008 7.9 2009 8.1 2010 8.4 2011 8.8 2012 9.2 2013 9.6 2014 10 2015 10.4 2016 10.7
1. I have attached an Excel file with this data already in a table so you do not need to retype it.
(a) Use either Excel or Desmos to create a graph of the data.
(b) Add a trendline to your graph. Make sure to display the equation.
(c) You will save this workbook or Desmos picture and upload it to Blackboard.
2. Answer the following questions in a word document.
(a) Calculate the y-intercept of your trendline (show your steps!)
(b) What does the y-intercept represent in this situation? Write your interpretation as a complete sentence.
(c) Calculate the x-intercept of your trendline (show your steps!)
(d) What does the x-intercept represent in this situation? Write your interpretation as a complete sentence.
(e) Assuming the model is accurate, what is the projected Death Rate due to falling in 2020?
(f) What year does the model project that the rate would be 15 deaths per 100,000 people?
3. Go to the discussion board for Project 1 and make a thread answering the following questions:
(a) Sometimes intercepts are important and meaningful for a model and sometimes they aren’t. How valuable are the x and y intercepts in this situation? Why?
(b) How well does the trendline model the data given in your opinion?
(c) Why would it be a bad idea to use this model to predict the death rate due to falling in the year 2100?
(d) Did you use Excel or Desmos for this, why?
4. Once you have posted your answers, read other students answers and reply to at least two of them in a productive way.