Question: The admission data for freshmen at Tech during the past 10 years are as follows: Techs admission objective is a class of 5000 entering freshmen,

The admission data for freshmen at Tech during the past 10 years are as follows:

The admission data for freshmen at Tech during the past

Tech€™s admission objective is a class of 5000 entering freshmen, and it wants to forecast the percentage of offers it will likely have to make in order to achieve this objective.
a. Develop a linear trend line to forecast next year€™s applicants and percentage acceptances and use these results to estimate the percentage offers that Tech should expect to make.
b. Develop a linear trend line to forecast the percentage offers that Tech should expect to make and compare this result with the result in part (a). Which forecast do you think is more accurate?
c. Assume Tech receives 18,300 applicants in year 11. How many offers do you think it should make to get 5000acceptances?

Year Applinfers Offers Acceptances Accoptances 113,876 1200 807 4112 2 4993 11522 778 4354 3 442 157 780 4755 4 16,285 13.207 811 5068 5 16922 11382 732 4532 6 16,109 937 71 4655 7 15.883 11616 731 4659 8 18,407 1539 627 4620 9 18,838 13,138 6 5054 10 17,756 11952 67.3 4822 36.7 373 41.1 380 39.8 39.0 40.1 40.0 38.5 40.3

Step by Step Solution

3.32 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a Forecast of applicants Forecast of acceptances ... View full answer

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

Document Format (1 attachment)

Excel file Icon

184_606efd6a51183_143089.xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!