Examlex

Solved

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

question 120

Short Answer

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:
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,the lowest level of significance at which the null hypothesis can be rejected is .
-Referring to Scenario 9-1,the lowest level of significance at which the null hypothesis can be rejected is .


Definitions:

SquareFeet

A unit of area measurement commonly used in the United States real estate and construction to describe the size of a space.

Data Type

A classification indicating the kind of value a variable or field can hold in programming and data storage, such as integer, string, or date.

Null

A value used in databases to represent missing or undefined data.

City field

A specific field in databases or forms designated for entering or displaying a city's name.

Related Questions