Complete "Practice Exercise 11" (page 157) and "Practice Exercise 11" (page 180) in the textbook. For the data set listed, use Excel to extract the mean and standard deviation for the sample of lengths of stay for cardiac patients. Use the following Excel steps: 1) Enter the data set into Excel. 2) Click on the Data tab at the top. 3) Highlight your data set with your mouse. 4) Click on the Data Analysis tab at the top right. 5) Click on Descriptive Statistics in the analysis tool list. 6) Find the mean and standard deviation of the data sets. 7) Send the results to instructor via e-mail, along with your analysis of the description of the data set. APA format is not required, but solid academic writing is expected. Question 11. . .Suppose that a health plan asserts that a patient hospitalized with coronary heart disease requires no more than 6.5 days of hospital care. However, we believe that a stay of6.5 days is too low. To examine the claim of the health plan, assume further that we collected data depicting the lengths of stay of 40 patients who were hospitalized recently with coronary heart disease. The results of the sample are as follows:5,8,9,12,7,9,10,11,4,7,8,5,8,13,11,10,6,5,8,9,5,12,7,9,4,8,7,7,11,5,8,10,5,8,2,11, 3,6,8,7. If = 0.05, use these data to evaluate the claim by the health plan. Question 11. Suppose that the medical staff indicates that the results of a given laboratory procedure must be available 30 minutes after the physician submits a request for the service. In this situation, if the results arrived 30 minutes or less after the request, we regard the performance of the laboratory as timely. If results arrived more than 30 minutes after the request, we regard the performance as tardy. Focusing on the day, evening, and night shifts, suppose that we selected a random sample and obtained the following results: Shift Performance Day Evening Night Timely 100 80 40 Tardy 20 30 40 If = 0.05, use these results to test the proposition that the performance of the laboratory is independent of shift. Broyles Textbook Practice Exercise 1 Unsatisfactory 0.00% 70.0 %Content 40.0 %Completion of the Practice Exercises in Broyles on pages 157 and 180 2 Less Than Satisfactory 65.00% 3 Satisfactory 75.00% 4 Good 85.00% 5 Excellent 100.00% Failure to Demonstrates Demonstrates Demonstrates Demonstrates demonstrate the only minimal ability to use Excelability to use clearly and fully ability to use Excel ability to use to extract the Excel to the ability to to extract the Excel to extract mean and extract the use Excel to mean and the mean and standard deviation mean and extract the standard deviation standard for the data set, standard mean and for the data set. deviation for the but has some deviation for standard data set. slight the data set. deviation for misunderstanding the data set. of the process. Failure to use Provides some Supports main Supports main Supports main 30.0 supporting points with points with points with %Integration references, examples, or examples, but examples and references, references, of minimal explanations, but explanations, examples, and Information explanations. explanations and fails to include and examples. full from Outside no published published Analysis and explanations of Resources references references to description is how they apply. into the Body included. support claims direct, Thoughtfully of Paper and ideas. competent, andanalyzes, appropriate of evaluates, and the criteria. describes major points of the criteria. 30.0 %Organizatio n and Effectiveness Inappropriate Some Language is The writer is The writer uses 15.0 appropriate to the clearly aware a variety of %Language word choice and distracting lack of variety in inconsistencies targeted audience of audience, sentence Use and language use are Audience evident. Writer Awareness appears to be (includes unaware of sentence construction, audience. Use of word choice, "primer prose" indicates writer etc.) either does not apply figures of speech or uses them inappropriately. Surface errors are 15.0 %Mechanics pervasive enough that they impede of Writing communication of (includes meaning. spelling, punctuation, Inappropriate word choice grammar, and/or sentence language construction are use) used. 100 %Total Weightage in language for the most part. uses a variety constructions, choice (register) of appropriate figures of and/or word vocabulary for speech, and choice are the targeted word choice in present. The audience, and distinctive and writer exhibits uses figures of creative ways some lack of speech to that are control in using communicate appropriate to figures of clearly. purpose, speech discipline, and appropriately. scope. Frequent and Some mechanical Prose is largely Writer is clearly repetitive errors or typos are free of in command of mechanical present, but are mechanical standard, errors distract not overly errors, written, the reader. distracting to the although a few academic Inconsistencies reader. Correct may be English. in language sentence structure present. A choice and audiencevariety of (register), appropriate sentence sentence language are structures and structure, and/orused. effective word choice are figures of present. speech are used