Your CEO wants to review the benchmarking data used to compare Choice Hospital with other hospitals in the same geographic region. The Board of Directors is looking at expanding the Emergency Department or adding more in-patient beds. The CEO needs to know how Choice Hospital compares with other hospitals in the region to be part of the discussion and inform decisions on expansion in these areas. As you assume the role the HCA at Choice Hospital, provide the data and analysis requested by your CEO as described below. In this exercise, assume that Choice Hospital is located in Colorado, and use these data provided by the Colorado Hospital Association for Colorado hospitals. If you wish to find data for your own state of residence, you may do that and start your search at your state’s Department of Health Web site.For comparison of Choice Hospital to others in the state of Colorado of comparable size, you will use the specific data points requested, perform the calculations, and prepare the presentation of the data as follows:You will first review the data available and summarize the data points as specified for this presentation by placing them in an Excel spreadsheet. Calculate descriptive statistics for the data, as specified below. Prepare an Excel spreadsheet of the data. Review the data in the spreadsheet, and prepare a discussion of the data for Colorado hospitals compared to the data for Choice Hospital. The table below includes the data for Choice Hospital: Hospital Licensed Beds Total Discharges Total Patient Days Inpatient Surgeries Births Inpatient Admissions for Emergency Departments Emergency Department Visits Total Outpatient Visits Choice Hospital 300 15,279 70,283 4,012 256 4,781 13,342 98,993 From these data, calculate the average length of stay (ALOS) for Choice Hospital.Now look at the data for Colorado Hospitals at the link provided. Because Choice Hospital is a 300-bed facility, identify the hospitals that have between 200 and 400 licensed beds. Those are the hospitals that you will use for your comparison to Choice Hospital. In your Excel spreadsheet, do the following:List the hospitals that have 200–400 licensed beds in the first column, with 1 hospital listed per row. Next, for each of those hospitals, enter the data in separate columns for Total Patient Days and Total Discharges. In the next column, enter your calculation for ALOS using the data for Total Patient Days and Total Discharges. At the bottom of the column for ALOS, calculate the mean and standard deviation for the average length of stay for all of the hospitals. Enter the mean and standard deviation in the cells below in that column, and be sure to identify which value is the mean and which is the standard deviation. You will submit your Excel spreadsheet along with your 600-800 word summary.Now that you have the data on ALOS for your comparison hospitals, write 600-800 word summary, not including the title page or reference page, and discuss the following:Consider the average length of stay for Choice Hospital that you calculated using the data for Choice Hospital. How does that compare to the ALOS on average for the hospitals in Colorado with similar numbers of licensed beds from your calculation? Identify the range of ALOS for the hospitals, and consider the standard deviation value. Did you calculate the standard deviation of a sample or of the entire population? What is the difference? Explain why you chose the one that you did. Research the ALOS for the United States, and find a statistic that is within the last 5 years. The ALOS may be an overall average or based on the number of beds. State the ALOS for the United States that you found in your research, and be sure to cite the reference source. How does the ALOS for Choice Hospital compare to the national average?

please check the attached file. This evaluation will cover the lessons in this unit. It is open book, meaning you can use your textbook, syllabus, and other course materials. You will need to understand, analyze, and apply the information you have learned in order to answer the questions correctly. To submit the evaluation by mail, follow the directions on your Enrollment Information Sheet. To take the evaluation online, access the online version of your course; use the navigation panel to access the prep page for this evaluation and follow the directions provided. You may use your calculator on this unit evaluation...................................................................................

Please answer at least 5 out of 7 correctly on this multiple choice quizA common convention in social science is to set the alpha level at .05 and to reject the null hypothesis if the observed significance level is less than the alpha level, p < .05. Which of the following is correct?a.If p = .041, do not reject the null hypothesis b.If p = .074, reject the null hypothesis c.If p = .000, reject the null hypothesisd.If p = .952, reject the null hypothesis14.29 points QUESTION 2A Type I error is when you incorrectly reject the null hypothesis of no difference or no correlation in a population based on the results found in a sample. The alpha level controls the rate of Type I errors. If alpha is set at .05, which of the following is correct?a.The probability that there is no difference or no correlation in the population is 5%.b.The probability that there is a difference or correlation in the population is 5%. c.The probability of incorrectly rejecting the null hypothesis from the results of a sample, if the null hypothesis in the population is true, is 5%.d.The probability of correctly rejecting the null hypothesis from the results of a sample, if the null hypothesis in the population is true, is 5%.14.285 points QUESTION 3A confidence interval is a range of population values estimated from the results of a sample. From a random sample of 100 graduate students at Walden, suppose you calculate the average age to be 37 plus or minus 11, which would make the lower limit of the confidence interval 26 (i.e., 37 – 11 = 26) and the upper limit 48 (i.e., 37 + 11 = 48). If this was a 95% confidence interval, which of the following is correct?a.There is a 5% probability that the true average age of Walden graduate students is between 26 and 48b.95% of all Walden graduate students are between 26 and 48 years of agec.The true average age of Walden graduate students could be less than 26 or greater than 48d.A 99% confidence interval would be narrower, for example between 32 and 4214.285 points QUESTION 4A 95% confidence interval of -1.34 to 2.56 was estimated from the sample data on the mean difference between males and females on statistics anxiety. Which of the following is a true statement?a.The mean difference between males and females is statistically significantly different at the .05 alpha levelb.The mean difference between males and females is NOT statistically significantly different at the .05 alpha level  c.95% of all male and female scores on statistics anxiety were between -1.34 to 2.56d.The power of the study was 5%14.285 points QUESTION 5Incorrectly accepting the null hypothesis of no difference or no correlation in a population based on the results found in a sample is… a.a Type I errorb.a Type II errorc.a Type III errord.a Type IV error14.285 points QUESTION 6Scenario:A purposive sample of psychology graduate students finishing up their dissertation at one online university (n = 80), one public brick-and-mortar university (n = 35), and one private brick-and-mortar university (n = 20) rated overall satisfaction with their dissertation chair using a scale of 0 (completely dissatisfied) to 100 (completely satisfied). Each university had 100 students finishing up their dissertation.  The mean satisfaction ratings were: online = 87.5, public brick-and-mortar = 82.7, private brick-and-mortar = 90.3. The standard deviations were equal. Which of the following pairwise comparisons of mean ratings would have the largest effect size?a.Public versus privateb.Public versus onlinec.Online versus privated.The effect size of each pairwise comparison would be equal14.285 points QUESTION 7If an independent samples t test was conducted between any two of the three types of universities, which of the following would be most appropriate effect size?a.Multiple-R2b.Cohen’s wc.Cohen’s dd.Likelihood ratio