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 moeth and schedule the surgery rooms. In order for you to schedule patients, you need to know about how much time surgeries are takng at the clinic so you do not over shedaule past your room capacity Prepare a report to shace with the physicians of the clinic that will help you make informed decisions about how much time you estumate 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 ponde 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? lmportance (5 points) State and explam 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 (Q2 points) State your sample size and when data was collectesd Methodology (5 points) State the statistical method used in thus section Findings (5 ponts) Present findings on both poin (mtan, median) and rterval (95% CD est n res Copy and paste relevant results on your excel calculation, bere Provide the results, but also give a description as to what each of the Matistis e Iaterpretations/Implicatious (5 pounts) Interpret whar the findangs mean Dacus what he deparct organuzation should do based on these findings in onder to improve the facility, or in plarning

Answer 1

Let us first of all try to understand as to what is required. From the question it is clear that we need to schedule hospital operating rooms given its constraints Now we have not been provided with any data. But based on the normal understanding, we can say that the scheduling of surgery rooms will depend on following factors amongst many more 1. cost of operation 2. number of emergency cases that come on the given day 3. pumber of surgery/operating room available for work at the start of the day. the output profit generated per day from the surgeries Now, as a planner /scheduler has taken the above three factors and collected the data for 100 days as follows.

Number ofNumber of s) emergency perating available Profit S.no. 000 cost('000- 2 5 3 2 6 8

20033-310-231 2212-311022323 4-5 44 2 50 60 7 3 24 2 4 5 3 4 6 7 8 9 40 32465244 32445545 67737220935892 44 5 6 44 6 3 3 3 7 4 3 60 5 3 5 87125469 224256653252 67890123 22223333333333 40 41 42 45 44

40662447|1|7450407|2|5406451|2|3|7-3. 1329838817 16449 3 5235433234 901234567890

81 82 崧수 24 54 52 42 59 2 46 85 86 87 35 10 46 31 41 91 92 45 58 94 20 50 30 64 95 97 65 54 18 32 98 46 41 20 100 Mean Median Mode sample size 38.6439.92 3.3 1.51 39.5 1..'i 100 Standard deviation 17.1912.27 100 100 1.06 100

Now this will act as the dataset for my analysis and eventual report. The mean. .median .mode ,sample size and the standard deviation is calculated and attached. I took the data and did regression analysis to understand the relationship between the various Thus we can see that the three variables are related to the overall operating profit as variable

ression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.101226 0.010247 0.02068 17.36892 100 ANOVA MS nificance F Regressiorn Residual 3 299.8319 99.94398 0.331292 0.80273 96 28961.21 301.6793 99 29261.04 otal tandard Err Intercept cost('000-$) Number of emergency cases Number of operating rooms available 38.48 6.84 -0.06 0.66 0.27 0.14 0.74 1.67 t stat 5.63 0.43 0.89 0.16 P-value 0.00 0.67 0.37 0.87 Lower 95%U 24.91 -0.35 0.81 3.05 per 95%ower 95.0% 52.05 0.22 2.14 3.58 24.91 -0.35 0.81 3.05 r 95. 52.05 0.22 2.14 3.58 Regression equation is Profit 38.48-0.06 Cost+0.66(emergency cases)+0.27 (operating room avaialable)

Profit-38.48-0.06*Cost+0.66(emergency cases)+0.27*(operating room available) But from the F statistic value significance (0.80),is much more than 0.05 which is the 95% confidence level critical limit, we can infer that the regression equation is not overall significant.