Analyze Filling Line Problems Using Control Charting Attached Files: File Filling line example for X-bar & control chart.xlsxOpen this document with ReadSpeaker docReader (13.354 KB) Using the provided data, calculate the control limits (X-bar and r-chart, Capability Index, create a control chart, and calculate the percentage of units that are expected to be out of spec (z-value). Show your work A quick way to do the percents part of the filling line problem (you know, the percent underfilled, the percent overfilled, etc.), is to use Excel's norm.dist function rather than looking it up on a printed Z table. Use the norm.dist excel function with the LSL in the first position in the parameter list. Norm.dist gives you the left side return from the Z table. "Excel offers you the NORM.DIST statistical function for working with normal distributions. The NORM.DIST function calculates the probability that variable X falls below or at a specified value" (https://www.dummies.com/software/microsoft-office/excel/how-to-use-the-norm-dist-function-in-excel/ ... the most succinct explanation I've found online).
Assignment: Analyze Filling Line Problems Using Control Charting Attached Files: File Filling line example for X-bar & control chart.xlsxOpen this document with ReadSpeaker docReader (13.354 KB) Using the provided data, calculate the control limits (X-bar and r-chart, Capability Index, create a control chart, and calculate the percentage of units that are expected to be out of spec (z-value). Show your work A quick way to do the percents part of the filling line problem (you know, the percent underfilled, the percent overfilled, etc.), is to use Excel's norm.dist
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 32 images