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%

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

keosha answered 10 months ago

Next > < Previous

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

Subjects