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:

  1. Develop a 3-year MOVING AVERAGE to FORECAST applications from YEAR 2013 through YEAR 2021 (round UP no partial students please!)
  2. 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.
  3. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!