If possible, please use excel to show work and formulas. I have done the work on my end but not 100% positive I am correct.

A shirt manufacturer buys cloth by the 100-yard roll from a supplier. For setting up a control chart to manage the irregularities (e.g., loose threads and tears), the following data were collected from a sample provided by the supplier.

SAMPLE	1	2	3	4	5	6	7	8	9	10
IRREGULARITIES	5	5	5	5	1	6	7	3	5	5

1. Determine the cc , S_p, UCL and LCL for a c -chart with z = 2. (Round answer to 2 decimal places)

C=

Sp =

UC:=

LCL=

2. Suppose the next five rolls from the supplier had three, two, five, three, and seven irregularities. Is the supplier process under control?

YES or O