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

question 142

True/False

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 biologist can conclude that there is sufficient evidence to show that the mean number of parasites per butterfly is greater than 20 with no more than a 5% probability of incorrectly rejecting the true null hypothesis.

---

Definitions:

Sales Increase

The rise in the volume or value of sales of goods or services over a specified period compared to a previous period.

Sustainable Growth Rate

The maximum rate at which a company can grow its revenues and earnings without borrowing new funds or seeking additional investment.

Retention Ratio

The proportion of net income that is retained by a company, rather than distributed to shareholders as dividends.

Receivables Balance

The total amount of money owed to a company by its customers for goods or services that have been delivered or used but not yet paid for.