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:
-True or False: Referring to Scenario 9-1, if these data were used to perform a two-tail test, the p-
value would be 0.042.

Question

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: 
-True or False: Referring to Scenario 9-1, if these data were used to perform a two-tail test, the p-
value would be 0.042.

Quizplus · Accepted Answer

The p-value for a two-tail test is twice the p-value for a one-tail test. In this case, the p-value for a one-tail test is 0.021, so the p-value for a two-tail test would be 0.042.

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