Answer the following questions using the data from the Excel file Spain unemployment.xlsx from Problem 16.45. a.

Question:

Answer the following questions using the data from the Excel file Spain unemployment.xlsx from Problem 16.45.

Unemployment Rate (%) Unemployment Rate (%) Year Year 2008 11.3 2013 26.2 2009 18.0 2014 24.6 2010 20.0 2015 22.2 2011 21.5 2016 19.7 2012 24.9 2017 17.3


a. Construct a graph showing the annual unemployment rate for Spain over time.

b. Forecast the unemployment rate for Spain in 2018 using a trend projection.

c. Calculate the MAD for the forecast in part b.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics

ISBN: 9780134685267

3rd Edition

Authors: Robert A. Donnelly

Question Posted: