Question: Can anyone explain the setup in excel for Input and Bin ranges for histogram for this problem: Need help fast Crank and Battery Auto Works

Can anyone explain the setup in excel for Input and Bin ranges for histogram for this problem: Need help fast

Crank and Battery Auto Works is a local auto repair shop operated by two brothers, Jim and Jerry. 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; (3) 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

Expert Answer

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

please help!!! 8:50 Goal 2 Analytical problem Solvers... Problem #1 Jack and Jill's Grocery is manufacturing a "store brand" chocolate bar that has a variable cost of $0.75 per unit and a selling...

Problem #1 Jack and Jill's Grocery is manufacturing a "store brand" chocolate bar that has a variable cost of $0.75 per unit and a selling price of $1.25 per unit. Under the current system, fixed...

Need script to do sentimental analysis in python for amazon review data Here is the dataset text ## I purchased this monitor because of budgetary concerns . inexpensive[+1][a] ## This item was the...

Here is the case to analyse: Rivian Automotive, Inc. "The change over the next two decades from non-connected, combustion-powered vehicles to electric, con- nected, and increasingly autonomous...

Can anyone explain question 3 for me please and explain how you got your answers? (c) Total cost of 100,000 units completed: $ (d) Total cost of 20,000 units in process at the end of the month: S 3)...

YOU MUST SHOW YOUR WORK AND SETUP EACH PART AND SHOW THE CONDITION FOR MAXIMIZATION OF PROFITS. You are given the following information: Q=3000-P c(qi) = 500ql a. For the following parts: b. through...

Question 6: Draw a full experimental setup for the out-of-band high-loss loopback LME system. Then explain the setup in details. Question 7 : State the main objective of the above LME experiment....

Could anyone explain why not to recommend? Thanks in advance During the early stages of the pandemic many U.S. residents were looking for recreation and ways to remain physically active that did not...

Could anyone explain why not to recommend? in 150 words Thank you so muchhhh During the early stages of the pandemic many U.S. residents were looking for recreation and ways to remain physically...

The answer is not to Recommend , could anyone explain why? in 150 words Thank you so muchhhh During the early stages of the pandemic many U.S. residents were looking for recreation and ways to remain...

Show that Dx |x| = |x| / x, x 0.

Find some data on the Canada-U.S. exchange rate for the period from January 2000 to December 2008 (there are many reliable sources of such data available on the web, including the Bank of Canada...

The XYZ s seven - year $ 1 , 0 0 0 par bonds pay 9 percent interest. Your required rate of return is 7 % . The current market value for the bond is $ 1 , 1 0 0 . Determine the expected rate of return

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...