Q2. Constructing a c-chart

please show formulas in excel

The XYZ company daily delivers multiple orders by truck from its regional distribution center to stores in the ABC Supermarket chain. One measure of its supply chain performance is the number of late deliveries. The companys goal is to make all deliveries within one day, so a delivery is late if it exceeds one day. The late deliveries for each of the past 20 days are as follows:

Construct a c-chart for late deliveries with 3s control limits and indicate if the delivery process was out of control at any time.

Day	Late Deliveries
1	6
2	15
3	16
4	8
5	19
6	12
7	10
8	14
9	10
10	9
11	6
12	12
13	15
14	11
15	15
16	18
17	15
18	12
19	19
20	23