The manager of a retail sales branch of a brokerage office is concerned with the number of undesirable trades made by the sales staff. A trade is considered undesirable if there is an error on the trade ticket. Trades that are in error must to be cancelled and resubmitted. The cost of correcting errors is billed to the brokerage. In studying the problem, the manager wants to know whether the proportion of undesirable trades is in a state of statistical control so he can plan the next step in a quality improvement process. Data are collected for a 30-day period and present in the excel sheet.

1. Construct an appropriate control chart for these data.
2. Is the process in a state of statistical control? If not, on which days is it out of control?

Day	Undesirable Trades	Total Trades
1	2	74
2	12	85
3	13	114
4	33	136
5	5	97
6	20	115
7	17	108
8	10	76
9	8	69
10	18	98
11	3	104
12	12	98
13	15	105
14	6	98
15	21	204
16	3	54
17	12	74
18	11	103
19	11	100
20	14	88
21	4	58
22	10	69
23	19	135
24	1	67
25	11	77
26	12	88
27	4	66
28	11	72
29	13	118
30	15	138