1. A local auto repair service had the following car repair shop data.

1. Prepare a check sheet (8 point) in MS Excel
2. Construct a Pareto Diagram (8 points) in MS Excel (Frequency of occurrence vs Repair work)
3. Professional look (4 point)

Ticket #	Repair work	Ticket #	Repair work
1	Alternator	21	Oil and filter
2	Batteries	22	Oil and filter
3	Oil and filter	23	Brakes
4	Tires	24	Tires
5	Brakes	25	Alternator
6	Brakes	26	Batteries
7	Oil and filter	27	Oil and filter
8	Oil and filter	28	Tires
9	Tires	29	Alternator
10	Transmission	30	Oil and filter
11	Oil and filter	31	Brakes
12	Bearings	32	Transmission
13	Oil and filter	33	Oil and filter
14	Batteries	34	Brakes
15	Batteries	35	Tires
16	Alternator	36	Oil and filter
17	Tires	37	Oil and filter
18	Oil and filter	38	Oil and filter
19	Brakes	39	Tires
20	Oil and filter	40	Brakes