For this Assignment, review the resources for this week that are specific to attribute control charts. You should focus on mimicking the development of c and u charts as demonstrated in the resources for this week. The Assignment: (3–4 pages) Using SPSS and Microsoft      Word, complete problems 1 through 5 on pages 330–331 in the Ross textbook.      Show all work. Submit both your      SPSS and Word files for grading. Required Readings Ross, T. K. (2014). Health care quality management: Tools and applications. San Francisco, CA: Jossey-Bass. Chapter 8, "Statistical Process Control for Monitoring Nonconformities” (pp. 301–332) U.S. Department of Commerce, National Institute of Standards and Technology. (2016). NIST/SEMATECH e-handbook of statistical methods. Retrieved from http://www.itl.nist.gov/div898/handbook Chapter 6.3.3, “Attributes Control Charts” Emmanuel, J. (2015a). SPC 4: c-chart (control chart for number defective). Retrieved from https://www.youtube.com/watch?v=RvEjgsYkTZk PROBLEMS 1. A hospital introduced hip protectors to reduce the frequency of injury-producing patient falls. The hip protectors were introduced in July. The following table records the number of injury-producing falls from January through December. Create and interpret a c chart for patient falls. Were the hip protectors effective in reducing injury-producing patient falls?  s Month Falls Jan 5 Jul 3 Feb 5 Aug 3 Mar 3 Sep 2 Apr 4 Oct 2 May 2 Nov 3 Jun 2 Dec 3 2. The director of medical records conducts a monthly audit of 50 medical records to iden- tify coding errors. The Chapter 08.xls, Problem 08–02 tab records the data. National sta- tistics indicate that approximately 15% of medical records contain errors, and in the past the director has found multiple errors in a single record. Create a c chart to analyze perfor- mance. Interpret the department’s performance based on your control chart and identify any issues that should be investigated. Is the department doing a good job?  3. The chief medical officer is concerned that the long lengths of stay at her hospital may be the result of missed oxygen treatments. She has enacted a program to reduce the number of missed treatments. The Chapter08.xls, Problem 08–03 tab, records the number of missed oxygen treatments over the last 40 weeks. The improvement program was introduced in week 20. Was the program effective?  4. Implementing regular nursing rounds has been demonstrated to increase patient satisfac- tion and reduce patient falls. A hospital has collected data on ten patients per month over the past 24 months. The first twelve months the hospital did not have a formal rounding system. During the second period nurses were required to make rounds on an hourly basis from 8:00 AM through 8:00 PM and every two hours from 8:00 PM to 8:00 AM. The Chapter 08.xls, Problem 08–04 tab displays the number of call lights received per day for the ten- patient sample. Create a c chart to determine the effect of the rounding system on the use of call lights. Did the rounding program reduce patients’ use of call lights? Are there any issues that should be investigated?  5. To supplement their patient satisfaction survey, End Result Hospital conducts in-depth tele- phone interviews of past patients. The interviews are based on a 1% sample of the completed surveys from the prior month. The sample varies widely due to differences in monthly admis- sions, the rate at which surveys are completed, and the willingness of patients to participate in the telephone interview. The Chapter 08.xls, Problem 08–05 tab records the total number of the patients’ concerns noted by the interviewers. These concerns range from the effective- ness of medical treatment to the cleanliness and comfort of the patient room and ease of parking. The interviewer addresses the same items found on the patient satisfaction survey, solicits additional information for any item on which the patient indicated performance was less than “Good” or “Very Good,” and provides the patient with the opportunity to voice any other concerns. Create a control chart to summarize the results. Are patient concerns stable? 

