SPC

Resources: Microsoft® Excel® and PowerPoint®

Select a complex continuous process from your personal life or work. INSTRUCTOR NOTE: YOU NEED RATIO LEVEL DATA FOR THIS ASSIGNMENT, AND TO HELP YOU WITH THAT, I HAVE PROVIDED THE DATA BELOW THAT YOU SHOULD USE FOR THIS ASSIGNMENT. I.E. USE THIS DATA, NOT SOMETHING FROM YOUR PERSONAL LIFE OR WORK. (If you understand ratio level data, and want to use something from your personal life, just let me know, and it would be fun to see your real data. But most of you are going to just want to use the race car data below.)

Complete the following:

• Use Microsoft® Excel® to calculate the defined process metrics including variation and process capability. SPECIFICALLY, TO DEFINE THE VARIATION AND PROCESS CAPABILITY, CALUATE STATISTICS FOR THE DATA TO INCLUDE THE MEAN, MEDAIN, MODE, RANGE, AND STANDARD DEVIATION OF THE DATA. Supplemental notes will include how I would like you to use Excel to complete the statisticalo calculations of the data provided here:
  
• Data: Speed of Race Car #10 for the final six laps of an auto race.
• Speeds 202,199, 198, 200, 197, 199 (in miles per hour)
• Use Microsoft® Excel® to comple and display the statistics for the process.

Evaluate whether the process could benefit from the use of Six Sigma tools.

Deliverable: NO PAPER IS DUE. SUBMIT AN EXCEL FILE SHOWING THE STATISTICAL CALCULATIONS FOR THE ABOVE DATA