Final Exam - HIMS 650 Winter 2016 Directions: Please answer all questions. There are 14 questions and the exam is worth 25% of your total grade. The questions are not equally weighted. The point value for each question is listed below (100 points total). Data needed to complete the exam are contained in this Excel file. All answers are to be contained in one excel file. You can save this file under your name and complete the work within this file. Please do not delete this tab, the instructions tab. This is an open book, open notes exam. The one limitation is that you may NOT work with other people. This test must be completed independently. Show your work to gain partial credit. Be sure your name is on your document. Good luck! Name: Problem # Point Value 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Sum 4 4 9 5 6 5 5 5 6 5 10 10 15 11 100 Your Points 0 The 10 questions on this page are multiple choice. Please enter your answers into column M in the shaded box. Q1. Which variable in the following list is a categorical variable? (Select the correct answer from the choices below.) Your Answer to Q1: A. height B. City C. time Q2. Which measure of central tendency can be used for both numerical and categorical variables? (Select the correct answer from the choices below.) Your Answer to Q2: A. Mode B. Geometric Mean C. Median D. Arithmetic Mean Q3: Match the appropriate inferential statistical test to the provided definitions. A. Chi-Square Test B. t-test C. ANOVA 1. Used to test independence for more than 2 means (i.e. compares the means of more than 2 groups) Letter: _______ Your Answer to Q3 #1: Your Answer to Q3 #2: Your Answer to Q3 #3: 2. Used to test the independence between 2 or more categorical variables Letter: _______ 3. Used to compare means of 2 groups Letter: _______ Q4: Statistical significance can be determined from descriptive statistical analysis alone? (Select the correct answer from the choices below.) Your Answer to Q4: A. True B. False Q5. Which of the words below are typically used to describe quantitative research methods? (Select all that apply.) Your Answer to Q5: A. Words B. Numbers C. Randomly selected samples D. Objective E. Subjective Q6. According to the empirical rule, if the data form a "bell-shaped curve" (normal distribution), what percent of the observations will be contained within + /- 3 standard deviations from the arithmetic mean. (Select the correct answer from the choices below.) Your Answer to Q6: A. 99.7 B. 95.0 C. 75.0 D. 68.26 Q7. You believe that there is a relationship between heart failure readmissions to the hospital and patients being educated on heart fialure symptoms. What would your null (H0) and alternative (H1) hypotheses be? (Select the correct answer from the choices below.) Your Answer to Q7: A. H0: Heart failure readmissions and patient education are independent. H1: Heart failure readmissions are dependent on patient education. B. H0: Heart failure readmissions are dependent on patient education. H1: Heart failure readmissions and patient education are independent. Q8. If you were to test the relationship between the 2 variables in Q7 (heart failure readmissions and patients being educated on symptoms), which inferential statistical test would you use (select the correct answer)? Note, heart failure readmission would be answered as yes or no. Patients being educated on symptoms would be answeres as yes or no. Your Answer to Q8: A. t-test B. Simple linear regression C. Chi-Square test Q9. Which of the following distributions are continuous probability distributions (select all that apply)? Your Answer to Q9: A. F Distribution B. Poisson Distribution C. Normal Distribution D. Binomial Distribution Q10. A confidence interval was used to estimate the proportion of statistics students that are females. A random sample of 72 statistics students generated the following 90% confidence interval: (0.438, 0.642). Based on the interval above, is the population proportion of females equal to 0.60? A) Yes, and we are 90% sure of it. B) No. The proportion is 54.17%. C) No, and we are 90% sure of it. D) Maybe. 0.60 is a believable value of the population proportion based on the information above. Your Answer to Q10: Q11. A random sample of 10 independent observations from a normally distributed population yielded the following value 49, 43, 47, 46, 45, 30, 60, 52. a) Using ?? = .05, test the hypothesis that the true mean is 50 against the alternative that the true mean is not 50. You will c confidence limits to solve this problem. Show your work. b) State the conclusion. n yielded the following values 51, 53, rue mean is not 50. You will calculate Q12. The age distribution of students at a community college is given below. A. Plot the frequency data . Make sure the graph includes a title. Label the x and y axis. B. Suppose a student is selected at random. Let A = the event the student's age is between 31 and 35. Find the probability of A. Age in Years Under 21 21 - 25 26 - 30 31 - 35 Over 35 Total Number of Students (f) 4946 4808 2673 29036 525 41988 a) Show your graph of the frequency distribution here per the instructions above. b) P (A) Q13. Refer to the tab titled "ED Satisfaction" for data required to solve this problem. You are looking at results of patien different hospitals in your healthcare system related to patient experience in the Emergency Department (ED). 100 pati took a survey related to their satisfaction after being treated in the ED. The survey results were calculated on a scale fro indicating complete satisfaction. Hospitals are titled Hospital A and Hospital B. You want to know if patient satisfaction in different based on the hospital. Answer questions 1 through 3 below. #1. What is your null hypothesis (H0) for this research topic? (Select either A or B from below.) A. There is no difference in patient satisfaction related to the ED experience in Hospital A or Hospital B. B. ED patient satisfaction is dependent on which hospital treatment was recieved from. #2. Calculate the average patient satisfaction score for each hospital. A. ______ Hospital A patient satistaction B. ______ Hospital B patient satisfaction #3. Perform the appropriate statistical test to test for significance between the the two groups. Note, you can use the toolpak" to get your result. Based on your results: A. What p-value did you find and is this significant? B. Would you accept or reject the null hypothesis? e looking at results of patient satisfaction from 2 y Department (ED). 100 patients from each hospital ere calculated on a scale from 0 to 10, with 10 know if patient satisfaction in the ED was the same or low.) r Hospital B. oups. Note, you can use the "data analysis Q14. Refer to the tab titled "Financial Data" for data required to solve this problem. This data represents financial d Use the column titled "Cause of Readmission" and the column titled "Length of Stay" to answer the following questio Answer questions 1 through 2 below. #1. What is an appropriate null hypothesis (H0) for this data analysis? A. There is a significant difference in length of stay for the 4 different causes of readmissions. B. There is no difference in length of stay for the 4 different causes of readmissions. #2. Perform a one-way ANOVA to test for significant difference in Length of Stay between the 4 causes for readmissio analysis toolpak addin to perform the test. You will need to rearange the data to be able to run the test appropriately ordered in the way that is required to run this test.) Based on the p-value from your ANOVA test, woul d you accept or reject your null hypothesis ? Explain why. data represents financial data associated with 4 different types of readmissions. nswer the following questions. s. the 4 causes for readmissions. (It is recommended that you use the data o run the test appropriately. You can create a new tab with the data esis ? Explain why. Hospital A Hospital B 8.1 6.8 0.1 7.8 2.3 4.6 1.4 9.1 2.4 6.6 4.8 1.0 8.5 7.7 3.7 4.6 7.8 0.9 8.3 1.1 4.0 3.2 8.8 0.2 8.0 1.7 3.2 8.9 4.5 2.8 8.8 7.9 1.5 9.2 7.2 3.9 7.5 3.2 3.8 1.8 3.6 4.8 7.2 7.1 4.3 2.8 4.6 7.2 8.0 9.9 6.1 6.8 8.3 3.0 0.9 9.9 3.8 6.1 9.3 3.4 7.2 5.3 6.9 9.0 2.5 5.5 3.9 8.6 4.5 3.0 5.2 0.2 0.7 2.6 8.0 7.0 5.9 1.1 8.8 6.3 3.7 4.3 9.0 8.2 7.4 8.3 7.6 1.7 2.2 4.1 9.2 9.9 7.4 6.6 8.2 6.6 7.5 9.2 2.8 5.8 4.1 8.2 6.1 1.4 4.2 9.8 5.3 3.2 3.6 8.0 5.2 5.1 9.6 9.9 5.8 6.7 0.6 9.3 1.6 0.2 4.5 0.7 3.5 7.4 9.3 1.9 8.1 9.2 8.9 2.6 7.1 8.1 0.9 1.0 9.3 7.2 7.5 5.6 8.4 9.4 1.1 0.6 9.8 2.0 7.7 0.7 0.7 8.3 2.7 7.1 8.5 6.5 5.5 3.9 2.8 2.5 9.3 5.3 7.9 10.0 7.7 9.7 7.6 5.2 7.3 6.2 6.0 2.8 3.5 2.7 3.5 6.6 9.7 6.1 8.5 2.1 7.9 8.8 1.2 8.9 7.7 6.5 8.9 6.8 9.0 7.0 9.4 9.0 7.7 2.7 5.9 8.5 6.6 4.0 8.1 5.6 4.3 9.6 6.7 7.5 Cost for Cost for Readmission Contribution Margin Readmission (Direct (Direct & Indirect (payments minus Direct Cause for Readmission Length of Stay Cost) Cost) Cost) Stroke 2 2,918.52 4,662.57 302.48 Stroke 4 6,126.04 10,283.49 7,659.49 Stroke 21 34,254.54 49,821.55 -34,254.54 Stroke 4 6,552.89 9,712.34 5,600.18 Stroke 6 7,527.53 13,344.35 2,582.65 Stroke 6 10,130.00 14,938.41 -4,333.01 Stroke 4 4,062.03 6,759.87 11,841.31 Stroke 3 9,810.99 16,237.06 6,092.35 Stroke 0 7,004.56 10,107.25 -3,816.56 Stroke 2 3,415.81 6,164.34 4,694.73 Stroke 4 5,714.02 8,542.52 8,012.06 Stroke 4 10,099.63 15,408.73 -1,509.29 Stroke 8 13,232.88 19,471.54 434.25 Stroke 13 24,369.46 36,267.13 -10,577.92 Stroke 1 2,541.71 4,011.66 6,038.03 Stroke 2 3,124.63 4,498.31 1,702.62 Stroke 9 18,791.70 27,502.88 -8,721.85 Stroke 10 14,250.70 24,682.84 12,575.80 GI bleed 6 13,644.71 19,962.66 3,710.95 GI bleed 7 10,641.59 17,457.52 17,331.56 GI bleed 6 19,804.83 32,001.11 12,920.91 GI bleed 12 19,963.48 32,880.62 6,702.69 GI bleed 64 129,991.43 193,072.59 109,846.26 GI bleed 6 12,268.38 20,159.23 -3,897.03 GI bleed 7 16,367.14 26,061.84 8,588.13 GI bleed 8 21,415.23 34,698.89 4,430.16 GI bleed 19 87,459.32 123,875.69 -87,459.32 GI bleed 7 5,195.98 9,438.76 -6.62 GI bleed 7 10,577.25 17,920.86 -4,310.07 GI bleed 1 4,461.89 7,489.02 -2,900.72 GI bleed 7 13,105.81 21,026.30 503.44 GI bleed 21 32,881.21 52,215.48 -10,518.27 GI bleed 5 11,913.88 17,580.10 1,504.32 GI bleed 3 7,219.69 11,569.92 2,439.11 GI bleed 125 380,925.88 611,084.63 66,334.11 GI bleed 5 7,812.40 11,141.75 5,854.60 GI bleed 4 11,157.51 16,504.90 -38.51 GI bleed 13 23,316.11 33,744.85 10,734.89 GI bleed 2 1,028.09 1,683.89 1,026.25 GI bleed 14 16,616.67 27,906.64 16,965.33 GI bleed 20 22,514.15 38,089.79 25,095.85 GI bleed 3 7,550.32 10,793.76 6,607.11 GI bleed 6 10,522.42 15,477.25 3,635.01 GI bleed 3 11,655.19 17,146.59 13,539.07 GI bleed 7 7,753.23 13,323.02 -4,127.58 GI bleed 6 18,359.35 26,862.81 -11,120.65 GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed GI bleed Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other 4 4 13 7 6 12 3 6 4 15 4 4 6 5 10 10 18 17 5 7 3 1 7 7 5 7 11 10 2 6 25 1 7 1 15 33 4 11 1 2 2 6 1 0 5 4 36 19 9 0 7,183.82 7,641.23 29,042.65 10,683.13 20,846.80 32,297.84 6,478.88 9,014.08 7,790.32 21,518.37 5,727.10 8,336.49 13,228.18 14,288.42 16,953.57 19,820.92 29,905.40 65,136.85 12,756.26 15,392.46 4,819.55 4,904.67 13,036.49 8,101.95 8,154.63 18,654.11 26,185.48 43,017.45 8,450.48 11,971.95 38,717.19 878.17 50,819.52 1,704.41 14,627.96 41,395.92 3,292.14 10,892.48 2,403.59 2,706.58 2,124.40 7,447.04 1,009.94 1,345.97 7,251.14 9,701.59 37,843.82 40,537.88 10,347.35 502.81 10,081.45 12,393.07 41,740.96 16,645.19 33,526.36 48,622.88 9,369.63 13,081.15 10,894.00 31,594.07 8,659.04 12,372.10 19,526.87 23,899.36 26,700.66 30,975.46 47,439.19 99,204.41 20,926.11 22,183.58 7,122.36 7,205.43 19,207.08 14,204.40 12,242.43 26,403.31 37,791.74 63,146.31 12,147.31 17,924.75 65,784.58 1,324.07 70,275.06 2,548.50 25,215.99 68,132.25 5,442.01 17,865.45 3,630.46 4,017.51 3,148.89 11,025.15 1,627.64 2,320.24 10,580.84 14,144.58 62,280.81 67,417.61 15,277.24 741.18 -1,344.29 4,799.39 -21,627.09 -3,733.57 -13,560.15 -10,229.69 1,063.85 -1,622.20 -2,666.93 -10,430.36 1,904.49 -944.61 -5,596.59 -7,338.86 -9,666.92 -12,534.27 -8,969.44 -33,408.50 -5,651.15 -6,419.09 2,470.62 2,607.40 -5,715.76 -3,937.79 -1,204.35 -1,487.16 15,709.95 -40,499.05 54,390.27 18,467.01 36,504.06 10,004.39 233,448.90 1,751.13 -2,120.03 -41,395.92 2,079.62 1,391.16 564.33 6,676.69 5,950.46 -2,273.50 904.76 936.83 2,369.64 -574.42 -19,537.49 -3,779.96 -3,464.14 -76.38 Other Other Other Other Other Other Other Other Other Other Other Other Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire Vtach &/or AICD fire 69 3 8 7 38 1 3 4 1 4 2 10 5 34 19 49 2 1 0 11 6 1 6 7 4 2 1 128 553,201.72 4,522.75 11,245.61 12,664.94 127,857.56 2,471.98 25,101.78 4,987.47 1,792.17 5,566.23 3,810.49 11,077.33 8,671.91 39,313.13 25,446.41 327,441.59 2,249.49 2,755.24 826.74 30,122.53 10,842.52 1,487.62 19,169.92 5,462.37 4,256.29 1,454.75 4,834.22 389,334.55 777,109.97 6,531.25 16,724.82 17,829.47 213,022.78 3,752.89 32,932.28 8,101.97 2,756.24 9,171.45 6,450.39 18,923.88 13,962.84 65,005.33 43,301.83 499,434.53 4,108.83 4,091.08 1,388.61 46,206.47 16,233.59 2,184.46 27,085.14 9,825.48 6,303.56 2,140.38 7,740.82 600,278.05 -89,298.98 2,774.44 -4,271.35 6,020.54 23,823.15 422.95 -15,933.98 2,289.03 -37.36 1,104.52 6,280.71 7,549.25 9,345.18 36,659.28 -6,082.33 18,358.68 2,593.51 2,742.04 617.31 -450.11 -3,916.62 4,519.55 -4,839.66 320.62 1,322.70 -13.82 9,552.99 23,539.80 Net Income (payments minus all costs) -1,441.57 3,502.04 -49,821.55 2,440.73 -3,234.17 -9,141.42 9,143.47 -333.72 -6,919.25 1,946.20 5,183.56 -6,818.39 -5,804.41 -22,475.59 4,568.08 328.94 -17,433.03 2,143.66 -2,607.00 10,515.63 724.63 -6,214.45 46,765.10 -11,787.88 -1,106.57 -8,853.50 -123,875.69 -4,249.40 -11,653.68 -5,927.85 -7,417.05 -29,852.54 -4,161.90 -1,911.12 -163,824.64 2,525.25 -5,385.90 306.15 370.45 5,675.36 9,520.21 3,363.67 -1,319.82 8,047.67 -9,697.37 -19,624.11 -4,241.92 47.55 -34,325.40 -9,695.63 -26,239.71 -26,554.73 -1,826.90 -5,689.27 -5,770.61 -20,506.06 -1,027.45 -4,980.22 -11,895.28 -16,949.80 -19,414.01 -23,688.81 -26,503.23 -67,476.06 -13,821.00 -13,210.21 167.81 306.64 -11,886.35 -10,040.24 -5,292.15 -9,236.36 4,103.69 -60,627.91 50,693.44 12,514.21 9,436.67 9,558.49 213,993.36 907.04 -12,708.06 -68,132.25 -70.25 -5,581.81 -662.54 5,365.76 4,925.97 -5,851.61 287.06 -37.44 -960.06 -5,017.41 -43,974.48 -30,659.69 -8,394.03 -314.75 -313,207.23 765.94 -9,750.56 856.01 -61,342.07 -857.96 -23,764.48 -825.47 -1,001.43 -2,500.70 3,640.81 -297.30 4,054.25 10,967.08 -23,937.75 -153,634.26 734.17 1,406.20 55.44 -16,534.05 -9,307.69 3,822.71 -12,754.88 -4,042.49 -724.57 -699.45 6,646.39 -187,403.70