Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Q:

Complete the following problems from Chapter 12 in Financial Management: Theory and Practice : Chapter 12: Topics: Additional Funds Needed, Forecasted Statements and Ratios, Financing Deficits...

Q:

Here is another one that I need assistance with. Let me know if you have any issues getting these done, because I have to turn them in by tonight On Pages 733 and 734, please read the background for...

Q:

B. Use the LOS worksheet in data file Patients_Assignment1.xls, do the following assignments (20 points). 1. Use the =MINO, =MAX(), and =FREQUENCY() functions, calculate the frequencies when separate...

Q:

Insert a column at D and, using Opinion 1 , convert the words to numbers, with All of the time being 5 , Most of the time being 4 , and so on . Name this variable Opinion 1 a . Using the following...

Q:

ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 AGE 50 21 35 49 38 42 17 20 49 41 20 55 44 23 64 65 23 44 29 32 18 22 43 39 38 22 43...

Q:

2.2 51 Summarizing Data for a Quantitative Variable Exercises Methods 11. Consider the following data. WEB 14 19 24 19 16 20 24 20 file Frequency a. b. SELF test 21 22 24 18 17 23 26 22 23 25 25 19...

Q:

Drive (miles) 4 6 6 20 25 25 28 29 33 36 36 36 36 36 40 42 42 54 54 55 63 63 71 71 73 76 76 76 78 80 80 80 80 88 94 State MI SC OR MI GA CA NY TX SC TX CA MI TX OR IL FL IL FL NY OH PA OR MI MI FL NY...

Q:

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Q:

Need assistance solving so I can check my answers for these 5 problems. Formulas (on a separate sheet) would be helpful. Thank you _x000D_ Accounting and Microsoft Excel_x0 -> data creation_x -> data...

Q:

Use either of the definitions below to find the slope of the tangent line to the graph of the given function at the indicated point. f(x)-r(xo) f'(xx) = lim or f'(xo) = lim &g+h)-[(x) X-Xo 1. f(x) =...

Q:

How does a methanotroph differ from a methanogen? Which pathway for C1 assimilation found in methanotrophs is most energetically efficient and why?

Q:

How would the new revenue recognition guidelines influence the way you would account for either option?

Q:

Hong is paid a semi-monthly salary of $1413.75. Regular hours are 37 1/2 per week and overtime is paid at time-and-a-half regular pay. (a) What is Hongs hourly rate of pay? (b) How many hours...

Q:

Find i0(t) for t > 0 in the network in Fig. P6.33 using the step-by-step method. t-0 i(t) 12V 10 mH

Q:

A wholesale distributor operating in different regions of Portugal has information on the annual spending of several items in their stores across different regions and channels. The data (Wholesale...

Q:

Determine if the conditions are met for constructing a confidence interval for the population mean in each of the following settings. a. We want to estimate the average age at which U.S. presidents...

Q:

1. How much allowance will each of the boys receive per month based on their parents assumptions of price increases? 2. (a) How much money must Victor and Jasmine invest for each son on June 1 to...

Q:

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

Q:

3. What is the z-score for the x552 observed cases of cancer? How do you interpret this zscore in light of the concern about an elevated rate of hematopoietic cancers in this area? How safe is it to...

Q:

31. Find the mean and standard deviation for a binomial distribution with n=100 and these values of p: a. p=.01 d. p=.7 b. p=.9 e. p=.5 c. p=.3.

Q:

28. Use Table 1 in Appendix I to find the sum of the binomial probabilities from x50 to x5k for these cases: a. n=10, p=.1,k=3 b. n=15, p=.6, k = 7 c. n=25, p=.5, k = 14