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

question 154

Short Answer

Instruction 9-1
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 ; \alpha = 0.10 ; \mathrm { df } = 45 ; T$ Test Statistic = 2.09;
One-Tailed Test Upper Critical Value $= 1.3006 ; p$ -value $= 0.021 ;$ Decision $=$ Reject.
-Referring to Instruction 9-1,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.

---

Definitions:

Stockholders' Equity

Represents the ownership interest of shareholders in a corporation, calculated as the difference between total assets and total liabilities.

Fair Value

The price that would be received for selling an asset or paid to transfer a liability in an orderly transaction between market participants.

Available-for-sale Securities

Financial assets intended to be sold off before they mature or in response to changes in market conditions, not classified as held-to-maturity or trading securities.

Market Value

The current price at which an asset or service can be bought or sold in the open market.