help with 12.2 12.2 The data in Table EX 12.2 records the patient falls in three care units over a seventeen-week period.a. For each unit, calculate LCL and UCL for an appropriate control chart, using 95.5 percent confidence limits.b. Construct a control chart for each unit.c. Are any observations in violation of the control limits for the unit?Table EX 12.2Patient Falls Unit I Unit II Unit IIIWeek 11Week 2Week 3Week 4Week 5Week 6Week 7Week 8Week 9Week 10Week 11Week 12Week 13Week 14Week 15Week 16Week 170221221012112122312101120201232 O2143121202331622 O

Patient FallsUnit IUnit IIUnit IIIWeek 1213Week 2121Week 3230Week 4222Week 5312Week 6101Week 7222Week 8101Week 9014Week 10113Week 11221Week 12102Week 13011Week 14222Week 15210Week 16102Week 17213a) A C chart is used to test the number of defects per item where each item can have multiple defects and the subgroups are of equal size. In this case, the attribute is patient fall for subgroups at three different care units. Thus, a c chart is an appropriate chart.The probabilty is 0.955.Use Excel function "=NORM.S.INV(0.955)" to obtain the z-score corresponding to it. The result is shown below:LCL and UCL for c chart are computed using the formulae:Calculations for unit I:SampleNumber of defects in Unit Ic-barLCLUCL121.47060.00003.5266211.47060.00003.5266321.47060.00003.5266421.47060.00003.5266531.47060.00003.5266611.47060.00003.5266721.47060.00003.5266811.47060.00003.5266901.47060.00003.52661011.47060.00003.52661121.47060.00003.52661211.47060.00003.52661301.47060.00003.52661421.47060.00003.52661521.47060.00003.52661611.47060.00003.52661721.47060.00003.526625Calculations for unit II:SampleNumber of defects in Unit IIc-barLCLUCL111.17650.00003.0154221.17650.00003.0154331.17650.00003.0154421.17650.00003.0154511.17650.00003.0154601.17650.00003.0154721.17650.00003.0154801.17650.00003.0154911.17650.00003.01541011.17650.00003.01541121.17650.00003.01541201.17650.00003.01541311.17650.00003.01541421.17650.00003.01541511.17650.00003.01541601.17650.00003.01541711.17650.00003.015420Calculations for unit III:SampleNumber of defects in Unit IIIc-barLCLUCL131.76470.00004.0169211.76470.00004.0169301.76470.00004.0169421.76470.00004.0169521.76470.00004.0169611.76470.00004.0169721.76470.00004.0169811.76470.00004.0169941.76470.00004.01691031.76470.00004.01691111.76470.00004.01691221.76470.00004.01691311.76470.00004.01691421.76470.00004.01691501.76470.00004.01691621.76470.00004.01691731.76470.00004.016930b) Control chart can be obtained for each unit using Excel.Steps to follow are given below:C-chart for unit I:Enter the table values in Excel sheet i.e., Sample, Number of defects, c-bar. LCL, UCL.Highlight the data. Go to Insert tab.Under charts select, 2D line chart.Add axis titles and chart title.Excel output is given below:C-chart for unit II:Enter the table values in Excel sheet i.e., Sample, Number of defects, c-bar. LCL, UCL.Highlight the data. Go to Insert tab.Under charts select, 2D line chart.Add axis titles and chart title.Excel output is given below:C-chart for unit III:Enter the table values in Excel sheet i.e., Sample, Number of defects, c-bar. LCL, UCL.Highlight the data. Go to Insert tab.Under charts select, 2D line chart.Add axis titles and chart title.Excel output is given below:Based on the charts obtained in part (b), there are no points that fall outside the LCL and UCL for each of the three units.Therefore, there are no observations in violation of the control limits for the unit.a) The limits for c-chart using 95.5 percent confidence limits for unit I are:The limits for c-chart using 95.5 percent confidence limits for unit II are:The limits for c-chart using 95.5 percent confidence limits for unit III are:b) C-chart for unit I:C-chart for unit II:C-chart for unit III:(c) There are no observations in violation of the control limits for the unit. Because none of the points for each unit lie outside LCL and UCL.