Required information Problem 9-1 (Algo) [The following information applies to the questions displayed below.] The following are the car repair shop data: Ticket No. Work Ticket No. Work Ticket No. Work Lube & oil 11 Lube & oil 21 Battery Lube & oil 12 Lube & oil 22 Lube & oil Brakes 13 Battery 23 Lube & oil Tires 14 Brakes 24 Lube & oil Brakes 15 Tires 25 Lube & oil Battery 16 Brakes 26 Lube & oil Lube & oil 17 Battery 27 Tires Lube & oil 18 Brakes 28 Tires Lube & oil 19 Brakes 29 Tires 10 Transmission 20 Lube & oil 30 Tires Click here for the Excel Data File Problem 9-1 Part a (Algo) a. Prepare a check sheet for the above car repair shop data: Work Type Frequency Lube & oil Brakes Tires Battery Transmission TotalD. Select a appropriate Pareto diagram for the above car repair shop data: Multiple Choice O -J UT A Lube & cil Brakes Tires Battery Transmission O 13 IT Luke & ol Era-e Tires Ballery Transmission O 13