Click on the data analysis tab at the top right click on


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 pf 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 a = 0.05, use these data to evaluate the claim by the health plan

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.

Solution Preview :

Prepared by a verified Expert
Macroeconomics: Click on the data analysis tab at the top right click on
Reference No:- TGS01471750

Now Priced at $30 (50% Discount)

Recommended (98%)

Rated (4.3/5)