Please help with the questions below. Attached is the excel worksheet of data that needs to be analyzed. There were several hospitals to choose from to analyze data from. I chose California Pacific Medical Center Davies Campus Hospital in California. I then calculated the Covered charges 25% taking the original number of covered charges and multiplying it by .25 as shown in the screenshot. Thank you for your help and guidance.

1. What is a question that comes to mind that you would ask about the data? Why is this interesting to you from your analysis?

2. Show visualizations that you have prepared that focus on interesting aspects from your analysis. (Question: In excel, which data should I collect to make a graph/table for a visualization? I am confused)

3. Present at least one action that your analysis would point to that should be taken in response to what was found in your data

F H 1 J K L N o DRG Definition Provider Name Provider Total Medicare Covered Hospital Referral Region Total Discharges Covered Charges (HRR) Description State Payments Payments Charges 6 -T - 25% CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 28 $53,259.89 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 19 1271 023 - CRANIOTOMY W MAJOR DEVICE IMPLANT OR ACUTE CNS PDX W MCC OR CHEMOTHE 1672 025 - CRANIOTOMY & ENDOVASCULAR INTRACRANIAL PROCEDURES W MCC 2461 027 - CRANIOTOMY & ENDOVASCULAR INTRACRANIAL PROCEDURES W/O CC/MCC 5319 057 - DEGENERATIVE NERVOUS SYSTEM DISORDERS W/O MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 15 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 14 6647 064 - INTRACRANIAL HEMORRHAGE OR CEREBRAL INFARCTION W MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 85 8332 065 - INTRACRANIAL HEMORRHAGE OR CEREBRAL INFARCTION W CC OR TPAIN 24 HRS CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 63 10377 066 - INTRACRANIAL HEMORRHAGE OR CEREBRAL INFARCTION W/O CC/MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 16 11632 069 - TRANSIENT ISCHEMIA CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 13 31949 190 - CHRONIC OBSTRUCTIVE PULMONARY DISEASE W MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 13 38180 193 - SIMPLE PNEUMONIA & PLEURISY W MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 11 40609 194 - SIMPLE PNEUMONIA & PLEURISY W CC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA CA - San Francisco CA-San Francisco ICA-San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA-San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA-San Francisco CA-San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA-San Francisco 11 $271,896.04 $251,213.84 $156,349.13 $53,803.79 $ 122,245.56 $72,562.14 $51,845.06 $41,559.69 $71,194.00 $64,506.64 $48,877.91 $50,389.17 $48,688.73 $156,014.93 $28,424.68 $47,810.17 $45,767.07 $44,332.44 $198,613.73 $ 106,048.38 $47,614.33 $45,412.32 $23,345.33 $17,428.36 $18,918.81 $10,741.49 $7,246.81 $7,270.23 $12,722.85 $11,999.00 $8,794.91 $14,040.39 $9,231.82 $36,075.86 $8,019.23 $10,814.00 $8,863.20 $7,608.78 $49,775.91 $18,087.87 $9,629.73 $45,572.14 $67,974.01 $44,599.26 $62,803.46 $22,378.00 $39,087.28 $8,242.29 $13,450.95 $17,115.28 $30,561.39 $9,668.17 $18,140.54 $6,002.63 $12,961.27 $6,152.92 $10,389.92 $9,535.54 $17,798.50 $10,912.73 $16,126.66 $7,600.73 $12,219.48 $13,004.39 $12,597.29 $8,260.91 $12,172.18 $35,039.14 $39,003.73 $6,874.55 $7,106.17 $9,929.42 $11,952.54 $7,980.80 $11,441.77 $6,358.61 $11,083.11 $47,825.91 $49,653.43 $16,214.72 $26,512.09 $8,564.87 $11,903.58 71713 291 - HEART FAILURE & SHOCK W MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 18 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 11 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 14 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 22 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 12 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 15 102153378-G.I. HEMORRHAGE W CC 122721 460 -SPINAL FUSION EXCEPT CERVICAL W/O MCC W/ 145058 603-CELLULITIS W/O MCC 152117 640 - MISC DISORDERS OF NUTRITION, METABOLISM, FLUIDS/ELECTROLYTES W MCC 160421 683 - RENAL FAILURE W CC 165522 690 - KIDNEY & URINARY TRACT INFECTIONS W/O MCC & 176933853 - INFECTIOUS & PARASITIC DISEASES W O.R. PROCEDURE W MCC 181826 871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV >96 HOURS W MCC 184639 872 - SEPTICEMIA OR SEVERE SEPSIS W/O MV >96 HOURS W/O MCC 196332 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 18 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 11 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 53 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 15 196333 F H 1 J K L N o DRG Definition Provider Name Provider Total Medicare Covered Hospital Referral Region Total Discharges Covered Charges (HRR) Description State Payments Payments Charges 6 -T - 25% CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 28 $53,259.89 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 19 1271 023 - CRANIOTOMY W MAJOR DEVICE IMPLANT OR ACUTE CNS PDX W MCC OR CHEMOTHE 1672 025 - CRANIOTOMY & ENDOVASCULAR INTRACRANIAL PROCEDURES W MCC 2461 027 - CRANIOTOMY & ENDOVASCULAR INTRACRANIAL PROCEDURES W/O CC/MCC 5319 057 - DEGENERATIVE NERVOUS SYSTEM DISORDERS W/O MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 15 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 14 6647 064 - INTRACRANIAL HEMORRHAGE OR CEREBRAL INFARCTION W MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 85 8332 065 - INTRACRANIAL HEMORRHAGE OR CEREBRAL INFARCTION W CC OR TPAIN 24 HRS CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 63 10377 066 - INTRACRANIAL HEMORRHAGE OR CEREBRAL INFARCTION W/O CC/MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 16 11632 069 - TRANSIENT ISCHEMIA CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 13 31949 190 - CHRONIC OBSTRUCTIVE PULMONARY DISEASE W MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 13 38180 193 - SIMPLE PNEUMONIA & PLEURISY W MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 11 40609 194 - SIMPLE PNEUMONIA & PLEURISY W CC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA CA - San Francisco CA-San Francisco ICA-San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA-San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA-San Francisco CA-San Francisco CA - San Francisco CA - San Francisco CA - San Francisco CA-San Francisco 11 $271,896.04 $251,213.84 $156,349.13 $53,803.79 $ 122,245.56 $72,562.14 $51,845.06 $41,559.69 $71,194.00 $64,506.64 $48,877.91 $50,389.17 $48,688.73 $156,014.93 $28,424.68 $47,810.17 $45,767.07 $44,332.44 $198,613.73 $ 106,048.38 $47,614.33 $45,412.32 $23,345.33 $17,428.36 $18,918.81 $10,741.49 $7,246.81 $7,270.23 $12,722.85 $11,999.00 $8,794.91 $14,040.39 $9,231.82 $36,075.86 $8,019.23 $10,814.00 $8,863.20 $7,608.78 $49,775.91 $18,087.87 $9,629.73 $45,572.14 $67,974.01 $44,599.26 $62,803.46 $22,378.00 $39,087.28 $8,242.29 $13,450.95 $17,115.28 $30,561.39 $9,668.17 $18,140.54 $6,002.63 $12,961.27 $6,152.92 $10,389.92 $9,535.54 $17,798.50 $10,912.73 $16,126.66 $7,600.73 $12,219.48 $13,004.39 $12,597.29 $8,260.91 $12,172.18 $35,039.14 $39,003.73 $6,874.55 $7,106.17 $9,929.42 $11,952.54 $7,980.80 $11,441.77 $6,358.61 $11,083.11 $47,825.91 $49,653.43 $16,214.72 $26,512.09 $8,564.87 $11,903.58 71713 291 - HEART FAILURE & SHOCK W MCC CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 18 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 11 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 14 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 22 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 12 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 15 102153378-G.I. HEMORRHAGE W CC 122721 460 -SPINAL FUSION EXCEPT CERVICAL W/O MCC W/ 145058 603-CELLULITIS W/O MCC 152117 640 - MISC DISORDERS OF NUTRITION, METABOLISM, FLUIDS/ELECTROLYTES W MCC 160421 683 - RENAL FAILURE W CC 165522 690 - KIDNEY & URINARY TRACT INFECTIONS W/O MCC & 176933853 - INFECTIOUS & PARASITIC DISEASES W O.R. PROCEDURE W MCC 181826 871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV >96 HOURS W MCC 184639 872 - SEPTICEMIA OR SEVERE SEPSIS W/O MV >96 HOURS W/O MCC 196332 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 18 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 11 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 53 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP CA 15 196333