Explore BrainMass

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

    Attachments

    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

    ADVERTISEMENT