Running head: UNIT 6 APPLICATION ASSIGNMENT 1
David A. Adkins
HA 612 Spring I
Dr. Ginger Raya
Park University
24 February 2019
This study source was downloaded by 100000830246019 from CourseHero.com on 06-07-2022 07:53:00 GMT -05:00
https://www.coursehero.com/file/39573284/Adkins-HA-612-Application-Assignment-Week-6docx/
, UNIT 6 APPLICATION ASSIGNMENT 2
Chapter 12, Question 1
1. Refer to the following data set for nurse staffing hours in Hospital XYZ
1992 34,084 1997 41,008 2002 47,000 2007 70,456
1993 37,051 1998 41,817 2003 51,206 2008 87,865
1994 36,845 1999 46,815 2004 78,456 2009 75,084
1995 37,815 2000 45,845 2005 62,559 2010 77,615
1996 39,908 2001 46,036 2006 68,048 2011 81,084
a. Using the latest period or naïve period method, compute the forecast the nurse staffing hours
in 2012. The forecast for nurse suffering hours in 2012 by using the latest period or naive method
is 81084. In this method a forecaster uses the value of the latest period to forecast the next
period. This method is sometimes referred to as the naive method because it uses just one piece
of data when other relevant data are available (Kros & Brown, 2013). b. Model the time
series using Excel’s TREND function
See MS Excel Spreadsheet
Question 2
Using Excel, compute the three-year and five-year moving averages for the data set from
question 1 and determine the expected nurse staffing hours for 2012. Now compute a three-year
weighted moving average using ½, 1/3, and 1/6 for the weights of the most recent the most
recent, second most recent, and third most recent periods.
A moving average is a technique to get an overall idea of the trends in a data set; it is
an average of any subset of numbers. The moving average is extremely useful for forecasting
long-term trends (Statisticshowto.com, 2018). In this example the expected nurse staffing hours
This study source was downloaded by 100000830246019 from CourseHero.com on 06-07-2022 07:53:00 GMT -05:00
https://www.coursehero.com/file/39573284/Adkins-HA-612-Application-Assignment-Week-6docx/
David A. Adkins
HA 612 Spring I
Dr. Ginger Raya
Park University
24 February 2019
This study source was downloaded by 100000830246019 from CourseHero.com on 06-07-2022 07:53:00 GMT -05:00
https://www.coursehero.com/file/39573284/Adkins-HA-612-Application-Assignment-Week-6docx/
, UNIT 6 APPLICATION ASSIGNMENT 2
Chapter 12, Question 1
1. Refer to the following data set for nurse staffing hours in Hospital XYZ
1992 34,084 1997 41,008 2002 47,000 2007 70,456
1993 37,051 1998 41,817 2003 51,206 2008 87,865
1994 36,845 1999 46,815 2004 78,456 2009 75,084
1995 37,815 2000 45,845 2005 62,559 2010 77,615
1996 39,908 2001 46,036 2006 68,048 2011 81,084
a. Using the latest period or naïve period method, compute the forecast the nurse staffing hours
in 2012. The forecast for nurse suffering hours in 2012 by using the latest period or naive method
is 81084. In this method a forecaster uses the value of the latest period to forecast the next
period. This method is sometimes referred to as the naive method because it uses just one piece
of data when other relevant data are available (Kros & Brown, 2013). b. Model the time
series using Excel’s TREND function
See MS Excel Spreadsheet
Question 2
Using Excel, compute the three-year and five-year moving averages for the data set from
question 1 and determine the expected nurse staffing hours for 2012. Now compute a three-year
weighted moving average using ½, 1/3, and 1/6 for the weights of the most recent the most
recent, second most recent, and third most recent periods.
A moving average is a technique to get an overall idea of the trends in a data set; it is
an average of any subset of numbers. The moving average is extremely useful for forecasting
long-term trends (Statisticshowto.com, 2018). In this example the expected nurse staffing hours
This study source was downloaded by 100000830246019 from CourseHero.com on 06-07-2022 07:53:00 GMT -05:00
https://www.coursehero.com/file/39573284/Adkins-HA-612-Application-Assignment-Week-6docx/
