Purchase Solution

X-bar Control Chart and Capability Index in Excel

Not what you're looking for?

Ask Custom Question

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

Attachments
Purchase this Solution
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.

Solution Preview

Student,

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

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • X bar and R chart, Cp

    This posting contains solution to following problem on process capability index Cp, X bar and R chart

  • Process Capability Index

    Assume that only these six samples are sufficient, and use the data to determine control limits for an R- and an x-bar chart. b.

  • Control Chart with LCL and UCL Control limits

    336573 Control Chart LCL UCL: Control limits for X-bar chart; X-chart and R-chart - resistors In OPS571, Week 5, DQ Ch. 13, 14, & 16 of Operations Management for Competitive Advantage.

  • Statistical Process Control Transactions

    is out of control for 5th and 10th sample for X-chart.

  • Process capability

    Please find the complete help in attached Excel and word file. Process Capability Till this point, we have evaluated the current processes to see whether the variability for the processes is within statistical control.

  • Determine what items need to be measured to substantiate the improved process, the data required to measure improvement, and the upper and lower control limits.

    Use both an average (X-bar) and range (R-bar) control chart to depict process performance and to identify upper and lower control limits as well as the process average.

  • X-bar and R-Chart

    587697 X-bar and R-Chart The dataset contained in the problem #4 Excel file gives data on moisture content for specimens of a certain type of fabric. a. Create an X-bar R chart, using the first 10 subgroups as the base period.

  • Control chart

    401949 Upper and lower control limits: X-bar chart and R-chart Find the upper and lower control limits for an X-bar chart and R-chart for the width of a chair seat when sample grand mean (based on 30 samples of 6 observations each) is 27 inches and the

  • Making an XBar Control Chart with Excel

    This solution contains 25 samples of 5 observations that each are used to construct an X-bar control chart and then based on the initial X-bar chart a revised X-bar chart is made and 6 new samples are then plotted in the new, revised X-bar control chart

View More Related Solutions