# X-bar Control Chart and Capability Index in Excel

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 ad1c9bdddfhttps://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.