The projected number of navigation systems (in millions) installed in vehicles in North America, Europe and...

 

Transcribed Image Text:

The projected number of navigation systems (in millions) installed in vehicles in North America, Europe and Japan from 2012 to 2016 are shown in the following table Year Systems 3.9 installed 2012 2013 4.7 2014 5.8 2015 6.8 2016 7.8 a) Draw a scatter diagram for this data (USE EXCEL). Use "Years since 2012" on the x-axis. Make sure the scatter diagram includes all required elements (axes labels, title, and appropriate scale) b) Use the points for 2013 and 2015 to find an equation of a line modeling this situation c) Use EXCEL's Trendline feature to find an equation of a line modeling this situation d) Use the equation in b to predict number of systems sold in 2018 and do this again for the equation in part c. e) Now use extrapolation using the last two data points to make a prediction for 2018 f) Which method, in your opinion, is optimal to use in this case The projected number of navigation systems (in millions) installed in vehicles in North America, Europe and Japan from 2012 to 2016 are shown in the following table Year Systems 3.9 installed 2012 2013 4.7 2014 5.8 2015 6.8 2016 7.8 a) Draw a scatter diagram for this data (USE EXCEL). Use "Years since 2012" on the x-axis. Make sure the scatter diagram includes all required elements (axes labels, title, and appropriate scale) b) Use the points for 2013 and 2015 to find an equation of a line modeling this situation c) Use EXCEL's Trendline feature to find an equation of a line modeling this situation d) Use the equation in b to predict number of systems sold in 2018 and do this again for the equation in part c. e) Now use extrapolation using the last two data points to make a prediction for 2018 f) Which method, in your opinion, is optimal to use in this case

Answer rating: 100% (QA)

The image displays a text that outlines a mathematical question involving the creation of a scatter diagram and various methods of extrapolation to pr... View the full answer