week 6 problems

For the Week 6 Problems activity, you will complete and submit the following items:

Chapter 8

• Problem 1
• Problem 2
• Problem 3
• Problem 5 (Hint: Create 2 worksheets ~ calculations/implications and line chart with markers)
• Problem 9 (Hint: Create 2 worksheets ~ calculations/conclusions and Pareto chart)
• Problem 22 (Hint: Create 3 worksheets ~ calculations, Histogram/chart, and Run Chart)
• Problem 29 (Hint: Use Xbar&R Template though you may want to review the Xbar&R Simulator too)
• Problem 41 (Hint: Use P-Chart Template ~ do not be concerned with ‘Approximate Control Limits’)
• Problem 47 (Hint: Use C-Chart Template)
• Problem 50
• The problems are circled and have a star by them if you get confused by the instructions:

Note 1: Many of the problems above will use the data sets found in . 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). Templates are the Modules area of the course entitled Excel Templates.

You should upload ONE Excel and/or Word file (LastnameFirstnameWK4Problem#.xlsx) where the worksheet tabs are named and numbered professionally. PLEASE DO NOT SUBMIT ZIP FILES.