As a hospital administrator of a large hospital you are concerned with the absen

As a hospital administrator of a large hospital you are concerned with the absenteeism among nurses aides. The issue has been raised by registered nurses who feel they often have to perform work normally done by their aides. To get the facts absenteeism data were gathered for the last 15 days. This is considered a representative period for future conditions. After taking random samples of 96 personnel files each day the following data were produced:Day Aides Absent Day Aides Absent1 6 9 112 5 10 33 3 11 54 2 12 35 3 13 26 8 14 57 5 15 118 6 Assume that there is sufficient data for preparing control charts. Because your assessment of absenteeism is likely to come under careful scrutiny you would like to use 2 control limits. You are not interested in the reasons for the absence but just if there is an absence or not. You want to be sure to identify any instances of unusual absences. If some are present you will have to explore them on behalf of the registered nurses. a) Calculate the 2 (sigma) control limits. The centerline should be based on the data from these 15 days. All calculations should be to three decimal places (x.xxx).b) After finding the control limits prepare and provide the appropriate control chart. c) Using this sample information and the control chart do the data indicate that absenteeism is a problem or not for the hospital s nurses aides? Why or why not d) Suppose that the administrator has obtained data from an industry association that indicates the acceptable industry standards for absenteeism has upper and lower limits of 0.135 and 0.035 respectively. Considering the performance based on the daily samples from the control chart what would you conclude about the hospital s experiences compared to the industry s standards? Explain your answer. Additional Requirements Level of Detail: Show all work