Question: CHAPTER 4 TECHNICAL CASE A major Polytechnical University collected data on yearly freshman applications (students who apply but might not be accepted or enroll). These
CHAPTER 4 TECHNICAL CASE
A major Polytechnical University collected data on yearly freshman applications (students who apply but might not be accepted or enroll). These are shown in the following table:
| YEAR | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 |
| REGISTRATIONS | 400 | 600 | 400 | 500 | 1000 | 800 | 700 | 900 | 1200 | 1400 | 1500 |
Use the above to answer these questions:
- Develop a 3-year MOVING AVERAGE to FORECAST applications from YEAR 2013 through YEAR 2021 (round UP no partial students please!)
- ESTIMATE the applications again for years 2013 through 2021 with a 3-year WEIGHTED MOVING AVERAGE in which registrations in the most recent year are given a weight of 2 and registrations in the others 2 years are each given a weight of 1.
- Graph the ORIGINAL DATA from the chart above against both the MOVING AVERAGE and the WEIGHTED MOVING AVERAGE. Which of the two methods comes closest to the actual and which seems better? Why?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
