Please explain in written format and EXCEL function.

Over the past few decades, public health officials have examined the link between weight and teen girls’ smoking. Researchers surveyed a group of 273 randomly selected teen girls between 12 and 15 years old living in Massachusetts . After four years, the girls were surveyed again. Sixty-three said that they smoked to stay thin. Is there good evidence that more than 30% of the teen girls smoke to stay thin?

After conducting the test, your decision and claim are

1. Reject H_o: sufficient evidence to conclude that more than 30% of teen girls smoke to stay thin.
2. Do not reject H_o : insufficient evidence to conclude that less than 30% of teen girls smoke to stay thin.
3. Do not reject H_o : insufficient evidence to conclude that more than 30% of teen girls smoke to stay thin
4. Reject H_o: insufficient evidence to conclude that less than 20% of teen girls smoke to stay thin.

1. Women athletes at the University of Jamestown have a long-term graduation rate of 72%. Over the past several years, a random sample of 45 women athletes at the school showed that 30 eventually graduated. Does this indicate that the population proportion of women athletes who graduate from the university is now less than 72%?

1. State the null (H₀) and alternative (H₁) hypotheses.

2. Give the test statistics and the p-value for this significance test.

3. Make a decision on whether or not to reject the null hypothesis.

4. Summarize the conclusion in the context of this problem.

2. A random sample of 300 one-year old baby boys is studied and their weights in pounds are recorded. Their mean weight was 25.7 pounds with a standard deviation 5.3 pounds. A medical researcher claims that the mean weight of one-year old boys is greater than 25 pounds. Does this study provide convincing evidence that the researcher’s claim is true? Use a 0.02 level of significance.

1. State the null (H₀) and alternative (H₁) hypotheses.

2. Give the test statistics and the p-value for this significance test.

3. Make a decision on whether or not to reject the null hypothesis.

4. Summarize the conclusion in the context of this problem.

Look at the following research questions. What would be an appropriate audience for each one? Why did you come to that answer?

1. How does the use of texting affect high school English grades?
2. What effect do medical budget cuts have on small town hospitals?
3. Does earning an MBA make you a better job candidate?
4. Why does the American government lend money to foreign countries?

The following information applies to the questions displayed below.] The county collector of Suncoast County is responsible for collecting all property taxes levied by funds and governments within the boundaries of the county. To reimburse the county for estimated administrative expenses of operating the tax agency fund, the agency fund deducts 2.1 percent from the collections for the town, the school district, and the other towns. The total amount deducted is added to the collections for the county and remitted to the Suncoast County General Fund. The following events occurred in 2017: 1. Current-year tax levies to be collected by the agency were: County General Fund $ 10,393,000 Town of Bayshore General Fund 4,870,000 Suncoast County Consolidated School District 6,580,000 Other towns 3,180,000 Total $ 25,023,000 2. $13,760,000 of current taxes was collected during the first half of 2017. 3. Liabilities to all funds and governments as a result of the first half-year collections were recorded. (A schedule of amounts collected for each participant, showing the amount withheld for the county General Fund and net amounts due the participants, is recommended for determining amounts to be recorded for this transaction.) 4. All cash in the tax agency fund was distributed. a. Prepare journal entries for each of the foregoing transactions that affected the tax agency fund. b. Prepare journal entries for each of the foregoing transactions that affected the Suncoast County General Fund. Begin with the tax levy entry, assuming 4 percent of the gross levy will be uncollectible. c. Prepare journal entries for each of the foregoing entries that affected the Town of Bayshore General Fund. Begin with the tax levy entry, assuming 2 percent of the gross levy will be uncollectible.

Jael is a hospitality company that considers acquiring Sisera Inc. Jael share market price is $50 and there are 1M of Jael shares outstanding. Sisera has 0.1M shares outstanding worth $150 each. If Jael acquires Sisera, then the resulting synergy will amount to $10M.

a) Suppose Jael offers to exchange every Sisera’s share for four shares in the merged company. What will be the share price of the merged company?

b) What will be the total benefit for the existing shareholders of Jael?

c) What about the existing shareholders of Sisera?

d) Suppose Jael offers to exchange every Sisera’s share for $200 in cash. What will be the share price of the merged company?

e) What will be the total benefit for the existing shareholders of Jael?

f) What about the existing shareholders of Sisera?

There are two lines of students. The first line has students s1, s2, s3, s4 and s5, in that order. The second line has students t1, t2, t3, t4, t5, and t6, in order. Both lines will be merged into one as follows: If both lines still have students in them, one of the two lines is randomly selected and the person in the front of that line will go to the back of the merged line. If only one line remains, then all of those students will join in the back of the merged line, in their original order. For example, one way in which the students could line up is: s1, t1, t2, t3, s2, t4, t5, s3, t6, s4 and s5. Using this procedure, how many possible ways could these 11 students line up?

The percentage of newborn baby boys in the United States is 51.2%. In a recent sample of 964 births, 473 of the newborn babies were boys. Use a level of significance of 0.02 to test the claim that the percentage of newborn baby boys is not equal to 51.2%. Show your work to receive credit.

Question text

In the early 1990's, the Oregon Department of Education was looking into the success of their school lunch programs. Critics of the current way funds were being diverted to school food services believed that the low quality of the food being served in the low-income school districts was leading to malnutrition among the students.

The state had already collected growth data for decades throughout Oregon, so they went through their records to look for signs of malnutrition. One metric they used was heights of children in the various school districts. If children did not have proper nutrition from healthy food, they would not grow to their full potential.

The CDC/National Center for Health Statistics put the average height for 12 year old girls in the United States at 59.4 inches, with standard deviation 2.3 inches.

1. Assume that heights are normally distributed. If we randomly selected a 12-year-old female student in a local school, what is the probability that she is no more than 55.4 inches tall?  

The Klamath county school district reported that their female 12-year-old students had a mean height of 58.2 inches out of a sample of 27 students. This a little more than an inch below the population mean for all 12 year old girl's heights.

2. Let's define an unusual event to be one where the probability of it occurring is less than 0.05 (or, equivalently, less than 1 in 20). If we wanted to find out if the school district's mean height was unusually low, what probability should we find?

(Hint: if 58 inches tall is unusually low, then so is 57 inches, and 56 inches.... )