1. Do the frequency distribution by using Pivot Table.

2. Sort the data in the pivot table by the frequency of each DRG Categ and do a column chart.

3. Generate a cumulative distribution for the DRG Categ data from 1 and do a chart with both frequencies and cumulative frequencies using different charts (column for frequencies and line for cumulative frequencies)

4. Generate a cross-tabulation using the Pivot Table capability with Sex as the column heading and DRG Categ as the row heading, also create a chart for this on the spreadsheet.

PLEASE RESPOND USING EXCEL FORMULAS IN EXCEL FORMAT

H M ID ID No 00 Sex 1 F 2 F 3 F 4 M 5 F 6 F 7 F 8 M 9M 10 F 11 F 12 M 13 M 14 F 15 M 16 F 17 F 18 F 19 F 20 F 21 F 22 F 23 M 24 F 25 F 26 F 27 F 28 F 29 F 30 M 31 M 32 F 33 F 34 M 35 M 36 M 37 F 38 M 39 F 40 F DRG DRG Categ- 294 Endrocine and Nutritional 139 Heart and Circulatory 34 Nervous System 140 Heart and Circulatory 141 Heart and Circulatory 15 Nervous System 294 Endrocine and Nutritional 241 Musculoskeletal and Connective 335 Male Reproductive 148 Digestive Tract 89 Respiratory 127 Heart and Circulatory 89 Respiratory 122 Heart and Circulatory 336 Male Reproductive 321 Kidney and Urinary 174 Digestive Tract 143 Heart and Circulatory 358 Female Reproductive 140 Heart and Circulatory 143 Heart and Circulatory 159 Digestive Tract 89 Respiratory 294 Endrocine and Nutritional 473 Rehab and Aftercare 128 Heart and Circulatory 15 Nervous System 121 Heart and Circulatory 128 Heart and Circulatory 140 Heart and Circulatory 209 Musculoskeletal and Connective 143 Heart and Circulatory 209 Musculoskeletal and Connective 96 Respiratory 144 Heart and Circulatory 90 Respiratory 88 Respiratory 183 Digestive Tract 430 Mental Illness 138 Heart and Circulatory Sex 41 F 42 F 43 F 44 M 45 F 46 F 47 F 48 F 49 F 50 F 51 M 52 F 53 M 54 F 55 M 56 F 57 M 58 F 59 M 60 F 61 F 62 M 63 F 64 F 65 F 66 F 67 F 68 F 69 M 70 F 71 M 72 M 73 F 74 F 75 F 76 M 77 M 78 M 79 M 80 F DRG DRG Categ 88 Respiratory 447 Injuries and Poisoning 183 Digestive Tract 140 Heart and Circulatory 127 Heart and Circulatory 444 Injuries and Poisoning 493 Liver and Pancreas 324 Kidney and Urinary 140 Heart and Circulatory 140 Heart and Circulatory 140 Heart and Circulatory 138 Heart and Circulatory 269 Skin Disorders 140 Heart and Circulatory 208 Liver and Pancreas 15 Nervous System 434 Alcohol, Drugs 88 Respiratory 78 Respiratory 89 Respiratory 89 Respiratory 316 Kidney and Urinary 140 Heart and Circulatory 166 Digestive Tract 175 Digestive Tract 203 Liver and Pancreas 87 Respiratory 296 Endrocine and Nutritional 294 Endrocine and Nutritional 127 Heart and Circulatory 294 Endrocine and Nutritional 183 Digestive Tract 197 Liver and Pancreas 132 Heart and Circulatory 240 Musculoskeletal and Connective 182 Digestive Tract 436 Alcohol, Drugs 175 Digestive Tract 207 Liver and Pancreas 359 Female Reproductive H M ID ID No 00 Sex 1 F 2 F 3 F 4 M 5 F 6 F 7 F 8 M 9M 10 F 11 F 12 M 13 M 14 F 15 M 16 F 17 F 18 F 19 F 20 F 21 F 22 F 23 M 24 F 25 F 26 F 27 F 28 F 29 F 30 M 31 M 32 F 33 F 34 M 35 M 36 M 37 F 38 M 39 F 40 F DRG DRG Categ- 294 Endrocine and Nutritional 139 Heart and Circulatory 34 Nervous System 140 Heart and Circulatory 141 Heart and Circulatory 15 Nervous System 294 Endrocine and Nutritional 241 Musculoskeletal and Connective 335 Male Reproductive 148 Digestive Tract 89 Respiratory 127 Heart and Circulatory 89 Respiratory 122 Heart and Circulatory 336 Male Reproductive 321 Kidney and Urinary 174 Digestive Tract 143 Heart and Circulatory 358 Female Reproductive 140 Heart and Circulatory 143 Heart and Circulatory 159 Digestive Tract 89 Respiratory 294 Endrocine and Nutritional 473 Rehab and Aftercare 128 Heart and Circulatory 15 Nervous System 121 Heart and Circulatory 128 Heart and Circulatory 140 Heart and Circulatory 209 Musculoskeletal and Connective 143 Heart and Circulatory 209 Musculoskeletal and Connective 96 Respiratory 144 Heart and Circulatory 90 Respiratory 88 Respiratory 183 Digestive Tract 430 Mental Illness 138 Heart and Circulatory Sex 41 F 42 F 43 F 44 M 45 F 46 F 47 F 48 F 49 F 50 F 51 M 52 F 53 M 54 F 55 M 56 F 57 M 58 F 59 M 60 F 61 F 62 M 63 F 64 F 65 F 66 F 67 F 68 F 69 M 70 F 71 M 72 M 73 F 74 F 75 F 76 M 77 M 78 M 79 M 80 F DRG DRG Categ 88 Respiratory 447 Injuries and Poisoning 183 Digestive Tract 140 Heart and Circulatory 127 Heart and Circulatory 444 Injuries and Poisoning 493 Liver and Pancreas 324 Kidney and Urinary 140 Heart and Circulatory 140 Heart and Circulatory 140 Heart and Circulatory 138 Heart and Circulatory 269 Skin Disorders 140 Heart and Circulatory 208 Liver and Pancreas 15 Nervous System 434 Alcohol, Drugs 88 Respiratory 78 Respiratory 89 Respiratory 89 Respiratory 316 Kidney and Urinary 140 Heart and Circulatory 166 Digestive Tract 175 Digestive Tract 203 Liver and Pancreas 87 Respiratory 296 Endrocine and Nutritional 294 Endrocine and Nutritional 127 Heart and Circulatory 294 Endrocine and Nutritional 183 Digestive Tract 197 Liver and Pancreas 132 Heart and Circulatory 240 Musculoskeletal and Connective 182 Digestive Tract 436 Alcohol, Drugs 175 Digestive Tract 207 Liver and Pancreas 359 Female Reproductive