Posted: July 8th, 2022

Stats

Complete “Practice Exercise 11” (page 156) 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:

Don't use plagiarized sources. Get Your Custom Essay on
Stats
Just from $13/Page
Order Essay

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 (for both exercises)

7) Include your analysis of the description of the data set in the excel document.

 

Question 11 page 156

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 of 6.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. (MUST INCLUDE IF YOU THINK 6.5 DAYS IS ENOUGH AND WHY. SIMPLY WRITE A SMALL PARAGRAPH EXCEL!)

 

Question 11 page 180

 

Suppose that the medical staff indicated that the results of a given laboratory procedure must be available 30 min after the physician submits a request for the service. In this situation, if the results arrived 30 min or less after the request, we regard the performance of the laboratory as timely. If results arrived more that 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. If α = 0.05  Test the proposition that the performance of the laboratory is independent of shift. (MUST INCLUDE THIS IN YOUR ANSWER BY WRITING A SMALL PARAGRAPH!)

 

Day

Evening

Night

Timely

100

80

40

Tardy

20

30

40

 

 

DO BOTH QUESTIONS ON ONE EXCEL DOCUMENT USING DIFFERENT SHE

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Live Chat 1 7633094299EmailWhatsApp

Order your essay today and save 20% with the discount code WELCOME