You have disaggregated the length of stay values

You have disaggregated the length of stay values and separated them into their appropriate MS-DRG category (This is in the spreadsheet attached).But you still haven’t answered the question that prompted the initial analysis: is your facility’s ALOS for heart failure consistent with that of all Medicare heart failure patients? You want to complete the analysis by testing the hypothesis that your facility’s ALOS is greater than the Medicare benchmark. More formally, you have specified the following null and alternative hypotheses:Ho: OUR ALOS FOR DRG = BENCHMARK ALOS FOR DRGH1: OUR ALOS FOR DRG > BENCHMARK ALOS FOR DRGYou choose to use the ALOS figures found in the Federal Register for 2010 as your benchmark data (this is in the spreadsheet attached).You have some familiarity with the Excel software and you have read about finding probabilities using standardized scores. You decide to answer the probability question posed above using Excel’s z.test function (I think I have already done this correctly just need it checked).Run your calculations using the data specified above to determine if your facility’s ALOS for heart failure is consistent with that of all Medicare heart failure patients. Then, prepare a brief so that you can replicate your analysis at some future date. Your brief should be between 250 and 300 words in length and should include the following:1)Discuss whether, in future analyses, you will collect data from a sample of heart failure patients at your facility or look at all heart failure patients at your facility. Be sure to support this decision.2)Distinguish between the statistics and parameters that you are using (i.e., what are the statistics and what are the parameters?).3)Once you have estimated the probabilities for each MS-DRG, explain whether you believe your facility has ALOS that are within an acceptable range compared to the national averages.4)Paste a screenshot of your Excel calculations into the last page of your assignment submission.