Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The VP of admissions at SWC knows from past experience how many of the students that apply to the school will actually end up attending

The VP of admissions at SWC knows from past experience how many of the students that apply to the school will actually end up attending and generating revenue (the “conversion rate”). However, it is always a guess as to how many students will end up applying each year, so projecting revenue and expenses is difficult. The VP would like a systematic way to predict applications for next year based on the number of applications in years past. The VP would like you to present at least three different methods to predict applications for next year, along with at least two ways to determine which prediction method is best. Which method would you recommend? Why? The number of applications received in previous years is found in Tab 1 of the Excel file “Case 3 Data which is listed below methods can be any used in forecasting, qualitative or quantitative and choosing can be MSE, MAD, or MAPE

YearApplications
2009803
2010877
2011942
2012863
2013937
20141054
2015922
2016976
20171103
20181351
2019907
20201322

Step by Step Solution

3.47 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

The three methods Single moving average 11145 Weighted moving average 102109 Exponential smoothing 1... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applied Statistics For Public And Nonprofit Administration

Authors: Kenneth J. Meier, Jeffrey L. Brudney, John Bohte

9th Edition

1285737237, 978-1285974521, 1285974522, 978-1285737232

More Books

Students also viewed these Mathematics questions

Question

=+f) What is the average size of the error standard deviation?

Answered: 1 week ago

Question

13. What change in the brain is responsible for musicians cramp?

Answered: 1 week ago