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,
.png)
Techs 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 years 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
a Forecast of applicants Forecast of acceptances ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
184_606efd6a51183_143089.xlsx
300 KBs Excel File