A recent survey found that 70% of all adults over 50 wear glasses for driving. a) In a random sample of 10 adults over 50, what is the probability that at least six wear glasses? Solve this problem with last week’s Binomial distribution.b) Now, solve the same problem with this week’s Normal distribution approximation to the Binomial distribution.c) Compare answers.

 Vila Health ® ActivityPresenting Statistical Results for Decision MakingIntroductionYour OfficeStakeholder InterviewsEmail ResponseConclusionIntroductionAt any enterprise, statistical results can point the way to better decisions. This is especially true in health care, where trends or changes in patient care or results can have powerful effects on health care organizations — clinical effects, and financial effects. Knowing the facts about trends and changes is crucial to navigating them, which means that in many ways, statistical results are powerful tools.But they’re less powerful if nobody understands them. More often than not, stakeholders in health care organizations are not well versed in statistics or data analysis. Especially for these stakeholders, it’s critical to make careful choices about which numbers to include — and how to talk about those numbers. Doing so helps you to present statistical results in a way that’s understandable and actionable even for those with less data literacy.In this activity, you’ll have an opportunity to analyze a health trend at a large urban hospital, and to decide which results of the analysis are most important to communicate to the stakeholders concerned with it.Your OfficeYou are an analyst in the Quality Assurance department at St. Anthony Medical Center, a large hospital in Minneapolis, Minnesota. You have an email from David Brooks, the manager of Quality Assurance, in which he explains your next assignment.EmailFrom: David BrooksSubject: HACsHello! So I’m aware that you’re relatively new around here, but I’ve got to pull you in on an important project. Here’s the short version, and I can answer questions later if this isn’t enough background.Since you’re in health care, you must know that hospital-acquired conditions (HACs) are a big deal. Hospitals are designed from the ground up to minimize them, but the fact is that hospitals always have a lot of bugs floating around and that means they’re a constant danger. And while we try to minimize mistakes, health care professionals are human, and sometimes mistakes cause real problems.The hospital’s board is getting worked up about them again, because we’ve had some high-profile cases where a patient went home and had to be readmitted because of a mistake or an infection they picked up while they were here. They’re worried about PR, of course, but they’re worried about patient outcomes, and — of course — financial reimbursement and penalties, too.What I need you to do is start working on a presentation about HACs here, specifically as they relate to staffing levels and skill mix. That presentation should explain our recommendations to the board. You’ll want to include some statistics to bolster our case, so take a look at the AHRQ National Scorecard on Hospital-Acquired Conditions and the CMS Hospital-Acquired Conditions Reduction Program. Look at published research about the relationship between HACs and staffing levels, too.Let’s get this right; this is our chance to get the board to understand that HACs will go down if they do what we recommend.Go talk to Rick Susskind first; he’s our senior data analyst and he’s already been working on this. He has completed a data analysis on this, and he can explain what the variables are. You’ll have to talk to a few other people too, to get everything you need.DavidEmailFrom: Rick SuskindSubject: HAC DataHi! I got your message about the HAC question. I’ve attached a spreadsheet of the data analysis we’ve got on that.Here are a few variables that might be unclear:HAC_Rate: That’s the number of HACs per 1,000 discharges. You could say it’s the measure for the extent of hospital errors.Nursing_HPPD: That’s the number of nursing staff hours per patient day. It’s the hospital’s nurse staffing level.Skill_Mix: That’s obviously about skill mix, but specifically, it’s the percentage of nursing staff hours that are provided by registered nurses, as opposed to other professionals.ALOS: That stands for average length of stay; it’s the number of inpatient days per hospital discharge. It’s a measure of how efficient the hospital is.Let me know if you have other questions! Oh, you’ll need to find out how many discharges we have per year. I don’t know that, but Troy Holland, our vice president of patient services, will know.Attachment: HAC AnalysisStakeholder InterviewsTroy HollandVice President of Patient ServicesIt’s nice to meet you! Yep, I’ve got those discharge stats. I’m assuming you’re confining your analysis to the last full year? If so, the number of discharges for last year was 10,000. That includes both adult and pediatric discharges.What I don’t have is information about nurse staffing or costs. For those, you’ll want to talk to Jackie, the chief nursing officer.Jackie SandovalChief Nursing OfficerHello. I understand you need some data about our staff costs related to nursing. I’ve got three numbers for you.Our cost per nurse is $72,000. Now, that’s an average of nurses and registered nurses.Our cost per registered nurse is $85,000.Per licensed practical nurse, it’s $52,000. Those numbers include salary, benefits, and overhead.You had asked about some other costs, but I don’t have those. You’ll want to talk to the CFO, Owen Welch.Owen WelchChief Financial OfficerHey, I’ve only got a couple of minutes but here’s what you asked about: Our cost per inpatient day is $2,600, and the penalty per HAC is $5,700.Email ResponseIt looks like David has followed up with you about the data analysis project you’re working on. Review David's latest message to you and send a reply with your initial thoughts.EmailFrom: David BrooksSubject: HACsThanks for doing all that running around. Now that you’ve got the data analysis you need, I’d like you to do some thinking about what results you’re going to include in the presentation. Remember, it’s the board, not a bunch of number geeks. You’ll want to give them the statistical results they need to make a decision, not just every bit of data we have.Write down a list of numbers you’re thinking about including in your presentation. We really need to make a data-driven recommendation to the board, and I’d really appreciate your expertise. Thanks!ReplySubject: RE: HACsThis message has not been composed yet.ConclusionIn this activity, you saw that while complicated analysis of data is an important step in guiding decisions at health care organizations, it’s not the only step. Decision makers need to understand how the data were collected, how variables are measured, and whether the analysis tools and techniques were appropriate.You also gathered necessary data for an analysis of HACs, nurse staffing levels, and skill mix, and did some pre-work on a presentation of the data analysis to the hospital’s board.