Need help in Excel

C. Use the DRG worksheet in data file Patients_Assignment1.xls, do the following assignments (20 points). 1. Do the frequency distribution by using Pivot Table. 2. Sort the data in the pivot table by the frequency of each DRG category and create column chart. 3. Generate a cumulative distribution for the DRG data from 1 and create chart with both frequencies and cumulative frequencies using different charts (column for frequencies and line for cumulative frequencies)

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