Question

You are in charge of quality control for computer keyboards at Dell. You have data on...

You are in charge of quality control for computer keyboards at Dell. You have data on twenty-five batches of keyboards, tracking five types of keyboard defects: key brightness, scissor mechanics, dusting, dead connections, and stuck keys. These data are given in the table below. Complete in Excel.

1a. For each defect type, find the average number of defects per batch. So, you should have an average defect rate for displays, another for color, and so on.

1b. For each batch, find the total number of defects (the sum of all five types). So, you should have one number for batch 1, another for batch 2, and so on.

1c. Sort the five columns of defects by descending average defect rate. The lowest rate should be on the right.

1d. Sort the batches by descending total defects. The batch with the highest total should be at the top. This will not affect the column sorting from the part 3 above.

1e. Create a Pareto chart showing the average defect rate for each of the five defect types. This will be a column chart, in descending left-to-right order, with each column and the axes labeled

Defects

Batch

Key Brightness

Dead Connections

Dusting

Scissor Mechanics

Stuck Keys

1

4

1

1

0

2

2

2

2

0

0

3

3

3

5

2

1

1

4

3

0

0

2

2

5

3

0

1

2

3

6

2

0

2

0

1

7

3

3

1

2

2

8

1

1

0

0

2

9

0

1

0

3

0

10

2

1

2

1

0

11

2

3

1

3

2

12

1

1

2

2

0

13

1

2

4

0

0

14

2

1

0

1

0

15

1

2

2

2

4

16

0

1

1

3

1

17

1

2

0

0

1

18

3

3

0

2

2

19

1

0

3

0

3

20

2

1

2

0

0

21

1

3

0

3

0

22

2

3

0

0

2

23

1

2

1

3

6

24

0

3

2

0

0

25

2

4

2

1

0

Homework Answers

Answer #1

1a Mean defects per batch for

(a) Key brightness = 43/25 =1.72

(b) Dead connections =1.8

(c) Dusting =1.16

(d) Scissor mechanics =1.24

(e) Stuck keys =1.48

2.

Batch Key Brightness Dead Connections Dusting Scissor Mechanics Stuck Keys Sum Mean
1 4 1 1 0 2 8 1.6
2 2 2 0 0 3 7 1.4
3 3 5 2 1 1 12 2.4
4 3 0 0 2 2 7 1.4
5 3 0 1 2 3 9 1.8
6 2 0 2 0 1 5 1
7 3 3 1 2 2 11 2.2
8 1 1 0 0 2 4 0.8
9 0 1 0 3 0 4 0.8
10 2 1 2 1 0 6 1.2
11 2 3 1 3 2 11 2.2
12 1 1 2 2 0 6 1.2
13 1 2 4 0 0 7 1.4
14 2 1 0 1 0 4 0.8
15 1 2 2 2 4 11 2.2
16 0 1 1 3 1 6 1.2
17 1 2 0 0 1 4 0.8
18 3 3 0 2 2 10 2
19 1 0 3 0 3 7 1.4
20 2 1 2 0 0 5 1
21 1 3 0 3 0 7 1.4
22 2 3 0 0 2 7 1.4
23 1 2 1 3 6 13 2.6
24 0 3 2 0 0 5 1
25 2 4 2 1 0 9 1.8

1c

Batch Dusting Scissors M Stuck keys Key brightness Dead connections
1 1 0 2 4 1
2 0 0 3 2 2
3 2 1 1 3 5
4 0 2 2 3 0
5 1 2 3 3 0
6 2 0 1 2 0
7 1 2 2 3 3
8 0 0 2 1 1
9 0 3 0 0 1
10 2 1 0 2 1
11 1 3 2 2 3
12 2 2 0 1 1
13 4 0 0 1 2
14 0 1 0 2 1
15 2 2 4 1 2
16 1 3 1 0 1
17 0 0 1 1 2
18 0 2 2 3 3
19 3 0 3 1 0
20 2 0 0 2 1
21 0 3 0 1 3
22 0 0 2 2 3
23 1 3 6 1 2
24 2 0 0 0 3
25 2 1 0 2 4

1d

Batch Key Brightness Dead Connections Dusting Scissor Mechanics Stuck Keys Sum
23 1 2 1 3 6 13
3 3 5 2 1 1 12
7 3 3 1 2 2 11
11 2 3 1 3 2 11
15 1 2 2 2 4 11
18 3 3 0 2 2 10
5 3 0 1 2 3 9
25 2 4 2 1 0 9
1 4 1 1 0 2 8
2 2 2 0 0 3 7
4 3 0 0 2 2 7
13 1 2 4 0 0 7
19 1 0 3 0 3 7
21 1 3 0 3 0 7
22 2 3 0 0 2 7
10 2 1 2 1 0 6
12 1 1 2 2 0 6
16 0 1 1 3 1 6
6 2 0 2 0 1 5
20 2 1 2 0 0 5
24 0 3 2 0 0 5
8 1 1 0 0 2 4
9 0 1 0 3 0 4
14 2 1 0 1 0 4
17 1 2 0 0 1 4

Note: As per policies, I can answer first 4 parts of a question. Inconvenience is regretted.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Class-In Assignment 3: Chapters 4&5 How to retrieve data from two or more tables Exercises 1....
Class-In Assignment 3: Chapters 4&5 How to retrieve data from two or more tables Exercises 1. Write a SELECT statement that returns all columns from the Vendors table inner-joined with all columns from the Invoices table. 2. Write a SELECT statement that returns four columns: vendor_name vendor_name from the Vendors table invoice_number invoice_number from the Invoices table invoice_date invoice_date from the Invoices table balance_due invoice_total minus payment_total minus credit_total from the Invoices table The result set should have one row...
EX16_AC_CH05_GRADER_ML1_HW - Hotel Chain Project Description: You are the general manager of a large hotel chain....
EX16_AC_CH05_GRADER_ML1_HW - Hotel Chain Project Description: You are the general manager of a large hotel chain. Your establishment provides a variety of guest services ranging from rooms and conferences to weddings. The data entry accuracy of your staff could bear some improvement, so you have decided to move to Microsoft Access and implement several data validation techniques. You also will take advantage of Access's Expression Builder to help analyze data. Steps to Perform: Step   Instructions   Points Possible 1   Start Access....
We constantly seem to be pricing ourselves out of some markets and not charging enough in...
We constantly seem to be pricing ourselves out of some markets and not charging enough in others. Our pricing policy is pretty simple: we mark up our full manufacturing cost by 50%. That means a computer that costs us $2,000 to manufacture will sell for $3,000. Until now I thought this was a workable approach, but now I’m not so sure. Steve Works, CEO, Cortland Manufacturing, Inc. (CMI) Steve’s Controller, Sally Nomer, had just told him that she believed the...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...
Please read the article and answear about questions. Determining the Value of the Business After you...
Please read the article and answear about questions. Determining the Value of the Business After you have completed a thorough and exacting investigation, you need to analyze all the infor- mation you have gathered. This is the time to consult with your business, financial, and legal advis- ers to arrive at an estimate of the value of the business. Outside advisers are impartial and are more likely to see the bad things about the business than are you. You should...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...