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

question 149

True/False

SCENARIO 9-1
Microsoft Excel was used on a set of data involving the number of defective items found in a random sample of 46 cases of light bulbs produced during a morning shift at a plant.A manager wants to know if the mean number of defective bulbs per case is greater than 20 during the morning shift.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 cases:

-Referring to Scenario 9-1,if these data were used to perform a two-tail test,the p-value would be 0.042.

---

Definitions:

Par

The face value of a bond or other security, at which it can be redeemed at maturity or the amount of money equal in value to a particular share or bond.

Coupon

The yearly payment of interest to those holding bonds, represented as a percentage of the bond's nominal value.

Semi-Annual Coupon

A bond payment made to bondholders twice a year, representing interest on the bond's face value.

Effective Annual Yield

The actual interest rate an investment earns in a year, taking into account the effects of compounding.