Excel Practice Questions

Suppose that a health plan asserts that a patient hospitalized with lung disease requires no more than 6.5 days of hospital care. We believe that 6.5 days is not enough time. To examine the claim of the health plan, assume further that the further data was collected depicting the lengths of stay of the 40 patients who were recently hospitalized. 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 Enter the data set into excel, Click on the Data tab at the top, highlight the data set, click on data analysis, then click descriptive statistics. Find the mean and stand deviation of the data sets. If alpha (a)

a = 0.05, use the new data to evaluate the claim by the health plan. I will need this done on excel preferably 2016 version.

Looking at the meeting a policy guideline: lab results must be available 30 minutes after the physician submits a request for the service. So if the lab results are available to the physician in 30 minutes or less this would be considered Timely. Anything after 30 minutes would be considered Tardy. Focusing on the day, evening, and night shifts, suppose that administration selected a random sample and obtained the following results (Timely: Days=100, Evenings=80, Nights=40) Tardy: Days= 20, Evenings=30, Nights=40). Enter the data set into excel, Click on the Data tab at the top, highlight the data set, click on data analysis, then click descriptive statistics. Find the mean and stand deviation of the data sets. If alpha (a) a = 0.05, use these results to test the proposition that the performance of the laboratory is independent of shift. I will need this done on excel preferably 2016 version.

I need the answer completed by 10/8/2017 @ 1700hrs Eastern Time