Question
Process Output Analysis A shaft with specifications of .500.005 is being turned on a CNC turning center. Measurements were taken and recorded in the table
Process Output Analysis
A shaft with specifications of .500.005 is being turned on a CNC turning center. Measurements were taken and recorded in the table below. Use Excel spreadsheet to perform all the necessary calculations to complete the process output analysis.
Enter data in yellow shaded cells and perform your calculations in the appropriate orange shaded cells.
The spreadsheet should be fully automated using cell addresses in all calculations and not typed in answers.
Add a histogram of the measurement data. Label process mean, USL, LSL, and process capability in the approximate spot on the histogram.
Table of Sample Data
0.502
0.496
0.501
0.502
0.501
0.498
0.502
0.498
0.499
0.504
0.497
0.501
0.502
0.503
0.500
0.501
0.500
0.499
0.500
0.502
0.496
0.502
0.500
0.499
0.505
0.496
0.499
0.502
0.500
0.504
0.495
0.499
0.503
0.499
0.504
0.499
0.501
0.502
0.499
0.498
0.499
0.501
0.503
0.498
0.501
0.501
0.500
0.502
0.500
0.501
0.501
0.498
0.503
0.499
0.498
0.500
0.501
0.502
0.503
0.499
0.500
0.502
0.501
0.500
0.499
0.500
0.501
0.499
0.500
0.501
0.501
0.494
0.500
0.501
0.499
0.502
0.502
0.501
0.500
0.501
0.499
0.500
0.502
0.499
0.498
0.500
0.499
0.500
0.502
0.497
0.500
0.502
0.501
0.500
0.500
0.503
0.502
0.501
0.495
0.501
0.501
0.499
0.500
0.504
0.497
0.500
0.501
0.496
0.500
0.501
0.498
0.500
0.500
0.500
0.502
0.501
0.501
0.497
0.501
0.505
0.501
0.503
0.498
0.501
0.503
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started