Using Patient's data in Excel Template file develop a graphical presentation that focuses on the insurance carried by the geriatric patients at the hospital. The data file Patients contains data for a sample of geriatric patients. In developing your presentation, please do the following:

1. Construct a pie chart that shows the percentage of patients with each health insurance payer.
2. Develop a bar chart that shows total charges for patients by insurance payer.

Please answer both the questions in excel and show step-by-step instructions on how to make the pie and bar chart.

1 Leave Status Length of Stay ICU Days Age (Years) Sex (M/F/U) Principal Payer Total Chges Drug Charges Lab Charges Imaging Charges RT Chge 2 LIVE 3 0 78 F CARE 5418.85 68.7 273.5 832 660.85 3 LIVE 3 74 F CARE 4575.1 58.65 439.5 725 276.5 4 4 LIVE 11 89 M CARE 12031.18 230.28 816.5 187 1312.3 5 LIVE 3 0 81 M M CARE 3617.84 142.89 387 93.5 231.95 6 LIVE 9 0 87 F CARE 12806.88 889.23 795.5 827.5 1526.35 7 LIVE 3 0 65 CARE 5295.55 102.5 837 959.5 177.45 8 LIVE 3 o 90 M CARE 3453.21 122.15 323 103 23.45 9 LIVE 3 0 61 M BC 1760.03 161.18 35 $- 303.85 10 LIVE 3 0 90 F CARE 3290.4 235.65 243 117.5 446.55 11 LIVE 5 0 0 78 M CARE 6253.65 103.05 487.5 941 $- 12 LIVE 3 0 78 F CARE 3896.16 229.06 222 93.5 477.05 13 LIVE 2 0 71 M CARE 1795.35 52.05 58 216 39.3 14 LIVE 3 0 76 M CARE 9265.17 211.37 1626.5 1255 827.65 15 DIE 3 0 76 F CARE 3282.9 298.4 381.5 214 476.75 16 DIE 5 0 79 F CARE 9565.83 477.03 974 214 2017.8 17 LIVE 3 0 72 M CARE 3782.15 166.85 345 93.5 253.6 18 LIVE 4 1 72 M CARE 6384.28 342.98 644.85 307.5 605.3 19 LIVE 3 0 64 M CARE 4904.25 208.65 768 832 369.6 20 LIVE 2 72 F CARE 4169.92 545.15 375.5 557 803.77 21 LIVE 3 69 F CARE 5204.41 510.01 870.5 158 599.05 22 LIVE 4 63 M 6740 480.2 1091.5 925.5 734.4 23 DIE 1 78 M CARE 5016.44 401.44 630 158 246.75 24 LIVE 2 83 M CARE 4178.94 604.49 433.5 1188.5 217.05 25 LIVE 3 62 F OTHR 4105.26 90.46 222 725 $- 26 LIVE 4 71 M CARE 4717.3 120.9 496 631.5 $- 27 LIVE 6 0 83 F CARE 6598.92 380.17 386 832 226.15 28 LIVE 2 0 63 F OTHR 1633.85 20.85 207 93.5 88.3 29 LIVE 1 0 83 M CARE 2200.85 21 176 117.5 202.75 30 LIVE 4 0 76 F CARE 7461.54 508.34 1082.5 1071.5 340.65 31 LIVE 5 0 79 M CARE 11413.23 1149.88 1335.5 267 1442.15 32 LIVE 3 0 65 M M CARE 5607.55 230.5 969.35 738.5 289.15 33 LIVE 2 79 M CARE 4850.62 172.52 867 845.5 206.05 34 LIVE 4 74 M CARE 7102.49 259.09 881 780 773.85 35 LIVE 15 63 M OGVT 13615.69 438.84 1930 912 1911.7 36 LIVE 3 0 84 M M CARE 5069.18 282.9 476.5 832 345.8 37 LIVE 6 0 90 F CARE 6536.07 122.85 651 947.5 458.05 38 LIVE 4 0 0 73 F CARE 7401.25 216.9 971.5 845.5 562.1 39 LIVE 2 0 81 M CARE 3744.34 176.24 394 1291.5 80 40 LIVE 5 0 CARE 8653.68 246.63 859 767 942.1 HMO oood 75 F 0 0 9 3 3 5 5 0 0 0 0 0 7 4 6 2 3 0 0 0 6 8 0 0 4 0 0 0 41 LIVE 42 LIVE 43 LIVE 44 LIVE 45 LIVE 46 LIVE 47 LIVE 48 LIVE 49 DIE 50 LIVE 51 LIVE 52 LIVE 53 DIE 54 LIVE 55 DIE 56 LIVE 57 LIVE 58 LIVE 59 LIVE 60 LIVE 61 LIVE 62 LIVE 63 LIVE 64 LIVE 65 LIVE 66 LIVE 67 LIVE 68 LIVE 69 LIVE 70 LIVE 71 LIVE 72 LIVE 73 LIVE 74 LIVE 75 LIVE 76 LIVE 77 LIVE 78 LIVE 79 LIVE 80 LIVE 5 8 7 8 3 12 2 5 5 0 0 0 0 0 87 F 70 M 73 F 77 M 71 M 76 M 49 F 78 F 86 M 67 M 69 M 73 F 88 F 67 M 69 M M 77 M 64 F 76 M 64 F 41 M 49 M 59 M 81 M 74 F 77 F 78 F 73 F 67 M 80 M 77 F 73 F 67 M 86 M 82 F 84 F 73 F 82 M 62 F 84 M 89 F CARE CARE CARE CARE CARE CARE CAID CARE CARE CARE CARE CARE CARE INS CARE CARE CAID CARE CAID SELF CAID BC CARE CARE CARE CARE CARE INS CARE CARE CARE CARE CARE CARE CARE BC CARE CARE CARE CARE 14423.21 3742.3 5514.09 7390.15 9358.2 14570.29 4526.43 6846.77 2927.62 4404.13 8056.36 10703.34 16458.95 4770.1 15282.57 10105.3 7871.29 3411.1 10962.17 7374.27 7788.51 8191.1 11117.35 5624.54 4574.92 3644.36 2937.92 3944.78 6366.1 4992.01 6929.35 5595.42 3466.7 7289.77 6375.95 3585.62 5970.45 10578.14 2223.6 2250.5 527.63 112.95 368.34 331.25 491.35 286.74 203.98 162.57 145.42 161.78 331.66 618.64 813.55 236.3 1704.77 597.3 606.64 124.7 712.67 361.47 478.85 661.65 142.35 149.69 159.82 126.46 50.67 602.98 169.15 148.66 679.25 582.56 78.15 162.77 275.3 276.29 156.45 696.94 36.25 182.7 2138 396.5 874.5 696 1223.5 1090 378.5 657.5 606.5 630 642 1297.5 1050.5 747 1860 1251 550 356.5 697 600.5 $ 610 800 318 542 186.5 $- 220.5 S- 268 462 1130 569.5 1286.5 714 408.5 821.5 1692.5 578 711.5 1329.35 229 205.5 925.5 1069 93.5 340.65 200.5 371.55 825 661.9 1230.8 736.95 939 921.8 725 608.95 93.5 181 107 543.1 93.5 491.1 767 367.15 692.5 958.3 971.5 2114.6 93.5 $- 1153 2221.3 1304.5 877 200.5 725.05 187 93.15 321 1144.35 554 736.5 500.85 117.5 445.3 736.5 50.85 1348.5 326.4 612.5 30.9 673.5 134.65 93.5 $- 971.5 $- 818.5 272.25 1135.5 766.7 980 848.75 187 338.25 818.5 825.85 93.5 755.65 951.5 40 738.5 1084.85 783.65 2058.75 725 253.1 117.5 226.85 0 3 2 0 1 0 4 3 2 6 3 3 0 4 5 3 7 7 3 4 o o o o o 8 2 0 0 0 0 3 1 4 3 6 5 0 0 0 0 0 0 0 0 0 5 7 1 2 4 0 11 3 2 1 4 6 0 2 0 0 0 0 0 0 81 LIVE 82 LIVE 83 LIVE 84 LIVE 85 LIVE 86 LIVE 87 LIVE 88 LIVE 89 LIVE 90 LIVE 91 LIVE 92 LIVE 93 LIVE 94 LIVE 95 LIVE 96 LIVE 97 LIVE 98 LIVE 99 LIVE 100 LIVE 101 LIVE 102 LIVE 103 LIVE 104 LIVE 105 LIVE 106 LIVE 107 LIVE 108 LIVE 109 DIE 110 LIVE 111 LIVE 112 LIVE 113 LIVE 114 LIVE 115 LIVE 116 LIVE 117 LIVE 118 LIVE 119 LIVE 120 LIVE 8 4 2 3 7 7 4 0 0 84 M 81 F 81 F 78 M 84 F 37 M 62 M 80 F 80 F 73 M 80 F 80 F 80 F 81 F 39 M 86 M 79 M 87 M 53 F 83 F 80 F 79 F 72 F 77 F 81 F 67 F 80 M 67 F 88 M 88 F 92 F 85 F 85 M 80 M 98 F 74 F 77 M 53 F 93 M 83 F CARE CARE CARE CARE CARE BC BC CARE CARE CARE CARE CARE CARE CARE CAID CARE CARE CARE CARE CARE CARE CARE CARE CARE CARE OTHR CARE OTHR CARE CARE CARE CARE CARE CARE CARE CARE CARE CARE CARE CARE 142 114 114 707 981.35 1791.5 971.8 440.5 276.5 540.5 2302 1393.5 707 414.5 971.5 700.5 2372 966 320 312.5 1504 1011.4 1062 1215.5 893.5 862.5 1644.55 2491.45 1691.5 7931.92 5121.97 6940.75 12088.08 2325.6 4452.78 6157.43 21474.9 8566.51 4910.27 3275.03 12080.81 7436.85 15624.2 4590.48 3232.63 3768.11 9862.26 10626.42 6967.99 5891.25 4756.91 8096.93 4620.59 5796.49 1483.39 2510.05 10185.83 3391.9 8418.13 4346.47 2043.85 2594.85 5499.36 11244.45 6565.55 6031.15 19.4 84.45 10.45 746.06 479.99 768.55 592.43 101.5 160.38 193.61 1420.14 446.11 307.97 152.28 708.4 242.7 462.4 414.4 200.9 216.01 432.36 449.47 176.89 260.65 104.66 473.98 178.59 472.74 30.34 82.45 403.13 49.6 281.48 108.11 49.2 131.6 153.91 500.3 710 294.6 107 137 93.5 381.7 64.5 12.95 200.5 2030.6 930 314.9 825 922.1 1566 2170.6 107 69.05 107 720 725 1140.57 2128 2765.6 214 1505.55 107 820.7 107 573.05 1374 881.1 1183 834.65 2965.65 2097.17 187 667.65 93.5 425.8 196.5 917.75 321 1555.25 107 2113.85 1658.2 221.6 107 465.5 725 87.1 818.5 1708.65 296 307.9 93.5 1399.3 214 136.3 188.5 148.65 832 1920.75 725 44.45 93.5 75.2 725 266.05 186.5 268.55 155.5 $- 660 528.2 738.5 1154.8 117.5 793.1 351.25 684.15 0 0 0 3 0 0 3 9 4 0 535 6 1 1 6 3 5 3 1007 172 485 1054.5 588.5 758 411 214 496 289.5 657 725 1313 2 3 5 9 0 0 7 4 0 0 0 0 7 3 3 16 3 o a 468.01 234.85 183.45 2768.32 290.77 109.59 141.78 175.18 $- 4 1 80 M 79 M 87 F 59 M 81 F 94 F 33 F 78 F 29 F 80 F 63 F 86 M 96 M $ 121 LIVE 122 LIVE 123 LIVE 124 LIVE 125 LIVE 126 LIVE 127 LIVE 128 DIE 129 LIVE 130 LIVE 131 LIVE 132 LIVE 133 LIVE 134 LIVE 135 LIVE 136 LIVE 137 LIVE 138 LIVE 139 DIE 2 2 2 o a CARE CARE CARE CARE CARE CARE CAID CARE CARE CARE INS CARE CARE CARE CARE CAID 4912.76 6182.45 4218.95 40231.27 3608.95 3041.44 1581.93 1468.48 2294.55 $- 7138.72 3845.96 5355.23 4573.05 5023.11 4238.3 6885.73 5447.63 6257.66 4601 333.5 843.5 309.5 4618 457.5 484 $- 539.5 $- 209 1317.5 443 890.9 1310 1039.5 654.75 838.5 660 761.85 1008 3 187 930.65 832 304.3 99 $- 1609 8792.5 941 225.9 569 107 230.75 237.65 187 688.75 300.5 261.45 93.5 245.15 951 361.65 296 25.75 187 683.45 725 290.45 738.5 792.8 1113 351.5 708.9 214 486.45 4 4 5 402.98 182.31 376.34 563.4 272.51 112.15 351.58 224.98 349.81 655.64 89 M 5 5 80 M 55 F 73 M CARE 912 5 7 2 67 F CARE CARE 75 M