answer a & b. dont just show the answer, please show how you did it in excel.

12. 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 3 weeks, which is considered a representative period for future conditions. After taking random samples of 64 personnel files each day, the following data were produced: Day Aides Absent Day Aides Absent 2 3 10 N 3 2 11 3 12 2 5 N 13 1 6 5 14 3 7 3 15 8 4 Because your assessment of absenteeism is likely to come under careful scrutiny, you would like a type I error of only 1 percent. 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. Design a p-chart. b. Based on your p-chart and the data from the last 3 weeks, what can you conclude about the absenteeism of nurses aides