Hello,

Please answer the problem below SHOWING SOLUTIONS to each questions. Please answer completely in an EXCEL document and attach here.

NOTE: If not able to attach document, please show step by step how to program in EXCEL.

Crank and Battery Auto Works is a local auto repair shop operated by two brothers, Huey and Dewey. The brothers have been collecting data for the past 30 days on the type of work performed on customers cars. The two brothers have hired you as a business manager and have asked you to summarize historical data collected using:

(a) a histogram;

(b) check sheet;

(c) and Pareto diagram.

You must also prepare a short report/analysis that summarizes your findings. Use EXCEL to complete draw the histogram and Pareto Chart.

Ticket No.	Work	Ticket No.	Work	Ticket No.	Work
1	Tires	11	Brakes	21	Lube & oil
2	Lube & oil	12	Lube & oil	22	Brakes
3	Tires	13	Battery	23	Transmission
4	Battery	14	Lube & oil	24	Brakes
5	Lube & oil	15	Lube & oil	25	Lube & oil
6	Lube & oil	16	Tires	26	Battery
7	Lube & oil	17	Lube & oil	27	Lube & oil
8	Brakes	18	Brakes	28	Battery
9	Lube & oil	19	Tires	29	Brakes
10	Tires	20	Brakes	30	Tires

THANK YOU VERY MUCH!