In: Operations Management
The admissions data for freshmen at a college in the past 10 years are as follows:
Year |
Applications |
Offers |
Acceptances |
% Goal for entering class |
2003 |
13,876 |
12,002 |
4,405 |
104.9% |
2004 |
14,993 |
11,858 |
4,494 |
107.0% |
2005 |
14,941 |
11,006 |
4,193 |
99.8% |
2006 |
16,285 |
11,894 |
4,662 |
97.1% |
2007 |
17,180 |
12,015 |
4,926 |
102.6% |
2008 |
16,517 |
11,975 |
4,826 |
100.5% |
2009 |
17,642 |
11,545 |
4,780 |
99.6% |
2010 |
18,207 |
12,241 |
5,117 |
100.3% |
2011 |
18,038 |
11,902 |
5,035 |
98.7% |
2012 |
18,855 |
11,742 |
5,014 |
98.3% |
use excel AND SHOW EXCEL FORMULAS