Explore BrainMass

# X-bar Control Chart and Capability Index in Excel

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Pieces 12.62 12.63 12.62 12.61 12.59 12.57 12.57 12.58 12.61 12.62
12.6 12.56 12.56 12.66 12.58 12.63 12.56 12.57 12.6 12.59
12.62 12.6 12.57 12.62 12.57 12.6 12.61 12.6 12.62 12.62
12.61 12.59 12.58 12.61 12.59 12.6 12.59 12.6 12.6 12.59
12.65 12.6 12.63 12.6 12.56 12.59 12.59 12.61 12.65 12.56

Questions 1 Identify the type of data
2 Determine the process capability
3 Determine the 3 sigma limits for X bar chart
4 Is the machine capable of meeting the specification requirements
5 Calculate the percentage defective, if any
6 Suggest possible ways by which the percent defective can be reduced

Assumptions
1 Normal distribution
2 d2 for group size 5 is 2.326

1. variable data

© BrainMass Inc. brainmass.com June 3, 2020, 11:11 pm ad1c9bdddf
https://brainmass.com/statistics/statistical-figures/bar-control-chart-capability-index-excel-267839

#### Solution Preview

Student,

Key to any capability index is the specificaton limits of the parts being produced. Your example gave ...

#### Solution Summary

For a given data set, Excel is used to calculate an X-Bar Control Chart and Capability Index. In addition, an image of histogram is provided to support skewing of the data.

\$2.19