Problem

Please number the problem properly and neatly so it can be easily understood.

For this week Problems activity, you will complete and submit the following items:

Chapter 9

· Problem 1

· Problem 5

· Problem 7

· Problem 12

· Problem 15

· Problem 20

Note 1 : Many of the problems above will use the data sets found in C09Data.xlsx. In addition, the Excel Templates folder on the course home page contains 'templates' that will aid in solving many of these problems.

Note 2 : In order to earn credit for your answers to the problems, you are required to show all supporting work . Also, you may be expected to use Microsoft Office applications (Excel, Word, and/or PowerPoint) when showing your supporting work. If you use a 'template', save all of the information (numerical/visual).

Problem

1. 1. Multisigma Corp. has a process they believe is operating near a six-sigma level and want to verify this. If the specification for a critical part in the process is 2.80 cm ` 0.10 and the standard devia- tion for the process is 0.0169, at what sigma level is this process operating?

Problem 5

5. NanosElectron, Inc. manufactures 75,000 circuit boards per month. A random sample of 800 boards is inspected every week for three characteristics. During a recent week, four defects were found for one characteristic, two defects were found for another characteristic, and one defect was found for the third characteristic. If these inspections pro- duced defect counts that were representative of the population, what is the overall sigma level for this process? What is the sigma level for the characteris- tic that showed four defects?

Problem 7

7. A flowchart for a hospital pre-admission testing process is shown in Figure 9.25. Determine the important quality characteristics inherent in this process and suggest possible improvements.

Problem 12

12. A Six Sigma analyst at Lakerio United Bank sus- pected that errors in counting and manually strap- ping cash into bundles were related to the number of weeks that employees had been employed on that job. The data available in the worksheet Prob. 9-12 were gathered from the process. What do you con- clude from your analysis? What do you recommend?

Problem 15

15. A process at Printwright, Inc.’s largest facility is used to make plastic gears for a computer printer. The data found in the worksheet Prob. 9-15 were gathered by a quality analyst. The gears were designed to be 3.57 ` 0.05 centimeters (cm) in diameter. Construct a histogram of the data. What can you observe about the shape of the dis- tribution? What would you recommend to the production manager based on your analysis?

Problem 20

20. The Cabo Fiesta Mexican Restaurant is trying to determine whether sales of its popular Pan Con Mucho Sabor breadsticks are correlated with the sales of margaritas. It has data on sales of bread- stick baskets and margaritas for 25 weeks, shown in the worksheet Prob. 9-20. Plot a scatter diagram and compute the correlation using Excel tools. What do your results indicate?