The work has not been graded but I like the output that was submitted to me. Is it possible for the same prof to do the next assignment I will be submitting? If possible, I will greatly appreciate it.
Would you be able to answer questions #1-4? Thanks
Assignment 3.2: Determining the Probability That a Statistic Comes from a Particular Distribution
After completing the assigned readings and watching the recommended videos, consider all that you have reviewed and think about the issues and analysis you completed in Assignment 3.1.
Words needed = 300
You have disaggregated the length of stay values and separated them into their appropriate MS-DRG category, 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:
Instead of the benchmark data used in Assignment 3.1 that are derived from state estimates using AHRQ H-CUP data, you choose to use the ALOS figures found in the Federal Register for 2014:
CMS Data
The CMS Data PDF contains each MS-DRG with charge and patient days (Average Patient Days = ALOS) for 2014. These figures are what CMS reported for 2014. Use the z-test function to test the hypothesis for each of the three MS-DRGs: 291, 292, 293.
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 given as:
=z.test(range:range,pdf ALOS), where range:range represents the cells where the facility data are located, and pdf ALOS is the national average against which to compare.
For a demonstration of how to use Excel’s z test function, view the video tutorial Calculating a z test in Excel (Transcript of Calculating a z test in Excel Tutorial)
The results of this test will tell you the probability that you will reject the null hypothesis when it is actually true (i.e., that you will say your ALOS is greater than the benchmark when in reality your ALOS is not statistically different than the benchmark). This is known as a “Type I” error, and you want the probability of making this type of error to be as small as possible. The conventional threshold (or comfort level) for making this type of mistake is five percent (i.e., you are willing to accept that in five samples out of 100 you will mistakenly reject the null hypothesis when it is true). Naturally, a probability that is smaller is preferred since the likelihood of having made a mistake is smaller. This is essentially what a “p-value” represents: the probability of making a Type I error (of rejecting the null hypothesis when it is true, or in practical terms, concluding that a difference exists when in reality none exists).
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, write a brief so that you can replicate your analysis at some future date. Your brief should include the following:
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more