Copy of HW 8

Insurance Type 1 Medicaid 2 Tricare 1 Medicare 1 Private 1 Tricare 2 Tricare 1 Medicaid 1 Medicare 1 Medicaid 1 Medicaid 1. Use excels pivot table function to create a table of 1 Medicaid 1 Private 2 Tricare 1 Medicaid Count - Length of Hospital Stay Length of Hospital 1 Medicare Insurance Type 1 1 Medicaid Medicaid 38 1 Tricare Medicare 41 2 Tricare Private 29 1 Medicaid Tricare 20 1 Medicare Total Result 128 2 Private 1 Medicare 2 Private 1 Medicare 1 Medicare 1 Private 1 Private 1 Private 1 Tricare 1 Medicaid 1 Tricare 1 Medicaid 2 Medicaid 1 Medicare 2. Calculate the EXPECTED values below: 1 Medicare 1 1 Private Medicaid 31.27 1 Tricare Medicare 31.27 1 Tricare Private 33.22 1 Private Tricare 32.24 1 Medicaid Length of Hospital Stay To the left is patient data that inclu 1-3 days, and > 3 days. There are fo administrators you are tasked with provided, use a chi-square test to d present them in your next team m

1 Medicare 1 Medicare 1 Private 3. Calculate your degrees of freedom: 1 Tricare 1 Tricare 4. What is the critical chi-square value for your test? 1 Medicaid 1 Medicare 5. What is your chi-square statistic? 1 Private 1 Tricare 6. What is the probability associated with your chi-sq 1 Tricare 1 Medicaid 7. State your null and alternative hypotheses: 1 Medicare 1 Tricare H0: There is no signific 2 Medicare 1 Medicaid H1: The distribution is 1 Private 2 Private 8. Highlight the outcome of your chi-square test: 1 Medicare 1 Medicaid ACCEPT 1 Private REJECT 2 Private 1 Private 9. Calculate the probability of different LOS given a p 1 Medicaid 1 Medicare 1 Medicare 1 Private 1 Private 1 Tricare 1 Tricare 1 Private 1 Medicaid 1 Medicare 10. State your findings: 1 Tricare 2 Medicaid 1 Medicaid 1 Medicare 1 Medicare 1 Private 1 Medicaid 1 Medicare 1 Private 1 Tricare The null hypothesis was rejected because the p value dependence between LOS and types of insurance.

1 Medicaid 2 Medicare 2 Medicare 1 Medicare 2 Medicare 1 Medicare 1 Medicaid 1 Private 1 Medicaid 1 Medicare 1 Tricare 1 Medicaid 1 Medicare 1 Medicare 1 Private 1 Medicaid 1 Medicare 2 Medicaid 1 Medicare 2 Medicare 1 Private 1 Medicaid 1 Medicare 1 Tricare 1 Medicare 1 Medicaid 1 Medicare 1 Medicare 1 Private 1 Medicaid 1 Medicare 1 Tricare 1 Private 1 Medicaid 1 Medicare 1 Private 1 Tricare 1 Medicare 1 Private 1 Private 1 Medicaid 1 Medicare

1 Medicare 1 Private 1 Medicaid 2 Tricare 1 Medicare 1 Tricare 1 Medicaid 1 Medicaid 1 Medicaid 2 Tricare 1 Medicaid 1 Medicaid 1 Medicaid 1 Medicaid 1 Medicare 2 Tricare 1 Medicare 1 Private 1 Private 2 Medicaid 1 Medicaid 2 Tricare 1 Medicare 1 Medicare 1 Private 2 Medicaid 2 Medicaid 2 Medicare 2 Medicare 2 Medicare 2 Tricare 2 Tricare 2 Tricare 2 Tricare 2 Tricare 2 Tricare 2 Tricare 2 Tricare 2 Private 2 Private 2 Private 2 Private

2 Tricare 2 Tricare 2 Tricare 2 Tricare 2 Tricare 2 Tricare 2 Medicare 2 Private 2 Private 2 Medicaid 2 Medicare 2 Medicare 2 Private 2 Private 2 Medicaid 2 Medicare 2 Medicare 2 Private 2 Private 2 Medicaid 2 Private 2 Private 2 Medicaid 2 Medicaid 3 Medicaid 3 Private 3 Medicaid 3 Medicare 3 Medicare 3 Private 3 Medicaid 3 Medicare 3 Tricare 3 Medicaid 3 Medicaid 3 Medicaid 3 Medicaid 3 Medicaid 3 Medicaid 3 Medicaid 3 Medicare 3 Medicare