AutoSay; . Off) B Ch13 Excel HW - Search (Alt+Q) AV X Q A Anthony WIpe File Home Insert Page Layout Formulas Data Review View Help Acrobat Conagents H IN P M A R W Y2 & Cut = ab Wrap Text Normal 2 LIX AutoSum Calibri 11 ~ A A General Normal Bad AY O [A Copy Fill Analyze Sensitivity Past nsert Delete Format Sort & Find & BIU~ ~ DAY = SEE Merge & Center ~ $ ~ % 2 08 28 Conditional Format as Good Neutral Calculation Format Painter Formatting ~ Table Clear ~ Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity N14 X V B E F G H K M N O P Q R S T U V W X Y Z AA AB Ten samples of 15 parts each were taken from an ongoing process to establish a p-chart. The samples and the TUI A W N number of defectives in each are shown in the following table a) Determine the p-bar, So, UCL and LCL for a p-chart with z = 3 (Format your answers with 4 decimal places.) b) Plot the p-chart. c) Based on the plotted data points, what comments can you make? (i.e., is the process in control or out of control?) Decide based on whether at least one point is outside the control limits. Recall a point is outside the 11 control limits if it is UCL. 12 13 14 15 Number of Defective 16 Sample Items 17 15 18 15 15 15 15 6 LD CO V G UI A W N H HNWI NH NWNE 15 15 15 |1 | 2 3 4 5 6 7 8 9 10| + D # @ J -- + 100% Ready Accessibility: Investigate