Instruction 9-2
Microsoft Excel Was Used on a Set of Data

question 31

Short Answer

Instruction 9-2
Microsoft Excel was used on a set of data involving the number of parasites found in a random sample of 46 Blue Tiger butterflies captured in Kakadu National Park. A biologist wants to know if the mean number of parasites per butterfly is greater than 20. She will make her decision using a test with a level of significance of 0.10. The following information was extracted from the Microsoft Excel output for the sample of 46 butterflies:
$n = 46$ ; Arithmetic Mean $= 28.00$ ; Standard Deviation $= 25.92$ ; Standard Error $= 3.82$ ;
Null Hypothesis: $H _ { 0 } : \mu \leq 20.000 ; a = 0.10 ; \mathrm { df } = 45 ; T$ Test Statistic $= 2.09$ ;
One-Tailed Test Upper CriticalValue $= 1.3006 ; p$ value $= 0.021$ ; Decision $=$ Reject.
-Referring to Instruction 9-2,the probability of committing a Type II error is________ if the mean number of parasites per butterfly on Blue Tiger butterflies in Kakadu National Park is 30 using a 0.1 level of significance and assuming that the population standard deviation is 25.92.

Understand the application of cumulative distribution functions.

Understand the properties and behaviors of different probability distributions including normal, exponential, triangular, and uniform distributions.

Calculate probabilities and parameters (mean, variance, expected value) for various probability distributions.

Distinguish between characteristics of continuous and discrete probability distributions.

---

Definitions:

Executive Branch

Refers to the part of the U.S. government responsible for implementing and enforcing laws, led by the President.

Devolution

The transfer of power or responsibilities from a central government to local or regional administrations.

Provision of Services

The act of supplying or making available services to people or organizations, often referring to those offered by governments to meet public needs.

Across States

Refers to activities, regulations, or issues that span multiple states within a country, often requiring coordination among them.