Question

In: Operations Management

The admissions data for freshmen at a college in the past 10 years are as follows:...

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%

  1. Plot the number of applications.
  2. Develop a trend model to forecast the number of applications for next year. Calculate the R2 of that model and the estimated number of applications for the next year.
  3. Plot the percentage of acceptances relative to the number of offers made (acceptance yield).
  4. Develop a trend model to forecast next year’s acceptance yield. Calculate the R2 of that model and the estimated yield for next year.
  5. 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?

use excel AND SHOW EXCEL FORMULAS

Solutions

Expert Solution


Related Solutions

A college admissions office takes a simple random sample of 120 entering freshmen and computes their...
A college admissions office takes a simple random sample of 120 entering freshmen and computes their mean SAT score to be 448. The population standard deviation is 116. Bsed on a 98%confidence interval mean, is it likely that the mean SAT score for entering freshmen is greater than 464? (first construct the 98% confidence interval)
Several years​ ago, a study of college freshmen found that 29.2​% of incoming freshmen characterized their...
Several years​ ago, a study of college freshmen found that 29.2​% of incoming freshmen characterized their political views as​ liberal, 46.6​% as​ moderate, and 24.2​% as conservative. For this​ year, a random sample of 500 incoming college freshmen yielded the following frequency distribution for political views. Complete parts​ (a) and​ (b) below. Liberal   145 Moderate   235 Conservative   120
From past studies the average time college freshmen spend studying is 22 hours per week. The...
From past studies the average time college freshmen spend studying is 22 hours per week. The standard deviation is 4 hours. This year, 60 students were surveyed, and the average time that they spent studying was 20.8 hours. Test the claim that the time students spend studying has not changed. Use a=1%
from past studies the average time college freshmen spend studying n 22 hours per week. The...
from past studies the average time college freshmen spend studying n 22 hours per week. The standard deviation is 4 hours. This year, 60 students were surveyed, and the average time that they spent studying was 20.8 hours. Test the claim that the time students spend studying has not changed. Use a=1%
TABLE 12-11 The director of admissions at a state college is interested in seeing if admissions...
TABLE 12-11 The director of admissions at a state college is interested in seeing if admissions status (admitted, waiting list, denied admission) at his college is independent of the type of community in which an applicant resides. He takes a sample of recent admissions decisions and forms the following table: Admitted Wait ADMITTED WAIT LIST DENIED TOTAL URBAN 45 21 17 83 RURAL 33 13 24 70 SUBURBAN 34 12 39 85 TOTAL 112 46 80 238 He will use...
Topic: Comparing support for including ethnic consideration in college admissions between White and Black Populations. Data:...
Topic: Comparing support for including ethnic consideration in college admissions between White and Black Populations. Data: Whites (659 of 2,997 say Yes, race should be a factor) Blacks (577 of 1,518 say Yes, race should be a factor) Provide the following: 1. Summary Statistics 2. T-Test (or Confidence Interval) 3. Hypothesis Test 4. Regression
Results of the American College Counseling Association indicate that 9% of college freshmen have seen a...
Results of the American College Counseling Association indicate that 9% of college freshmen have seen a professional counselor, 14% of college sophomores have seen a professional counselor, 16% of college juniors have seen a professional counselor, and 21% of college seniors have seen a professional counselor. The Syracuse University Health Center conducts its own survey, and finds the following: CHI SQ Freshmen Sophomores Juniors Seniors # Seeing a Counselor 20 25 36 48 Is the distribution of students seeking counselors...
Selected data concerning the past year’s operations of the Ozarks Manufacturing Company are as follows:
Selected data concerning the past year’s operations of the Ozarks Manufacturing Company are as follows:InventoriesBeginningEndingRaw material$61,000$81,000Work in process80,00030,000Finished goods90,000110,000Other data:Direct material used$334,000Total manufacturing costs charged to productionduring the year (includes direct material,direct labor, and manufacturing overheadapplied at a rate of 60% of direct-labor cost)686,000Cost of goods available for sale826,000Selling and administrative expenses30,500Required:1.  What was the cost of raw materials purchased during the year?2.  What was the cost of goods sold during the year?
The admissions office of a small college is asked to accept deposits from a number of...
The admissions office of a small college is asked to accept deposits from a number of qualified prospective freshmen so that, with probability about 0.95, the size of the freshman class will be less than or equal to 1,100. Suppose the applicants constitute a random sample from a population of applicants, 80% of whom would actually enter the freshman class if accepted. (Use the normal approximation.) (a) How many deposits should the admissions counselor accept? (Round your answer up to...
Here are quarterly data for the past two years, from these data, prepare a forecast for...
Here are quarterly data for the past two years, from these data, prepare a forecast for the upcoming year using decompostion. foreccast years 9 to 12. FORECAST ERROR? Period Actual period Actual 1 300 5 416 2 540 6 760 3 885 7 1191 4 580 8 760
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT