Question
The monthly employment reports issued by the US Department of Labor are eagerly monitored by investors as indicators of the health of the overall economy.
The monthly employment reports issued by the US Department of Labor are eagerly monitored by investors as indicators of the health of the overall economy. The file Job_openings.xlsx (Job_openings.xlsx Download Job_openings.xlsx) contains the monthly figures for total non-farm openings, from January2001-December2015, seasonally adjusted.To provide investing insights, develop a forecasting procedure for this series, using 2001-2012 as the estimation sample and 2013-2015 as the hold-out sample. You should consider all the options described in the chapter: SES, LES. All these options may be explored via the ESM.
At a minimum, produce an SES forecast and at least one of LES forecasts. So you should have a minimum of two models. For each of the forecast models, provide the name of the method, all model parameters, RMSE, and MAPE.
For example: Model: SES Parameter(s):alpha=0.26 RMSE:2478.2 MAPE: 12.6
Month 2001-01-01 Job Openings 2001-02-01 2001-03-01 2001-05-01 2001-06-01 2001-07-01 2001-08-01 2001-09-01 2001-10-01 2001-12-01 -01-01 2002-02-01 2002-04-01 2002-08 -01 2002-09-01 2002 - 12 - 2003-0 203-0 2003 -1 2004 - 0 2004 - 0 08-01 3619 3792 2004 - 12- 01 2005-02-01 -04-01 2005-05-01 2005-06-01 2005-07-01 2005-08-01 2005-09-01 2005-10-01 2005 - 11 - -12-01 2006-01- 01 2006-02-01 2006-03-01 2006-04-01 2006-05-01 2006-06-01 2006-07-01 4560 2006-09-01 2006-10-01 4278 2007-01-01 2007 -02-01 2007- 03-01 2007-04-01 2007-05-01 2007-07-01 2007-08-01 2007-09-01 4555 2007-10-01 4300 2007-11-01 2007-12-01 4123 2008-02-01 2008-03-01 4001 2008-04-01 2008-05-01 2008-06-01 2008-07-01 2008-08-01 2008-09-01 2008-10-01 2008-11-01 2009-01-01 2830 2009-02 - 01 2009-03-01 2009-04-01 2009-05-01 2009 -06 - 01 2009-07-01 2009-08- 01 2196 2009-09-01 2478 2009-12-01 2407 2010-02-01 2578 2010-04-01 2010-05 2010-06-01 2010-07-01 2010-08-01 2920 2010-09-01 2010-10 3033 2010-11 2010-12-01 2857 2011-01-01 2011-02-01 3056 2011-03-01 2011-04-01 3287 2011-05-01 2011-06-01 3224 2011-07 3475 2011-08-01 2011-09-01 2011-10 3421 2011-11 2011-12-01 3369 2012-01-01 2012-02-01 3501 2012-03-01 2012-04-01 2012-05-01 3706 2012-06-01 2012-07-01 2012-08-01 3655 2012-09-01 2012-10 3713 2012-1 2012-12 3576 2013-01-01 2013-02-01 3972 2013-0 2013-04 2013-05 3886 2013 -0 2013 -07 2013-08 3921 2013 -09 2013-10 2013-1 2013 - 12 2014-02 2014- 0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started