Question

Question 1: Scenario:  Point and Interval Estimate :

You are the manager of an outpatient surgery facility. You are trying to plan for the upcoming month and schedule the surgery rooms. In order for you to schedule patients, you need to know about how much time surgeries are taking at the clinic so you do not over schedule past your room capacity. Prepare a report to share with the physicians of the clinic that will help you make informed decisions about how much time you estimate each surgery will take based on the data provided to you in the excel sheet. Prepare a report that addresses each of these areas. Make sure to provide in your findings the mean, median, margin of error and 95% confidence intervals

Purpose (5 points): Identify the purpose of the analysis in this section. What questions do you hope to answer?

Importance (5 points): State and explain the importance of this analysis to the department/organization. How can the findings be used?

Variables (3 points): List all variables, explain how they will be measured, and how they will be collected.

Sample Size (2 points): State your sample size and when data was collected.

Methodology (5 points): State the statistical method used in this section.

Findings (5 points): Present findings on both point (mean, median) and interval (95% CI) estimates. Copy and paste relevant results from your excel calculations here. Provide the results, but also give a description as to what each of the statistics mean.

Interpretations/Implications ( 5 points): Interpret what the findings mean. Discuss what the department/organization should do based on these findings in order to improve the facility, or in planning.

Patient	Date	Surgery_Time
100	1/1/2018	30
101	1/2/2018	45
102	1/14/2018	96
103	1/4/2018	24
104	1/19/2018	23
105	1/6/2018	23
106	1/4/2018	12
107	1/8/2018	18
108	1/10/2018	19
109	1/10/2018	19
110	1/11/2018	21
111	1/1/2018	12
112	1/29/2018	43
113	1/14/2018	20
114	1/15/2018	12
115	1/22/2018	12
116	1/17/2018	64
117	1/18/2018	34
118	1/14/2018	20
119	1/20/2018	18
120	1/21/2018	25
121	1/12/2018	24
122	1/23/2018	42
123	1/12/2018	42
124	1/25/2018	14
125	1/26/2018	32
126	1/1/2018	12
127	1/15/2018	12
128	1/1/2018	32

Answer 1

Purpose

To find the descriptive statistics and 95% confidence interval for the mean surgery time for the patients in the surgery rooms.

Importance

By finding the descriptive statistics and confidence interval for the mean surgery time, we will get idea for scheduling the next surgeries and administration would take proper decision for increasing the surgery rooms for decreasing the average waiting time for the patients.

Variables

The variable under study for this scenario is given as surgery time for which we have to find the descriptive statistics and confidence interval for the population mean.

Sample Size

The sample size used for this research study is 29 patients.

Methodology

Here, we have to use both descriptive and inferential statistical techniques for finding the numerical summary and confidence interval for the population mean surgery time for the patients in the surgery rooms.

Findings

First of all, we have find the descriptive statistics for the variable surgery time. The descriptive statistics by using excel are given as below:

Surgery Time
Mean	27.58621
Standard Error	3.376067
Median	23
Mode	12
Standard Deviation	18.18068
Sample Variance	330.5369
Kurtosis	6.505206
Skewness	2.260696
Range	84
Minimum	12
Maximum	96
Sum	800
Count	29

Now, we have to find the 95% confidence interval by using excel which is given as below:

Confidence Interval Estimate for the Mean
Data
Sample Standard Deviation	18.18067506
Sample Mean	27.5862069
Sample Size	29
Confidence Level	95%
Intermediate Calculations
Standard Error of the Mean	3.376066604
Degrees of Freedom	28
t Value	2.0484
Interval Half Width	6.9156
Confidence Interval
Interval Lower Limit	20.67
Interval Upper Limit	34.50

Interpretations/Implications

From above excel outputs for descriptive statistics and confidence interval, interpretations for this research study are given as below:

The average mean surgery time is given as 27.59 minutes with the standard deviation of 18.18 minutes.

We are 95% confident that the average population surgery time will lies between the 20.67 minutes and 34.50 minutes.