The Damon family owns a large grape vineyard in western New York along Lake Erie. The grapevines must be sprayed at the beginning of the growing season to protect against various insects and diseases. Two new insecticides have just been marketed: Pernod 5 and Action. To test their effectiveness, three long rows were selected and sprayed with Pernod 5, and three others were sprayed with Action. When the grapes ripened, 390 of the vines treated with Pernod 5 were checked for infestation. Likewise, a sample of 420 vines sprayed with Action were checked. The results are:   Insecticide Number of Vines Checked (sample size) Number of Infested Vines Pernod 5 390 23 Action 420 46     At the 0.02 significance level, can we conclude that there is a difference in the proportion of vines infested using Pernod 5 as opposed to Action? Hint: For the calculations, assume the Pernod 5 as the first sample.   State the decision rule. (Negative values should be indicated by a minus sign. Do not round the intermediate values. Round your answers to 2 decimal places.)         Compute the pooled proportion. (Do not round the intermediate values. Round your answer to 2 decimal places.)           Compute the value of the test statistic. (Negative value should be indicated by a minus sign. Do not round the intermediate values. Round your answer to 2 decimal places.)         What is your decision regarding the null hypothesis?     multiple choice Reject Fail to reject

The bacterium Staphylococcus aureus is commonly found on the skin and rarely causes major problems. If it gets under the skin or into the lungs it can cause boils or pneumonia. If the strain of bacterium causing these problems is resistant to methicillin, the infections can be life threatening. Methicillin resistant Staphy- lococcus aureus or MRSA is, therefore, a major concern in hospitals and clinics. Given the death rate from MRSA lung infections is 20%, if 20 patients are admitted in the hospital find the following probabilities:   (a) Less than 3 die (b) At least 3 die. (c) Between 6 and 3 die.

Avobenzone is one of the active ingredients in several commercially available sunscreens. It can be absorbed into the bloodstream when sunscreen is applied to the skin. The Food and Drug Administration has expressed concern about the safety of absorbing too much avobenzone. Researchers recruited 24 healthy volunteers to investigate avobenzone absorption for four different commercially available sunscreens: two sprays, a lotion, and a cream. Do the types of sunscreens (spray, lotion, and cream) differ in terms of how much avobenzone is absorbed into the blood? Subjects were randomly assigned to one of the four sunscreens, with six subjects for each. Subjects had 2 milligrams of sunscreen per 1 cm? applied to 75% of their body surface area (area outside of normal swimwear) four times per day for four days. The amount of avobenzone absorbed into the bloodstream (in nanograms per milliliter ap-plied, ng/mL) after 150 hours was then measured for each subject. For the purpose of analyzing…

This is a practice exam.  I would like to know how to slove usign excel or megastat Wenton Powersports produces dune buggies. They have three assembly lines, “Razor,” “Blazer,” and “Tracer,” named after the particular dune buggy models produced on those lines. Each assembly line was originally designed using the same target production rate. However, over the years, various changes have been made to the lines. Accordingly, management wishes to determine whether the assembly lines are still operating at the same average hourly production rate. Production data (in dune buggies/hour) for the last eight hours are as follows. (You may find it useful to reference the F table.)   Razor   Blazer   Tracer   11       10       9     10       8       9     8       11       10     10       9       9     9       11       8     9       10       7     12       11       8     12       8       9         Click here for the Excel Data File   a. Specify the competing hypotheses to…