An admission office at a university is processing freshman applications which fall into three groups: in-state,...

An admission office at a university is processing freshman applications which fall into three groups: in-state, out-of-state, and international. The male–female ratios for in-state and out-ofstate applicants are 1:1 and 3:2, respectively. For international students, the corresponding ratio is 8:1. The ACT score is an important factor in accepting new students. The statistics gathered by the university indicate that the average ACT scores for in-state, out-of-state, and international students are 27, 26, and 23, respectively. The admission committee has established the following desirable goals in priority order for the new freshman class:

1. The incoming class is at least 1200 freshmen.

2. The average ACT score for all incoming students is at least 25

3. International students constitute at least 10% of the incoming class.

4. The female–male ratio is at least 3:4.

5. Out-of-state students constitute at least 20% of the incoming class.

a) Solve this problem using Excel Solver, label the sheets appropriately and use short comments for describtion.

Formulate a Goal Programming model to meet these goals presented, define your decision variables, constraints and objective(s)

Solutions

Expert Solution

keosha answered 8 months ago

Next > < Previous

Related Solutions

At a university the historical mean of scholarship examination scores for freshman applications is 800. A...

At a university the historical mean of scholarship examination scores for freshman applications is 800. A historical population standard deviation σ = 150 is assumed known. Each year, the assistant dean uses a sample of applications to determine whether the mean examination score for the new freshman applications has changed. (a) State the hypotheses. (b) What is the 95% confidence interval estimate of the population mean examination score if a sample of 90 applications provided a sample mean x = 834?...

An Office of Admission document at a certain university claims that 55.3% of their undergraduates are...

An Office of Admission document at a certain university claims that 55.3% of their undergraduates are female. To test this claim, a random sample of 220 undergraduates was selected. In this sample, 56.1% were female. Is there sufficient evidence to conclude that the document's claim is false? Carry out a hypothesis test at a 8% significance level. A. The value of the test statistic is: B. The p-value is D. Your decision for the hypothesis test: A. Reject H0H0. B....

At Western University the historical mean of scholarship examination scores for freshman applications is 900. Each...

At Western University the historical mean of scholarship examination scores for freshman applications is 900. Each year the assistant dean uses a sample of applications to determine whether the mean examination score for new freshman applications has changed. (a) What hypotheses is the assistant dean testing each year? (b) This year for a sample of 75 freshman, the dean finds the sample average examination score to be 875. The dean also knows that σ= 100. What is the value of...

The admission office of famous university has a policy of offering equal opportunity to all applicants...

The admission office of famous university has a policy of offering equal opportunity to all applicants without regard to religion, race, color, height, weight, marital status, sexual orientation, age or gender. Here are some data on recent admission to the university’s first-year class: Gender Admitted Not admitted Female 370 130 Male 660 622 Perform an appropriate statistical procedure to demonstrate a gender bias in admission.

The admission office of famous university has a policy of offering equal opportunity to all applicants...

The admission office of famous university has a policy of offering equal opportunity to all applicants without regard to religion, race, color, height, weight, marital status, sexual orientation, age or gender. Here are some data on recent admission to the university’s first-year class: gender admitted not admitted female 370 130 male 660 297 perform an appropriate statistical procedure to demonstrate a gender bias in admission

Out of a random sample of 355 freshman at State University, 192 students have declared a...

Out of a random sample of 355 freshman at State University, 192 students have declared a major. Find a 96% confidence interval for the true population proportion of freshman at State University who have declared a major. Find the left endpoint of the confidence interval . Round to three decimal places

According to the record of the registrar's office at a state university, 40% of the students...

According to the record of the registrar's office at a state university, 40% of the students are freshmen, 30% are sophomores, 20% are juniors, and the rest are seniors. Among the freshmen, sophomores, juniors, and seniors, the portion of students who live in the dormitory are, respectively, 75%, 50%, 35%, and 15%. If a randomly selected student does not live in the dormitory, what is the probability that the student is a freshman?

TABLE 4-8 (According to the record of the registrar's office at a state university, 35% of...

TABLE 4-8 (According to the record of the registrar's office at a state university, 35% of the students are freshman, 25% are sophomore, 16% are junior, and the rest are senior. Among the freshmen, sophomores, juniors, and seniors, the portion of students who live in the dormitory are, respectively, 80%, 60%, 30%, and 20%. ) 40. Referring to Table 4-8, what is the probability that a randomly selected student is a freshman who lives in a dormitory? 41. Referring to...

a) List some applications which find batch-mode processing useful. Justify your answer. b) List some applications...

a) List some applications which find batch-mode processing useful. Justify your answer. b) List some applications which find interactive-mode processing useful. Justify your answer

which groups are over-represented and which are under-represented in state legislatures?

Subjects