14. Refer to the tab titled "Financial Data" for data required to solve this problem. This data represents financial d the column titled "Cause of Readmission" and the column titled "Length of Stay" to answer the following questions. 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 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. Use the following questions. s. he 4 causes for readmissions. (It is recommended that you use the data run the test appropriately. You can create a new tab with the data ordered sis ? Explain why. 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 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 GI bleed Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other Other 7 6 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 7,753.23 18,359.35 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 13,323.02 26,862.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 -4,127.58 -11,120.65 -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 Other Other Other Other 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 36 19 9 0 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 37,843.82 40,537.88 10,347.35 502.81 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 62,280.81 67,417.61 15,277.24 741.18 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 -19,537.49 -3,779.96 -3,464.14 -76.38 -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