- 5 The Admissions Data For Freshmen At A Prestigious Public College In The Past 10 Years Are As Follows Goal For Ente 1 (23.62 KiB) Viewed 16 times
5. The admissions data for freshmen at a prestigious public college in the past 10 years are as follows: % Goal for entering class Year 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Applications Offers 13,876 12,002 14,993 11,858 11,006 11,894 12,015 14,941 16,285 17,180 16,517 17,642 18,207 18,038 18.855 11,975 11,545 12,241 11,902 11,742 Acceptances 4,405 4,494 4,193 4,662 4,926 4,826 4,780 5,117 5,035 5,014 104.9% 107.0% 99,8% 97.1% 102.6% 100.5% 99,6% 100.3% 98.7% 98.3% a. Plot the number of applications. b. Develop a trend model to forecast the number of applications for next year. Calculate the R² of that model and estimate number of applications for the next year. C Plot the percentage of acceptances relative to the number of offers made (yield). d. Develop a trend model to forecast next year's acceptance yield. Calculate the R² of that model and estimated yield for next year. e. Assume that the college is planning for an entering class of 5,000 freshmen for each of the next two years and a class of 5,300 in the following year. What is the number of offers it should make in each year? Is it getting tougher to get into this college?