A private college report contains these​ statistics:

75​% of incoming freshmen attended public schools.

65​% of public school students who enroll as freshmen eventually graduate.

80​% of other freshmen eventually graduate.

What percent of students who graduate from the college attended a public high​ school?

___ ​% of students who graduate attended a public high school.

​(Round to two decimal places as​ needed.)

Discuss whether the human capital and signaling models have different implications for each of the following education policies:

a. Providing financial aid to students for college.

b. Introducing a test that high school students could take to provide reliable measures of task commitment and capacity to work effectively in teams.

c. Increasing the age at which students can drop out of high school from 16 to 17.

PLEASE ANSWER ONLY IF YOU KNOW

subject is Unix System programming

Create a SQLite Replit(or SQLite on another coding platform) that creates a table representing students in a class, including   name, graduation year, major, and GPA. Include two queries searching this student data in different ways, for example searching for all students with graduation year of 2021, or all students with GPA above a certain number.

Do female college students tend to weigh more or less than male college students, on average? Suppose that we use data from the Student Data sheet to help us make a decision about this question. We will assume that those who responded to the student data sheet are representative of all college students and are a random sample. Below are summary statistics from the student data sheet (rounded to the nearest integer):

a. Create a 95% confidence interval for the mean weight of all female college students

b. interpret the interval created in part a

c. create a 95% confidence interval for the mean weight of all male college students

d. interpret the interval created in part c

e. based on your interpretations of the confidence intervals above, do these data support any difference in average weight between female and male college students? Breifly justify your response.

Two teaching methods and their effects on science test scores are being reviewed. A random sample of 16 students, taught in traditional lab sessions, had a mean test score of 71.1 with a standard deviation of 4.4 A random sample of 11 students, taught using interactive simulation software, had a mean test score of 80.7 with a standard deviation of 5.9. Do these results support the claim that the mean science test score is lower for students taught in traditional lab sessions than it is for students taught using interactive simulation software? Let μ1μ1 be the mean test score for the students taught in traditional lab sessions and μ2be the mean test score for students taught using interactive simulation software. Use a significance level of α=0.05 for the test. Assume that the population variances are equal and that the two populations are normally distributed.

State the null and alternative hypotheses for the test.

Compute the value of the t test statistic. Round your answer to three decimal places.

Determine the decision rule for rejecting the null hypothesis H0. Round your answer to three decimal places.

State the test's conclusion.

Continuing the discussion about SAT scores, these parameters are for all people who took the SAT, not just students who went to college. However, there are some assumptions that people with higher SAT scores will make certain choices. One such choice is the decision to go to college. We do not know the data (mean and standard deviation) for students who go to college, but we can estimate it with a sample. We took a random sample of 27 first year students. Results of these tests are summarized below. ? = 27 ? = 1170 ? = 143 a. Calculate the test statistic (the thing that you will use to look up in a table) using the hypotheses: ??: ?????????? = 1086, the average SAT score of first year students is 1086 (average) ??: ?????????? > 1086, the average SAT score of first year students is greater than 1086 b. State a conclusion using either a p-value or a critical value using a sentence. c. Regardless if you rejected the null hypothesis or not, use the data to find the bounds for a 95% confidence interval to estimate the average score of the students in the current first year class. Your answer does not need to be a sentence

College officials want to estimate the percentage of students who carry a gun, knife, or other such weapon. A 9898% confidence interval is desired where the interval is no wider than 5 percentage points?

(a)    How many randomly selected students must be surveyed if we assume that there is no available information that could be used as an estimate of p^p^.

First Hint: note the question is limiting the "width" of the interval to 5 percentage points. Also, use at least five decimals places of accuracy with all values used in calculations. Your final answer however should be an integer.

Answer:

(b)    How many randomly selected students must be surveyed if we assume that another study indicated that 66% of college students carry weapons. Answer:

A college student surveyed fellow students in order to determine a 90% confidence interval on the proportion of students who plan on voting in the upcoming student election for Student Government Association President. Of those surveyed, it is determined that 82 plan on voting and 169 do not plan on voting.

(a) Find the 90% confidence interval.
Enter the smaller number in the first box.

Confidence interval: ( , ).

, believes that the mean number of hours per day all male students at the University use cell/mobile phones exceeds the mean number of hours per day all female students at the University use cell/mobile phones. To test President Loh’s belief, you analyze data from 29 male students enrolled in BMGT 230/230B this semester and 13 female students enrolled in BMGT 230/230B this semester.

a. Assuming equal population variances, if the level of significance equals 0.05 and the one-tail p-VALUE equals 0.0242, determine the following, in order: the one-tail critical value, the two-tails p-VALUE, and the two-tails critical value (again, order matters)

b. Assuming equal population variances and the level of significance equals 0.05, if the calculated value for the associated test statistic equals 1.8333 (where males are group 1), can you conclude the mean number of hours per day all male students at the University use cell/mobile phones exceeds the mean number of hours per day all female students at the University use cell/mobile phones?

A clinical psychologist wished to compare three methods for reducing hostility levels in university students using a certain psychological test (HLT). High scores on this test were taken to indicate great hostility, and 11 students who got high and nearly equal scores were used in the experiment. Five were selected at random from among the 11 students and treated by method A, three were taken at random from the remaining six students and treated by method B, and the other three students were treated by method C. All treatments continued throughout a semester, when the HLT test was given again. The results are shown in the table.

Let μ_A and μ_B, respectively, denote the mean scores at the end of the semester for the populations of extremely hostile students who were treated throughout that semester by method A and method B.

(a) Find a 95% confidence interval for μ_A.

(b) Find a 95% confidence interval for μ_B.

(c) Find a 95% confidence interval for (μ_A − μ_B).

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)