Cable wire diameter data

An engineer at a metals company wants to determine whether the diameter of a cable wire that the company manufactures meets specifications. Each hour, operators take a subgroup of five consecutive cable wires from the production line and measure the diameters. A cable wire must be 0.55 ± 0.05 cm in diameter to meet engineering specifications.

You can use this data to demonstrate Normal Capability Analysis and other analyses that require normally distributed data.

Worksheet column Description
Diameter The cable wire diameter. Some missing values are present, represented as *.
Subgroup The subgroup identification number. Every 5 rows represent a subgroup.