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 2021 ACTUAL REGISTRATIONS 400 600 400 500 1000 800 700 900 1200 1400 1500 1300 Use the above to answer these questions Develop a 3 year MOVING AVERAGE to FORECAST applications from YEAR 2012 through YEAR 2021 (round UP no partial students please ) ESTIMATE the applications again for years 2012 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 each of the previous 2 years are each given a weight of 1 Graph the ACTUAL REGISTRATIONS 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 What is the trend Discuss

The Answer is in the image, click to view ...

Question: 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

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

2021

ACTUAL

REGISTRATIONS

400

600

400

500

1000

800

700

900

1200

1400

1500

1300

Use the above to answer these questions:

Develop a 3-year MOVING AVERAGE to FORECAST applications from YEAR 2012 through YEAR 2021 (round UP no partial students please!)
ESTIMATE the applications again for years 2012 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 each of the previous 2 years are each given a weight of 1.
Graph the ACTUAL REGISTRATIONS 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? What is the trend? Discuss.

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!

Determine the reactions at pins A and B of the frame needed to support the 200-lb load. The pulley at C has a radius of 0.5 ft. The pulley at D has a radius of 0.25 ft. 4 ft 60% 30 30 3 ft B

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...

undefined AutoSave OFF Document1 Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments to V V SmartArt h Chart Screenshot A T22 Pages Table Pictures Shapes Icons...

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...

Business Decision Making Assignment 1 Harvard Referencing should be done Plagiarism isn't allowed. Assignment Task / Description: Task 1: (This provides evidence for outcome 1 - assessment criteria...

MGMT4308 DR. HUANG Knowledge Base for General Environmental Analysis1 The general environment is composed of factors that can have dramatic effects on firm strategy. We divide the general environment...

Hello, you already did chapter 1 and 2 of my MASTERS Thesis already for me. (See attached) So normally you know masters thesis consist of 5 chapters right ??..... But in this case my thesis will be 4...

Data collected on the yearly registration for business major at the Worcester State University are shown in the following table: Registrations (hundreds) 4 6 4 5 10 Year 2010 2011 2012 2013 2014 2015...

In Chapter 10 of the text the author refers to the ways in which the prominence of high-profile institutions exacerbates and highlights problems with student debt, athletic and admissions,...

kindly reviewed this article The current issue and full text archive of this journal is available de Emerald Insight at www.emeraldinsight.com/2016-469x.htm Downloaded by Ghana Institute of...

1.What is the 5-step process to recognise revenue? 2. What criteria needs to be met for a contract to exist? 3. Light up Limited signed a contract on the 28th of February 2022, with Soni Limited (the...

You are an attorney. A former client has fired you because of what he claims are "personality conflicts." He refuses to pay you the remainder of the legal fees you are due. A prospective client...

The Certified Community Behavioral Health Clinic ( CCBHC ) model was created to improve access to mental health and substance abuse treatment. It became law through the Protecting Access to Medicare...

What is an example of constructive feedback? provide reference